>From: Nishshanka Sirisena <nishsha...@opensource.lk>
>To: Tommy Pham <tommy...@yahoo.com>
>Sent: Sunday, September 20, 2009 7:13:02 AM
>Subject: Re: [PHP] How to work with embedded mysql from php.
>>I tried with Mysqli using mysqli_server_init() and mysql_server_end() 
>>functions and I am using Lighttpd as my web server. But when I'm running the 
>>page error log of the lighttpd web server listed following error. And I have 
>>correctly configured lighttpd-php and mysql.
>PHP Fatal error:  Call to undefined function mysqli_server_init() in 
> C:\lighttpd\htdocs\web\test_db.php on line 27
>2009-09-20 09:02:58: (mod_fastcgi.c.1452) 
>>2009-09-20 09:02:58: (connections.c.764) missing cleanup in fastcgi 
>I have no previous experience to use this So please can somebody send me a 
>simple implementation of this issue.


What version and bitness of PHP are you using?  Did you compile it?  Have you 
tried connecting to a non embedded MySQL to ensure the configuration of 
Lighttpd + PHP is correct?  I had breakage of some apps when PHP is configured 
as CGI/FASTCGI and didn't bother using it as such.  Note: If you didn't build 
both, you need to match right Visual Studio version of PHP with Lightthpd.  Mix 
match is very bad...  Official PHP releases are available in VS6 & VS9 only.

What version of embedded MySQL are you using?  Check the phpinfo() to see if 
MySQL/MySQLi is using MySQLnd driver. MySQLnd cannot connect to MySQL 4.1+ 
using old authentication. It may look something like this in phpinfo():
Client API version:  mysqlnd 5.0.5-dev - 081106 - $Revision: 286739 $
(This is my build of PHP-5.3.2-dev x64 running with my build of Apache 2.2.13 
x64 on Win2008 x64.)

You may have to download the PHP source, do some hacking and then compile it 
against embedded MySQL's lib/dll.  Look for HAVE_EMBEDDED_MYSQL in PHP's source 
code files in ext\mysql and ext\mysqli.  After you hack the PHP's source code, 
you should be able to connect the embedded with this or something similar in 

$mysql = mysql_init();
mysql_options($mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, null);
mysql_real_connect($mysql, null,null,null, "database1", 0,null,0);

Of course, depending on your requirement, the other alternative and easy fix is 
use a non embedded and bind the server to  You'll also don't have to 
deal with the limitations of embedded ;). 


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

Reply via email to