Create simple numeric PHP array from MySQL result [duplicate]

Question

If I create a manual array in PHP:

$numbers = array(3,5,7,8,10,12);

Then, inside a loop where $j is incrementing, I can use:

if (in_array($j, $numbers)) { //THIS } else { //THAT }

for some logic to do 'this or that' on the third, fifth, seventh, eighth, tenth and twelfth iteration of a loop.

I'd like the content of $numbers to come from a MySQL query result.

However, if I grab an array using the below code, the array is not built the same and I cannot reference it from in_array ($conn is obviously the connection details not provided here):

$numbers_from_query_sql= "SELECT (round*1) as round FROM event";
$numbers_from_query = mysqli_query($conn, $numbers_from_query_sql);

$numbers_ms_array= array();
while ($row = mysqli_fetch_assoc($numbers_from_query)) {
    $numbers_ms_array[] = $row;
}

The var_dump($numbers_ms_array) of the above produces:

array(6) { [0]=> array(1) { ["round"]=> string(1) "3" } [1]=> array(1) { ["round"]=> string(1) "5" } [2]=> array(1) { ["round"]=> string(1) "7" } [3]=> array(1) { ["round"]=> string(1) "8" } [4]=> array(1) { ["round"]=> string(2) "10" } [5]=> array(1) { ["round"]=> string(2) "12" } }

If I then pass $numbers_ms_array to the in_array code, it does not work .

Note that in the database, the 'round' column is varchar(3).

How can I get a simple array (like my first manual example) from the result of my MySQL query (with all of the results as integers, if that's also necessary)?

$numbers = array_map($numbers_ms_array, function($element) { return (int)$element['round']; }); — Daniel W.
– Daniel W., Commented Jan 24, 2022 at 16:23

cOle2 · Accepted Answer · 2022-01-24 16:24:23Z

1

You are assigning the whole $row to your numbers array which is giving you the entire row as an array in your values.

It sounds like you want only the value so you should assign just the column you want instead:

$numbers_ms_array[] = $row['round'];

answered Jan 24, 2022 at 16:24

cOle2

4,7741 gold badge26 silver badges27 bronze badges

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

1 Comment

Andrew Abbott Over a year ago

Thank you, a simple addition, I was close... I am an amateur programmer so hoped it would be something silly I'd missed.

Collectives™ on Stack Overflow

Create simple numeric PHP array from MySQL result [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related