Ciprian,
I may have missed whether or not you were able to resolve your problem
from a couple days ago.
In one of my development environments (Win2K), I decided to install PHP
5.0 with MySQL(i) 4.1.x support in IIS5.0 and Apache 2 (running on
different ports). It took a bit more work than I intended, but here's
what I did:
FOR IIS (port 80):
1. downloaded and unzipped php-5.0.0-Win32.zip to c:\php
2. installed php as ISAPI
3. edited php-ini-recommended, tailored it to my environment, and copied
it as php.ini into c:\winnt
NOTE: extension_dir = c:\php\ext
4. tested phpinfo() without extensions
5. edited php.ini enabling needed extensions.
NOTE: when uncommenting the line: extension=mysql.dll, changed line to
read: extension=mysqli.dll
6. downloaded and unzipped mysql-4.1.3b-beta-win-noinstall.zip to c:\
7. configured mysql per www.mysql.com install instructions
8. copied c:\mysql\bin\libmysql.dll to c:\winnt\system32
9. restarted IIS, and IIS started successfully,
10. reloaded phpinfo(), and noticed that mysqli was properly loaded, but
now my old mysql_connect_db scripts don't work!
Refer to the new mysqli PHP code:
http://us3.php.net/manual/en/ref.mysqli.php
11. Here's a VERY basic example of the old mysql VS. new mysqli PHP code:
OLD mysql:
?php
// connect to the database
mysql_connect(localhost, wong, password) or die (Could not
connect to mySQL server);
// select the database
mysql_select_db(music) or die (Could not connect to database);
// store result
$result = mysql_query(SELECT * FROM artists) or die (mysql_error());
// display returned results
while ($row = mysql_fetch_array($result))
{
echo $row[artist], nbsp;nbsp;, $row[album];
echo BR /;
}
// free result
mysql_free_result($result);
?
NEW mysqli:
?php
// connect to the database
$link = mysqli_connect(localhost, wong, password, music);
// check connection
if (mysqli_connect_errno()) {
printf(Connect failed: %s\n, mysqli_connect_error());
exit();
}
// store query
$query = SELECT * FROM artists;
// store result
$result = mysqli_query($link, $query);
// loop thru rows using associative array
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
{
echo $row[artist], nbsp;nbsp;, $row[album];
echo BR /;
}
// free the result
mysqli_free_result($result);
// close the link
mysqli_close($link);
?
Additionally, for Apache 2 on Win2k (running on port 82):
1. Copied php.ini to c:\Apache Groups\Apache2
2. edited httpd.conf:
- added LoadModule php5_module c:/php/php5apache2.dll
- added AddType application/x-httpd-php .php
3. Restarted Apache server
Hopes this helps.
Dan
Ciprian Constantinescu wrote:
I have included the extension. Now I get Unable to load dynamic library
'C:\php\ext\php_mysql.dll' - The specified procedure could not be found
I have in Windows\System32 the file libmysql.dll. I have also put it in the
php\ext directory without any result.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
