Advertisement
Guest User

Untitled

a guest
Nov 26th, 2014
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. <div class="row">
  2. <div class="label">Appointment Type:</div><!-- end .label-->
  3. <div class="input">
  4. <select input type="text" id="Booking" class="detail" name="ApptType" value="">
  5. <option value="">Appointment for</option>
  6. <option value="Consultation">Consultation</option>
  7. <option value="Photo Shoot">Photo Shoot</option>
  8. <option value="Dress Fitting">Dress Fitting</option>
  9. </select>
  10. </div><!-- end .input -->
  11. </div><!-- end .row -->
  12.  
  13. <div class="row">
  14. <div class="label">Select Date and Time:</div><!-- end .label-->
  15. <div class="input">
  16. <input type="text" id="DateTime" class="detail" name="DateTime" value="">
  17. </div><!-- end .input-->
  18. </div><!-- end .row -->
  19.  
  20. $validate = mysql_query("SELECT FROM Appointment (Appt_DateTime) where $apptdatetime !== $bookingdatetime");
  21.  
  22. if (!$validate) {
  23.  
  24. echo "Enter Valid Date";
  25.  
  26. } else {
  27.  
  28. return $sql = mysql_query("INSERT INTO Appointment (Client_ID,Svc_ID,Appt_DateTime)
  29. VALUES ('$_POST[ClientID]','$_POST[ApptType]','".date('Y-m-d H:i:s', strtotime($_POST[DateTime]))."')");
  30.  
  31. }
  32.  
  33. mysql_query($conn);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement