Advertisement
Guest User

INSERT

a guest
Jul 26th, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.80 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "root";
  4. $password = "";
  5. $dbname = "test";
  6.  
  7. try {
  8.     // Create Connection
  9.     $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  10.     $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  11.  
  12.     //////////////////// INSERT Example //////////////////////////////
  13.     $sql = "INSERT INTO users (first_name, last_name) VALUES (:first_name, :last_name)";
  14.    
  15.     $stmt = $conn->prepare($sql);
  16.     $stmt->bindParam(':first_name', $first_name);
  17.     $stmt->bindParam(':last_name', $last_name);
  18.    
  19.     $first_name = "Donald"
  20.     $last_name = "Trump";
  21.     $stmt->execute();
  22.  
  23.     echo "Inserted user with id: " . $conn->lastInsertId();
  24. }
  25. catch(PDOException $e)
  26. {
  27.     echo "Error: " . $e->getMessage();
  28. }
  29.  
  30. $conn = null;
  31. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement