mySQL get data intro an associative array

Question

I am using the below code to get the users list from my db:

if ($result = mysqli_query($mysqli, "SELECT user_name, name, surname, avatar, user_email FROM users")) {


    while ($row = $result->fetch_assoc()) {
        $username[]  = $row["user_name"];
        $user_email[] = $row["user_email"];
        $user_name[] = $row["name"];
        $user_surname[] = $row["surname"];
        $avatar[] = $row["avatar"];

    }

    $result->close();
}

But I get the below error:

Fatal error: [] operator not supported for strings

did you initialise all those variables ($username, $user_email, ... etc) as arrays before using them? — pala_
– pala_, Commented Apr 27, 2015 at 13:12
mySQL get data intro an asociative array....??? what is the question — lakshman
– lakshman, Commented Apr 27, 2015 at 13:15

pala_ · Accepted Answer · 2015-04-27 13:14:00Z

1

This is probably what you want to do:

   $rows = array();
   while ($row = $result->fetch_assoc()) {
       $rows[] = $row;
   }
   // $rows is now an array that contains each individual row from your result set

You can then do whatever you want with that data, eg display it in a table or whatever.

  foreach($rows as $user)
  {
    echo $user['user_name'] . ' - ' . $user['user_email'];
  }

And so on

answered Apr 27, 2015 at 13:14

pala_

9,0101 gold badge18 silver badges32 bronze badges

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

Comments

Kristian Lilov · Accepted Answer · 2015-04-27 13:21:50Z

1

Your $username variable has been set as a string somewhere in the code before the codeblock you have posted. If you use $username=array(); you will loose that variable. I don't know if you need it or not.

Here is a better way to do :

$users = array();
while ($row = $result->fetch_assoc()) {

$users[]  = array(
        "username" => $row["user_name"],
        "email"    => $row["user_email"],
        "name"     => $row["name"],
        "surname"  => $row["surname"],
        "avatar"   => $row["avatar"]
    );

}

And you can loop the users using foreach:

foreach($users as $user){
   echo $user["username"];
   echo $user["email"];
}

answered Apr 27, 2015 at 13:21

Kristian Lilov

6106 silver badges12 bronze badges

Comments

Manoj Dhiman · Accepted Answer · 2015-04-27 13:13:52Z

0

you should take an empty array befor loop if you want these into array. like this

 if ($result = mysqli_query($mysqli, "SELECT user_name, name, surname, avatar, user_email FROM users")) {

    $results=array();

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

        }

        $result->close();
    }

other wise you should remove []

edited Apr 27, 2015 at 13:13

answered Apr 27, 2015 at 13:11

Manoj Dhiman

5,1616 gold badges32 silver badges71 bronze badges

Comments

Sougata Bose · Accepted Answer · 2015-04-27 13:13:56Z

0

You can do this also -

$user_data = array();
while ($row = $result->fetch_assoc()) {
    $user_data[]  = $row;
}

By this you can get all the data in a single array. The keys will be the same as database fields.

answered Apr 27, 2015 at 13:13

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

Collectives™ on Stack Overflow

mySQL get data intro an associative array

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related