PDA

View Full Version : $config dbtype 'mysqli' - if PHP version is prior to 5. ?


SpreadingLight
Wed 23rd Jan '08, 4:10am
$config['Database']['dbtype']

If you are using PHP5 in combination with MySQL 4.1.x you may want to change this variable to 'mysqli (http://www.vbulletin.com/docs/html/main/mysqli)' to take advantage of the MySQL Improved engine

http://www.vbulletin.com/docs/html/main/editconfig

My host (LunarPages) has PHP4.4.8 (and mySQL 5.0.45). Will that still qualify for mysqli?
peterska2
Wed 23rd Jan '08, 4:37am
Leave it at mysql unless you are sure it will work otherwise you will receive errors.
SpreadingLight
Wed 23rd Jan '08, 4:43am
Thanks :) I'm NEW at all this, so I appreciate the community.


I was searching online and saw this at http://www.php.net/manual/en/ref.mysqli.php


Note: The mysqli extension is designed to work with the version 4.1.3 or above of MySQL. For previous versions, please see the MySQL (http://www.php.net/manual/en/ref.mysql.php) extension documentation.

So I'm wondering whether to follow the req's of php.net or vB...
peterska2
Wed 23rd Jan '08, 4:46am
No worries. Leaving it at the default mysql setting will not cause any problems and your forums will run fine with it like that.
SpreadingLight
Wed 23rd Jan '08, 6:11am
My Host help just said they allow users to enable php5.

It looks like a clear choice to me (at least from these numbers)www.sourcelabs.com/pdfs/SourceLabsPHP4vsPHP5.pdf (http://www.sourcelabs.com/pdfs/SourceLabsPHP4vsPHP5.pdf)
jason|xoxide
Wed 23rd Jan '08, 6:20pm
My Host help just said they allow users to enable php5.

It looks like a clear choice to me (at least from these numbers)www.sourcelabs.com/pdfs/SourceLabsPHP4vsPHP5.pdf (http://www.sourcelabs.com/pdfs/SourceLabsPHP4vsPHP5.pdf)

In defense of PHP 4, 4.4.x is faster than 4.3.x. Then again, 5.2.x is WAY faster than 5.0.x (fast but crash-happy) and 5.1.x (slower than 5.0.x but more stable).
Wayne Luke
Wed 23rd Jan '08, 6:48pm
You cannot use mysqli with PHP 4.4.8. It is only available with PHP 5 and higher.
SpreadingLight
Thu 24th Jan '08, 6:10am
I have 5.2.5 now. Hopefully, it's in the "fast but not crash-happy" category?
jason|xoxide
Thu 24th Jan '08, 10:37am
Yes, 5.2.x is faster than 5.0.x and 5.1.x and is very stable.