mhunt
04-04-2007, 09:33 PM
ok so i have a calendar, and it shows a link under the day that has an event on it and when i click that date theres an onlick="getEvent('somedatehere')
but im not getting any response from the php file maybe someone can tell me what i am doing wrong.
javascript:
var xmlhttp = false;
try {
xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
} catch(e) {
try {
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
} catch(E) {
xmlhttp = false;
}
}
if(!xmlhttp && typeof XMLHttpRequest != 'undefined') {
xmlhttp = new XMLHttpRequest();
}
function getEvent($date) {
//make the box visible
serverPage = "getEvent.php?date=$date";
var obj = document.getElementById("popup");
xmlhttp.open("GET", serverPage);
xmlhttp.onreadystatechange = function() {
if(xmlhttp.readyState == 4 && xmlhttp.status == 200) {
obj.innerHTML = xmlhttp.responseText;
}
}
xmlhttp.send(null);
}
php:
<?php
require_once('SystemComponent.php');
require_once('DbConnector.php');
require('make_safe.php');
$db = new DbConnector();
$date = make_safe($_GET['date']);
$result = $db->query("SELECT event_date, event_title, event_desc FROM calendar_events WHERE event_date = '$date'");
if(!$result) {
echo "failed";
} else {
while($row = $db->fetchArray($result)) {
echo $row['event_date']."<br />\n";
echo $row['event_title']."<br />\n";
echo $row['event_desc']."<br />\n";
}
}
?>
but im not getting any response from the php file maybe someone can tell me what i am doing wrong.
javascript:
var xmlhttp = false;
try {
xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
} catch(e) {
try {
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
} catch(E) {
xmlhttp = false;
}
}
if(!xmlhttp && typeof XMLHttpRequest != 'undefined') {
xmlhttp = new XMLHttpRequest();
}
function getEvent($date) {
//make the box visible
serverPage = "getEvent.php?date=$date";
var obj = document.getElementById("popup");
xmlhttp.open("GET", serverPage);
xmlhttp.onreadystatechange = function() {
if(xmlhttp.readyState == 4 && xmlhttp.status == 200) {
obj.innerHTML = xmlhttp.responseText;
}
}
xmlhttp.send(null);
}
php:
<?php
require_once('SystemComponent.php');
require_once('DbConnector.php');
require('make_safe.php');
$db = new DbConnector();
$date = make_safe($_GET['date']);
$result = $db->query("SELECT event_date, event_title, event_desc FROM calendar_events WHERE event_date = '$date'");
if(!$result) {
echo "failed";
} else {
while($row = $db->fetchArray($result)) {
echo $row['event_date']."<br />\n";
echo $row['event_title']."<br />\n";
echo $row['event_desc']."<br />\n";
}
}
?>