Wanted to know the right MySQL connection

[ruprety]

Hello,

Since I successfully install Apache, PHP, and MySQL 5.1 on my local machine, I wanted them to run locally. As my understanding to connect to the MySQL 5.1 on the local machine, I must write the following parameters in mysql_pconect method. The password is my real password, but the remaining I thought I should leave them as a default. So the “localhost” and “root” are the default since I install MySQL 5.1on the same machine.

Even if I follow all the procedures to make it work, I am still unable to load the data into MySQL database using PHP. Correct me if I make a mistake passing right parameters in the following method. Again to be more specific, I am using Windows XP Pro.


@ $db = mysql_pconnect("localhost", "root", "488704");

[NogDog]

Firstly, I would recommend using mysql_connect() instead of mysql_pconnect() unless you really understand the difference and know that your web host and database are configured to support persistent persistent connections via this mechanism.

In any case, start by getting rid of the "@" while you are debugging, and outputting some error info if it fails.

<?php
ini_set('display_errors', 1); // set to 0 when ready to turn off error displays
error_reporting(E_ALL);

$db = mysql_connect('localhost', 'root', '488704');
if($db == false)
{
   user_error(mysql_error());
}

[ruprety]

I did change the way you suggest me by changing the code like this:

ini_set('display_errors', 1); // set to 0 when ready to turn off error displays
error_reporting(E_ALL);

$db = mysql_connect("localhost", "root", "488704");
if($db == false)
{
user_error(mysql_error());
}

mysql_select_db("information");

Once I run the page, I am seeing the following error:

Fatal error: Call to undefined function mysql_connect() in C:\webdocs\PHPandMysql\page239\insert_book.php on line 39

[NogDog]

OK, that tells us that as far as PHP is concerned, the PHP MySQL extension is not installed. A couple choices:

1. You could try using the newer MySQLi extension, instead.

2. You could check the relevant "sticky" posts here in the Install and Database sub-forums for details on getting the MySQL extension up and running in PHP 5.

(A third option if you just want to get it done is to uninstall PHP, MySQL, and Apache and then reinstall with an all-in-one installer like WAMP or XAMPP, though you don't learn as much that way. 😉 )

[ruprety]

Since this is one time deal, I want to take a hard way to configure all this manually so I can learn how to do it, by following your second option. I went on to set the environmental variable for PHP, and the path was C:\php, as I have all PHP executable folders under this C:\php folder.

Even I went to reconfigure the php.ini file by commenting out the colon of “;extension=php_mysql.dll” to be able to see the MySQL database.

One thing that makes me confused is I configure Apache HTTP Server 2.2 in a C:\webdocs\ where I can run all the .php files only under this folder. Does this make a difference to the setting I follow earlier?

The reason is I am getting the same error: Fatal error: Call to undefined function mysql_connect() in C:\webdocs\PHPandMysql\page239\insert_book.php on line 39

Thank you so much.

[NogDog]

I don't think it especially matters where the PHP executables are, as long as the various path settings and such point to the same place. It's a separate issue from the web document root.

Also, don't forget to restart Apache after any changes to php.ini or httpd.cnf.