وجدنا الحل
كود PHP:
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
function checkAll(field)
{
var drearray = affect.elements;
for (i = 0; i < drearray.length; i++)
drearray[i].checked = true ;
}
function uncheckAll(field)
{
var drearray = affect.elements;
for (i = 0; i < drearray.length; i++)
drearray[i].checked = false ;
}
// End -->
</script>
كود PHP:
<?
$total = mysql_query("SELECT * FROM crm_clients WHERE campagne='$cmp' and client='TN' ");
$total_num = mysql_num_rows($total);
?>
<form action="do.php" method="post" name=affect>
<?
while($row = mysql_fetch_array($total){
?>
<table border="1" width="100%" id="table1" style="font-family:tahoma;font-size:11px" bgcolor=c1c1c1>
<tr>
<td><input type="checkbox" name=check[] value="<? echo $row[id]; ?>" > </ttd>
<td><? echo $row[nom]; ?></td>
<td><? echo $row[tel]; ?></td>
<td><? echo $rowr[fax]; ?></td>
<td><? echo $row[code_fiscal]; ?></td>
</tr>
</table>
<?
}
?>
<table border="1" width="100%" id="table1">
<tr><td><input type="button" name="CheckAll" value="Check All"
onClick="checkAll(affect)">
</td><td><input type="button" name="UnCheckAll" value="Uncheck All"
onClick="uncheckAll(affect)"></td></tr>
</table>
<input type=submit value=go>
</form>
Do.php
كود PHP:
//اتصال بالقاعدة هنا
foreach($_POST[check] as $val){
$upd = mysql_query("UPDATE crm_clients SET paid_client='$ss' WHERE id='$val' ");
echo "<font face=tahoma size=1>$val تم تعديله ( تم دفع الإعتمادات المالية ) <br>";
}