Here are my problems:
1. When deleting a record, the AJAX response doesn't come through. It deletes the extension as requested, but still shows the deleting message. The response area is a <tr> with id=rowID (where ID is the database ID, so database id 333 will be <tr id=row333>)
Here is the Javascript and php.
Code: Select all
function deleteID(id)
{
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=deleteItem(id);
xmlhttp.open("GET","extensionEdit.php?id="+id,true);
xmlhttp.send(null);
}
function deleteItem(id)
{
if (xmlhttp.readyState!=4)
{
document.getElementById("row"+id).innerHTML="<img src=\"../../images/breadcrumbload.gif\"/> Deleting Extension..."
}
if (xmlhttp.readyState==4)
{
document.getElementById("row"+id).innerHTML=xmlhttp.responseText;
}
}
Code: Select all
$id = $_GET['id'];
if(!mysql_query("DELETE FROM extensions WHERE id='$id'"))
die(mysql_error);
else
echo "<td colspan='2'> </td>";
Code: Select all
function addExt(id)
{
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=stateChanged;
var name = document.getElementById('name').value;
var ext = document.getElementById('ext').value;
var office = document.getElementById('office').value;
xmlhttp.open("GET","extensionEdit.php?name="+name+"&ext="+ext+"&office="+office,true);
xmlhttp.send(null);
}
function stateChanged()
{
if (xmlhttp.readyState!=4)
{
document.getElementById("newOne").innerHTML="<img src=\"../../images/breadcrumbload.gif\"/> Adding Extension..."
}
if (xmlhttp.readyState==4)
{
document.getElementById("newOne").innerHTML=xmlhttp.responseText;
}
}
Code: Select all
$name = $_GET['name'];
$ext = $_GET['ext'];
$office = $_GET['office'];
if(!mysql_query("INSERT INTO extensions (name, ext, office) VALUES ('$name', '$ext', '$office')"))
die(mysql_error);
else
{
echo "<td>
<input type='hidden' id='office' name='office' value='".$_GET['branch']."'/>
<input type='text' id='name' name='name'/>
</td>
<td>
<input type='text' id='ext' name='ext'/>
</td>
<td>
<span onclick='addExt()'>+</span>
</td>
</tr>
<tr id='row$id'>
<td>$name</td>
<td>$ext</td>
<td><span onclick='deleteID(\"$id\")'>X</span></td>";
}
Code: Select all
<span onclick="addExt()">+</span></td><tr><td>Dawie</td>
Any help?