Soeren_K_K

For at bruge PDO

Dec 30th, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.66 KB | None | 0 0
  1.         $query = "INSERT INTO `event` (`date`, `name`, `signup_start`, `signup_end`) VALUES (:date, :name, :signup_start, :signup_end)";
  2.  
  3.  
  4.         $sql = $pdo->prepare($query);
  5.  
  6.  
  7.         $sql->bindParam(':date', $this->date->format("Y-m-d"));
  8.  
  9.         $sql->bindParam(':name', $this->name);
  10.  
  11.         $sql->bindParam(':signup_start', $this->signup_start->format("Y-m-d H:i:s"));
  12.  
  13.         $sql->bindParam(':signup_end', $this->signup_end->format("Y-m-d H:i:s"));
  14.  
  15.  
  16.         $sql->execute();
  17.  
  18.  
  19.         if ($sql->errorCode() != "00000") {
  20.  
  21.             throw new Exception("[" . $sql->errorCode() . "]" . " " . $sql->errorInfo());
  22.  
  23.         } else {
  24.  
  25.  
  26.             $last_insert_id = $pdo->lastInsertId();
  27.  
  28.  
  29.             return true;
  30.  
  31.  
  32.         }
Advertisement
Add Comment
Please, Sign In to add comment