Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "localhost";
- $username = "username";
- $password = "password";
- $dbname = "myDBPDO";
- DB::Connect("mysql:host=$servername;dbname=$dbname", $username, $password);
- // Insert your thing:
- DB::Insert('MyGuests', ['firstname'=>'John', 'lastname'=>'Doe', 'email'=>'john@example.com']);
- // Query:
- DB::Query("SELECT * FROM whatever WHERE name = :name AND size = :size", [':size'=>10, ':name'=>'hello']);
- // Query 1 row
- DB::QueryRow("SELECT name,length FROM whatever WHERE id = :id", [':id'=>5]);
- // Query a single value
- DB::QueryValue("SELECT name FROM whatever WHERE id = :id", [':id'=>5]);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement