Store Mysql rows in Array

Question

I was wondering how I can store values in an Array, because I can just echo the $row['Name'], but if I want to store multiple values in array I get nothing.

$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);

if (!$conn) {
    die ('Failed to connect to MySQL: ' . mysqli_connect_error());
}

$sql = "SELECT * FROM " . $dbname . " WHERE id ='$id'";

$query = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_array($query)) {

    $thisArray[] = array( $row['Name'],$row['accountNumber']);
}

echo $thisArray[0];

you did not declared the array. so, first declared the array like this $thisArray =array(); before start of the loop and use print_r — Bilal Ahmed
– Bilal Ahmed, Commented Mar 19, 2018 at 10:12
$thisArray[0] is itself an array, so you should use print_r($thisArray[0]); — Nigel Ren
– Nigel Ren, Commented Mar 19, 2018 at 10:13

Nigel Ren · Accepted Answer · 2018-03-19 12:28:14Z

2

As you just want to load the results of a SQL statement into an array, you can use mysqli_fetch_all() and just fetch the columns you need.

When outputing the results, arrays should be output with something like print_r()...

$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);

if (!$conn) {
    die ('Failed to connect to MySQL: ' . mysqli_connect_error());
}

$sql = "SELECT Name,accountNumber FROM " . $dbname . " WHERE id ='$id'";

$query = mysqli_query($conn, $sql);
$thisArray = mysqli_fetch_all($query, MYSQLI_ASSOC);
print_r( $thisArray[0]);

Update: If you want to re-arrange the array to key by one of the columns, array_column() can do this...

$thisArray = array_column($thisArray, 'accountNumber', 'Name');

edited Mar 19, 2018 at 12:28

answered Mar 19, 2018 at 10:19

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

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

2 Comments

Death-is-the-real-truth Over a year ago

much better solution rather than other-one.+1

user9419091 Over a year ago

I am getting a result : Array ( [Name] => Kristiqn [accountNumber] => 0 ). How can I get just the value (Kristiqn and 0)

Vaios P. · Accepted Answer · 2018-03-19 10:28:58Z

0

You have to initialize your array outside of the loop first and when you echo it you don't need to specify a key except if you need a specific key. Based on your code above:

$thisArray = [];
while ($row = mysqli_fetch_array($query)) {
    $thisArray[] = [
        $row['Name'],
        $row['accountNumber']
    ];
}

echo $thisArray;

answered Mar 19, 2018 at 10:28

Vaios P.

4049 silver badges23 bronze badges

Collectives™ on Stack Overflow

Store Mysql rows in Array

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related