Reply to Deleting from table using AJAX

Your name:

Reply:


Posted by sahm on 01/21/08 11:14

HI every one
I have problem for deleting data from table using ajax
this code to insert user data and show the data in table using ajax it
work fine but for another code that use to delete data and show the
date in same table it dose not work
and this are my codes

this code for show user data
/////////////////////////////////////////////
<form method="get" action="insert_user.php">
<tr>
<td align=left width='15%'>
<tr>
<td align=left><label>Employee Name:</label></td>
<td align=left width=90%><input type="text"
id="employee_name" value="" size=30></td>
</tr>
<tr>
<td align=left>User Name:</td>
<td align=left><input type="text" id="user" value=""
size=30></td>
</tr>
<tr>
<td align=left>Password:</td>
<td align=left><input type="password" id="password" value=""
size=30></td>
</tr>
<tr>
<td align=left>E-Mail:</td>
<td align=left><input type="text" id="e_mail" value=""
size=30></td>
</tr>
<tr>
<td align="left">User Department:</td>
<td align="left">
<select id="department">
<option value="Management">Management</option>
<option value="Accounting">Accounting</option>
<option value="Sales">Sales</option>
</select>
</td>
</tr>
</td>
</tr>
<tr>
<td colspan=2 align=left>
<input type="reset" value="Reset">
<input type="button" value="Submit"
onclick="insertUser(employee_name.value, user.value, password.value,
e_mail.value, department.value)">
</td>
</tr>
</form>
<tr>
<td colspan="2" align="left">
<h2>User Table</h2>
</td>
</tr>
<tr>
<td colspan='2' align='left'>
<form method="get" action="delete_user.php">
<span id='employee'>
<table border=1 width='500'>
<tr>
<th>Employee Name</th>
<th>Employee Department</th>
</tr>
<?
$sql = "select * from user";
$result = mysql_query($sql);
if(@mysql_num_rows($result)!=0)
{
while ($data = mysql_fetch_assoc($result))
{
echo "<tr>\n";
echo "<td>\n";
echo $data['employee_name'];
echo "</td>\n";
echo "<td>\n";
echo $data['employee_Department'];
echo "</td>\n";
echo "<td>\n";
//echo "<input type='button' value='Delete'
onclick='deleteUser(".$data['employee_name'].")'>\n";
echo<<<HERE
<input type='button' value='Delete'
onclick="deleteUser($data[employee_name])">\n
HERE;
echo "</td>\n";
echo "</tr>\n";
}
}
?>
</table>
</span>
</form>

//////////////////////////////////////////
and this is for ajax inser data
////////////////////////////////////////////
var xmlHttp;

function insertUser(emp, user, pass, email, depar)
{
if (emp.length==0)
{
document.getElementById("employee").innerHTML=""
return
}
xmlHttp=GetXmlHttpObject()
if (xmlHttp==null)
{
alert ("Browser does not support HTTP Request")
return
}
var url="insert_user.php"
url=url+"?employee_name="+emp+"&user="+user+"&password="+pass
+"&e_mail="+email+"&department="+depar
xmlHttp.onreadystatechange=stateChanged
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}

function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
document.getElementById("employee").innerHTML=xmlHttp.responseText
}
}

function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;

//////////////////////////
and this php for insert user data

/////////////////////////////////////////

$sql = "insert into user VALUES(null, '$employee_name', '$user',
'$password', '$e_mail', '$department')";
$result = mysql_query($sql);
if($result)
{
$sql = "select * from user";
$result = mysql_query($sql);
if(@mysql_num_rows($result)!=0)
{
echo "<table border=1 width='500'>";
echo "<tr>";
echo "<th>Employee Name</th>";
echo "<th>Employee Department</th>";
echo "</tr>";
while ($data = mysql_fetch_assoc($result))
{
echo "<tr>\n";
echo "<td>\n";
echo $data['employee_name'];
echo "</td>\n";
echo "<td>\n";
echo $data['employee_Department'];
echo "</td>\n";
echo "<td>\n";
echo "<input type='button' value='Delete' onclick='deleteUser(".
$data['employee_name'].")'>\n";
echo "</td>\n";
echo "</tr>\n";
}
echo "</table>\n";
}

//////////////////////////////////
and this is for ajax deleting data

var xmlHttp;

function deleteUser(emp)
{
alert("HI2");
if (emp.length==0)
{
document.getElementById("employee").innerHTML=""
return
}
xmlHttp=GetXmlHttpObject()
if (xmlHttp1==null)
{
alert ("Browser does not support HTTP Request")
return
}
var url="delete_user.php"
url=url+"?employee_name="+emp
xmlHttp.onreadystatechange=stateChanged
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}

function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
document.getElementById("employee").innerHTML=xmlHttp.responseText
}
}

function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}

///////////////////////
and this for php delete user data

//////////////////////////////////

$sql = "delete from user where employee_name ='$employee_name'";
$result = mysql_query($sql);
if($result)
{
$sql = "select * from user";
//$result =
$result = mysql_query($sql);
if(@mysql_num_rows($result)!=0)
{
echo "<table border=1 width='500'>";
echo "<tr>";
echo "<th>Employee Name</th>";
echo "<th>Employee Department</th>";
echo "</tr>";
while ($data = mysql_fetch_assoc($result))
{
echo "<tr>\n";
echo "<td>\n";
echo $data['employee_name'];
echo "</td>\n";
echo "<td>\n";
echo $data['employee_Department'];
echo "</td>\n";
echo "<td>\n";
echo "<input type='button' value='Delete' onclick='deleteUser(".
$data['employee_name'].")'>\n";
echo "</td>\n";
echo "</tr>\n";
}
echo "</table>\n";
}
////////////////////////

and
thank you for your help
Best
Salim

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация