Re: How to access MySQL through PHP in windows 2K.

Katiyar (GMail) wrote:

Hi List, I am new to PHP and as well as with MySQL,

    * I have installed PHP 5.28, on win 2K  (with IIS) and it is
      installed properly I suppose, as when I call phpinfo (), through
      a script, it shows the PHP Information.
    * then I installed MySQL 5.1.30, and through MySQL command prompt
      I am  able to do things (creating tables, making queries etc).
    * Now I want to use MySQL with PHP, but seems that MySQLI is not
      installed properly. as when I write a following script in a php
      page I get the error, that 'MySQLi'* *is not installed properly,.

            *<?php           $si = function_exists ( 'mysqli_connect' ) ;
          if ( $si )
          {
              echo ' MySQLi appears to be installed correctly ' ;
          }
          else
          {
              echo 'MySQLi <B> does not </B> appears to be installed. ' ;
          }
      ?>*
 I understand that it is a configuration error somewhere, as I am new here in this world I am unable to figure out what ?
 I am attaching the php.ini for the reference.
 

Praveen K. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-=-=-=-= Praveen Katiyar Site : http://praveenkatiyar.co.cc =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-=-=-=-= I did not see an attached file, but the mysqli extension must be activated in the php.ini file. Search the file and see if you have a line like this:

;extension=php_mysqli.dll Note the ';' at the beginning. The semicolon makes the line a comment and php ignores it. You have to remove the comment to activate the extension. The other thing is the php_mysqli.dll file must be present in the extension directory for php. To find the extension directory search the php.ini file extension_dir. In my php.ini the line looks like this: extension_dir = "c:\php\ext". Make sure the php_mysqli.dll file is in the directory listed in extension_dir. Thanks, James -- James Crow IT Manager ULTRATAN, Inc <james@ultratans.com>