Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $query = "INSERT INTO `event` (`date`, `name`, `signup_start`, `signup_end`) VALUES (:date, :name, :signup_start, :signup_end)";
- $sql = $pdo->prepare($query);
- $sql->bindParam(':date', $this->date->format("Y-m-d"));
- $sql->bindParam(':name', $this->name);
- $sql->bindParam(':signup_start', $this->signup_start->format("Y-m-d H:i:s"));
- $sql->bindParam(':signup_end', $this->signup_end->format("Y-m-d H:i:s"));
- $sql->execute();
- if ($sql->errorCode() != "00000") {
- throw new Exception("[" . $sql->errorCode() . "]" . " " . $sql->errorInfo());
- } else {
- $last_insert_id = $pdo->lastInsertId();
- return true;
- }
Advertisement
Add Comment
Please, Sign In to add comment