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 ? Link to comment https://forums.phpfreaks.com/topic/162585-solved-ajax-php-help/ 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. Link to comment https://forums.phpfreaks.com/topic/162585-solved-ajax-php-help/#findComment-858607 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 Link to comment https://forums.phpfreaks.com/topic/162585-solved-ajax-php-help/#findComment-858752 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... Link to comment https://forums.phpfreaks.com/topic/162585-solved-ajax-php-help/#findComment-858756 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>"; Link to comment https://forums.phpfreaks.com/topic/162585-solved-ajax-php-help/#findComment-858760 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.