I need help with PHP AJAX

dannywebnoob · Aug 26, 2021

hey guys
I need help with AJAX. I want to UPDATE my DB without refreshing. I don't really know how to do this. I have found piece of code online but for some reason is not working. Another thing is : how to make run PHP code after 5 minutes. For example: someone push the button and after 5 minutes my DB will be updated. Any Ideas?

Dopani · Aug 26, 2021

It is easy mate!

Check example here https://www.w3schools.com/php/php_ajax_database.asp

Their codes

<html>
<head>
<script>
function showUser(str) {
if (str == "") {
document.getElementById("txtHint").innerHTML = "";
return;
} else {
var xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("txtHint").innerHTML = this.responseText;
}
};
xmlhttp.open("GET","getuser.php?q="+str,true);
xmlhttp.send();
}
}
</script>
</head>
<body>

<form>
<select name="users" onchange="showUser(this.value)">
<option value="">Select a person:</option>
<option value="1">Peter Griffin</option>
<option value="2">Lois Griffin</option>
<option value="3">Joseph Swanson</option>
<option value="4">Glenn Quagmire</option>
</select>
</form>
<br>
<div id="txtHint"><b>Person info will be listed here...</b></div>

</body>
</html>

In getuser.php file, you need to make the Mysql query to return the string and display it in txtHint div by ID

Hope that helps!

webnoob · Aug 28, 2021

thank you for your reply. I will check today. I hope it will work for me

I'm just desperate to add AJAX to my code.

webnoob · Aug 28, 2021

I have send you a code in private message.

S4 Hosting · Sep 29, 2021

dannywebnoob said:
Another thing is : how to make run PHP code after 5 minutes. For example: someone push the button and after 5 minutes my DB will be updated. Any Ideas?

I'm curious, what is the use case for this, what are you trying to achieve?

I don't see any reason why you would want to update something in a database with that much delay. I can think of possible reasons to not show something being updated to frontend viewers for a while, but not to actually not update it, it introduces all sorts of potential issues with the server going down or other failure during the time period between click and update.

xiamuguizhi · Oct 4, 2021

VUE can better fulfill your needs.

I need help with PHP AJAX

dannywebnoob

New member

Dopani

Well-known member

webnoob

New member

Dopani

Well-known member

webnoob

New member

Dopani

Well-known member

S4 Hosting

Well-known member

xiamuguizhi

New member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud