mySQL connection error using php codes

Question

"Warning: mysql_connect(): A connection attempt failed because the connected party did not properly respond after a period of time or established connection failed because connected host has failed to respond. in C:\xampp\htdocs\appraisal\database.php on line 5 No database selected"

Why does it show most of the time? But when I refresh the page by entering F5, the error will be gone and will show the output correctly. This doesn't really affects the system but it is quite bothering when our users see the error.

I have the codes here.

<?php
$dbhost='localhost';
$dbuser='root';
$dbpass='';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db('db_appraisal');
?>

Hoping for your response. Thanks!

Please don't add 'solved' to question titles.

The Blue Dog
– The Blue Dog

2014-10-23 11:21:56 +00:00
Commented Oct 23, 2014 at 11:21 — The Blue Dog
– The Blue Dog, Commented Oct 23, 2014 at 11:21

RiggsFolly · Accepted Answer · 2014-10-23 10:16:35Z

2

Try adding the $conn parameter to the mysql_select_db function call

<?php
$dbhost='localhost';
$dbuser='root';
$dbpass='';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db('db_appraisal', $conn);
?>

Link to The Manual

If you are writing new PHP code you should really not be using the mysql_* extension as it has been deprecated i.e. it will be removed from PHP sometime soon.

Use either the mysqli_* extension or the PDO one.

answered Oct 23, 2014 at 10:16

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mySQL connection error using php codes

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related