Return MySQL query in PHP using mysqli class

Question

It appears that I am connecting to a MySQL database but unable able to return a query using mysqli class. I've done some searches and what I have coded should return the results, but I am missing something.

   <?php

set_include_path('/Applications/MAMP/db/mysql57');

$host = "127.0.0.1";
$user = "admin";
$password = " ";
$bookDatbase = "Books";

$mysqli = new mysqli($host,$user, $password, $bookDatabase);

if ($mysqli->connect_errno) {
    printf("Connect failed: %s\n", $mysqli->connect_error);
    exit();
}

$result = $mysqli->query("SELECT Title FROM Book");

echo $result;

What else does it return if not the results?

JTinkers
– JTinkers

2019-02-21 12:56:00 +00:00
Commented Feb 21, 2019 at 12:56 — JTinkers
– JTinkers, Commented Feb 21, 2019 at 12:56
Hi, you have typo in $bookDatbase/$bookDatabase

Kristijan Mikulec
– Kristijan Mikulec

2019-02-21 13:02:39 +00:00
Commented Feb 21, 2019 at 13:02 — Kristijan Mikulec
– Kristijan Mikulec, Commented Feb 21, 2019 at 13:02

Kristijan Mikulec · Accepted Answer · 2019-02-21 14:30:12Z

1

$conn = new mysqli("localhost","username","password","Books");

$result = $conn->query("SELECT Title FROM Book");

if(mysqli_error($conn)){
    echo mysqli_error($conn);
}
else{

    $titles = [];

    while ($r = mysqli_fetch_assoc($result)){
        $titles[] = $r;
    }

    echo "<pre>";
    print_r($titles);
    echo "</pre>";
}

answered Feb 21, 2019 at 14:30

Kristijan Mikulec

1641 silver badge13 bronze badges

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

2 Comments

Keimille Over a year ago

Yes!!! That worked Thank you! I see that I needed to pass the values to an array. Also, because of how you designed the code I was able to see yet another typo in the query. It should have been "Books" and not "Book"

Kristijan Mikulec Over a year ago

I am glad it helped you :)

Rohit Mittal · Accepted Answer · 2019-02-21 13:10:13Z

0

You need to pass mysqli object as well as below:

$result = mysqli_query($mysqli, "SELECT Title FROM Book");

Hope it helps you.

edited Feb 21, 2019 at 13:10

answered Feb 21, 2019 at 13:08

Rohit Mittal

2,1142 gold badges12 silver badges21 bronze badges

1 Comment

JTinkers Over a year ago

The second $mysqli is reduntant.

Collectives™ on Stack Overflow

Return MySQL query in PHP using mysqli class

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related