Announcement

Collapse
No announcement yet.

mysql or mysqli ?

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

  • 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

  • #2
    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/

    Comment


    • #3
      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

      Comment


      • #4
        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

        Comment


        • #5
          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.

          Comment


          • #6
            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.
            Best Regards
            Colin Frei

            Please don't contact me per PM.

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            X