01.<html>
02.<head>
03.<title>ThaiCreate.Com PHP & MySQL Tutorial</title>
04.</head>
05.<body>
06.<script language="JavaScript">
07. function ClickCheckAll(vol)
08. {
09.
10. var i=1;
11. for(i=1;i<=document.frmMain.hdnCount.value;i++)
12. {
13. if(vol.checked == true)
14. {
15. eval("document.frmMain.chkDel"+i+".checked=true");
16. }
17. else
18. {
19. eval("document.frmMain.chkDel"+i+".checked=false");
20. }
21. }
22. }
23.
24. function onDelete()
25. {
26. if(confirm('Do you want to delete ?')==true)
27. {
28. return true;
29. }
30. else
31. {
32. return false;
33. }
34. }
35.</script>
36.<form name="frmMain" action="phpMySQLDeleteMultiRecord.php" method="post" OnSubmit="return onDelete();">
37.<?
38.$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
39.$objDB = mysql_select_db("mydatabase");
40.$strSQL = "SELECT * FROM customer";
41.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
42.?>
43.<table width="600" border="1">
44. <tr>
45. <th width="91"> <div align="center">CustomerID </div></th>
46. <th width="98"> <div align="center">Name </div></th>
47. <th width="198"> <div align="center">Email </div></th>
48. <th width="97"> <div align="center">CountryCode </div></th>
49. <th width="59"> <div align="center">Budget </div></th>
50. <th width="71"> <div align="center">Used </div></th>
51. <th width="30"> <div align="center">
52. <input name="CheckAll" type="checkbox" id="CheckAll" value="Y" onClick="ClickCheckAll(this);">
53. </div></th>
54. </tr>
55.<?
56.$i = 0;
57.while($objResult = mysql_fetch_array($objQuery))
58.{
59.$i++;
60.?>
61. <tr>
62. <td><div align="center"><?=$objResult["CustomerID"];?></div></td>
63. <td><?=$objResult["Name"];?></td>
64. <td><?=$objResult["Email"];?></td>
65. <td><div align="center"><?=$objResult["CountryCode"];?></div></td>
66. <td align="right"><?=$objResult["Budget"];?></td>
67. <td align="right"><?=$objResult["Used"];?></td>
68. <td align="center"><input type="checkbox" name="chkDel[]" id="chkDel<?=$i;?>" value="<?=$objResult["CustomerID"];?>"></td>
69. </tr>
70.<?
71.}
72.?>
73.</table>
74.<?
75.mysql_close($objConnect);
76.?>
77.<input type="submit" name="btnDelete" value="Delete">
78.<input type="hidden" name="hdnCount" value="<?=$i;?>">
79.</form>
80.</body>
81.</html>
