miniBB ® 

miniBB

®
Support Forums
  
 | Start | Register | Search | Statistics | File Bank | Manual |
The Other miniBB Support Forums / The Other /  
 

mysql_ is deprecated and about to be deleted

 
Author felgall
Partaker
#1 | Posted: 25 Aug 2013 01:39 
Updating the setup_mysql file to replace the obsolete mysql_ calls with mysqli_ calls is a relatively minor change that ought to have been done long before now. Why hasn't it been done yet or are you waiting for the next version of PHP to be released in a few months time so as to have the script stop working?

Author Paul
Lead Developer 
#2 | Posted: 26 Aug 2013 11:06 
MySQL itself can't be deprecated. All mySQL-related PHP extensions (mysqli, PDO, mysql) are just plug-ins to the default MySQL core, having minor differences in performance. mysqli is the same kind of PHP extension, it's not related to mySQL dev.

Yes, it's a sad fact that PHP developers are going to eliminate mysql module support in the future releases. But there's also another question, if most part of primary web developers (i.e. those developing private and small-to-medium websites) will whatever need all those OOP- and class-oriented changes. miniBB doesn't require all those new functions at all.

Definitely, as soon as PHP team will stop to support old mySQL module, we will re-program miniBB to support mysqli (or at least we will provide 2 different modules). You could be wrong saying that the script will stop working immediately after PHP announces that. All servers will continue to work, as soon as they will keep older versions of PHP. A few months time sounds a wrong term for that. I know that many servers still use PHP 4. PHP 6 may take few years for being installed widely. Admins are not crazy to create problems for themselves, they will wait until the last point when there's no other way that to upgrade.

Author felgall
Partaker
#3 | Posted: 26 Aug 2013 21:53 
It is NOT a sad fact that PHP is dropping the mysql interface that is filled with security holes.

The script did not stop working two years ago when PHP announced it was dropping support. They have provided a couple of years for people to upgrade their scripts.

The only crazy admins are those that wait until the last minute to upgrade their scripts. Most upgraded to either mysqli_ or PDO over a year ago. Only the lazy ones are yet to do so.

Author kuopassa
Partaker
#4 | Posted: 26 Aug 2013 22:03 
I've been lately reading about mysqli and have found this article quite helpful:

http://codular.com/php-mysqli

The article hasn't got much to tell about PDO, but it has some very clear code examples that even such a newbie like me can understand. :-)

Author tom322
Active Member
#5 | Posted: 27 Aug 2013 05:48 
It's going to take couple of years at least before reasonable hosts change remove PHP5.3, so there's no need to panic.

Author Paul
Lead Developer 
#6 | Posted: 27 Aug 2013 13:09 
felgall:
It is NOT a sad fact that PHP is dropping the mysql interface that is filled with security holes.
Don't you mess up something? PHP extensions are not about mySQL interface. They are just bridges to connect to mySQL database and interface.

If mysql extension has security holes, then it's a sick point of PHP team. They have coded the buggy one bridge and instead of fixing it, they have produced another two with new bugs.

felgall:
The script did not stop working two years ago when PHP announced it was dropping support. They have provided a couple of years for people to upgrade their scripts.
What kind of two years are you about?

C'mon, if you read these posts from StackOverflow marked as posted in 2009, you will see very contrast opinions on that. Some quotes from there:

cletus:
I have abandoned using mysqli. It is simply too unstable. I've had queries that crash PHP using mysqli but work just fine with the mysql package. Also mysqli crashes on LONGTEXT columns. This bug has been raised in various forms since at least 2005 and remains broken.
MarkR:
What is better is PDO; it's a less crufty interface and also provides the same features as MySQLi.
Your opinion is just your opinion. It doesn't mean it's the right one.

I must add that the current mysql extension is being so popular because it's extermely simple and flexible. If we don't have object-oriented side in miniBB, then why we, or some other simple website, would need object-oriented extensions plugged in? If we are about SQL injections, then it's up to the coders themselves to provide the secured code. mysqli should not take care of somebody because of it.

The Other miniBB Support Forums / The Other /
 mysql_ is deprecated and about to be deleted
 Share Topic's Link

Your Reply Click this icon to move up to the quoted message


  ?
Post as a Guest, leaving the Password field blank. You could also enter a Guest name, if it's not taken by a member yet. Sign-in and post at once, or just sign-in, bypassing the message's text.


Before posting, make sure your message is compliant with forum rules; otherwise it could be locked or removed with no explanation.

 

 
miniBB Support Forums Powered by Forum Software miniBB ® Home  Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contact Us
Install the Captcha add-on: protect your miniBB-forums from the automated spam and flood.


  ⇑