php No database selected

Question

Have been trying to figure out for about an hour why, when I enter log in information on the index page, then click submit, it says "No database selected" on the Login.php page. Any advice would be much appreciated, thanks!

The connect.php file

<?php
$host= "127.0.0.1";
$username = "root";
$password = "";
$db = "users";

mysql_connect($host, $username, $password) or die(mysql_error());
mysql_select_db($db);
?>

The login.php file

<?php
session_start();

//Login Script

//Make sure have access to database
include_once("connect.php");

//If the post of the username (username has been submitted on login form)
if (isset($_POST["username"])) {

//set variables
$usernmame = $_POST["password"];
$password = $_POST["password"];

//Select the column from the users table where the username is the username entered aps same for password
$sql = "SELECT * FROM users WHERE username='$username' AND password='$password' LIMIT 1";

//Run quety
$result = mysql_query($sql) or die(mysql_error());

if (mysql_num_rows($result) == 1) {
    echo "Success";


}

else {
    echo "Again";
}
}

The index file

<?php
session_start();
?>

<head>
<title>Login test</title>
<link rel="stylesheet" type"text/css" href="style.css" />
</head>

<div id="wrapper">
<h2>test log in</h2>

<?php
//If not logged in, display login formThe 
if(!isset($_SESSION["uid"])) {
    echo "<form action='Login.php' method='post'>
            Username: <input type='text' name='username' />&nbsp;
            Password: <input type='password' name='password' />&nbsp;
            <input type='submit' name='submit' value='Login'/>";
}

else {
    echo "<p>You are logged in as ".$_SESSION['username']." <a href='Logout.php'>Log out</a>";
}
?>

Migrate from mysql_* function to eg. PDO. Also, show us include_onceTh function. — Elon Than
– Elon Than, Commented Sep 10, 2015 at 17:29
Also, you are using wrong variable in mysql_num_rows($res). — Elon Than
– Elon Than, Commented Sep 10, 2015 at 17:30
Yeah sorry I corrected those two, but mysql_connect should work?? — WebDev661
– WebDev661, Commented Sep 10, 2015 at 17:36
you have a typo there include_onceTh("connect.php"); should be include_once("connect.php"); ;-) — Alex
– Alex, Commented Sep 10, 2015 at 17:36

Alex · Accepted Answer · 2015-09-10 17:48:49Z

1

First of all you should stop using mysql_* functions.

But just to try to help you pass this obstacle for now try this way:

$db_link = mysql_connect($host, $username, $password) or die(mysql_error());
mysql_select_db($db, $db_link);

and then always use that $db_link like:

$result = mysql_query($sql, $db_link) or die(mysql_error());

answered Sep 10, 2015 at 17:48

Alex

17.3k1 gold badge31 silver badges52 bronze badges

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

Comments

undefined · Accepted Answer · 2015-09-10 17:47:12Z

0

The mysql_connect(note the deprecation warning on the page) function doesn't let you specify a default database. However the mysqli_connect function does.
Also the return value of mysql_select_db should be checked, to see if the database is actually selected.

answered Sep 10, 2015 at 17:47

undefined

2,0933 gold badges26 silver badges48 bronze badges

Comments

undefined · Accepted Answer · 2015-09-10 18:44:30Z

0

I could be wrong but I don't believe the mysql_connect function allows you to select the database. Try the following in your connect file. You should also consider switching to the MYSQLI functions which support selecting a database on connect.

mysql_connect($host, $username, $password) or die(mysql_error());
mysql_select_db($db);

edited Sep 10, 2015 at 18:44

undefined

2,0933 gold badges26 silver badges48 bronze badges

answered Sep 10, 2015 at 17:31

blazerunner44

6578 silver badges19 bronze badges

3 Comments

WebDev661 Over a year ago

This is what it was originally isn't it?

Alex Over a year ago

@WebDev661 no there is a difference when call mysql_connect

Alex Over a year ago

@WebDev661 update your original post with updated code please

Collectives™ on Stack Overflow

php No database selected

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related