RES: [PHP] Class mysqli not found
in [General]
|
From: Alejandro Michelin Salomon on 6 Oct 2010 16:33 Sueandant : mysqli is set of functions not a class. The name to connect is mysqli_connect /** * * * @version $Id$ * @copyright 2010 */ $mysqli = mysqli_connect ("localhost", "root", "woodcote", "testDB"); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } else { printf("Host information: %s\n", mysqli_get_host_info($mysqli)); } Try adodb lib for php ( http://adodb.sourceforge.net/ ), is great layer on top of php db functions. Alejandro M.S. -----Mensagem original----- De: sueandant [mailto:hollandsathome(a)tiscali.co.uk] Enviada em: quarta-feira, 6 de outubro de 2010 17:27 Para: sstaples(a)mnsi.net Cc: PHP Assunto: Re: [PHP] Class mysqli not found Thanks Steve. Here's the php file: <?php /** * * * @version $Id$ * @copyright 2010 */ $mysqli = new mysqli("localhost", "root", "woodcote", "testDB"); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } else { printf("Host information: %s\n", mysqli_get_host_info($mysqli)); } ?> When I run this small program I get a Fatal Error: Class mysqli not found error message. ----- Original Message ----- From: "Steve Staples" <sstaples(a)mnsi.net> To: "sueandant" <hollandsathome(a)tiscali.co.uk> Cc: "PHP" <php-general(a)lists.php.net> Sent: Wednesday, October 06, 2010 9:09 PM Subject: Re: [PHP] Class mysqli not found > On Wed, 2010-10-06 at 21:00 +0100, sueandant wrote: >> I'm still fighting a losing battle in my attempts to get PHP speak to >> mysqli. I can access MySql via the prompt. Apache and PHP are installed >> and working. In Apache's config file PHPIniDir is set to "C:\php", >> which is where I unzipped the binary download files, and set LoadModule >> php5_module C:\php\php5apache2_2.dll. In php.ini I have uncommented the >> mysql.dll and mysqli.dll extensions and set extension_dir = >> "C:\php\ext\". I have edited the environment variables to include >> C:\php and C:php\ext. >> >> I am running Vista Home Premium 32 bit with SP2, Apache 2.2, PHP 5.3.3 >> and MySql Server 5.1. >> >> What have I missed? > > How are you connecting to the mysql? What does your connection string > look like from your php file? Can you cut and paste it here for us to > trouble shoot (if it is the apache->php->mysql connection problem) > > > Steve > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
From: Simon J Welsh on 6 Oct 2010 16:43 http://php.net/manual/en/class.mysqli.php definitely says MySQLi is a class. It looks like PHP was complied without MySQLi support. Does running a phpinfo() show the MySQLi module? On 7/10/2010, at 9:33 AM, Alejandro Michelin Salomon wrote: > Sueandant : > > mysqli is set of functions not a class. The name to connect is mysqli_connect > /** > * > * > * @version $Id$ > * @copyright 2010 > */ > $mysqli = mysqli_connect ("localhost", "root", "woodcote", "testDB"); > > if (mysqli_connect_errno()) { > printf("Connect failed: %s\n", mysqli_connect_error()); > exit(); > } else { > printf("Host information: %s\n", mysqli_get_host_info($mysqli)); > } > > > Try adodb lib for php ( http://adodb.sourceforge.net/ ), is great layer on top of php db functions. > > Alejandro M.S. > > -----Mensagem original----- > De: sueandant [mailto:hollandsathome(a)tiscali.co.uk] > Enviada em: quarta-feira, 6 de outubro de 2010 17:27 > Para: sstaples(a)mnsi.net > Cc: PHP > Assunto: Re: [PHP] Class mysqli not found > > Thanks Steve. Here's the php file: > > <?php > > /** > * > * > * @version $Id$ > * @copyright 2010 > */ > $mysqli = new mysqli("localhost", "root", "woodcote", "testDB"); > > if (mysqli_connect_errno()) { > printf("Connect failed: %s\n", mysqli_connect_error()); > exit(); > } else { > printf("Host information: %s\n", mysqli_get_host_info($mysqli)); > } > > ?> > > When I run this small program I get a Fatal Error: Class mysqli not found > error message. > > > ----- Original Message ----- > From: "Steve Staples" <sstaples(a)mnsi.net> > To: "sueandant" <hollandsathome(a)tiscali.co.uk> > Cc: "PHP" <php-general(a)lists.php.net> > Sent: Wednesday, October 06, 2010 9:09 PM > Subject: Re: [PHP] Class mysqli not found > > >> On Wed, 2010-10-06 at 21:00 +0100, sueandant wrote: >>> I'm still fighting a losing battle in my attempts to get PHP speak to >>> mysqli. I can access MySql via the prompt. Apache and PHP are installed >>> and working. In Apache's config file PHPIniDir is set to "C:\php", >>> which is where I unzipped the binary download files, and set LoadModule >>> php5_module C:\php\php5apache2_2.dll. In php.ini I have uncommented the >>> mysql.dll and mysqli.dll extensions and set extension_dir = >>> "C:\php\ext\". I have edited the environment variables to include >>> C:\php and C:php\ext. >>> >>> I am running Vista Home Premium 32 bit with SP2, Apache 2.2, PHP 5.3.3 >>> and MySql Server 5.1. >>> >>> What have I missed? >> >> How are you connecting to the mysql? What does your connection string >> look like from your php file? Can you cut and paste it here for us to >> trouble shoot (if it is the apache->php->mysql connection problem) >> >> >> Steve >> > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > --- Simon Welsh Admin of http://simon.geek.nz/ Who said Microsoft never created a bug-free program? The blue screen never, ever crashes! http://www.thinkgeek.com/brain/gimme.cgi?wid=81d520e5e
From: "sueandant" on 6 Oct 2010 16:58 phpinfo() includes mysqli in its detailed output: mysqli MysqlI Support enabled Client API library version mysqlnd 5.0.7-dev - 091210 - $Revision: 300533 $ Active Persistent Links 0 Inactive Persistent Links 0 Active Links 0 Directive Local Value Master Value mysqli.allow_local_infile On On mysqli.allow_persistent On On mysqli.default_host no value no value mysqli.default_port 3306 3306 mysqli.default_pw no value no value mysqli.default_socket no value no value mysqli.default_user no value no value mysqli.max_links Unlimited Unlimited mysqli.max_persistent Unlimited Unlimited mysqli.reconnect Off Off ----- Original Message ----- From: "Simon J Welsh" <simon(a)welsh.co.nz> To: "Alejandro Michelin Salomon" <amichelins(a)hotmail.com> Cc: "'sueandant'" <hollandsathome(a)tiscali.co.uk>; <php-general(a)lists.php.net> Sent: Wednesday, October 06, 2010 9:43 PM Subject: Re: RES: [PHP] Class mysqli not found http://php.net/manual/en/class.mysqli.php definitely says MySQLi is a class. It looks like PHP was complied without MySQLi support. Does running a phpinfo() show the MySQLi module? On 7/10/2010, at 9:33 AM, Alejandro Michelin Salomon wrote: > Sueandant : > > mysqli is set of functions not a class. The name to connect is > mysqli_connect > /** > * > * > * @version $Id$ > * @copyright 2010 > */ > $mysqli = mysqli_connect ("localhost", "root", "woodcote", "testDB"); > > if (mysqli_connect_errno()) { > printf("Connect failed: %s\n", mysqli_connect_error()); > exit(); > } else { > printf("Host information: %s\n", mysqli_get_host_info($mysqli)); > } > > > Try adodb lib for php ( http://adodb.sourceforge.net/ ), is great layer on > top of php db functions. > > Alejandro M.S. > > -----Mensagem original----- > De: sueandant [mailto:hollandsathome(a)tiscali.co.uk] > Enviada em: quarta-feira, 6 de outubro de 2010 17:27 > Para: sstaples(a)mnsi.net > Cc: PHP > Assunto: Re: [PHP] Class mysqli not found > > Thanks Steve. Here's the php file: > > <?php > > /** > * > * > * @version $Id$ > * @copyright 2010 > */ > $mysqli = new mysqli("localhost", "root", "woodcote", "testDB"); > > if (mysqli_connect_errno()) { > printf("Connect failed: %s\n", mysqli_connect_error()); > exit(); > } else { > printf("Host information: %s\n", mysqli_get_host_info($mysqli)); > } > > ?> > > When I run this small program I get a Fatal Error: Class mysqli not found > error message. > > > ----- Original Message ----- > From: "Steve Staples" <sstaples(a)mnsi.net> > To: "sueandant" <hollandsathome(a)tiscali.co.uk> > Cc: "PHP" <php-general(a)lists.php.net> > Sent: Wednesday, October 06, 2010 9:09 PM > Subject: Re: [PHP] Class mysqli not found > > >> On Wed, 2010-10-06 at 21:00 +0100, sueandant wrote: >>> I'm still fighting a losing battle in my attempts to get PHP speak to >>> mysqli. I can access MySql via the prompt. Apache and PHP are >>> installed >>> and working. In Apache's config file PHPIniDir is set to "C:\php", >>> which is where I unzipped the binary download files, and set LoadModule >>> php5_module C:\php\php5apache2_2.dll. In php.ini I have uncommented >>> the >>> mysql.dll and mysqli.dll extensions and set extension_dir = >>> "C:\php\ext\". I have edited the environment variables to include >>> C:\php and C:php\ext. >>> >>> I am running Vista Home Premium 32 bit with SP2, Apache 2.2, PHP 5.3.3 >>> and MySql Server 5.1. >>> >>> What have I missed? >> >> How are you connecting to the mysql? What does your connection string >> look like from your php file? Can you cut and paste it here for us to >> trouble shoot (if it is the apache->php->mysql connection problem) >> >> >> Steve >> > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > --- Simon Welsh Admin of http://simon.geek.nz/ Who said Microsoft never created a bug-free program? The blue screen never, ever crashes! http://www.thinkgeek.com/brain/gimme.cgi?wid=81d520e5e -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
From: chris h on 6 Oct 2010 17:12 Are you doing phpinfo() off the CLI or via apache mod? Is it the same way you are running the actual script that's calling on mysqli? On Wed, Oct 6, 2010 at 4:58 PM, sueandant <hollandsathome(a)tiscali.co.uk>wrote: > phpinfo() includes mysqli in its detailed output: > > mysqli > MysqlI Support enabled > Client API library version mysqlnd 5.0.7-dev - 091210 - $Revision: > 300533 $ > Active Persistent Links 0 > Inactive Persistent Links 0 > Active Links 0 > > Directive Local Value Master Value > mysqli.allow_local_infile On On > mysqli.allow_persistent On On > mysqli.default_host no value no value > mysqli.default_port 3306 3306 > mysqli.default_pw no value no value > mysqli.default_socket no value no value > mysqli.default_user no value no value > mysqli.max_links Unlimited Unlimited > mysqli.max_persistent Unlimited Unlimited > mysqli.reconnect Off Off > > ----- Original Message ----- From: "Simon J Welsh" <simon(a)welsh.co.nz> > To: "Alejandro Michelin Salomon" <amichelins(a)hotmail.com> > Cc: "'sueandant'" <hollandsathome(a)tiscali.co.uk>; < > php-general(a)lists.php.net> > Sent: Wednesday, October 06, 2010 9:43 PM > Subject: Re: RES: [PHP] Class mysqli not found > > > > http://php.net/manual/en/class.mysqli.php definitely says MySQLi is a > class. > > It looks like PHP was complied without MySQLi support. Does running a > phpinfo() show the MySQLi module? > On 7/10/2010, at 9:33 AM, Alejandro Michelin Salomon wrote: > > Sueandant : >> >> mysqli is set of functions not a class. The name to connect is >> mysqli_connect >> /** >> * >> * >> * @version $Id$ >> * @copyright 2010 >> */ >> $mysqli = mysqli_connect ("localhost", "root", "woodcote", "testDB"); >> >> if (mysqli_connect_errno()) { >> printf("Connect failed: %s\n", mysqli_connect_error()); >> exit(); >> } else { >> printf("Host information: %s\n", mysqli_get_host_info($mysqli)); >> } >> >> >> Try adodb lib for php ( http://adodb.sourceforge.net/ ), is great layer >> on top of php db functions. >> >> Alejandro M.S. >> >> -----Mensagem original----- >> De: sueandant [mailto:hollandsathome(a)tiscali.co.uk] >> Enviada em: quarta-feira, 6 de outubro de 2010 17:27 >> Para: sstaples(a)mnsi.net >> Cc: PHP >> Assunto: Re: [PHP] Class mysqli not found >> >> Thanks Steve. Here's the php file: >> >> <?php >> >> /** >> * >> * >> * @version $Id$ >> * @copyright 2010 >> */ >> $mysqli = new mysqli("localhost", "root", "woodcote", "testDB"); >> >> if (mysqli_connect_errno()) { >> printf("Connect failed: %s\n", mysqli_connect_error()); >> exit(); >> } else { >> printf("Host information: %s\n", mysqli_get_host_info($mysqli)); >> } >> >> ?> >> >> When I run this small program I get a Fatal Error: Class mysqli not found >> error message. >> >> >> ----- Original Message ----- From: "Steve Staples" <sstaples(a)mnsi.net> >> To: "sueandant" <hollandsathome(a)tiscali.co.uk> >> Cc: "PHP" <php-general(a)lists.php.net> >> Sent: Wednesday, October 06, 2010 9:09 PM >> Subject: Re: [PHP] Class mysqli not found >> >> >> On Wed, 2010-10-06 at 21:00 +0100, sueandant wrote: >>> >>>> I'm still fighting a losing battle in my attempts to get PHP speak to >>>> mysqli. I can access MySql via the prompt. Apache and PHP are >>>> installed >>>> and working. In Apache's config file PHPIniDir is set to "C:\php", >>>> which is where I unzipped the binary download files, and set LoadModule >>>> php5_module C:\php\php5apache2_2.dll. In php.ini I have uncommented >>>> the >>>> mysql.dll and mysqli.dll extensions and set extension_dir = >>>> "C:\php\ext\". I have edited the environment variables to include >>>> C:\php and C:php\ext. >>>> >>>> I am running Vista Home Premium 32 bit with SP2, Apache 2.2, PHP 5.3.3 >>>> and MySql Server 5.1. >>>> >>>> What have I missed? >>>> >>> >>> How are you connecting to the mysql? What does your connection string >>> look like from your php file? Can you cut and paste it here for us to >>> trouble shoot (if it is the apache->php->mysql connection problem) >>> >>> >>> Steve >>> >>> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> > --- > Simon Welsh > Admin of http://simon.geek.nz/ > > Who said Microsoft never created a bug-free program? The blue screen never, > ever crashes! > > http://www.thinkgeek.com/brain/gimme.cgi?wid=81d520e5e > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
From: "sueandant" on 6 Oct 2010 17:18 I'm running phpinfo from my browser under localhost. ----- Original Message ----- From: chris h To: sueandant Cc: PHP Sent: Wednesday, October 06, 2010 10:12 PM Subject: Re: RES: [PHP] Class mysqli not found Are you doing phpinfo() off the CLI or via apache mod? Is it the same way you are running the actual script that's calling on mysqli? On Wed, Oct 6, 2010 at 4:58 PM, sueandant <hollandsathome(a)tiscali.co.uk> wrote: phpinfo() includes mysqli in its detailed output: mysqli MysqlI Support enabled Client API library version mysqlnd 5.0.7-dev - 091210 - $Revision: 300533 $ Active Persistent Links 0 Inactive Persistent Links 0 Active Links 0 Directive Local Value Master Value mysqli.allow_local_infile On On mysqli.allow_persistent On On mysqli.default_host no value no value mysqli.default_port 3306 3306 mysqli.default_pw no value no value mysqli.default_socket no value no value mysqli.default_user no value no value mysqli.max_links Unlimited Unlimited mysqli.max_persistent Unlimited Unlimited mysqli.reconnect Off Off ----- Original Message ----- From: "Simon J Welsh" <simon(a)welsh.co.nz> To: "Alejandro Michelin Salomon" <amichelins(a)hotmail.com> Cc: "'sueandant'" <hollandsathome(a)tiscali.co.uk>; <php-general(a)lists.php.net> Sent: Wednesday, October 06, 2010 9:43 PM Subject: Re: RES: [PHP] Class mysqli not found http://php.net/manual/en/class.mysqli.php definitely says MySQLi is a class. It looks like PHP was complied without MySQLi support. Does running a phpinfo() show the MySQLi module? On 7/10/2010, at 9:33 AM, Alejandro Michelin Salomon wrote: Sueandant : mysqli is set of functions not a class. The name to connect is mysqli_connect /** * * * @version $Id$ * @copyright 2010 */ $mysqli = mysqli_connect ("localhost", "root", "woodcote", "testDB"); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } else { printf("Host information: %s\n", mysqli_get_host_info($mysqli)); } Try adodb lib for php ( http://adodb.sourceforge.net/ ), is great layer on top of php db functions. Alejandro M.S. -----Mensagem original----- De: sueandant [mailto:hollandsathome(a)tiscali.co.uk] Enviada em: quarta-feira, 6 de outubro de 2010 17:27 Para: sstaples(a)mnsi.net Cc: PHP Assunto: Re: [PHP] Class mysqli not found Thanks Steve. Here's the php file: <?php /** * * * @version $Id$ * @copyright 2010 */ $mysqli = new mysqli("localhost", "root", "woodcote", "testDB"); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } else { printf("Host information: %s\n", mysqli_get_host_info($mysqli)); } ?> When I run this small program I get a Fatal Error: Class mysqli not found error message. ----- Original Message ----- From: "Steve Staples" <sstaples(a)mnsi.net> To: "sueandant" <hollandsathome(a)tiscali.co.uk> Cc: "PHP" <php-general(a)lists.php.net> Sent: Wednesday, October 06, 2010 9:09 PM Subject: Re: [PHP] Class mysqli not found On Wed, 2010-10-06 at 21:00 +0100, sueandant wrote: I'm still fighting a losing battle in my attempts to get PHP speak to mysqli. I can access MySql via the prompt. Apache and PHP are installed and working. In Apache's config file PHPIniDir is set to "C:\php", which is where I unzipped the binary download files, and set LoadModule php5_module C:\php\php5apache2_2.dll. In php.ini I have uncommented the mysql.dll and mysqli.dll extensions and set extension_dir = "C:\php\ext\". I have edited the environment variables to include C:\php and C:php\ext. I am running Vista Home Premium 32 bit with SP2, Apache 2.2, PHP 5.3.3 and MySql Server 5.1. What have I missed? How are you connecting to the mysql? What does your connection string look like from your php file? Can you cut and paste it here for us to trouble shoot (if it is the apache->php->mysql connection problem) Steve -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Simon Welsh Admin of http://simon.geek.nz/ Who said Microsoft never created a bug-free program? The blue screen never, ever crashes! http://www.thinkgeek.com/brain/gimme.cgi?wid=81d520e5e -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
|
Pages: 1 Prev: Class mysqli not found Next: RES: [PHP] Class mysqli not found |