Editable Table/Form

[jnance2004]

I have created a table that allows the user to edit specific cells by clicking on them. Their new entered values set the value on the table. They then should be able to submit a form which sets several hidden inputs equal to the values in the table then passing the information to a php page to process. However, the php page doesn't output anything when it is submitted.

This is the form layout.

<form method="post" action="mypage.php" id="complex" name="complex">

<input type="hidden" id="1x1" value="">
...etc.

When the user enters all the data into the table they click on a submit button which calls a script like this...

function getValues()
{
	document.getElementById("1x1").value = document.getElementById('table').rows[3].cells[1];
...
document.getElementById("complex").submit();

NOTE: although I have the id of the cell as "1x1" it is actually the 4th row and 2nd cell of the table.

The form is then submitted to a PHP page like such:

<?php
$con = mysql_connect("localhost","user","pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("b6_6229906_main", $con);

$1x1 = $_POST['1x1'];

$sql="INSERT INTO 'table' VALUES ('$1x1')";

if(mysql_query($sql) === FALSE ) {
    die('Error: ' . mysql_error());
}
echo "1 record added"; 


mysql_close($con);
?>

I know this is a javascript thread but I really don't know if the error is in the javascript or php, but no PHP error is displayed. Also, there are about 75 entries being processed not just the "1x1", I just simplified it for readability.

[tirna]

......I really don't know if the error is in the javascript or php, but no PHP error is displayed.......

This statement suggests to me you did not do any testing along the way as you wrote the code.

To me it looks like you just need to do some Basic Debugging 101 (post #1) to find the errors in your code.

Think of debuging as character building

[jnance2004]

I actually did alot of debugging. It took me several hours of debugging and now i receive 0 javascript errors and 0 php errors. im just getting no output on the php page. there are no loops within my code that it could be stuck in either.

[jnance2004]

I guess what im asking is how should i go about debugging? because Im getting no client-side errors but even if I try to say echo $1x1 i get no output. So, Im wondering if im doing something wrong with retreiving table values or perhaps there is something with passing values using hidden inputs and the post method that im unaware of. I really am just not sure where to go from here because of the lack of output/errors im receiving

[Fang]

The ids used are invalid: http://www.w3.org/TR/html401/types.html#type-name

Form controls must have a name if you want to send data to the server.

Always check you are receiving the expected data:

<?php
foreach ( $_POST as $key => $value ) {
 print $key . " = " . $value . "<br>";
}
?>

document.getElementById("1x1").value = document.getElementById('table').rows[3].cells[1].innerHTML

[tirna]

I actually did alot of debugging. It took me several hours of debugging and now i receive 0 javascript errors and 0 php errors. im just getting no output on the php page. there are no loops within my code that it could be stuck in either.

Did you check the values of the parameters being sent to the php script are actually correct before submitting them.

And in my Basic Debugging 101 link I suggest you check the values of parameters being received by the form before you code any further.

Have you checked the values of the parameters received by your php script?

If you did check the parameter values received by our php script, the cause of your error would have become very obvious.

I am not convinced you did any debugging.