mysql or mysqli ?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • arkadia2006
    Senior Member
    • Aug 2006
    • 152

    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
    Homes for sale by owner (house, apartment, condo, or land) and vacation rentals. The largest international FSBO home selling and home buying real estate website
  • Floris
    Senior Member
    • Dec 2001
    • 37767

    #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

    • arkadia2006
      Senior Member
      • Aug 2006
      • 152

      #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

      • arkadia2006
        Senior Member
        • Aug 2006
        • 152

        #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

        • JJLenz
          Member
          • Sep 2006
          • 31

          #5
          Originally posted by arkadia2006
          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

          • Colin F
            Senior Member
            • May 2004
            • 17689

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