Hi, I'm trying to set up my MySQL in the program on this page. I'm putting in the exact information with my password that I set up in the MySQL setup. When I test the file in my browser, I get a:

FATAL ERROR: Call to underfined function mysql_connect() in ...

This is what I have in my code:

$connect = mysql_connect("localhost", "root", "mypassword") or
die ("Hey loser, check your server connection!");

Can you please help me!!!

Are you using PHP 5? You are getting this error because mysql support is not built into PHP5.. you have to enable the mysql extension. On Windows you'd open up the php.ini file located at C:\Windows\php.ini and uncomment the extension reference (remove the semi-colon), verify the path to the extensions directory:

extension_dir = "C:\PHP\ext"

Save changes.

Make sure that you've downloaded the zip package that contains the mysql .dll (this will be in the ext directory).

Restart Apache, retry the script.

hth,
: )
Rich

::::::::::::::::::::::::::::::::::::::::::
The Spicy Peanut Project
http://www.spicypeanut.net
::::::::::::::::::::::::::::::::::::::::::

I am using PHP 5. I have made the changes that you said to make above, but now i have another problem. When I try to restart my Apache server it says that it can't find the "C:\php\ext\php_mysql.dll" file. I know that I've put the correct extensions and stuff.

What else do i need to do to get this to work? Please help me!

I think I can recall having the same (or similar) problem with my attempt at using PHP5. I know the proceedures for installing the extension to be complete, as this is the same proceedure for installing any other PHP extension. So I'm not really sure at this point, as I haven't explored PHP5 much. You might want to stick with a PHP4 release till PHP5 comes out of beta testing (mysql support is built into PHP4).

You might ask on a PHP mailing list:
http://www.php.net/mailing-lists.php.

I'd be interested in hearing the solution too.

Regards,
Richard York


::::::::::::::::::::::::::::::::::::::::::
The Spicy Peanut Project
http://www.spicypeanut.net
::::::::::::::::::::::::::::::::::::::::::

You also need to uncomment this line:

;extension=php_msql.dll

... and you need to copy libmysql.dll to the %systemroot% directory. That is "WINNT" on NT based systems. Usually will be "Windows" on 95/98/ME/XP-home(?) .

If not sure go to a command window (cmd on NT, command on 9x/me) and type in "CD %systemroot%" (without the quotes). That will take you to your the sysroot.

I had a similar problem with the code on page 96. The file simply would not connect to the server. After much looking around the internet I tried a tip of typing the following through the command prompt :

c:\mysql\bin>mysqld --console

This seemed to make mysql ready for connections thus allowing the php files to work. Why this is needed I don't know, or if there is a better way around this problem.

Hope that helps somebody !

In other words you started the daemon aka service. What you did there was start to start the service so it could receive connections, write errors to the console, and keep the console open.

you might also try NET START MYSQL or go to the services MMC console and start or stop it.

Possibly you made a change in mysql or you installed it to NOT run as a service or you killed the service for whatever reason.

I'm trying this out on an actuall free host ( www.5gigs.com) as I blundered the mysql installation. Unfortunatly I was only givin 1 database. From reading the scripts it looks like all i need is 1 database (wiley). Is this true and if so how do I code createmovie and moviedata as 1 file/database?

You do only need one database to complete chapter 3. To write to and query that database you can use as many php files as you want. Also you could create more tables in that database (on a different theme) and use alternate php files to write to and query those.

For the purposes of going through the rest of the book, if you are new to all this, it is probably wise to take the time out to get your AMP setup working locally. As a pointer, some of the main setup woes come from version problems of the three varying. The setup information in the book was written for:

Apache 2.0.49, PHP 4.3.7, MySQL 4.0.15