Save SQL column value to an array

Question

I want to save a value to an array. I have a column called numbers values are 1,2,3.

If I select this value, then save it into a variable $value and try to put it into an array:

$array = array($value);

But its not working properly.

How are you selecting? Probably use explode. Also using mysql or sql-server? — chris85
– chris85, Commented Sep 14, 2017 at 2:13
<?php $array = array("1","2","3"); echo implode(" ",$array); — Barclick Flores Velasquez
– Barclick Flores Velasquez, Commented Sep 14, 2017 at 2:17
Is this SQL Server or MySQL (you've tagged both, and it's very unlikely that this is correct)? Or does it not matter at all? Your question seems to be about how to handle your data in PHP, not in the database? — alroc
– alroc, Commented Sep 14, 2017 at 2:38

parker_codes · Accepted Answer · 2017-09-14 03:03:53Z

1

PHP does not automatically convert strings into integers. Your dump showed that it is one string, so do this:

// separate by the comma into array
$array = explode("," $str); // array( '1', '2', '3' );

// re-create an array, converting strings into integers
foreach ($array as $index => $value) {
    $array[$index] = (int)$value; 
}

answered Sep 14, 2017 at 3:03

parker_codes

3,4151 gold badge21 silver badges27 bronze badges

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

2 Comments

JYoThI Over a year ago

$final_array = array_map('intval',$array); instead of foreach

parker_codes Over a year ago

@JYoThl, Yes, array_map is shorter code, but I was meaning to help the OPer understand what was going on.. 😊 Any who already understand it should use your snippet.

Collectives™ on Stack Overflow

Save SQL column value to an array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related