Error: No Database Selected - php/mysql

Question

HELP!!! I can't figure out why I am getting an error: no database selected. My code is below:

session_start();

$db_host        = 'localhost';
$db_user        = 'username';
$db_pass        = 'password!';

/* End config */

$link = mysql_connect($db_host,$db_user,$db_pass) or die('Unable to establish a DB     connection');

mysql_select_db("database", $link);

mysql_query("INSERT INTO table (field1, field2) 
VALUES ('$field1', '$field2')");

if(mysql_affected_rows($link)==1) { 

    echo "success";
}
else 
{
    echo "Error: ". mysql_error() ."";
}

Don't use the mysql_* functions; they are deprecated. Use PDO or MySQLi. — elixenide
– elixenide, Commented Jul 7, 2014 at 18:42
@Bhushya no, i changed it to that for privacy purposes when i posted it. — Paige Rose Figueira
– Paige Rose Figueira, Commented Jul 7, 2014 at 18:45
Then chk ur using proper database credentials or not.. even used credentials has required permission to the db — bhushya
– bhushya, Commented Jul 7, 2014 at 18:48
@Bhushya That worked! It was the database credentials. I just upgraded to cpanel and didn't realize you had to take that extra step. Thank you! — Paige Rose Figueira
– Paige Rose Figueira, Commented Jul 7, 2014 at 18:55

go0n · Accepted Answer · 2014-07-07 18:47:50Z

2

Possible problems
1. Does "username" have access to "database" (PRIVILEGES)
2. Does "database" exist?

Side note - You should be using mysqli or PDO because mysql will be deprecated in upcoming releases

answered Jul 7, 2014 at 18:47

go0n

1082 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

Error: No Database Selected - php/mysql

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