[RESOLVED] jquery AJAX submits but there is no $_POST in php

jrough

I post this form in jquery and it looks like it posts. I get these form fields in firefox Jquery POST:
HeadersPostResponseHTML
Parametersapplication/x-www-form-urlencoded
due_date By when?
task_todo laundry
todo_name janis rough

BUt there is no AJAX response. The form_handler.php page has an if{} to check if the submit button was submitted and it does not ever get any $_POST data. DO you see something simple with the form_handler or form that is wrong? Otherwise I will try to add in an error handler in the AJAX but it SEems like it should respond. In the required db.php page I got the msql_connect to connect the mysql db.
url :http://99.185.244.210/todo8.html

form_handler.php

error_reporting(E_ALL | E_NOTICE);
require("db.php");
if (isset($_POST['submit'])){
alert("hello");
$task= $_POST['task_todo'];
echo $task;
$name = $_POST['todo_name'];
echo $name;
$date = $_POST['due_date'];
echo $date;

$sql = "INSERT INTO taskos.task(todo, date, name) values('$task','$date','$name') ";
$result = mysql_query($sql);
    if ( !$result ) {die("<font style='color:red'>Invalid query:</font>" . mysql_error() . "<br>$sql");}
echo "result1";

$sql2 = 'SELECT todo FROM task WHERE todo >"" ';
$result2= mysql_query($sql2);
$arr_result = array();

if ( !$result2 ) {die("<font style='color:red'>Invalid query:</font>" . mysql_error() . "<br>$sql");} 
while($result_of_result2 = mysql_fetch_assoc($result2))
{
    $arr_result = $result_of_result2;
}
var_dump($arr_result);

}

I can send you the jquery code but maybe you can see it in the url?

Bonesnap

Yeah, looks like a compound problem with the undefined alert function and the non-existent $_POST['submit'] element.

jrough

bradgrafelman;11004629 wrote:
What is in db.php? One thing I notice is that if $_POST['submit'] is defined, you're probably causing a fatal error due to alert() being an undefined function. If it isn't defined, your script doesn't generate any output. Thus you've got a script that either causes a fatal error, or doesn't do anything. 🙂

Second, if there are PHP error messages being generated, how are you attempting to view them? My personal preference would be to enable error logging and check the PHP error log, seeing as how this script is going to be accessed in the background by some JS code.

Finally, have you tried doing a print_r() on the $_POST array itself to see what it contains?

EDIT: Just took a look at your HTML form, and realized one problem: You don't have any form entities named 'submit', thus this if() statement:
if (isset($_POST['submit'])){
shouldn't ever be true. So, either check for the name of a form entity you are sending, or else add an entity that is named 'submit'.

I had the submit input of the first form as name="submit" but when I do that the onsubmit event does not even fire. I do get the round submit button but it doesn't fire at all. There seems to be a bug with that according to this page on Jquery site.
http://forum.jquery.com/topic/click-on-submit-button-doesn-t-trigger-form-s-jquery-submit-handler

I fixed the alert() to echo "hello"; I also wrote the error message to a file. I can't find the error log but it did respond back in the AJAX response in firebug.
 
Parse error: syntax error, unexpected T_REQUIRE in /Library/WebServer/Documents/form_handler.php on line 5

It looks like line 5 of the db.php page doesn't work?
This is the code for the required db.php connection page.



$dbname= "taskos";
$link = mysql_connect('99.XX.XXX.XXX:3306', 'root', 'jrough');
mysql_select_db($dbname);

if ( !mysql_select_db($dbname,$link) ) {
   echo 'Could not select database taskos<br>';
   exit;}else{echo "connected to taskos!";}

Bonesnap

Remove your database credentials. You masked your IP, and that's great, but you seem to have forgotten that you posted your IP in your first post...

jrough

I fixed a few typos. Now it is saying:

Parse error: syntax error, unexpected T_VAR in /Library/WebServer/Documents/db.php on line 2

but I think it is choking somewhere still on the form handler since db.php appears to be ok. I checked the opening and closing {}'s.

 
$dbname= "taskos";
 $link = mysql_connect('xx.xx.xxx.xx:3306', 'xxx', 'xxxxx');
mysql_select_db($dbname);

if ( !mysql_select_db($dbname,$link) ) {
   echo 'Could not select database taskos<br>';
   exit;}else{echo "connected to taskos!";}

require("db.php");

error_log("form_handler error",3,"/var/tmp/Janis-Rough.local.err");

print_r($_POST);
if (isset($_POST['submit'])){
echo "hello";
$task= $_POST['task_todo'];
echo $task;
 $name = $_POST['todo_name'];
echo $name;
 $date = $_POST['due_date'];
echo $date;

$sql = "INSERT INTO taskos.task(todo, date, name) values('$task','$date','$name') ";
$result = mysql_query($sql);
    if ( !$result ) {die("<font style='color:red'>Invalid query:</font>" . mysql_error() . "<br>$sql");}
echo "result1";

$sql2 = 'SELECT todo FROM task WHERE todo >"" ';
$result2= mysql_query($sql2);
$arr_result = array();

if ( !$result2 ) {die("<font style='color:red'>Invalid query:</font>" . mysql_error() . "<br>$sql");} 
while($result_of_result2 = mysql_fetch_assoc($result2))
{
    $arr_result = $result_of_result2;
}
var_dump($arr_result);
print (json_encode($arr_result));

}else{
	echo "nothing posted";
}

?>

url: http://99.185.244.210/todo8.html
I would like to see it post something, I don't see something wrong with form_handler.php tnx,