Thanks!
here is the code:
Code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title></title>
<script language="javascript">
function loud1(basenm, min, max)
{
var mt1 = new Array;
fr1.data.value="";
var e, picked = 0;
for(var i = min; i < max; i++)
{
if (document.fr1.elements[basenm + i].checked==true)
{
mt1[i] = document.fr1.elements[basenm + i].value;
//confirm(mt1[i]);
e = document.fr1.elements[basenm + i]
picked++;
fr1.data.value = fr1.data.value + "\"" + e.value + "\";";
}
}
fr1.data.value = fr1.data.value;
}
function setCheckboxesRange(the_form, do_check, basename, min, max)
{
for (var i = min; i < max; i++)
{
if (typeof(document.forms[the_form].elements[basename + i]) != 'undefined')
{
document.forms[the_form].elements[basename + i].checked = do_check;
}
if (typeof(document.forms[the_form].elements[basename + i + 'r']) != 'undefined')
{
document.forms[the_form].elements[basename + i + 'r'].checked = do_check;
}
}
return true;
}
</script>
</head>
<body text="#333333" link="#333333" vlink="#333333" alink="#333333">
<?php
$next = $HTTP_SERVER_VARS['QUERY_STRING'];
$mode1 = isset($HTTP_GET_VARS['user']);
$filename = $HTTP_GET_VARS["next"];
$filename1 = $HTTP_GET_VARS["next1"];
$link = mysql_connect('xxxx', 'xxxx', 'xxxx');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('xxxxx');
if (empty($HTTP_GET_VARS["next"]))
{
global $data;
$sql = ("SELECT * FROM userreg LIMIT 0 , 30");
$result = mysql_query($sql);
$num = mysql_numrows($result);
echo "<form name=\"fr1\" action=\"deldata.php?next=deletedata&next1=$data\" method=\"POST\" onsubmit=\"javascript:loud1('deldata', 1, ".$num.");\"><table>";
for($i=1; $i<$num+1; $i++)
{
$row = mysql_fetch_array($result);
echo("<tr bgcolor=\"#ccffee\"><td><input type=\"checkbox\" name=\"deldata".$i."\" value=\"DELETE FROM `userreg` WHERE `username` = '".$row['username']."' LIMIT 1\">".$row['username']."</td><td>".$row['password']."<br></td></tr>");
}
echo "<a href=\"#\" onclick=\"setCheckboxesRange('fr1', true, 'deldata', 0, ".$i."); return false;\">Check All</a> <a href=\"#\" onclick=\"setCheckboxesRange('fr1', false, 'deldata', 0, ".$i."); return false;\">Uncheck All</a>";
echo "<tr><td> </td><td> </td></tr><tr><td align=right>";
echo "<input type=hidden name=\"data\" value=\"\">";
echo "<input type=hidden name=action value=3>";
echo "<input type=\"submit\" name=\"deletedata\" value=\"DELETE\">";
echo "</td>";
echo "</tr>";
echo "</table></form><br><br>";
}
if ($action == "3")
{
$picks = urldecode(stripslashes($data));
$data1=split(";",$picks);
array_pop($data1);
foreach ($data1 as $k => $v )
{
echo "row to be deleted: (".$data1[$k].") <br><br>";
$sql = ($data1[$k]);
$result = mysql_query($sql);
}
$sql1 = ("SELECT * FROM userreg LIMIT 0 , 30");
$result1 = mysql_query($sql1);
$num = mysql_numrows($result1);
echo "<table>";
for($i=0; $i<$num; $i++)
{
$row = mysql_fetch_array($result1);
echo("<tr bgcolor=\"#ccffee\"><td><input type=\"checkbox\" name=\"deldata\" value=\"".$row['username']."\">".$row['username']."</td><td>".$row['password']."<br></td></tr>");
}
echo "</table>";
}
?>
</body>
</html>
hope this will help you to understand.