Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

standard method of php connection on iis

Options
  • 02-08-2015 8:38pm
    #1
    sheesh
    Registered Users Posts: 4,080 ✭✭✭


    can someone clear up something for me.

    Developed an application in php mysql
    moving it to production server which is iis Mysql and php are running on IIS I cannot get php to connect to mysql.

    Is odbc_connect the standard method of connecting to a database using php on an iis server
    windows server 2008 r2
    IIS 7.5.7600
    php5

    mysql workbench 6.3
    MYSQL 5.6


Comments

  • Options
    #2
    NeutralHandle
    Registered Users Posts: 136 ✭✭NeutralHandle


    Did it connect to MySQL on the development machine? If so then probably either missing the driver on the server or something up with the connection string.

    Otherwise you could look at using Pdo or mysqli.


  • Options
    #3
    sheesh
    Registered Users Posts: 4,080 ✭✭✭sheesh


    NeutralHandle wrote: »
    Did it connect to MySQL on the development machine? If so then probably either missing the driver on the server or something up with the connection string.

    Otherwise you could look at using Pdo or mysqli.

    yes it connected on the development machine (window 8) using mysqli on iis.
    Basically on the production machine(windows 2008) it is connecting to the database with odbc_connect but not mysqli_connect.


  • Options
    #4
    NeutralHandle
    Registered Users Posts: 136 ✭✭NeutralHandle


    In PHP 5.0 - 5.2 on Windows the mysqli extension is not enabled by default, so the php_mysqli.dll DLL must be enabled inside of php.ini

    details:

    http://php.net/manual/en/mysqli.installation.php


Advertisement