Abundances Posted April 16, 2014 Share Posted April 16, 2014 (edited) if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $result = mysqli_query($con,"SELECT * FROM Request"); echo "<table border='1'> <tr> <th>First Name</th> <th>Last Name</th> <th>Prayer Request</th> <th>Deactivate Request</th> </tr>"; while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['Reg_F_Name'] . "</td>"; echo "<td>" . $row['Reg_L_Name'] . "</td>"; echo "<td>" . $row['Reg_Request'] . "</td>"; echo "<td><input name=\"checkbox[]\" type=\"checkbox\" id=\"checkbox[]\" value=\"".$rows['Reg_ID']. "\" /></td>"; echo "</tr>"; } echo "</table>"; echo "<form action='' method='post'> <input type='submit' name='use_button' value='Update' /> </form>"; if(isset($_POST['use_button'])) { echo "Updated"; $update_id = $_POST['checkbox']; foreach($update_id as $value){ $sql = "Update Request set Reg_Status=0 WHERE Reg_ID='".$value."'"; $result = mysql_query($sql); } } mysqli_close($con); ?> the database is not updated when i click update. Edited April 16, 2014 by Abundances Quote Link to comment https://forums.phpfreaks.com/topic/287824-issue-with-updating-database-from-checkboxes-in-table/ Share on other sites More sharing options...
QuickOldCar Posted April 16, 2014 Share Posted April 16, 2014 You are mixing mysqli_ and mysql_ functions $result = mysql_query($sql); Quote Link to comment https://forums.phpfreaks.com/topic/287824-issue-with-updating-database-from-checkboxes-in-table/#findComment-1476401 Share on other sites More sharing options...
Abundances Posted April 16, 2014 Author Share Posted April 16, 2014 What changes do i need to make to have it update the records that have been selected with the check boxes Quote Link to comment https://forums.phpfreaks.com/topic/287824-issue-with-updating-database-from-checkboxes-in-table/#findComment-1476403 Share on other sites More sharing options...
QuickOldCar Posted April 16, 2014 Share Posted April 16, 2014 $con->query($sql); Quote Link to comment https://forums.phpfreaks.com/topic/287824-issue-with-updating-database-from-checkboxes-in-table/#findComment-1476407 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.