| |
автор: Dark Smoke (05.02.2005 в 14:55) |
|
| | <html>
<body>
<?
$db = mysql_connect("localhost", "dsorder","qwerty");
mysql_select_db("dsorder",$db);
$result = mysql_query("SELECT * FROM zadd",$db);
$num=0;
echo "<table border=0 cellSpacing=2 cellPadding=0>\n";
echo "<tr><td bgcolor=#E0F0E0>Íîìåð</td><td bgcolor=#E0F0E0>Äàòà</td><td bgcolor=#E0F0E0>Ô.È.Î.</td><td bgcolor=#E0F0E0>Àäðåññ</td><td bgcolor=#E0F0E0>Ýòàæ</td><td bgcolor=#E0F0E0>Êîä</td><td bgcolor=#E0F0E0>Òåëåôîí</td><td bgcolor=#E0F0E0>Ìîá.òåë.</td><td bgcolor=#E0F0E0>IP</td><td bgcolor=#E0F0E0>Óïðàâ.</td></tr>\n";
while ($myrow = mysql_fetch_row($result))
{
$num++;
printf("<tr><td bgcolor=#E0E0E0>%s</td><td bgcolor=#E0E0E0>%s</td><td bgcolor=#E0E0E0>%s</td><td bgcolor=#E0E0E0>%s</td><td bgcolor=#E0E0E0>%s</td><td bgcolor=#E0E0E0>%s</td><td bgcolor=#E0E0E0>%s</td><td bgcolor=#E0E0E0>%s</td><td bgcolor=#E0E0E0>%s</td> <td bgcolor=#E0E0E0><form action=show_tmp.php method=\"get\"><input type=checkbox name=Check[] value=\"{$myrow[0]}\"></td></tr>\n", $myrow[0], $myrow[1], $myrow[3], $myrow[4], $myrow[6], $myrow[7], $myrow[5], $myrow[8], $myrow[2]);
}
echo "</table>\n";
echo "<b>Âñåãî çàÿâîê $num</b>";
#################################
# delete
if(!empty($del))
{
if(isset($Check) && (count($Check) > 0))
{
for ($i = 0; $i < count($Check); $i++)
{
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!
Что здксь надо написать чтобы удалялись строки из БД те что отмеченны!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
}
#print ("<br>Number of selected checkboxes = $i");
}
# else
# {
# print ("No selected checkboxes");
# }
}
# end delete
################################
echo "<br><br><input type='submit' name='del' value='Óäàëèòü'></form>";
?>
</body>
</html> | |
| |
|
