01. <?php
02.
03. $serverName = "localhost";
04. $userName = "root";
05. $userPassword = "44@44";
06. $dbName = "mydatabase";
07. $conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
08.
09.
10.
11. $customer = " SELECT * FROM customer ";
12. $Q_customer = mysqli_query($conn,$customer);
13.
14.
15.
16.
17. ?>
18. <?php
19.
20. $CheckBox = $_POST['Ch_INSERT'];
21. if(isset($_POST["SAVE"]))
22. {
23. if(empty($CheckBox) || $CheckBox == 0 ) {
24. echo "Please Select Checkbox after click Save!!!";
25. }else{
26. foreach($_POST['Ch_INSERT'] as $i)
27. {
28. $INSERT = "INSERT INTO user (UserID,
29. UserName,
30. Email)
31. VALUES
32. ('{$_POST['CustomerID'][$i]}',
33. '{$_POST['Name'][$i]}',
34. '{$_POST['Email'][$i]}')";
35. $Q_INSERT = mysqli_query($conn,$INSERT);
36. }
37. }
38. if($Q_INSERT)
39. {
40. echo "<script> alert('SAVE DONE !!!') </script>";
41. }
42.
43. }
44. ?>
45.
46.
47.<form action="#" name="Frm1" id="Frm1" method="post" enctype="multipart/form-data">
48.<table width="100%" border="1" cellspacing="0" cellpadding="0">
49. <tr>
50. <td colspan="7" align="center">PHP MYSQLI INSERT BY CHECKBOX</td>
51. </tr>
52. <tr>
53. <td>CustomerID</td>
54. <td>Name</td>
55. <td>Email</td>
56. <td>CountryCode</td>
57. <td>Budget</td>
58. <td>Used</td>
59. <td>Checkbox</td>
60. </tr>
61. <?php
62. $i = 0;
63. while ($row = mysqli_fetch_array($Q_customer,MYSQLI_ASSOC))
64. {
65.
66. ?>
67. <tr align="center">
68. <td> <input type="text" name="CustomerID[]" id="CustomerID"
69. value="<?php echo $row["CustomerID"]; ?>" />
70. </td>
71. <td> <input type="text" name="Name[]" id="Name"
72. value="<?php echo $row["Name"]; ?>" />
73. </td>
74. <td> <input type="text" name="Email[]" id="Email"
75. value="<?php echo $row["Email"]; ?>" />
76. </td>
77. <td> <input type="text" name="CountryCode[]" id="CountryCode"
78. value="<?php echo $row["CountryCode"]; ?>" />
79. </td>
80. <td> <input type="text" name="Budget[]" id="Budget"
81. value="<?php echo $row["Budget"]; ?>" />
82. </td>
83. <td> <input type="text" name="Used[]" id="Used"
84. value="<?php echo $row["Used"]; ?>" />
85. </td>
86. <td> <input type="checkbox" name="Ch_INSERT[]" id="Ch_INSERT" value="<?php echo $i++; ?>" /></td>
87. </tr>
88. <?php } ?>
89. <tr>
90. <td colspan="7" align="center"><input type="submit" id="SAVE" name="SAVE[]" value="SAVE" /></td>
91.
92. </tr>
93.</table>
94.</form>
