i started php nt long ago, went far with a web application project. one day i was goin through an article online. i saw a serious criticism on the three APIs ie MySQL, MySQLi & PDO. where pdo was given priority. is there any problem if i continued with mysql? thank u.

ysd01: i started php nt long ago, went far with a web application project. one day i was goin through an article online. i saw a serious criticism on the three APIs ie MySQL, MySQLi & PDO. where pdo was given priority. is there any problem if i continued with mysql? thank u.

php mysql extension is deprecated.... it is better to learn mysqli and pdo,, cos they are more recent.

edited because micodon is creating unnecessary argument below

mysql ? no no no

MySQL functions are now in the museum.
$mysqli->query is the way

Not a PHP programmer by I belief the following would help.

MySQL: Deprecated

PDO
********************
1. Database support: 12 different drivers
2. API: OOP
3. Connection: Easy
4. Named parameters: Yes
5. Object mapping: Yes
6. Prepared statements: (client side) Yes
7. Performance: Fast
8. Stored procedures: Yes

MySQLi
*****************************
1. Database support: MySQL Only
2. API: OOP + procedural
3. Connection: Easy
4. Named parameters: No
5. Object mapping: Yes
6. Prepared statements: No
7. Performance: Fast
8. Stored procedures: Yes

http://code.tutsplus.com/tutorials/pdo-vs-mysqli-which-should-you-use--net-24059

You would also find helpful information along with comparison here;
http://en.wikipedia.org/wiki/MySQLi

^^That is excellent

uken73: Not a PHP programmer by I belief the following would help.

MySQL: Deprecated

PDO
********************
1. Database support: 12 different drivers
2. API: OOP
3. Connection: Easy
4. Named parameters: Yes
5. Object mapping: Yes
6. Prepared statements: (client side) Yes
7. Performance: Fast
8. Stored procedures: Yes

MySQLi
*****************************
1. Database support: MySQL Only
2. API: OOP + procedural
3. Connection: Easy
4. Named parameters: No
5. Object mapping: Yes
6. Prepared statements: No
7. Performance: Fast
8. Stored procedures: Yes

http://code.tutsplus.com/tutorials/pdo-vs-mysqli-which-should-you-use--net-24059

You would also find helpful information along with comparison here;
http://en.wikipedia.org/wiki/MySQLi

THANX ALOT

okay
[img]http://www.?aff=391[/img]

MySQL is a database Management System.

MySQLi is just an Extension of MySQL. It's Just a different Interface to accessing MySQL functions. Those saying MySQL is deprecated don't know what they are saying.

PDO is not a database system. It's an ABSTRACTION LAYER.

My Point? You shouldn't compare those three. They're functionally different

MySQL functions are deprecated - I said it, just type that into google and press enter - then we will see who knows and who does not know that they are saying.
Technically, you can access mysql database via:
- MySQL functions
- MySQLi functions
- PDO functions
so, the three are related in the first place as they serve as means to connect to, and query the database. However, due to some recent changes, MySQL functions became deprecated, so to use MySQL database now, it is either you use MySQLi or PDO.
Technically, you can still use mysql functions, but some higher versions of PHP will swear for you except you suppress the functions with @ e.g @mysql_query.
Dont come and start confusing us with wrappers and abstraction layer (big big grammars). We all know that mysqli and pdo are not databases.

micodon: MySQL is a database Management System.

MySQLi is just an Extension of MySQL. It's Just a different Interface to accessing MySQL functions. Those saying MySQL is deprecated don't know what they are saying.

PDO is not a database system. It's an ABSTRACTION LAYER.

My Point? You shouldn't compare those three. They're functionally different

Yes MySQL is a database and MySQLi and PDO are just extensions or APIs to connect to MySQL server but so is MySQL...MySQL is the old way of connecting to a MySQL server.

Just last week i wanted to use a feature which was available only on php 5.4, instead of upgrading to 5.4 i upgraded to 5.5 then i got an error that said something like "MySQL has been deprecated as of PHP 5.5.0 and will be removed in the future bla bla bla"

adewasco2k:

Yes MySQL is a database and MySQLi and PDO are just extensions or APIs to connect to MySQL server but so is MySQL...MySQL is the old way of connecting to a MySQL server.

Just last week i wanted to use a feature which was available only on php 5.4, instead of upgrading to 5.4 i upgraded to 5.5 then i got an error that said something like "MySQL has been deprecated as of PHP 5.5.0 and will be removed in the future bla bla bla"

That's talking about the MySQL DLL extension. That's the library that connects PHP with MySQL and it's not written by Oracle. It's written by Zend. Dude know what's happening before you misinform people

dhtml18: MySQL functions are deprecated - I said it, just type that into google and press enter - then we will see who knows and who does not know that they are saying.
Technically, you can access mysql database via:
- MySQL functions
- MySQLi functions
- PDO functions
so, the three are related in the first place as they serve as means to connect to, and query the database. However, due to some recent changes, MySQL functions became deprecated, so to use MySQL database now, it is either you use MySQLi or PDO.
Technically, you can still use mysql functions, but some higher versions of PHP will swear for you except you suppress the functions with @ e.g @mysql_query.
Dont come and start confusing us with wrappers and abstraction layer (big big grammars). We all know that mysqli and pdo are not databases.

