I am having a problem I do not understand. I have gone through everything in the book and have had no problems until I started to use PHP to connect to the MySQL server (page 96/96) at which point my browser displays the following error message:

"Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\desops\PHP with MySQL\createmovie.php on line 3"

I can connect to the server from the command prompt without any problems and I cannot understand why I am getting this particular error.

Does anyone out there have any idea what is going on please?

SleepyD

MySQL is not yet enabled in php, so it does not recognise the mysql_connect query as an existing function.

you have to make sure that libmysql.dll is in your \windows\system32 folder.

If that doesn't solve it, try looking in your php.ini in the \windows folder to see if you have the correct steps enabled for mysql support and just to be sure, backup the php.ini in your \PHP folder and replace it with the EXACT same copy as the one in your \windows folders as i have heard of instances where php refuses to use the php.ini in windows.

Thank you club662, your suggestion partially worked. I moved libmysql.dll into my \windows\system32 folder. It didn't work straight away, so I had a look around and found that I had to enable the loading of the php_mysql.dll module in php.ini in the \windows directory (it had no effect in the \php directory!!)

However, I am now getting another error, namely "Fatal error: Call to undefined function mysql_create_db() in C:\Program Files\Apache Group\Apache2\desops\PHP with MySQL\createmovie.php on line 6", which is the very next php command.

Now if the first error was caused by MySQL not being enabled in php, why am I now getting a create_database error? I would have thought that the procedures would have corrected the php/MySQL recognition problem. Hmmmmm...something to think about.

Incidentally, whilst looking at the php.ini file, I did notice that, by default, none of the modules were enabled , neither was the path to the loadable modules set. I did set the path and enabled only the php_mysql.dll module, but would I also need to enable the rest? The path setting on its own appears to have no effect. Any thoughts please? Would be most appreciated.

By the way, I am using Apache 2.0.54, MySQL 4.1 and php 5.0 on Windows XP Professional, all on a Toshiba Satellite Pro laptop. Does this help?

Aha, I thought that I had read of someone having the same problem as I had outlined above - I found the answer to the "call to undefined function" error presented by Triplegee and answered by garethtaylor 04/06/2005. I changed the "mysql_create_db()" function to "$query = mysql_query("CREATE DATABASE wiley") or die(mysql_error());" and - voila - database successfully created.

I would like to extend many thanks for all your help and assistance, but, being an awkward cuss - I would really like to know why one form works and the other fails (in addition to the other queries posted earlier!!).

SD

It probably has to do with diffrent versions of MySQL,
the book i have only uses the mysql_query("CREATE DATABASE moviesite") function and thus never gives me any trouble.
I guess this has been done for several reasons, unknown to me.

The only functions used in the next book are the following:

$connect = mysql_connect()
mysql_select_db("databasename", $connect)

and for any other query

$query = "whatever"
mysql_query($query)

if you use these options you'll get along just fine.

be sure to check back here once in a while though, to see if you can help someone, or just for general solutions, maybe we can kick this forum back to life :).

good luck

Thank you again Club662. The information was very helpful.

And yes, I will be checking in often - I appreciated your assistance and am more than willing to contribute in any way that I can.

Thank you again

SD