Fatal error: Call to undefined function mysql_connect()

[Julian Bowler]

Please can some one help with my problem; I am running Apache web server on my lap top, plus a mysql server and php. The version of php currently installed is 5.2.5.
when i write some php to connect to my mysql database server instead of it connecting i get :
Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\h tdocs\chephrenr epairs\dataentr yprocess.php on line 16.

question 1 is this:
Is this happening because the version of php i have installed has no support for mysql bundled with it?

Question 2: Are there some versions of php 5 that have no support for mysql at all because it was removed by the php writters and if so which versions of php 5 do have mysql support built in to them that works properly?

I have looked on this forum and found that someone said that mysql support was removed in php 5, but it sdoes not say which version of php 5 it was removed from, neither does it hint as what to do to get php communicating twith the local mysql server??

if questions 1 and 2 have been answered in anther thread on this forum then please where???

[Julian Bowler]

as per the post by ak1dnar previous, i tried putting this line into php.ini
extension = php_mysql.dll
and then saving the file and stopping and then restarting Apache, but what happens is that Apache will not start, and instead we see a message on the screen that says:
PHP Startup: Unable to load dynamic library 'C|PHP5\ext\php _mysql.dll' - The specified procedure could not be found.

so please does any one know what this means and does it have any relavance to my problem which is that I can ot run a php script that simply calls the mysql_connect() function??? ?

What is missing ? Is php unable to run any mysql type function and is the reason possible to discover?
I come back to this question, what is needed in a php installation to be able to run all mysql functions to communicate with a local MySQL Server??
And which versions of php work with MySQL? Has Mysql support ben remved form some or all php 5 versions, I am sure I had it all working fine previously with a php 4 version!!?
is the next thing to try, removing php 5.0.2 and install a php 4 version?

[Julian Bowler]

many thanks for Dormilich response, yep i could try a WAMP Package but one thing that concerns me is are there any WAMP Packages that work reliably, and also if the WAMP Package does not work properly can it be uninstalled without messing up my computer.
Has anybody any experience of WAMP Packages that work well and are straight forward to install, of course i would need a WAMP Package for use on windows XP Home.....
Finally, would I need to uninstall Apache MySQL and PHP prior to installing a WAMP Package??? What set up of the MySQL part would be required, normally in My SQL you need t remove some default users, and create some new users to get MySQL Server to work I do believe.?

[Dormilich]

@Julian Bowler
the path looks strange. I'd have expected something like 'C:\PHP\...'
@Julian Bowler
I have 5.2.8. working (through MDB2) and so do thousands of others.

[Julian Bowler]

PHP 5.2.8 working with MDB2, please tell me what is MDB2 is that a relational database like MySQL that can be ran on a web server? I have not herd of MDB2?
ta..

[Dormilich]

in short MDB2 is a Database Abstraction Package provided through PEAR. see PEAR :: Package :: MDB2 (it makes working with databases easier)

note: MDB2 for MySQL uses PHP's mysql functions

[Julian Bowler]

many thanks for your reply, I am tomorrow going to remove php 5.0.2 and then try installing php version 4.4.7, this is the zipped win32 version. I will then attempt to configure this to work with MYSQL that is installed and running on my lap top. I have read on the internet that php 5 does not have MySQL Support built into it and that it has to be configured manually, but I have tried quite a few things so far and i still get the
Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\h tdocs\chephrenr ep.....
every time i run the php script calling this function.

IF PHP 4.4.7 will not solve the problem I will most likely rebuild the entire Lap Top from scratch starting with using the original cd to put it back to how it was in the factory and then installing Apache, php 4.4.7 which i do hope will work, and then Mysql 4.1.

All replies to this thread have been very helpful.... intend to add to this thread tomorrow

[ak1dnar]

Sorry guys, I was quite busy with my works last day. :(

Ok, back to the questions. My first recommendation is do not revert back to Php 4.x.x as now we have Php 5.x.x which is more powerful and stable.

Your problem is some what strange to me. may be as "Dormilich" said, you have used some corrupted version of php installer.

Still I suggest you to install MySQL, Php, Apache as separate installations. Doesn't matter if you happy with WAMP also, it a good tool. But I still like to configure them individually.

If you need to do it from scarch here we go !

Uninstall Php, MySQL, apache from your system.and restart your pc.

Install Apache
Download apache_2.2.11-win32-x86-openssl-0.9.8i.msi and install it with the default settings.

Install MySQL
Download and install mySQL from here MySQL 5.1 and install it with default settings

Install Php
Now get thePhp 5.x.x from php.net, PHP 5.2.8 installer is better.

When Installing select the Apache Version 2.2.x as your target web server.

Provide the apache configuration dir when asking.
ex: C:\Program Files\Apache Software Foundation\Apac he2.2\conf\

Then you can select the Extensions > MySQL and enable it. (Do not select all the extensions as it will brake the configuration)

Restart the Apache or your PC.

Now create a test script ( phpconfigtest.p hp ) with these lines of code and put it to Apache Doc Root. (Hope you know where it is)

<?php
phpinfo();
?>
 

exceute the page as http://localhost/phpconfigtest.php
you will see the Php confuguration info in detail in the page. find the "mySQL" details area. if it is there and if mysql support enabled, you are good to go with Php-MySQL.

Happy coding.
--ak1dnar

[Julian Bowler]

very helpful response from ak1dnar,many thanks... yep it is possible that some file or files are corrupted it does actually happen!! As to uninstalling Apache, well it appears in the add and remove programs feature of Control Panel, so i guess can be removed using that. also PHP 5.2.2 also appears in add and remove programs, but is is not there as i removed its directory before, that is bizarre and plan bonkers!!

Hence i will try to remove Apache using add and remove programs and do the same with MySQL and MySQL Query Browser and MySQL Administrator. then i will remove the current php directory and remove all the files i copied to C:/Windows and to C:/Windows/system and then finally start again with the pieces of software recommended by ak1dnar.

just to be clear, you can test whether or not php is working by writing a program like:
<?php

phpinfo():
?>
and running it and you will see a blue page, but you can not test a php connection to a MySQL database unless you write some specific functions to connect and to use a database etc, and to do this you need of course an actual database and a user to actually exist first, and probably a table in that database would be also very useful me thinks......

[Dormilich]

@Julian Bowler
jepp.

@Julian Bowler
correct, the phpinfo() tells you whether PHP correctly recognized its MySQL part. testing the mysql functions indeed requires a database, user, ... which are usually unknown to php.ini

[Julian Bowler]

I have now installed all recommended by ak1dnar, and it has all installed fine,but when i run the mysql _connect function in a web page, i get a blank page, absolutely nothing, white screen.....
I have checked that in php .ini
and there is in it
error_reporting = E_ALL
and
display_errors = On, and i restarted the Apache server,
so what is going on why will it apparently not work. what should i try to do next??