Advertisement
michaelyuen

Untitled

Mar 9th, 2019
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.59 KB | None | 0 0
  1. public function create_wish_list($title,$product,$price,$message)
  2.     {
  3.         $db = DB();
  4.         $joindate = date("F j, Y, g:i a");
  5.         $stmt = $db->prepare("INSERT INTO wishlist(title,product,price,description,JOINDATE)
  6.             VALUES(:utitle, :uproduct, :uprice, :umessage, :JOINDATE)");
  7.         $stmt->execute([
  8.             ':utitle' => $title,
  9.             ':uproduct' => $product,
  10.             ':uprice' => $price,
  11.             ':umessage' => $message,
  12.             ':JOINDATE' => $joindate
  13.         ]);
  14.  
  15.         if ($stmt->rowCount() == 1) {
  16.             return $db->insert_id;  // Reference: http://php.net/manual/en/mysqli.insert-id.php
  17.         } else {
  18.             return false;
  19.         }
  20.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement