Question: I am having trouble to sign up for the php and it gives me this error Warning : mysqli_connect(): (HY000/1049): Unknown database 'lab' in C:xampphtdocslab1

I am having trouble to sign up for the php and it gives me this error

Warning: mysqli_connect(): (HY000/1049): Unknown database 'lab' in C:\xampp\htdocs\lab1 ew_user.php on line 8

I dont know if the code was different

here is the code

$username = "root";

$password = "";

$hostname = "localhost";

$dbname = "lab";

$selected = mysqli_connect($hostname, $username, $password, $dbname);

if(isset($_POST['user']) && isset($_POST['pass'])){

$user = $_POST['user'];

$pass = $_POST['pass'];

$query = "SELECT * FROM users WHERE username='$user'";

$result = mysqli_query($selected, $query);

if(mysqli_num_rows($result) > 0 ) { //check if there is already an entry for that username

echo "Username already exists!";

}else{

$query = "INSERT INTO users (username, password) VALUES ('$user', '$pass')";

$result = mysqli_query($selected, $query);

header("location:index.php");

}

}

mysqli_closhe($selected);

?>

Signup!

" method="POST">

Username:

Password:


Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!