PHP/Ajax Issue

kbc1

Hi all

I'm learning how to integrate PHP/Ajax and have come across a stumbling block that I need help/advice on please.

I call a PHP script (via an Ajax function) which updates my database. Now at the end of my script, if I do the following:

if (mysql_affected_rows() == 1) {
	echo "It Worked!";
}

The Ajax function will alert() the text 'It Worked!' no problem, but instead of echoing text here, I actually want to include another PHP file which outputs HTML which would ultimately become the response.Text for my ajax function and i can't get it to work.

I have tried putting the string 'It Worked!' into the myscript.php script in the example below and nothing is returned in the alert() - any ideas why?

if (mysql_affected_rows() == 1) {
	include("myscript.php");
}

Thanks for reading

sneakyimp

How did you 'put the string' on myscript.php? If all you did was define a variable then that's not going to do it. You actually have to echo "It Worked" in myscript.php.

effim

kbc1;10911979 wrote:
Hi all

I'm learning how to integrate PHP/Ajax and have come across a stumbling block that I need help/advice on please.

I call a PHP script (via an Ajax function) which updates my database. Now at the end of my script, if I do the following:
if (mysql_affected_rows() == 1) {
	echo "It Worked!";
}
The Ajax function will alert() the text 'It Worked!' no problem, but instead of echoing text here, I actually want to include another PHP file which outputs HTML which would ultimately become the response.Text for my ajax function and i can't get it to work.

I have tried putting the string 'It Worked!' into the myscript.php script in the example below and nothing is returned in the alert() - any ideas why?
if (mysql_affected_rows() == 1) {
	include("myscript.php");
}
Thanks for reading

You should really be using 'require' to ensure that you're linking to a file that exists and you aren't pulling in a file from another location on accident. Also, you can try accessing the file directly through your browser to ensure that you aren't just having trouble with your AJAX. Honestly, unless it's a large file, I'd recommend you just put the contents of your myscript.php directly in the 'if' control statement rather than read it in from another file, unless of course you have another reason for doing it that way.

PS: Posting the text of myscript.php is going to be helpful for everybody to debug.