[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_m ysqli.dll
extension=php_m ysql.dll
just in case he wants to pick one.

Also I copied this dll in c:\windows\syst em32
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]

universalbitmap per 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_m ysqli.dll
extension=php_m ysql.dll
just in case he wants to pick one.

Also I copied this dll in c:\windows\syst em32
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]

universalbitmap per,

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\ww w\database\data base.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
authentificatio n, 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]

universalbitmap per,

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]

universalbitmap per 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]

universalbitmap per,

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.