get response through ajax request

Asked Mar 18 '17 at 13:17

Active Oct 25 '19 at 01:56

Viewed 32 times

I am passing a ajax request to php page and alert the response.

php file contains below line

$sql2 = "INSERT  INTO `post_tags` (`post_id`, `tag`) VALUES (".$mysqli->insert_id.", ".$tag.")";
echo $sql2;

I get the alert. But the sql query is wrong because I need to pass $tag as string as tag is a varchar in sql.

So when I replace the php code with

$sql2 = "INSERT  INTO `post_tags` (`post_id`, `tag`) VALUES (".$mysqli->insert_id.", '".$tag."')";
echo $sql2;

It inserts the data successfully in the table. But I am not getting any data in return. What may be the issue?

And is there some way to debug these kind of issues? i.e to find php errors from front end?

edited Oct 25 '19 at 01:56

Cœur

asked Mar 18 '17 at 13:17

tarun14110

1

Which data you are expecting in return? – Sahil Gulati Mar 18 '17 at 13:20
I want to return the sql query for know – tarun14110 Mar 18 '17 at 13:23
Why did you post the first not working query? – Paul Spiegel Mar 18 '17 at 13:35
If I use that. I am getting echo result in js alert. – tarun14110 Mar 18 '17 at 13:36
1

Then the "problem" is somwhere in the code that you don't show. You probably have something like `if ($result) {... exit();} echo $sql2`. And `$sql2` is only echoed, when the query fails. – Paul Spiegel Mar 18 '17 at 13:39
There is something wrong echoing the second sql string. Because when I echo hard coded string like echo "string". It works. – tarun14110 Mar 18 '17 at 13:50
Sounds like you're getting an error but cannot see it. Check out [How can I get useful error messages in PHP?](https://stackoverflow.com/questions/845021/how-can-i-get-useful-error-messages-in-php) – Phil Oct 25 '19 at 02:38

0 Answers0