I am using the instructions in the tutorial at: http://www.freewebmasterhelp.com/tutorials/phpmysql/3
to load my local mysql table called "contacts" in my local database "local_db" with data. I can't connect to the database. I get this error message:
Notice: Use of undefined constant localhost - assumed 'localhost' in c:\program files\easyphp1-8\www\new folder\load_contacts.php on line 6

Warning: mysql_connect(): Access denied for user 'ODBC'@'localhost' (using password: NO) in c:\program files\easyphp1-8\www\new folder\load_contacts.php on line 6
Unable to select database
my php code is in easyphp1-8\www\new folder\load_contacts.php.
Is the "new folder" location OK?
The code of contacts.php is:

PHP Code:

<?php
$username="";
$password="";
$database="local_db";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
mysql_query($query);
$query = "INSERT INTO contacts VALUES ('','John','Smith','01234 567890','00112 334455','01234 567891','johnsmith@gowansnet.com','http://www.gowansnet.com')";
mysql_close();
?>

What am I doin'?
Thanks in advance!

localhost needs to be your IP, for example

"81.938.534.35"

Localhost should have been in quotes. If the database is local then localhost is correct. This should work.

PHP Code:

 <?php
$username="";
$password="";
$database="local_db";
$host="localhost";
$connection = mysql_connect($host,$username,$password);
mysql_select_db($database,$connection) or die( "Unable to select database");

$query = "INSERT INTO contacts VALUES ('','John','Smith','01234 567890','00112 334455','01234 567891','johnsmith@gowansnet.com','http://www.gowansnet.com')";
mysql_query($query);
mysql_close();
?>

Originally Posted by maxxximus

Localhost should have been in quotes. If the database is local then localhost is correct. This should work.

PHP Code:

 <?php
$username="";
$password="";
$database="local_db";
$host="localhost";
$connection = mysql_connect($host,$username,$password);
mysql_select_db($database,$connection) or die( "Unable to select database");
 
$query = "INSERT INTO contacts VALUES ('','John','Smith','01234 567890','00112 334455','01234 567891','johnsmith@gowansnet.com','http://www.gowansnet.com')";
mysql_query($query);
mysql_close();
?>

Using your code (thank you!) I get this error message:

Warning: mysql_connect(): Access denied for user 'ODBC'@'localhost' (using password: NO) in c:\program files\easyphp1-8\www\new folder\load_contacts.php on line 6

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in c:\program files\easyphp1-8\www\new folder\load_contacts.php on line 7
Unable to select database

I need to find out my username and password don't I! Is that it?

Default installation; username is 'root', if you didn't set a password then leave blank.

$username="root";
$password="";