CODEWITHSUNDEEP
phpmysql
jingchyu
jingchyu

Reputation: 159

Does PDO implements mysqli or mysql

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?

Upvotes: 2

Views: 253

Answers (4)

artragis
artragis

Reputation: 3713

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.

Upvotes: 0

Vijaya Pandey
Vijaya Pandey

Reputation: 4282

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. ;)

Upvotes: 0

Explosion Pills
Explosion Pills

Reputation: 191749

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

Upvotes: 2

Yogesh Suthar
Yogesh Suthar

Reputation: 30488

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.

Upvotes: 1

Related Questions