superfreak112 Posted June 17, 2009 Share Posted June 17, 2009 Hi All, im wondering if any one can help, i am setting up a reminder system . basically ajax to refresh in the back and run php sciprt 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\" type=\"text/javascript\"> alert(\'This is what an alert message looks like.\');"; // this is to test the popup </script> echo test; $q=$_GET["q"]; $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 ? Quote Link to comment Share on other sites More sharing options...
xtopolis Posted June 18, 2009 Share Posted June 18, 2009 You would have to use eval() on the code to get it to execute. My suggestion though would be for on first load to check if any events happen today, and if so create a countdown timer for them. Then the background script can just check if anything has changed, and if so reload the page. Quote Link to comment Share on other sites More sharing options...
superfreak112 Posted June 18, 2009 Author Share Posted June 18, 2009 hi, Thanks for the reply, do you mean php eval or javascritp eval ? thanks Quote Link to comment Share on other sites More sharing options...
xtopolis Posted June 18, 2009 Share Posted June 18, 2009 Ya.... im going to go with javascript on this one.. especially since you're trying to exec something on the client side.. and I liked to javascript.. .. yaa... Quote Link to comment Share on other sites More sharing options...
superfreak112 Posted June 18, 2009 Author Share Posted June 18, 2009 he he thanks would this suffice ? echo "<script language='javascript'>eval(\"test\");</script>"; 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.