superfreak112 Posted June 18, 2009 Share Posted June 18, 2009 Hi All, im wondering if any one can help, i am setting up a reminder system . basically i need ajax to refresh in the back and run php script to check the sql database to see if the reminder is now and if so popup a javascript alert box so far i have <html> <head> <script type="text/javascript"> var page = "getuser.php"; function ajax(url,target) { // native XMLHttpRequest object document.getElementById(target).innerHTML ; if (window.XMLHttpRequest) { req = new XMLHttpRequest(); req.onreadystatechange = function() {ajaxDone(target);}; req.open("GET", url, true); req.send(null); // IE/Windows ActiveX version } else if (window.ActiveXObject) { req = new ActiveXObject("Microsoft.XMLHTTP"); if (req) { req.onreadystatechange = function() {ajaxDone(target);}; req.open("GET", url, true); req.send(); } } setTimeout("ajax(page,'scriptoutput')", 10000); } function ajaxDone(target) { // only if req is "loaded" if (req.readyState == 4) { // only if "OK" if (req.status == 200 || req.status == 304) { results = req.responseText; document.getElementById(target).innerHTML = results; } else { document.getElementById(target).innerHTML="ajax error:\n" + req.statusText; } } } </script> </head> <body> <body onload="ajax(page,'scriptoutput')"> <span id="scriptoutput"></span></p> </body> </html> and the php <?php $todays = date('Y-m-d H:i:s'); echo $todays; echo "<script language='javascript'>eval(\"$todays\");</script>"; $con = mysql_connect('localhost', 'root', ''); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("test", $con); $sql="SELECT * FROM reminder WHERE datetime >'$todays' "; $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { echo $row['datetime'] ; } mysql_close($con); ?> but i cant get the alert message to appear, it will work if i place echo "<script language='javascript'>eval(\"$todays\");</script>"; in just a standalone php file, Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.