Making Ticked checkboxes to "save" content in corresponding textareas into DB

[bsb87angel]

Currently, I am working with many checkboxes and textareas.
The textareas and checkboxes are side to side.

What I want to do: By ticking many/one checkbox(es), content in "selected" textareas will be saved into the database when i click the submit button.

//some query and result codes here//

<table border=1>
  <td align="center"><b>Placeholder</b></td><td align="center"><b>EN</b></td><td align="center"><b><? echo $_SESSION['lan'];?></b></td><td align="center"><b>Save</b></td>
<form name="edit_text" method="post" action="<?php echo $PHP_SELF?>">
<?
//below is a while loop to generate table rows and increment in values (of the name [textarea1,2,3 and so on])

$number_t=1;
$number_c=1;
$value_c=1;
// Get each row of data on each iteration until there are no more rows
while($row = mysql_fetch_array($result)){
echo "<tr>";
echo "<td align='center'>";
echo $row['ph_name'];
echo "<td align='center'>";
echo $row['text'];
echo "<td align='center'>";
echo "<textarea name='textarea";
echo $number_t;
echo "'onBlur='check(this)'></textarea>"; //this part is for a Javascript function that checks the checkbox when textarea is filled in
echo "<td align='center'>";
echo "<input type='checkbox'";
echo "name='cbox";
echo $number_c;
echo "' value='";
echo $value_c;
echo "'>";
echo "</tr>";
$number_t++;
$number_c++;
$value_c++;
}
?>
<input type="hidden" name="submitted" value="true">
<input type="Submit" name="submit" value="Submit">		

Has it got anything to do with the checkbox values?
How do I go about doing it? I'm at my wit's end...
I've seen people telling me to use AJAX and all that sort... but is it that complicated? I dont think I should be using AJAX.. it's just PHP right??

I'd appreciate any help, thanks!

[bpat1434]

One issue you're going to have is that more than 1 element will have the same name, thus the last element will overwrite all others. So you either need to increment the name (cbox1, cbox2) or figure something else out.

As for adding it only if there's been a checkbox checked:

<?php
$add = array(); // Will hold all our data to be inserted
// Assuming you make arrays of all your data (cbox[], textarea[] . . . )
for($i=0; $i<count($_POST['cbox']); $i++)
{
  if($_POST['cbox'][$i] == true)
  {
    $add[] = $_POST['textarea'][$i];
  }
}

// Now just loop through and insert the data
$sql = "INSERT INTO `tablename` ('textarea') VALUES";
foreach($add as $value)
{
  $sql .= sprintf(" ('%s'),", mysql_real_escape_string($value));
}

$sql = substr($sql, 0, -1); // Remove the last "," to make a valid SQL Statement

$result = mysql_query($sql);
if($result)
{
  if(mysql_affected_rows($result) == count($add))
  {
    echo 'All Rows inserted Successfully';
  }
  else
    echo 'Some rows inserted, others not :(';
}
else
  echo 'Query Failed!! ' . mysql_error();
?>

Tha'ts a short and simple way of doing it.

[bsb87angel]

Yes, i did have increasing values for textarea1, textarea2, textarea3, and onwards.... and cbox1, cbox2, cbox3, and onwards...

Thanks.

I edited $add into the values.

$sql = "INSERT INTO content_test (text) VALUES ('".$add."')"; 

I've used the codes that you've provided and it submitted the text "Array" for me.

This error was displayed too-
Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource

There's something wrong with the query right?

[bpat1434]

Yes. If $add is an array, you then need to [man]implode/man the array into a string, or use a loop to add the values. As I did here:

// Now just loop through and insert the data
$sql = "INSERT INTO `tablename` ('textarea') VALUES";
foreach($add as $value)
{
  $sql .= sprintf(" ('%s'),", mysql_real_escape_string($value));
}

You may find it helpful at this stage to start echoing out the query you're running prior to running it. That way you can see exactly what's going on. If you are already doing that, good.

Yes, i did have increasing values for textarea1, textarea2, textarea3, and onwards.... and cbox1, cbox2, cbox3, and onwards...

Sorry. From the looks of the first post, it didn't seem like you had increasing numbers, just the name. I didn't look too hard at the code, but now I see that you separated everything onto a new line with echo instead of concatenation. Neither way is wrong, I'm just used to concatenation and didn't catch it. I apologize.