How to get single column values using MySQLi? [duplicate]

Question

I am trying to get list or emails in a one-dimensional array from MySQL database. However, I am getting multidimensional array, rather then array:

$query = "SELECT DISTINCT `EmailAddress` FROM `Emails` WHERE `JobID` = 1";
$result = $conn->query($query);
if (!$result) {
    printf("Query failed: %s\n", $mysqli->error);
    exit;
}
while ($row = $result->fetch_row()) {
    $rows[] = $row;
}
$result->close();
$conn->close();
var_dump($rows); // This will return array(2) { [0]=> array(1) { [0]=> string(24) "[email protected]" } [1]=> array(1) { [0]=> string(17) "[email protected]" } }
//This is how array should be
$MyV = array("[email protected]", "[email protected]");
var_dump($MyV); //this is an array I need to have: array(2) { [0]=> string(11) "[email protected]" [1]=> string(11) "[email protected]" }

ɹɐqʞɐ zoɹǝɟ · Accepted Answer · 2015-06-10 16:43:58Z

5

do fetch_assoc

while($row = $result->fetch_assoc()) {
  $rows[]=$row['EmailAddress'];
}

answered Jun 10, 2015 at 16:43

ɹɐqʞɐ zoɹǝɟ

4,3703 gold badges25 silver badges36 bronze badges

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

1 Comment

Your Common Sense Over a year ago

fetch_assoc is rather superfluous here, you need to know the exact column name. with fetch_row it's simpler, shorter and universally applicable to any query

Kita · Accepted Answer · 2015-06-10 16:50:25Z

5

The answers above are correct, but here's an example with minimum code modifications to your current source.

while($row = $result->fetch_row()) {
  $rows[]=$row[0];
}

Now $rows will be a one dimensional array populated with email addresses.

answered Jun 10, 2015 at 16:50

Kita

1,56814 silver badges21 bronze badges

Comments

Dharman · Accepted Answer · 2022-01-24 16:52:47Z

2

I would recommend one of the following three options:

You could use foreach and insert just the column you need into a new array.

foreach ($result as $row) {
    $emailAddresses[] = $row['EmailAddress'];
}

You can use fetch_all() with array_column()

$emailAddresses = array_column($result->fetch_all(MYSQLI_ASSOC), 'EmailAddress');

Using fetch_column():

while($email = $result->fetch_column()) {
    $emailAddresses[] = $email;
}

edited Jan 24, 2022 at 16:52

answered Dec 7, 2019 at 15:30

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

Comments

Bas Slats · Accepted Answer · 2015-06-10 16:20:27Z

0

At this point in your loop, you have access to the simple array you are talking about.

while($row = $result->fetch_row()) {
  $rows[]=$row;
}

So if you want to do anything with that array assign it to some variable or call a function with the array, something like this:

while($row = $result->fetch_row()) {
    doSomethingFun($row);
}

answered Jun 10, 2015 at 16:20

Bas Slats

2772 silver badges10 bronze badges

Collectives™ on Stack Overflow

How to get single column values using MySQLi? [duplicate]

4 Answers 4

1 Comment

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Linked

Related