Advertisement
Guest User

Untitled

a guest
Apr 30th, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. <?php
  2. dateIndaysoff($_GET['date']);
  3. function dateIndaysoff($mydate){
  4. if(!$mydate)return false;
  5.  
  6.  
  7. $host = "localhost";
  8. $user = "user";
  9. $pass = "pass";
  10. $databaseName = "db";
  11. $con = new mysqli($host,$user,$pass,$databaseName);
  12. if ($con->connect_error) {
  13. die("Connection failed: " . $conn->connect_error);
  14. }
  15.  
  16. $query = "SELECT date FROM table WHERE date = '$mydate'";
  17. $result = $con->query($query);
  18. if ($result->num_rows < 1) {$exists = "FALSE";} else {$exists = "TRUE";}
  19. return $exists;
  20. }
  21. ?>
  22.  
  23. jQuery(".datepicker").change(function() {
  24. var val = jQuery(this).datepicker().val();
  25. var finalval = jQuery.get("url-to-phpfile/daysoff.php",{date:val});
  26. if (finalval) {
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement