i cant seem to find where my problem is with this function. Any help is greatly appreicated.
function update_reservation($room_id, $reg_id, $reserve_date) {
global $db;
$query = 'UPDATE reservations
SET room_id = :room_id,
reserve_date = :reserve_date,
WHERE reg_id =:reg_id';
try {
$statement = $db->prepare($query);
$statement->bindValue(':room_id', $room_id);
$statement->bindValue(':reserve_date', $reserve_date);
$statement->bindValue(':reg_id', $reg_id);
$row_count = $statement->execute();
$statement->closeCursor();
return $row_count;
} catch (PDOException $e) {
$error_message = $e->getMessage();
display_db_error($error_message);
}
}
<form action="." method="post" id="add_edit_reservation_form">
<?php if (isset($reg_id)) : ?>
<input type="hidden" name="action" value="update_reservation" />
<label>Reservation ID:</label>
<input type="text" name="reg_id" value="<?php echo $reg_id ?>" />
<?php else: ?>
<input type="hidden" name="action" value="add_reservation" />
<label>User_ID</label>
<input type="text" name="ms_user_id" value="<?php echo $user_info['ms_user_id']; ?>" />
<?php endif; ?>
<label>Which room would you like?</label>
<select name="room_id">
<?php foreach ($room_ids as $room_id) :
if ($room_id['room_id'] == $reservation['room_id']) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $room_id['room_id']; ?>" <?php
echo $selected ?>>
<?php echo $room_id['room_name']; ?>
</option>
<?php endforeach; ?>
</select><br>
<label>What date would you like to reserve your room?</label>
<input type="date" name="reserve_date"
value="<?php echo ($reservation['reserve_date']); ?>"><br>
<label>Please submit form to reserve your room.</label>
<input type="submit" value="Submit">
</form>