MYSQLi select / fetch into one array

Question

I tried to return MYSQLi data into an array but it doesn't get into the form I want.

$sql = <<<SQL
SELECT *
FROM pricee 
ORDER BY idd ASC
SQL;


if(!$result = $db->query($sql)){
die('There was an error running the query [' . $db->error . ']');
}

while($row = $result->fetch_assoc()){
$price=$row['price'];


$tt=(array)$price;
$i=(array)$row['idd'];
$p=array_combine($i,$tt);
print_r($p);
}

This gives me $p in the following form

Array ( [1] => "0.99" ) Array ( [2] => "0.47" ) Array ( [3] => "0.49" )

But I need it in the following:

Array ( [1] => 0.99 [2] => 0.47 [3] => 0.49)

How can I convert it in that form?

So you want to convert strings to floating point numbers in PHP and combine them into a single array? — tadman
– tadman, Commented Jun 26, 2014 at 21:49
basically I need the values returned from the database in one (numbered) array (see above please) — user3780856
– user3780856, Commented Jun 26, 2014 at 23:16

AbraCadaver · Accepted Answer · 2014-06-26 21:51:13Z

1

Easiest:

while($row = $result->fetch_assoc()){
    $p[$row['idd']] = $row['price'];
}

I don't know if it was intentional, but if you are also showing a string to float conversion, then:

    $p[$row['idd']] = (float)$row['price'];  // or use floatval()

answered Jun 26, 2014 at 21:51

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

2 Comments

user3780856 Over a year ago

Thanks but it doesn't seem to work. It returns the values in the following form: Array ( [0] => 0.49 ) Array ( [0] => 0.99 ) but it should be only one Array

AbraCadaver Over a year ago

No, the code I posted creates one array. Remove any code you have and check.

Collectives™ on Stack Overflow

MYSQLi select / fetch into one 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