0
I've got a small problem with a bit of AJAX and PHP...
I have two files, adminActions.php and newCat.php:
newCat.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "[url="http://www.w3.org/TR/html4/loose.dtd"]http://www.w3.org/TR/html4/loose.dtd[/url]">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<meta name="author" content="Bradlc">
<title>Title</title>
<script type="text/javascript">
var XMLHttpRequestObject = false;
if(window.XMLHttpRequest){
XMLHttpRequestObject = new XMLHttpRequest();
} else if(window.ActiveXObject){
XMLHttpRequestObject = new ActiveXObject("Microsoft.XMLHTTP");
}
function getData(dataSource, divID, newCat){
if(XMLHttpRequestObject){
var obj = document.getElementById(divID);
XMLHttpRequestObject.open("POST", dataSource);
XMLHttpRequestObject.setRequestHeader('Content-Type','application/x-www-form-urlencoded');
XMLHttpRequestObject.onreadystatechange = function(){
if(XMLHttpRequestObject.readyState == 4 && XMLHttpRequestObject.status == 200){
obj.innerHTML = XMLHttpRequestObject.responseText;
}
}
XMLHttpRequestObject.send("newCat=" + newCat);
}
}
</script>
</head>
<body>
<form method="post" onSubmit="getData('adminActions.php?action=addCategory','exampleID', document.getElementById('newCat').value)">
<input type="text" id="newCat" name="newCat" /><br /><br />
<input type="submit" name="submit" value="Submit" /><br /><br />
<span id="exampleID"></span>
</form>
</body>
</html>
adminActions.php
<?php
/**
* @author Bradlc
* @copyright 2007
*/
$c = mysql_connect("HOST","USER","PASS")or die(mysql_error());
mysql_select_db("DB", $c);
switch($_GET['action']){
case 'addCategory':
$newCat = $_POST['newCat'];
$putCat = mysql_query("INSERT INTO `categories` (`name`) VALUES ('$newCat')")or die(mysql_error());
if($putCat){
echo 'Category added!';
}
break;
}
?>
Basically what it's supposed to do is put the category name I enter in to the database then without a page refresh echo 'Category added!'
Now, it does enter the name in to the database but it doesn't echo the 'Category added!'
Anyone got any idea?
Any help is appriciated.
Thanks,
Brad.
Edited by Bradlc, 23 July 2007 - 10:45 AM.
)
