Help with a PHP and AJAX problem?

  • Thread starter Thread starter laughingboydecky
  • Start date Start date
L

laughingboydecky

Guest
Does anyone know why I can't add values to the database with this code? It's not bringing up any errors.. please help!!

<?php

/* return values
0 = cannot connect
1 = cannot select database
2 = cannot insert record
3 = record inserted
*/

//get the values
$url = addslashes($_GET['url']);
$describe = addslashes($_GET['comments']);


$con = mysql_connect("localhost","root","");
if ($con)
{
$selectdb = mysql_select_db("addressbook", $con);
if(!$selectdb)
{
print 1;
return;
}
else
{
$insert = mysql_query("INSERT INTO bookmarks (url, detail) VALUES ('$url','$describe')",$con);
if (!$insert)
{
print 2;
return;
}
else
{
print "Successfully Uploaded Bookmark!!!";
return;
}
}
}
else
{
print 0;
return;
}


?>


And Here's the Javascript

var address;
var comments;


function insertBookmark()
{

xmlHttp=GetXmlHttpObject();
if (xmlHttp==null)
{
alert ("Browser does not support HTTP Request");
return;
}

address = document.getElementById("url").value;
comments = document.getElementById("comments").value;

var url="insertBookmark.php";
url=url+"?address="+address+"&comments="+comments;

xmlHttp.onreadystatechange=stateChanged;
xmlHttp.open("GET",url,true);
xmlHttp.send(null);

}

function stateChanged()
{ alert(xmlHttp.responseText);
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{

//cannot connect to database
if(xmlHttp.responseText == 0)
{
document.getElementById("insertStatus").innerHTML= "Cannot connect to database!";
}
//cannot select the database
else if(xmlHttp.responseText == 1)
{
document.getElementById("insertStatus").innerHTML= "Cannot select the database";
}
else if(xmlHttp.responseText == 2)
{
document.getElementById("insertStatus").innerHTML= "Cannot insert record";
}
else if(xmlHttp.responseText == 3)
{
document.getElementById("insertStatus").innerHTML= "Record has been successfully added";
}
else
{
document.getElementById("insertStatus").innerHTML= "Unknown error, server may not be running";
}
}
}

function GetXmlHttpObject()
{
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;
}
 
Back
Top