Click here to get back home

Mysqli problems

 HomeNewsGroups | Search | About
 comp.lang.php    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Mysqli problems theiviaxx 07-16-2008
Posted by theiviaxx on July 16, 2008, 2:32 pm
Please log in for more thread options
So i have the need to run stored procedures and the best way to do
this is with mysqli, so i have read. So i tried to enable that module
with no luck.

IIS 6, PHP 5, MySQL 5

I enabled the module in php.ini and made sure the php_mysqli.dll was
in the php/ext dir. mysql,, oci8, mssql all load fine and are in the
same folder. When i run phpinfo() mysqli is not there. libmysql.dll
is in the php root

What i have tried:
- Moving libmysql.dll to windows/system32
- moving php.ini to c:\Windows
- reinstalling php from installer with mysqli support


Odd behavior:
in the php.ini file, if i comment out mysql (standard) it will still
load. I have to remove the dll from php/ext in order to not load
mysql support

I have no idea what else to even try. The PATH is set correctly to
the php root and php/ext folders. The PHPRC is set to the php root.
All other modules load just fine in the php/ext folder. Any help?

Thanks

Posted by Jerry Stuckle on July 16, 2008, 6:12 pm
Please log in for more thread options
theiviaxx@gmail.com wrote:
> So i have the need to run stored procedures and the best way to do
> this is with mysqli, so i have read. So i tried to enable that module
> with no luck.
>
> IIS 6, PHP 5, MySQL 5
>
> I enabled the module in php.ini and made sure the php_mysqli.dll was
> in the php/ext dir. mysql,, oci8, mssql all load fine and are in the
> same folder. When i run phpinfo() mysqli is not there. libmysql.dll
> is in the php root
>
> What i have tried:
> - Moving libmysql.dll to windows/system32
> - moving php.ini to c:\Windows
> - reinstalling php from installer with mysqli support
>
>
> Odd behavior:
> in the php.ini file, if i comment out mysql (standard) it will still
> load. I have to remove the dll from php/ext in order to not load
> mysql support
>
> I have no idea what else to even try. The PATH is set correctly to
> the php root and php/ext folders. The PHPRC is set to the php root.
> All other modules load just fine in the php/ext folder. Any help?
>
> Thanks
>

Sounds like you're modifying the wrong php.ini file. Look near the top
of your phpinfo() output where it tells you which configuration file it
is using.

Of course, I'm assuming you're stopping and starting the server after
modifying the php.ini file.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================


Posted by theiviaxx on July 17, 2008, 1:34 pm
Please log in for more thread options
> theivi...@gmail.com wrote:
> > So i have the need to run stored procedures and the best way to do
> > this is with mysqli, so i have read. =A0So i tried to enable that modul=
e
> > with no luck.
>
> > IIS 6, PHP 5, MySQL 5
>
> > I enabled the module in php.ini and made sure the php_mysqli.dll was
> > in the php/ext dir. mysql,, oci8, mssql all load fine and are in the
> > same folder. =A0When i run phpinfo() =A0mysqli is not there. =A0libmysq=
l.dll
> > is in the php root
>
> > What i have tried:
> > - Moving libmysql.dll to windows/system32
> > - moving php.ini to c:\Windows
> > - reinstalling php from installer with mysqli support
>
> > Odd behavior:
> > in the php.ini file, if i comment out mysql (standard) it will still
> > load. =A0I have to remove the dll from php/ext in order to not load
> > mysql support
>
> > I have no idea what else to even try. =A0The PATH is set correctly to
> > the php root and php/ext folders. =A0The PHPRC is set to the php root.
> > All other modules load just fine in the php/ext folder. =A0Any help?
>
> > Thanks
>
> Sounds like you're modifying the wrong php.ini file. =A0Look near the top
> of your phpinfo() output where it tells you which configuration file it
> is using.
>
> Of course, I'm assuming you're stopping and starting the server after
> modifying the php.ini file.
>
> --
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

the quirks with the php.ini were solved, i only had 1 php.ini on the
machine and the phpinfo() read the right one. Maybe some wierdness
with the server restarts. ANyhow, i finally fixed it. I read
somewhere else that i had to give IUSR_machineName read access to the
dll. I gave it to the /ext folder and that didnt help, i to
explicitly give it to that dll file. which was odd considering all
other extensions loaded just fine.

anyhow, crisis averted :)

Similar ThreadsPosted
having problems getting mysqli installed on PHP 5.2.1 April 4, 2007, 5:09 am
OOP PHP with MySQLi January 31, 2006, 9:04 am
Mysql or mysqli ? August 11, 2004, 4:20 pm
Zend 4.0 and Mysqli March 21, 2005, 6:01 pm
Mysqli class March 24, 2005, 2:11 pm
Zend and PHP with MySQLi Please help March 28, 2005, 5:29 pm
MySQLi group April 29, 2005, 4:00 pm
MySQLi problem in PHP October 11, 2005, 3:52 pm
CGI to ISAPI, now no MySQLi January 15, 2006, 7:37 am
Confused by mysqli July 5, 2006, 6:18 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap