Announcement

Collapse
No announcement yet.

mysql or mysqli ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Colin F
    replied
    MySQLi has caused problems in the past. Generally it's a good idea to use it if possible, but if not or if you get errors with it then it doesn't matter if you use mysql either.

    Leave a comment:


  • JJLenz
    replied
    Originally posted by arkadia2006 View Post
    I read the Vbulletin manual and i read (http://www.vbulletin.com/docs/html/install) :

    MySQLi is an improved database layer for PHP 5 and MySQL 4.1+. It is strongly recommended that MySQLi be used if your MySQL server is at version 4.1 or higher !

    Are you sure that it's better to run in mysql instead of mysqli ?
    That's the same question I had. The advice being given in the manual is the exact opposite of the advice given here.

    I tried to run with mysqli and got an error, so I went to see if I had the proper .dll for mysqli. Php 4.4.4 on Windows tells me that there's no mysqli.dll OR mysql.dll - that mysql support is built in to php - so mysqli may not even be a valid option.

    Leave a comment:


  • arkadia2006
    replied
    if you have no problem running the forum i don't recommend to run with mysqli.
    I read the Vbulletin manual and i read (http://www.vbulletin.com/docs/html/install) :

    MySQLi is an improved database layer for PHP 5 and MySQL 4.1+. It is strongly recommended that MySQLi be used if your MySQL server is at version 4.1 or higher !

    Are you sure that it's better to run in mysql instead of mysqli ?

    thank you
    stephane
    http://www.arkadia.com

    Leave a comment:


  • arkadia2006
    replied
    Thanks Floris !

    i will take your advice and stay in msql and not use mysqli ... i m just curious about what kind of problem i can have to swith to mysqli ?

    thank you
    stephane
    http://www.arkadia.com

    Leave a comment:


  • Floris
    replied
    if you have no problem running the forum i don't recommend to run with mysqli.

    The mysqli extension allows you to access the functionality provided by MySQL 4.1 and above. More information about the MySQL Database server can be found at http://www.mysql.com/

    Leave a comment:


  • arkadia2006
    started a topic mysql or mysqli ?

    mysql or mysqli ?

    In the config php i have this option :

    // ****** DATABASE TYPE ******
    // This is the type of the database server on which your vBulletin database will be located.
    // Valid options are mysql and mysqli, for slave support add _slave. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
    $config['Database']['dbtype'] = 'mysql';

    What is the difference between mysql and mysqli??

    thank you
    stephane
    http://www.arkadia.com
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X