php / ajax help please

superfreak112 · 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,

Sign In

php / ajax help please

Recommended Posts

superfreak112

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information