JavaScript AJAX POST does not work for mysqli

[erichmiller1989]

Hi, Geniuses:
I have followed the instructions on this page using a database on my machine.
Everything works fine.
However, the code does not work when I change all "GET"s to "POST"s and change
xmlhttp.open("GET","getuser.php?q="+str,true); xmlhttp.send();
to
xmlhttp.open("POST","getuser.php",true); xmlhttp.send("q="+str);
So what do I miss?

 

[erichmiller1989]

Yeah, I thought the same for setting the header for content type. I wonder if the file that is receiving the POST (or GET originally) is expecting a different content-type. Worth a check

Thanks for stopping by, Ghost.

 

[Deleted member 2829]

Thanks a lot, cbreemer.
I changed $q = intval($_POST['q']) to $q = intval($_REQUEST['q']), it works immediately.
When I changed back to intval($_POST['q']), it works too. Quite strange, but works anyway.
Thanks again.

You're welcome

 

[Deleted member 2829]

Thanks a lot, cbreemer.
I changed $q = intval($_POST['q']) to $q = intval($_REQUEST['q']), it works immediately.
When I changed back to intval($_POST['q']), it works too. Quite strange, but works anyway.
Thanks again.

Hm... weird. Perhaps your page needed refreshing. Anyway, I think we've cracked this one, right ?

 

[erichmiller1989]

Hm, strange, I did test it. Admittedly, I used a different W3C example : https://www.w3schools.com/xml/ajax_php.asp
This uses GET and I got it to work with POST by making your changes (which did not work), then adding my line (which made it work).

Hi, cbreemer.
I tried to move function showUser(str) out of the HTML file, and put it in a ajax.js file. Then I put a line <script type="text/javascript" src="ajax.js"></script> to refer to it. The entire set immediately stops working. So what do I miss here?

 

[erichmiller1989]

Hm... weird. Perhaps your page needed refreshing. Anyway, I think we've cracked this one, right ?

Yes, I have marked your reply as an answer. Thanks a lot. cbreemer.

 

[Deleted member 2829]

I tried to move function showUser(str) out of the HTML file, and put it in a ajax.js file. Then I put a line <script type="text/javascript" src="ajax.js"></script> to refer to it. The entire set immediately stops working. So what do I miss here?

That looks like it should work. But are you sure that js file is in the same directory as the html file ? And have you started the debugger and looked for errors, in this case specifically in the Network tab ?

EDIT - Actually this should have been a new thread. It has nothing to do with the current issue which has been marked as solved.

 

[erichmiller1989]

That looks like it should work. But are you sure that js file is in the same directory as the html file ? And have you started the debugger and looked for errors, in this case specifically in the Network tab ?

EDIT - Actually this should have been a new thread. It has nothing to do with the current issue which has been marked as solved.

Thanks, cbreemer, for replying.
Yes, my ajax.js is in the same directory as the HTML file. I will debug it and post it on a new thread.