Plot to kill mysql extensions

Programming for Search Engines 101. An area for avid PHP and .NET developers to chat about Programming techniques and how to make better use of search engines.

Moderator: Moderators

Plot to kill mysql extensions

Postby beniston » Fri Nov 04, 2011 10:48 pm

PHP core developers are planning to kill the PHP original MySQL extension.

Through its a popular extension, the application would get affected when upgraded to future versions if direct commends of mysql extension is used.

Read more here:

So guys, even in Wordpress or any other open source application or in any framework avoid using mysql commands directly. Use the functions supplied by the open source itself.

Well, if not mysql_***** what are the alternative methods that are there to work with Mysql database? There are advanced extensions like PDO, mysqlnd, etc are available for the same. So nothing to worry on the alternative :D
beniston
 
Posts: 502
Joined: Wed Nov 02, 2011 4:35 am
Location: Cochin
Tell us why you would like to become a WyseLabs Member:

Re: Plot to kill mysql extensions

Postby beniston » Thu Jul 05, 2012 10:28 pm

This Php class can access SQL databases using PDO.

http://www.phpclasses.org/package/7533- ... g-PDO.html

If you have not changed to PDO yet, here is a helping class to change. :D
beniston
 
Posts: 502
Joined: Wed Nov 02, 2011 4:35 am
Location: Cochin
Tell us why you would like to become a WyseLabs Member:

Re: Plot to kill mysql extensions

Postby beniston » Thu Jul 05, 2012 10:37 pm

Here is a supporting article for you to change to PDO. :D

http://net.tutsplus.com/tutorials/php/p ... gle+Reader

Why Should I change from using mysql_* commands
Deprecated: Though it hasn't been officially deprecated – due to widespread use – in terms of best practice and education, it might as well be.
Escaping: The process of escaping user input is left to the developer – many of which don't understand or know how to sanitize the data.
Flexibility: The API isn't flexible; the code is made for working with MySQL database.

Bottom Line: Your code will be significantly more secure and streamlined if you adopt the PDO extension.
beniston
 
Posts: 502
Joined: Wed Nov 02, 2011 4:35 am
Location: Cochin
Tell us why you would like to become a WyseLabs Member:


Return to Programming

Who is online

Users browsing this forum: No registered users and 4 guests

cron