hi all
im new with PHP and Mysql
so i have this stuipt errer each time
-----------------------------------------------------------------
Fatal error: Call to undefined function mysql_pconnect() in c:\Inetpub\wwwroot\lesson7\testconn.php on line 8
------------------
for this code
<?php
$username = "root";
$password = "123";
$link = mysql_pconnect("localhost", $username, $password)
or die ("Connection <font color='#FB0209'>Not</font> Complete<hr>".mysql_error());
echo "Connection <font color='#1A5816'>Complete</font>!!! ";

?>
plz help

The function "mysql_pconnect isnt a defined function - you have added a 'p' by accident, take it away and it should be fine. The function should read "mysql_connect".

Stoot

The mysql_pconnect function creates persistent connections to the database.
It sounds like your PHP configuration does not support MySQL - check the output of phpinfo(); to confirm this.

I guess you are using PHP 5. If so you may be missing the MySQL client library and appropriate php.ini configuration.
Are you using Linux or Windows?

reply to stoot 98
i correct the mistake but stil the same


reply to electricsheep
plz , can u tell me how to configure php.ini

im using

winxp with ISS
php-5.1.4-installer
mysql-4.0.26-win32

you need php_mysql dont know what its called under windows but its obviously a lack of mysql support.

Ibbo

Hi again,

I haven't used Windows for a while but I think the following will work :

Try these steps BEFORE running any php scripts :

don't worry if you cannot carry out a particular step, just complete the steps that you can

go to your php folder
look in the extensions subfolder ( possibly called 'ext' )
look for the files 'php_mysql.dll' and 'libmysql.dll'
copy what you find in to your 'WINDOWS/system32' folder

find your php.ini file, possibly in the Windows folder
copy the file and save it to a safe place as a backup

open the original in Notepad

look for the line that starts extension=libmysql.dll
remove the ; at the beginning of this line

look for the line that starts extension=php_mysql.dll
remove the ; at the beginning of this line

save the file

run a script that uses a mysql function to see if things are working
it may be best to reboot your machine to double check that it is now working

let us know how you get on - good luck!

Ah ok, wasnt aware of that other function, just presumed it was a typo... hope you get it working....