[PHP 5 MySQL 5 Apache2 win32]Hi everybody, I'm really stuck

[universalbitmapper]

Am I the only one on this planet to try:

PHP 5
MySQL 5
Apache 2

On Windows XP no firewall

With Symantec Norton Internet

I got apache 2 and PHP 5 to work fine.

Previously, using a package called Wamp 5 ( PHP5, Apache 1.3., MySQL 4)
, I managed to read a table in a PHP page.

No I got an error message at the first MYSQL function:

$database = mysql_connect( $server, $user, $password )

PHP complains that he doesn't know this function.

I have these lines in the php.ini file:
extension_dir = "c:\php\ext"
and both
extension=php_mysqli.dll
extension=php_mysql.dll
just in case he wants to pick one.

Also I copied this dll in c:\windows\system32
libmysql.dll

So I'm really at a loss, and frustrated, I feel like I done my homework
and got an F--.

I really do need MySQL 5 for the triggers and I don't feel like
configuring Apache 1.3 for security now and having to do it again later
for Apache 2 from scratch.

I'm ready to everything, even reading some wikipedia faq if I have to.

PPPlease help!!

[David Haynes]

universalbitmapper wrote:

Am I the only one on this planet to try:

PHP 5
MySQL 5
Apache 2

On Windows XP no firewall

With Symantec Norton Internet

I got apache 2 and PHP 5 to work fine.

Previously, using a package called Wamp 5 ( PHP5, Apache 1.3., MySQL 4)
, I managed to read a table in a PHP page.

No I got an error message at the first MYSQL function:

$database = mysql_connect( $server, $user, $password )

PHP complains that he doesn't know this function.

I have these lines in the php.ini file:
extension_dir = "c:\php\ext"
and both
extension=php_mysqli.dll
extension=php_mysql.dll
just in case he wants to pick one.

Also I copied this dll in c:\windows\system32
libmysql.dll

So I'm really at a loss, and frustrated, I feel like I done my homework
and got an F--.

I really do need MySQL 5 for the triggers and I don't feel like
configuring Apache 1.3 for security now and having to do it again later
for Apache 2 from scratch.

I'm ready to everything, even reading some wikipedia faq if I have to.

PPPlease help!!

A couple of things..
1. when you say 'PHP complains that he doesn't know this function', is
that from running from the command line or from apache?
2. If apache, try moving the libmysql.dll to the apache2/bin directory.
3. If apache, try running a small mysql php file from the command line.
4. What does php_info() tell you?

-david-

[pizzy]

universalbitmapper,

Dude, just use MSAS 4.5.2 or whatever release is out now! It's the
easiest way to get all three services up and running.
~pizzy

[universalbitmapper]

Hi,

many thanks for your reply,

I'll try points 2 and 3 ASAP but I never ran PHP/MySQL from the command
line, so it's going to take some time.

I have a full .php script that connects to MySQL, serves a query,
extracts the results and displays them in a table and is working on
MySQL 4, that come from a package called WAMP.

Now when I run the exact same script with mysql 5 I get the message in
the Internet Explorer 6 window:

Fatal error: Call to undefined function mysql_connect() in
C:\jbmorla\data\sources\php\www\database\database. php on line 25

In the Wamp site faq, there is a question, why don't u propose MySQL 5
and they reply it's because now MySQL 5 doesnot accept password
authentification, so you have to use mysqli.dll instead of mysql.dll.

Point 4 php_info()
I don't know this function, I'll try it now, I'll keep you posted.

[pizzy]

universalbitmapper,

Dude, just use MSAS 4.5.2 or whatever release is out now! It's the
easiest way to get all three services up and running.
~pizzy

[universalbitmapper]

Hi,
I just visited the mamboserver site, I did not find any mention of php,
mysql or apache.
But I'll download it, just to check what's in the zip.
Many thanks.

[universalbitmapper]

Hi,
about phpinfo(),
I just ran phpinfo(), which should return the full configuration, it
says nothing about MySQL.
I'm pretty sure it's just a question of having the right .dll in the
right directory and some settings in the php.ini.

[David Haynes]

universalbitmapper wrote:

Hi,
about phpinfo(),
I just ran phpinfo(), which should return the full configuration, it
says nothing about MySQL.
I'm pretty sure it's just a question of having the right .dll in the
right directory and some settings in the php.ini.

If phpinfo does not say anything about MySQL, then the mysql dll is not
being loaded. Typically that means that the php.ini file is not being
read or has not been set up correctly.

Do the other settings you are seeing from phpinfo() make sense? Do they
correspond to the php.ini file? Is there any chance there is another
instance of php on the system?

Also, is there a php_mysql.dll and php_mysqli.dll in c:\php\ext?

-david-

[pizzy]

universalbitmapper,

Google search "MSAS Mambo Stand Alone Server" for it... :-) I found it
on http://mamboxchange.com/frs/?group_id=106 ... There's a
msas-web-installer-45232.

~pizzy

[pizzy]

I personally don't like the template idea of Mambo because I like to
code my own stuff, but this MSAS is really an easy way to get a web
server up and running in minutes.

[sid.bachtiar]

Hi, I tried it too, in the end I found that PHP5 no longer supports
MySQL as a built-in component like it used to. The reason for this is
that MySQL gone fully commercial since version 4, PHP doesn't ship with
the driver any longer. The MySQL dll's packed with PHP now only
supports MySQL 3.

It's been such a long time ago that I may have gotten some facts or
info wrong here.

[universalbitmapper]

Hi, 200602221028

After a late nite of research I got a message indicating that there is
a new version of WAMP that supports both PHP 5 and MySQL 5.
I just installed it and tried /localhost/ and got the wamp welcome
page. PhPMyAdmin is also included, which spares a lot of make hassle.
Now I'll try MySQL 5.
I'll keep you posted.

[universalbitmapper]

Yes! Yes! Yes!

I got the database.php script running first try, MySQL5, PHP 5, Apache
2.
Kudos for the WAMP project.
The world is my fried oyster.

Many thanks for your replies