evo koda:
Code:
$username= $_SESSION["username"];
$zahtev="ne";
$resbr = mysql_query("SELECT * FROM chatzahtevi where userza='$username'") or die(mysql_error());
if (mysql_num_rows($resbr)!=0)
{
$userod=mysql_result($resbr,0,"userod");
$sql="DELETE FROM chatzahtevi WHERE userza='$username' and userod='$userod'";
//mysql_query($sql) or die(mysql_error());
$zahtev="da";
}
echo $zahtev;
$username= $_SESSION["username"];
$zahtev="ne";
$resbr = mysql_query("SELECT * FROM chatzahtevi where userza='$username'") or die(mysql_error());
if (mysql_num_rows($resbr)!=0)
{
$userod=mysql_result($resbr,0,"userod");
$sql="DELETE FROM chatzahtevi WHERE userza='$username' and userod='$userod'";
//mysql_query($sql) or die(mysql_error());
$zahtev="da";
}
echo $zahtev;
direktnim izvrsavanjem u browseru radi ok, ali kad ajaxom pokusam da citam podatke umesto da vrati mi ne iako podatak postoji (i mozzila vrati da)
evo ajax skripte
Code:
<script type="text/javascript">
var xmlhttp;
function ZahtevZaChat() {
xmlhttp=GetXmlHttpObject1();
if (xmlhttp==null)
{
alert ("Your browser does not support AJAX!");
return;
}
var url="ajax.php";
xmlhttp.onreadystatechange=stateChanged1;
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
setTimeout('ZahtevZaChat()', 4000);
}
function stateChanged1()
{
//alert ('radi');
if (xmlhttp.readyState==4)
{
alert (xmlhttp.responseText); // ovaj deo mi vrati da i mozili i ne u IE i chrome
if (xmlhttp.responseText=='da')
{
window.open('http://www.pageresource.com/jscript/jex5.htm','mywindow','width=400,height=200');
}
}
}
function GetXmlHttpObject1()
{
var xmlHttp = null;
try {
// Firefox, Opera 8.0+, Safari
xmlHttp = new XMLHttpRequest();
} catch (e) {
// Internet Explorer
try {
xmlHttp = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
</script>
<script type="text/javascript">
var xmlhttp;
function ZahtevZaChat() {
xmlhttp=GetXmlHttpObject1();
if (xmlhttp==null)
{
alert ("Your browser does not support AJAX!");
return;
}
var url="ajax.php";
xmlhttp.onreadystatechange=stateChanged1;
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
setTimeout('ZahtevZaChat()', 4000);
}
function stateChanged1()
{
//alert ('radi');
if (xmlhttp.readyState==4)
{
alert (xmlhttp.responseText); // ovaj deo mi vrati da i mozili i ne u IE i chrome
if (xmlhttp.responseText=='da')
{
window.open('http://www.pageresource.com/jscript/jex5.htm','mywindow','width=400,height=200');
}
}
}
function GetXmlHttpObject1()
{
var xmlHttp = null;
try {
// Firefox, Opera 8.0+, Safari
xmlHttp = new XMLHttpRequest();
} catch (e) {
// Internet Explorer
try {
xmlHttp = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
</script>
gde gresim?
hvala unapred