No Database selected error in PHP with MySQLi

Question

I have to select data from MySQL Database. I have been looking for the answer, but still haven't found any. I am learning from W3School

My MySQL doesn't have any username or password, so my code looks like this:

<?php
$servername = "localhost";
$dbName = "db_Test";

//Create Connection
$conn = mysqli_connect($servername, $dbName);
//Check Connection
if(!$conn){
    die("Connection Failed. ". mysqli_connect_error());
}
$sql = "SELECT ID, Name, Category, Description, Price FROM items";
$result = mysqli_query($conn, $sql);

if(!$result){
    die(mysqli_error($conn));
}

if(mysqli_num_rows($result) > 0){
    while($row = mysqli_fetch_assoc($result)){
        echo "ID: ".$row['ID']." Name: ".$row['Name']." Category: ".$row['Category']."<br>";
    }
}
?>

First I got this error

mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in

On further tracing it back in the stack, I got this:

No database selected

I don't know what I'm doing wrong. So can you explain it to me and give me the solution. Thanks in advance

you need to add username and password for connect mysql database. for your reference: http://www.w3schools.com/php/php_mysql_connect.asp — Vishal Khunt, Sep 23 '16 at 06:30
As I said to you, My database dont have any username or password. And for your noted, I have succsessfully connection with that code — Tommy Sayugo, Sep 23 '16 at 06:42

score 1 · Answer 1 · edited Sep 23 '16 at 13:37

1

Set mysql username and passwork something like this.

$username = "root";
$password = "";

And set connection like this.

$conn = mysqli_connect($servername, $username, $password, $dbname);

edited Sep 23 '16 at 13:37

Oldskool

34,211
7
53
66

answered Sep 23 '16 at 06:28

Rax Shah

531
5
18

No Database selected error in PHP with MySQLi

1 Answers1

Linked

Related