4'eren sletter i min database? :S
Hele koden:
<?php
require("config.php");
$sql = "SELECT * from test";
$result=mysql_query($sql);
?>
<html>
<head>
<script language="javascript">
function fnDeleteRecord(id){
if(response("Er du sikker på at denne skal slettes?"))
{
if (window.XMLHttpRequest)
{
xmlhttp=new XMLHttpRequest();
}
else (window.ActiveXObject)
{
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
if(xmlhttp)
{
xmlhttp.onreadystatechange=function()
{
if(xmlhttp.readyState==4)
{
if(xmlhttp.responseText == "Lykkedes")
{
//Slet td/tr'en der lige er blevet slettet
}
}
}
xmlhttp.open("GET",'delete.php?action=Delete&id='+id,true);
xmlhttp.send(null);
}
else
{
window.location.href='delete.php?action=Delete&id='+id;
}
</script>
</head>
<body>
<table id="userrecords" border="1" cellpadding="0" cellspacing="0" width="700">
<tr>
<th> User Name </th>
<th> Password </th>
<th> Address </th>
<th> Phone Number </th>
<th> Action </th>
<th> Status </th>
</tr>
<?php
while($row = mysql_fetch_array($result))
{
echo "<tr id='".$row[id]."'>";
echo "<td>".$row['overskrift']."</td>";
echo "<td>".$row['underskrift']."</td>";
echo "<td>".$row['tekst']."</td>";
echo "<td>".$row['username']."</td>";
echo "<td><a href=\"#\" onclick=\"fnDeleteRecord('".$row['id']."');return false;\" >Delete</a></td>";
if($row['status'] == 'enabled')
echo "<td><img src='images/spinner.gif' id='a[$row[id]]' alt=icon border=0 style='display:none;' /><img src='images/enable.png' alt=icon border=0 onClick=fnUpdateStatus('".$row['id']."','disabled') /></td>";
else if ($row['status'] == 'disabled')
echo "<td><img src='images/spinner.gif' id='a[$row[id]]' alt=icon border=0 style='display:none;' /><img src='images/disable.png' alt=icon border=0 onClick=fnUpdateStatus('".$row['id']."','enabled') /></td>";
echo "</tr>";
}
echo "</table>";
?>
</body>
</html>
