trying to connect to my database in my localhost but keep getting an error

Question

 < ?php
     $connection = mysql_connect(localhost","user","password") or die ("Couldn't connect to the server!");
     mysql_select_db("users", $connection) or die ("Couldn't connect to the database!");

I used the above code above to try and connect to my database but keep getting an error in line 2 where mysql_connect(localhost)---- I've typed in my localhost name correctly why won't it work?

please help this is my first day ever dealing with php and databases. thanks in advance.

It usually helps if you look at the actual error message: http://php.net/mysql_error (sigh, and here was me assuming that since you didn't say what error message you were getting, it was because you were getting *Couldn't connect to the server!*) — Quentin, Oct 26 '14 at 14:28
`localhost` needs to be quoted fully. You are missing the opening quote. `"localhost"` — Michael Berkowski, Oct 26 '14 at 14:28
You are using [an **obsolete** database API](http://stackoverflow.com/q/12859942/19068) and should use a [modern replacement](http://php.net/manual/en/mysqlinfo.api.choosing.php). — Quentin, Oct 26 '14 at 14:29
@MichaelBerkowski if that was the issue the PHP parser wouldn't have started and he would not be getting any errors at all. — I wrestled a bear once., Oct 26 '14 at 14:33
@MOHAMEDAHMED Post your actual code. As in copy/paste. If that IS infact your code you need to first fix the two things that have been pointed out to you. — I wrestled a bear once., Oct 26 '14 at 14:36
The only reason to edit the actual code is to remove your user or pass — I wrestled a bear once., Oct 26 '14 at 14:36

score 0 · Accepted Answer · edited Oct 26 '14 at 14:31

0

Missing a quote in localhost:

$connection = mysql_connect("localhost","user","password") or die ("Couldn't connect to the server!");

edited Oct 26 '14 at 14:31

I wrestled a bear once.

21,988
17
67
115

answered Oct 26 '14 at 14:29

benscabbia

16,476
12
45
60

the "localhost" still is highlighted in red and when I load up the page i get "opject not found!" "Error 404" – MOHAMED AHMED Oct 26 '14 at 14:31
@MOHAMEDAHMED are you running the script from a webserver or locally? – benscabbia Oct 26 '14 at 14:33

score 0 · Answer 2 · 2014-10-26T14:38:08.443

0

The correct way to do it is:

<?php
$connexion = mysql_connect("localhost", "user", "password")
    or die("Couldn't connect to the database! : " . mysql_error());
mysql_close($connexion);
?>

Nota Bene:

Rather use mysqli_ or PDO. What you are using here is deprecacted for security reasons.

edited Oct 26 '14 at 14:38

answered Oct 26 '14 at 14:31

trying to connect to my database in my localhost but keep getting an error

2 Answers2