PHP code will not connect to database

Question

I can connect to MySQL server but not the DB. So on my webpage it shows "Connected to MySQL" but then underneath that I get "Could not select examples which tells me it didn't connect to the database". Could anyone help?

<?php
$username = "user_admin";
$password = "Password";
$hostname = "localhost:3306"; 

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password) 
  or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";
?>

**<?php
//select a database to work with
$selected = mysql_select_db ("my_dbname", $dbhandle)
  or die("Could not select examples");  
?>**

<?php
$sql = "SELECT * FROM `company` WHERE \'companyname\' like \'%a%\' LIMIT 0, 30 "; 

 while($row = mysqli_fetch_array($sql))
   {
   echo $row['companyname'];
   echo "<br>";
   }

 mysql_close($con);
?>

What it may reall be telling you is that the database my_dbname doesn't exist. Are you 10000% it does? — Pekka
– Pekka, Commented Dec 29, 2013 at 17:25
mysql_ is deprecated. But use the command line to check permissions. i.e. dev.mysql.com/doc/refman/5.6/en/mysql.html — Ed Heal
– Ed Heal, Commented Dec 29, 2013 at 17:26
The companyname is a field within the company table. The database definitely exists, I have just double checked and it is holding within the company table over 849,000 rows. — SJOM
– SJOM, Commented Dec 29, 2013 at 17:32

Tosx · Accepted Answer · 2013-12-29 17:33:11Z

2

As Lincb said, maybe the database doesn't exist.

Try to display the error to have more information :

$selected = mysql_select_db('my_dbname', $dbhandle);
if (!$selected ) {
   die ('Error database : ' . mysql_error());
}

answered Dec 29, 2013 at 17:33

Tosx

6063 silver badges8 bronze badges

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

12 Comments

SJOM Over a year ago

I have used your script Tosx. Error database : Access denied for user 'my_username'@'localhost' to database 'my_dbname'

Tosx Over a year ago

I think the information like password is not correct. Try to open directly your phpMyadmin or your database client, and access to your base. Your password is 'Password' ? Generaly the default identifiant is : login : root pwd : ""

lincb Over a year ago

This means you either have the wrong password, or you don't have permissions for that db. Can you try accessing it through PHPMyAdmin or some other way? If you can get into it there, then your script has the wrong password.

SJOM Over a year ago

The password must be correct as there is only one used in the script. It connects to MYSQL but not to the DB, so if the password was incorrect surely it would fail on connecting to MYSQL too? I access MySQL through hostgator so I do not get prompted for any username or password and cannot see a logout option.

Tosx Over a year ago

using 'hostgator' can you see your table ? Indeed is weird that the database connection don't failed. Try to list all database using this : $sql = "SHOW TABLES FROM $dbname"; $result = mysql_query($sql); if (!$result) { echo 'Error MySQL : ' . mysql_error(); }

|

lincb · Accepted Answer · 2013-12-29 17:29:01Z

1

THe most likely cause is that the database "my_dbname" doesn't exist. Also, use mysqli or PDO. mysql is deprecated and insecure.

answered Dec 29, 2013 at 17:29

lincb

6325 silver badges20 bronze badges

2 Comments

SJOM Over a year ago

The database name is not actually "my_dbname" it is something else which I don't want to post up.

lincb Over a year ago

OK, but make sure it's the same as what you have in your script. Anyway, I don't think this is the problem, based on your other comment.

Collectives™ on Stack Overflow

PHP code will not connect to database

2 Answers 2

12 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

12 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related