MjM8082 Posted August 16, 2011 Share Posted August 16, 2011 Need help with this UPDATE statement... This is my code right now for my form. I run this in my Web Browser and fill out the form but the information still wont carry over to the database. Here is my code... <html> <head> <title>Update User</title> </head> <body> <form method="post" action="update_user2.php"> <?php $dbc = mysqli_connect('localhost', 'se266_user', 'pwd', 'se266') or die(mysql_error()); //delete users echo '<b>Delete or Update User</b>.<br />'; if (isset($_POST['remove'])) { foreach($_POST['delete'] as $delete_id) { $query = "DELETE FROM users WHERE course_id = $delete_id"; mysqli_query($dbc, $query) or die ('can\'t delete course'); } echo 'user has been deleted.<br />'; } if (isset($_POST['update'])) { foreach($_POST['update'] as $update_id) { $course_id = $_POST['course_id']; $course_name = $_POST['course_name']; $student_id = $_POST['student_id']; $query = "UPDATE users SET course_name = $course_name WHERE course_id = $course_id"; mysqli_query($dbc, $query) or die ('can\'t update course'); $update_count = $db->exec($query); } echo 'course has been updated.<br />'; } //display users info with checkbox to delete $query = "SELECT * FROM users"; $result = mysqli_query($dbc, $query); while($row = mysqli_fetch_array($result)) { echo '<input type="checkbox" value="' .$row['course_id'] . '" name="delete[]" />'; echo ' ' .$row['course_name'] .' '. $row['student_id']; echo '<br />'; } mysqli_close($dbc); ?> <input type="submit" name="remove" value="Remove" /> <input type="submit" name="update" value="Update" /> <br> <br> <form method="POST" action="update_user2.php"> <label for="course_id">Course ID:</label> <input type="text" id="course_id" name="course_id" /><br /> <label for="course_name">Course Name:</label> <input type="text" id="course_name" name="course_name" /><br /> <label for="course_name">Student ID:</label> <input type="text" id="student_id" name="student_id" /><br /> </form> </body> </html> Link to comment https://forums.phpfreaks.com/topic/244951-anyone-good-with-update-statements/ Share on other sites More sharing options...
voip03 Posted August 16, 2011 Share Posted August 16, 2011 $query = "UPDATE users SET course_name ='". $course_name ."' WHERE course_id = $course_id"; Link to comment https://forums.phpfreaks.com/topic/244951-anyone-good-with-update-statements/#findComment-1258263 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.