How to access MySQL through PHP in windows 2K.

------=_NextPart_000_00E0_01C9C824.93F71070
Content-Type: multipart/related;
type="multipart/alternative";
boundary="----=_NextPart_001_00E1_01C9C824.93F71070"


------=_NextPart_001_00E1_01C9C824.93F71070
Content-Type: multipart/alternative;
boundary="----=_NextPart_002_00E2_01C9C824.93F71070"


------=_NextPart_002_00E2_01C9C824.93F71070
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Praveen's MailHi List,


I am new to PHP and as well as with MySQL,=20

a.. 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.=20
b.. then I installed MySQL 5.1.30, and through MySQL command prompt I =
am able to do things (creating tables, making queries etc).=20
c.. 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,.
$si =3D function_exists ( 'mysqli_connect' ) ;
if ( $si )
{
echo ' MySQLi appears to be installed correctly ' ;
}
else
{
echo 'MySQLi does not 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.=20


=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- =3D- =
=3D-=3D-=3D-=3D-=3D-=3D-=
Praveen Katiyar=20

Site : http://praveenkatiyar.co.cc=20
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- =3D- =
=3D-=3D-=3D-=3D-=3D-=3D-=


------=_NextPart_002_00E2_01C9C824.93F71070
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable



charset=3Dwindows-1252"> href=3D"file://C:\Program Files\Common Files\Microsoft =
Shared\Stationery\">



background=3Dcid:00df01c9c7f6$7a353780$0100007f@pc1001>

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

Should be simple enough... Do you have the mysqli driver enabled in your
php.ini file?

;extension=3Dphp_mysqli.dll

should become

extension=3Dphp_mysqli.dll

hth,

Yves

------ Original Message ------
Received: Tue, 28 Apr 2009 06:55:37 PM CDT
From: "Katiyar \(GMail\)"
To: Cc:
Subject: [PHP-DB] How to access MySQL through PHP in windows 2K. =


Praveen's MailHi List,


I am new to PHP and as well as with MySQL, =


a.. I have installed PHP 5.28, on win 2K (with IIS) and it is installe=
d
properly I suppose, as when I call phpinfo (), through a script, it shows=
the
PHP Information. =

b.. then I installed MySQL 5.1.30, and through MySQL command prompt I a=
m =

able to do things (creating tables, making queries etc). =

c.. Now I want to use MySQL with PHP, but seems that MySQLI is not inst=
alled
properly. as when I write a following script in a php page I get the erro=
r,
that 'MySQLi' is not installed properly,.

$si =3D function_exists ( 'mysqli_connect' ) ;
if ( $si )
{
echo ' MySQLi appears to be installed correctly ' ;
}
else
{
echo 'MySQLi does not 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. =



=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- =3D- =3D-=3D-=
=3D-=3D-=3D-=3D-=3D =

Praveen Katiyar =


Site : http://praveenkatiyar.co.cc =

=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- =3D- =3D-=3D-=
=3D-=3D-=3D-=3D-=3D =




-- =

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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,.
>
> * > $si = function_exists ( 'mysqli_connect' ) ;
> if ( $si )
> {
> echo ' MySQLi appears to be installed correctly ' ;
> }
> else
> {
> echo 'MySQLi does not 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



--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php