Imploding to mysqli_fetch_array()

Question

Im new to web development. I need the array like following

["Mercury", "Venus", "Earth", "Mars", "Jupiter", "Saturn", "Uranus", "Neptune"]

I tried. But I failed.I connected the database. How can I make it?

my array-code

$count=0;
$sql="SELECT name FROM planet";
$sql_run=mysqli_query($con,$sql); 

while($row = mysqli_fetch_assoc($sql_run))
{
    $result[] = "'".implode("\'",$row)."'".",";
    echo $result[$count++];
}

By using above code, i couldn't get the result what I expected.

I don't at all understand why you write "'".implode("\'",$row)."'".",". Anyway, to get what you want, you must do $result[] = '"' . $row['name'] . '"' inside of the while(). — cFreed
– cFreed, Commented Jan 9, 2016 at 19:28
I got like this, all are repeated. 'Mercury\'Mercury','Venus\'Venus','Earth\'Earth','Mars\'Mars','Jupiter\'Jupiter','Saturn\'Saturn','Uranus\'Uranus','Neptune\'Neptune', but I need like this 'Mercury', 'Venus', 'Earth','Mars', 'Jupiter', 'Saturn', 'Uranus', 'Neptune' — user5669842
– user5669842, Commented Jan 9, 2016 at 19:30
thank you so much. its working. Really thanks. Problem is Im new to php@cFreed — user5669842
– user5669842, Commented Jan 9, 2016 at 19:43

Zbynek Vyskovsky - kvr000 · Accepted Answer · 2016-01-09 19:26:20Z

1

Each fetch returns one planet in associative array. To get array of rows, you have to do:

$list = array();
while($row = mysqli_fetch_assoc($sql_run)) {
     array_push($list, $row['name']);
}
var_dump($list);

answered Jan 9, 2016 at 19:26

Zbynek Vyskovsky - kvr000

19.1k3 gold badges41 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

Imploding to mysqli_fetch_array()

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related