Problem with jokelist.php

[The_Ohh]

Hi,

I've just started going through Chapter 4 in Build Your Own Database Driven Website Using PHP & MySQL and I've already run into some difficulties.

I tried running jokelist.php but I kept getting a blank page! I then removed the @ sign from the front of the mysql_connect function and got the following message:

Fatal error: Call to undefined function mysql_connect() in C:\Documents and Settings\.......

What should I do?

Oye

[Phases]

I'm guessing you'll be asked to post your code so the gurus can take a looksee :P

[The_Ohh]

I'm slowly working my way through this problem......

[vinyl-junkie]

I'm guessing that you typed the code by hand instead of using the download code from the book, right? If so, you may just have a typo in your code. Go get the code from the code archive. It will save you a lot of debugging time.

[The_Ohh]

I tried that, but unfortunately, I get the same problem of:

Fatal error: Call to undefined function mysql_connect() in C:\Documents and Settings\.......

When I run phpinfo.php, I can't see any mention of mysql in the Configure Command field.

[The_Ohh]

What an annoying error! I've spent hours scouring different forums but none of the solutions mentioned seem to work!

[Dylan B]

You have to uncomment the mysql lines in your php.ini

[The_Ohh]

Do you mean extension=php_mysql.dll?

I removed the comment a while ago and it still doesn't work.

[The_Ohh]

It's getting late (too late!!!) and I don't want to throw my computer across the room! Catch you guys some other time....

[psyon]

you should probably check and ensure that php_mysql.dll exists. if it says the function isnt defined, it has nothing to do with your code, only your PHP installation.

[The_Ohh]

i've checked the PHP/ext folder (my folder's called php-5.0.1/ext) and php_mysql.dll does exist.

i've also copied both libmysql.dll and libmysqli.dll to the WINDOWS/system32 folder.

[The_Ohh]

It works!!!

And now the information in phpinfo.php is correct i.e. the correct folders are being displayed in the 'Configuration File (php.ini) Path' field and in the 'extension_dir' field!

HOORAY!

[The_Ohh]

The last thing I did before switching off my computer was to change PHPIniDir (it resides in Apache's httpd, and is used to configure the path to php.ini).

I made it point to "C:/WINDOWS" because my php.ini file is inside my WINDOWS directory. I found it at the bottom of the httpd file.

e.g. PHPIniDir "C:/WINDOWS"

[The_Ohh]

Thanks for all the suggestions!