Format array from sql query result

Question

I have the following query

$sql = "SELECT nomInteretUser from userInteret where idUser='$id_user' ";
$result = $conn->query(sprintf($sql));

I want to produce an array with following structure: array ('User1','User2')

I have tried this :

if ($result->num_rows != 0) {
    $rows=array(); 
    while($r=mysqli_fetch_assoc($result))
    { 
        $rows[]=$r;
    } 
}

But it gives following result:

{
   array(1) {
       ["nomInteretUser"]=> "foot"
   }
   array(1) {
       ["nomInteretUser"]=> "cyclisme"
   }
}

Did you try $rows[]=$r["nomInteretUser"] ?

Peon
– Peon

2016-05-18 11:15:09 +00:00
Commented May 18, 2016 at 11:15 — Peon
– Peon, Commented May 18, 2016 at 11:15

dev87 · Accepted Answer · 2016-05-19 07:22:42Z

2

use $rows[]=$r['nomInteretUser']; in your code than you get the right result. :)

if ($result->num_rows != 0) {
    $rows=array(); 
    while($r=mysqli_fetch_assoc($result))
    { 
        $rows[]=$r['nomInteretUser'];
    } 
}

answered May 19, 2016 at 7:22

dev87

1641 silver badge9 bronze badges

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

Comments

David Ansermot · Accepted Answer · 2016-05-18 11:16:42Z

1

Simply update your code to :

if($result)
{           
   if ($result->num_rows != 0) {

      $rows=array(); 

      while($r=mysqli_fetch_assoc($result))
      { 
         $rows[]=$r["nomInteretUser"];
      } 
   }
 }

answered May 18, 2016 at 11:16

David Ansermot

6,1148 gold badges51 silver badges84 bronze badges

Comments

Parixit · Accepted Answer · 2016-05-18 11:27:17Z

1

You can do this 2 ways:

Please update your current code like this

while($r=mysqli_fetch_assoc($result))
{ 
    $rows[]=$r['nomInteretUser'];  //Update here
}

If you don't want to update your current code then modify code, then use array_column() (>= PHP 5.5 Required)

$rows = array_column($rows, 'nomInteretUser');

Hope it helps!

edited May 18, 2016 at 11:27

answered May 18, 2016 at 11:21

Parixit

3,8193 gold badges39 silver badges65 bronze badges

Collectives™ on Stack Overflow

Format array from sql query result

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related