MySQL functions ARE NOT DEPRECATED. THE deprecated functions are those written by PHP makers in the php mysql dll that connects PHP to MySQL. PHP have decided that they are not gonna continue with
the library.
You still don't know what you are talking about.

dhtml18: MySQL functions are deprecated - I said it, just type that into google and press enter - then we will see who knows and who does not know that they are saying.
Technically, you can access mysql database via:
- MySQL functions
- MySQLi functions
- PDO functions
so, the three are related in the first place as they serve as means to connect to, and query the database. However, due to some recent changes, MySQL functions became deprecated, so to use MySQL database now, it is either you use MySQLi or PDO.
Technically, you can still use mysql functions, but some higher versions of PHP will swear for you except you suppress the functions with @ e.g @mysql_query.
Dont come and start confusing us with wrappers and abstraction layer (big big grammars). We all know that mysqli and pdo are not databases.

MySQL functions ARE NOT DEPRECATED. THE deprecated functions are those written by PHP makers in the php mysql dll that connects PHP to MySQL. PHP have decided that they are not gonna continue with the library.
You still don't know what you are talking about.

Now I get what you're talking about. You're talking about the MySQL, MySQLi and PDO extensions Written by PHP. Your use of those three should be less ambiguous in future.

PHP's MySQL driver will be removed from PHP 5.6.

MySQLi or PDO? PDO for sure. With PDO, you can Connect to different Database systems with the same code. MySQLi will only connect to MySQL

I have said my own, google knows the correct answer - so whether we argue from here till tomorow, will not change anything.

dhtml18: MySQL functions are deprecated - I said it, just type that into google and press enter - then we will see who knows and who does not know that they are saying.
Technically, you can access mysql database via:
- MySQL functions
- MySQLi functions
- PDO functions
so, the three are related in the first place as they serve as means to connect to, and query the database. However, due to some recent changes, MySQL functions became deprecated, so to use MySQL database now, it is either you use MySQLi or PDO.
Technically, you can still use mysql functions, but some higher versions of PHP will swear for you except you suppress the functions with @ e.g @mysql_query.
Dont come and start confusing us with wrappers and abstraction layer (big big grammars). We all know that mysqli and pdo are not databases.

RYT

micodon:


That's talking about the MySQL DLL extension. That's the library that connects PHP with MySQL and it's not written by Oracle. It's written by Zend. Dude know what's happening before you misinform people

hmmm, some body is smoking weed

Just when you were making sense! where did i mention oracle?

Very true, the guy must be on weeds too for mentioning oracle. Just searched the page for where anyone mentioned oracle.

very dry weed I must say cos he is Jst confusing himself

adewasco2k:

hmmm, some body is smoking weed

Just when you were making sense! where did i mention oracle?

Imagine. So you don't know that Oracle Owns MySQL?

dhtml18: Very true, the guy must be on weeds too for mentioning oracle. Just searched the page for where anyone mentioned oracle.

Ignorance kills. Which Company owns MySQL?? Who's smoking weed?

Jeezus lawd of all mercies! *dies*

micodon:

Imagine. So you don't know that Oracle Owns MySQL?

what has the owner of MYSQL gat to do with wat d OP is trying to achieve

micodon:

Imagine. So you don't know that Oracle Owns MySQL?

what has the owner of MYSQL gat to do with wat d OP is trying to achieve. guy behave!

The guy don dey smoke weed tay tay, first it is oracle, now owner of mysql

Oracle Inc. has a Database System called MySQL Server. But ordinarily, PHP, JAVA, .NET, C++ and so on cannot talk with MySQL.

Each of the companies or groups managing these languages built libraries or drivers having functions that makes talking to MySQL server possible. PHP has php_mysql.dll, php_mysqli.dll and php_pdo.dll (check in your php/ext folder). NET has mysql_connector.dll (or so).

Now, PHP managers are saying that they are going to discontinue development of the php_mysql driver thus deprecating its functions. That's not Oracle's business as their MySQL is still under active development.

All you who go about googling yet not understanding, misinforming and arguing with someone who's been programming for 9 years now without basis, THAT LITTLE EXPLANATION IS FOR YOUR ENLIGHTENMENT

[img]http://t0.gstatic.com/images?q=tbn:ANd9GcRJOdg6cBa--40A2yXg-eahpC6ulTrFfuZ7RVIz657gua3XPB3YY6AE-kA[/img]

@micodon, konk your head and repeat after me - I, micodon don dey madt.

dhtml18: @micodon, know your head and repeat after me - I, micodon don dey madt.

[img]http://t0.gstatic.com/images?q=tbn:ANd9GcRJOdg6cBa--40A2yXg-eahpC6ulTrFfuZ7RVIz657gua3XPB3YY6AE-kA[/img]

micodon:

Imagine. So you don't know that Oracle Owns MySQL?

OMG not again