Advertisement
meowmeowcats

Untitled

Jun 12th, 2016
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "username";
  4. $password = "password";
  5. $dbname = "myDBPDO";
  6.  
  7. DB::Connect("mysql:host=$servername;dbname=$dbname", $username, $password);
  8.  
  9. // Insert your thing:
  10. DB::Insert('MyGuests', ['firstname'=>'John', 'lastname'=>'Doe', 'email'=>'john@example.com']);
  11.  
  12. // Query:
  13. DB::Query("SELECT * FROM whatever WHERE name = :name AND size = :size", [':size'=>10, ':name'=>'hello']);
  14.  
  15. // Query 1 row
  16. DB::QueryRow("SELECT name,length FROM whatever WHERE id = :id", [':id'=>5]);
  17.  
  18. // Query a single value
  19. DB::QueryValue("SELECT name FROM whatever WHERE id = :id", [':id'=>5]);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement