Faced the following problem, information from the form is not entered into the database, but if I remove the id = "datepicker" from the line

<input name = "datepicker" type="text" id="datepicker" value="" /> 

Everything starts to work right away (but id = "datepicker" needs a calendar from JQuery to work)

Form Code:

  <form action="reserve_room_process.php" method="post"> <input name="user_id" type="hidden" value="<?php echo $_SESSION["username"];?>" /> <input name="name" type="hidden" value="<?php echo $nameOfUser; ?>" /> <input name="room" type="hidden" value="1" /> <p>Choose time for meeting room: <input name = "datepicker" type="text" id="datepicker" value="" /> <select name="time"> <option value="9">9:00</option>; <option value="10">10:00</option>; <option value="11">11:00</option>; <option value="12">12:00</option>; <option value="13">13:00</option>; <option value="14">14:00</option>; <option value="15">15:00</option>; <option value="16">16:00</option>; <option value="17">17:00</option>; <option value="14">18:00</option>; <option value="14">19:00</option>; </select> </p> <input type="submit" name="submit" value="Reserve" /> <br /><br /> <!-- <a href="manage_content.php">Cancel</a>--> </table> </form> 

Handler Code:

 if(isset($_POST['submit'])){ $user_id = $_POST["user_id"]; $name = $_POST["name"]; $time = (int) $_POST["time"]; $date = $_POST["datepicker"]; $room = $_POST["room"]; $visible = 0 ; $currentTime = (int)date('H'); $query = "INSERT INTO room_reserv (user_id , name , rtime , rdate, room) VALUES ('{$user_id}' , '{$name}' ,'{$time}' , '{$date}', '{$room}') "; $result = mysqli_query($connection, $query) or die(mysqli_error($connection)); redirect_to("discussion.php"); } 
  • Since the server does not know what kind of id you have there, then you probably have some kind of js-magic transmitting data to the server. - u_mulder
  • I just have the standard Jquery c datepicker library, can you tell me what you need to add to make it work? - pavel

1 answer 1

Try a different name, for example.

 <input name = "date_picker" type="text" id="datepicker" value="" />