Does PDO implements mysqli or mysql

Question

I'm using PDO and I got this message, but from what I found I thought PDO actually implemented mysqli.

You are using PHP's deprecated 'mysql' extension, which is not capable of handling multi queries. The execution of some stored routines may fail! Please use the improved 'mysqli' extension to avoid any problems.

Why do I get this message, then?

yes mysql_* api is deprecated you have to use new api for connecting to database like pdo or mysqli — Arun Killu, Apr 25 '13 at 03:50
@ArunKillu So if I use pdo there is no need for mysqli right? — jingchyu, Apr 25 '13 at 03:53
Yeah. `PDO` implements `mysqli` instead of `mysql`. Just check out a latest version. — BlitZ, Apr 25 '13 at 03:54
I suppose it would be useful to get more detail of the PDO version and if other thing in your setup could be connecting without PDO. — madth3, Apr 25 '13 at 15:33

score 2 · Answer 1 · answered Apr 25 '13 at 03:51

This is almost like asking what's the difference between DOMDocument and SimpleXML or what's the difference between php and python. They're different libraries, although they're both for interfacing with a MySQL database server.

PHP has done quite a nice job of cataloging the differences

score 1 · Answer 2 · answered Apr 25 '13 at 03:50

1

Mysql doesn't support for running multiple queries at a time. Mysql also doesn't support for prepared statement. Because of that you have to use Mysqli, it supports both.

answered Apr 25 '13 at 03:50

Yogesh Suthar

30,424
18
72
100

`php_mysql` doesn't support stored procedures as well. – BlitZ Apr 25 '13 at 03:51
@user2308038 Install `mysqli` extension on your server and use this tutorial http://php.net/manual/en/book.mysqli.php – Yogesh Suthar Apr 25 '13 at 03:53

score 0 · Answer 3 · edited May 23 '17 at 12:28

0

There are a lot of discussion on this topic previously. You better search on the Internet (Even only in the Stackoverflow).

Like:

What is difference between mysql,mysqli and pdo?

Difference between mysqli and mysql?

You need to do more research man. Think critically and be a programmer. ;)

edited May 23 '17 at 12:28

Community

1
1

answered Apr 25 '13 at 04:00

Vijaya Pandey

4,252
5
32
57

I was not asking the difference between them. I was asking why using PDO prompted that message since from what I found PDO actually implemented mysqli. – jingchyu Apr 25 '13 at 04:29
then, first link would be better for you. – Vijaya Pandey Apr 25 '13 at 04:31

score 0 · Answer 4 · answered Apr 25 '13 at 16:18

I thought PDO actually implemented mysqli.

Nice question but false though. PDO implements the interface so that you can use all Database System. So, it just can't implement some features from mysqli as they require some special features that are not yet emulated for SQLite for example ! You can find similar issues when you compare PDO and pgsql_ API.

Does PDO implements mysqli or mysql

4 Answers4