mysqli or PDO – what are the pros and cons? [closed]

by

Well, you could argue with the object oriented aspect, the prepared statements, the fact that it becomes a standard, etc. But I know that most of the time, convincing somebody works better with a killer feature. So there it is:

A really nice thing with PDO is you can fetch the data, injecting it automatically in an object. If you don’t want to use an ORM (cause it’s a just a quick script) but you do like object mapping, it’s REALLY cool :

class Student {

    public $id;
    public $first_name;
    public $last_name

    public function getFullName() {
        return $this->first_name.' '.$this->last_name
    }
}

try 
{
    $dbh = new PDO("mysql:host=$hostname;dbname=school", $username, $password)

    $stmt = $dbh->query("SELECT * FROM students");

    /* MAGIC HAPPENS HERE */

    $stmt->setFetchMode(PDO::FETCH_INTO, new Student);


    foreach($stmt as $student)
    {
        echo $student->getFullName().'<br />';
    } 

    $dbh = null;
}
catch(PDOException $e)
{
    echo $e->getMessage();
}

More Related Contents:

  1. Can I mix MySQL APIs in PHP?
  2. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  3. How to prevent duplicate usernames when people register?
  4. What is the difference between MySQL, MySQLi and PDO? [closed]
  5. PHP PDO and MySQLi [duplicate]
  6. Unknown database error in PHP but it exists in PHPMyAdmin
  7. PHP: mysql v mysqli v pdo [closed]
  8. Save the data into a database and return another value from database using PHP
  9. inserting information and image in php and mysql
  10. Insert form in MySQL with PDO [duplicate]
  11. Undefined index $_POST
  12. mysqli or die, does it have to die?
  13. Why is mysqli giving a “Commands out of sync” error?
  14. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  15. PDO with INSERT INTO through prepared statements [closed]
  16. PDO::fetchAll vs. PDO::fetch in a loop
  17. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  18. Real escape string and PDO [duplicate]
  19. PHP PDO vs normal mysql_connect
  20. Can I create a database using PDO in PHP?
  21. PDO fetch one column from table into 1-dimensional array
  22. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  23. Getting a PHP PDO connection from a mysql_connect()?
  24. Having issue with matching rows in the database
  25. Set PDO to throw exceptions by default [duplicate]
  26. php password_verify() hash and pass won’t match
  27. PHP to MySQL SSL Connections
  28. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  29. How to get a list of databases?
  30. PDO and MySQL ‘between’

Leave a Comment