Advertisement
zero50x

Проверка даты и занесение в БД

Nov 12th, 2015
186
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.73 KB | None | 0 0
  1. function CheckTrueDate($date){
  2.     $d = trim($date);
  3.     $DArr = explode(",", $d);
  4.         for ($i = 0; $i < count($DArr); $i++) {
  5.             intval($DArr[$i]);
  6.         }
  7.     return checkdate($DArr[0], $DArr[1], $DArr[2]);
  8. }
  9.  
  10.  
  11. if(isset($_POST['add']) && isset($_POST['date'])){
  12.  
  13. $CheckDate = CheckTrueDate($_POST['date']);
  14. echo "$CheckDate<br><br>";
  15.  
  16.     $a = '2007-08-09 01:00:00';
  17.     $b = '2007-08-09 08:00:00';
  18.    
  19.     $st = $pdo->prepare('set profiling=1');
  20.     $st->execute();
  21.    
  22.     $st = $pdo->prepare('SELECT `timastamp` FROM `date` WHERE `timastamp` BETWEEN :a AND :b ');
  23.     $st->bindParam(':a', $a);
  24.     $st->bindParam(':b', $b);
  25.     $st->execute();
  26.     $KeyInDB = $st->fetchAll();
  27.  
  28.     var_dump($KeyInDB);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement