Removing the @ to know error between my php and mysql connection

comcentury

I have been having problems connecting php with mysql and was advised to remove the @ from the following code below;

// Connect to the database server
$dbcnx = mysql_connect('localhost', 'root',
'mypasswd');
if (!$dbcnx) {
exit('<p>Unable to connect to the ' .
'database server at this time.</p>');
} else {
echo '<p>Database connection established.</p>';
}

I have removed the @ on the code on my php script(work.php) and this is the error message i received;

Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\wwwroot\work.php on line 10

So what next??
remember here is the code;

...Can i connect from my mysql command line client and produce the desired output i need...?

if not how do i correct the error statement shown above??

If it's the command line prompt on mysql,i have installed it successfully on my windows platform..how can i connect mysql with php from the command line prompt and have a confirmation that the connection has been established ??is that possible

if not how do i correct the error statement shown above??

devinemke

that error would suggest that you have enabled the mysql extension in your php.ini. read this.

Piranha

Why do you start 3 threads in the same forum about the same problem? The threads are 10339743, 10339634 and 10339635. One thread is enough.

comcentury

i have done all that is required and therefore i am attaching myphp files for you to see for yourself maybe you can let me know the problem from there
however,Mysql is working fine,as soon as i enter my passoword on the command prompt it opens up and i start
entering data into my database,it all works pretty fine.
I am sending a copy of my <?php and php.ini file
phpinfo();
?>
file for you to check if there are any errors between my php and mysql connection and for you to find out if my directory is reading the php.ini from the right location.

For my server i use IIS 5.1 on windows xp as my local machine server.
I am using the installer version of php 5.1.2-win32 i downloaded from the php site.

Here is the directory of mysql installation

#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 4.1/

I also included "libmysql.dll", in my windows directory and systems 32 directory as well,should i remove it from from one??

please check and see,you might find out something wrong somehere

my server is working pretty well and are interpreting my php scripts superbly ,all i need is to connect mysql and php to be working fine .

NogDog

Did you re-start the web server after you made any configuration changes?

tomhath

Is the file named php.ini? In the zip file it's named php.ini.ini-recommended

According to the php_info file it's looking in C:\WINDOWS, but it doesn't appear that it found the php.ini file (it should say the "Configuration File (php.ini) Path" is something like "C:\WINDOWS\php.ini", not just the directory).

bradgrafelman

To add on to tomhath's observation, you should never see "C:\WINDOWS" the path anyway, because you should never move any files (.ini, .dll, etc.) outside of the PHP directory (which I'll guess is c:\php).

tomhath wrote:
I also included "libmysql.dll", in my windows directory and systems 32 directory as well,should i remove it from from one??

Not one - both. Read my above comment.

When you installed PHP, you followed all of the instructions found at [man]install.windows.manual[/man], right?? No you didn't, and there's your problem; you didn't add your PHP directory to your system's PATH environment variable. See this FAQ for more information on how to do this. But, when you get to the step about restarting your computer, you might want to wait, as you have one more thing to do...

Since you're using IIS (eww!) and not Apache, you should add the PHPRC environment variable to your system so that PHP knows where to find the php.ini file. For more information on how to do this, see this FAQ. Now that you've made this change and the aforementioned one, make sure you restart your computer so that they can take effect.

EDIT: By the way... as Piranha has pointed out, there is absolutely no reason to create a new thread when one already exists. It's not that we don't like new threads in themselves, but when you create multiple threads for one topic it gets quite annoying and might possibly provoke the wrath of the mods 😉

tomhath

Although it's tempting to keep what you have since it's almost working, you might want to try a completely different installation. As bradgrafelman hinted, Apache is a very nice web server; I've found it much easier than IIS to work with.

xampp http://www.apachefriends.org/en/xampp-windows.html installs and configures everything for you.

comcentury

bradgrafelman wrote:
To add on to tomhath's observation, you should never see "C:\WINDOWS" the path anyway, because you should never move any files (.ini, .dll, etc.) outside of the PHP directory (which I'll guess is c:\php).

Not one - both. Read my above comment.

When you installed PHP, you followed all of the instructions found at [man]install.windows.manual[/man], right?? No you didn't, and there's your problem; you didn't add your PHP directory to your system's PATH environment variable. See this FAQ for more information on how to do this. But, when you get to the step about restarting your computer, you might want to wait, as you have one more thing to do...

Since you're using IIS (eww!) and not Apache, you should add the PHPRC environment variable to your system so that PHP knows where to find the php.ini file. For more information on how to do this, see this FAQ. Now that you've made this change and the aforementioned one, make sure you restart your computer so that they can take effect.

EDIT: By the way... as Piranha has pointed out, there is absolutely no reason to create a new thread when one already exists. It's not that we don't like new threads in themselves, but when you create multiple threads for one topic it gets quite annoying and might possibly provoke the wrath of the mods 😉

Thanks man i did everything you told me and it eventually worked..o 'm so excited i couldnt rest until i made sure i send you my gratitude