Creating an array with mysqli

Question

I am using mysqli to query an item database. I am trying to create an array out of the items in the database, but am stuck. Here is what I have so far.

$DB_HOST = 'localhost';
$DB_USER = 'root';
$DB_PASS = '';
$DB_NAME = 'test';

$connection = mysqli_connect($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);

if ($query = $connection->prepare('SELECT name, due_date, complete FROM items WHERE user_id = ?')) {
    $query->bind_param('i', $_SESSION['id']);
    $query->execute(); 
    $query->store_result();
    //var_dump($query->num_rows);
    if ($query->num_rows > 0) {
        $query->bind_result($name, $due_date, $complete);
        //$query->fetch();

        while ($query->fetch()) {

       }
    }
    $query->close();

}

I am completely unsure how to turn this into an array for use in a foreach loop in my list of items.

Kevin · Accepted Answer · 2018-07-11 01:25:55Z

1

If you have mysqlnd, just use ->get_result() after execute().

$query = $connection->prepare('SELECT name, due_date, complete FROM items WHERE user_id = ?');
$query->bind_param('i', $_SESSION['id']);
$query->execute();
$result = $query->get_result();
$rows = $result->fetch_all(MYSQLI_ASSOC); // fetch as associative

// then make your foreach or whatnot
foreach ($rows as $row) {
    // echo $row['name'];
}

If you don't want them all loaded up immediately, you can still use the while + fetch combo:

while ($row = $result->fetch_assoc()) {
    // echo $row['name']
    // $data[] = $row;
    // or whatever you need to do
}

edited Jul 11, 2018 at 1:25

answered Jul 11, 2018 at 1:18

Kevin

41.9k12 gold badges57 silver badges72 bronze badges

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

1 Comment

Kevin Over a year ago

@TheDizzle sure glad this helped

Collectives™ on Stack Overflow

Creating an array with mysqli

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related