1 / 11

PDO: PHP Data Objects

PDO: PHP Data Objects. CSCI 215 Tina Ostrander. PDO: What?. PDO - PHP Data Object An interface for accessing databases in PHP Provides a data-access abstraction layer Same functions are used across DBMSs Object-oriented. PDO: Why?. Portability Speed Security

milo
Download Presentation

PDO: PHP Data Objects

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. PDO:PHP Data Objects CSCI 215 Tina Ostrander

  2. PDO: What? • PDO - PHP Data Object • An interface for accessing databases in PHP • Provides a data-access abstraction layer • Same functions are used across DBMSs • Object-oriented

  3. PDO: Why? • Portability • Speed • Security • Supports prepared statements • Pre-compiled SQL statements that accept zero or more parameters • Prevents SQL injection by using placeholders for data

  4. Get connected This creates a database object called $dbh try { /*** instantiate a database object ***/ $dbh = new PDO("mysql:host=$hostname;dbname=myDB",$username, $password);echo 'Connected to database';}catch(PDOException $e) {    echo $e->getMessage(); }

  5. Insert $sql = "INSERT INTO animals(animal_type, animal_name)  VALUES ('kangaroo', 'troy')"; $dbh->exec($sql); //Get the ID of the last inserted row $id = $dbh->lastInsertId(); lastInsertId() returns the ID of the last inserted row

  6. Update $sql= "UPDATE animals SET animal_name='Joey' WHERE animal_name='Troy'"; //exec() returns the number of rows affected $count = $dbh->exec($sql); print "$count rows were updated."; exec() returns the number of rows affected

  7. Delete $sql= "DELETE FROM animals WHERE animal_type='kangaroo'"; //exec() returns the number of rows affected $count = $dbh->exec($sql); print "$count rows were deleted.";

  8. Select One Row //Define the query $sql = "SELECT * FROM animals WHERE animal_id = 3"; //query() returns the result$result = $dbh->query($sql); //fetch() returns the first row$row = $result->fetch();print $row['animal_type'] . ' - '. $row['animal_name']; query() returns a result set fetch() returns a single row

  9. Select Multiple Rows //Define the query $sql = "SELECT * FROM animals"; //query() returns the result$result = $dbh->query($sql); //iterate through the result set foreach($result as $row) { print $row['animal_type'] . ' - '. $row['animal_name']; }

  10. Common Methods

  11. References • PDO Manual • PDO Tutorial I • PDO Tutorial II

More Related