Selecting MySql table data into an array

Question

I try to catch data from mysql to put them all in array. Suppose:

    users table
    -----------------------
    id| name | code 
    ----------------------
    1| gorge | 2132
    2| flix | ksd02
    3| jasmen | skaod2

    $sql = mysql_query("select id, name, code from users");
    $userinfo = array()
    while($row_user = mysql_fetch_array($sql)){
    $userinfo = $row_user[name] 
    }
-------------------------
foreach($userinfo as $usinfo){
echo $usinfo."<br/>";
}

Here is the problem i can only insert user name but cant insert also code & id in userinfo array please help me to insert all data in same array.

[P.S] No object oriented please.

score 36 · Answer 1 · edited Oct 06 '14 at 16:20

36

$sql = mysql_query("select id, name, code from users");
$userinfo = array();

while ($row_user = mysql_fetch_assoc($sql))
    $userinfo[] = $row_user;

This will give you $userinfo as an array with the following structure:

[
    [id => 1, name => 'gorge', code => '2123'],
    [id => 2, name => 'flix', code => 'ksd02'],
    [id => 3, name => 'jasmen', code => 'skaod2']
]

If you want to output the data:

foreach ($userinfo as $user) {
    echo "Id: {$user[id]}<br />"
       . "Name: {$user[name]}<br />"
       . "Code: {$user[code]}<br /><br />";
}

edited Oct 06 '14 at 16:20

K-G

2,799
4
26
42

answered Jan 18 '11 at 21:39

jasonbar

13,333
4
38
46

I'm sure you typed this really fast, but you are using mysql_query twice. That isn't going to work. – Christa Jan 18 '11 at 21:43
@user553786, this answers your question as I understand it. Please explain further what you are trying to do. – jasonbar Jan 18 '11 at 21:45
i ask about how to insert id, name, code in array when while loop is work focus in ex – Kareem Nour Emam Jan 18 '11 at 21:53
user.. This line is going to do what you asked: $userinfo[] = $row_user; did you try it? The $row_user will contain the id, name, and code in it. Instead of being the variable $row_user it will be reassigned to the next array (as indicated by $userinfo[]). That's why both answers have the same solution. – Christa Jan 18 '11 at 21:59
oky i try like u say $userinfo[] = $row_user; did you try it? yes i try and give me that ^^ Fatal error: Cannot use [] for reading – Kareem Nour Emam Jan 18 '11 at 22:06
@user553786, updated answer to reflect how you would use the array for output. – jasonbar Jan 18 '11 at 22:10

Phill Pafford · Answer 2 · 2011-01-18T21:52:43.440

5

while($row_user = mysql_fetch_assoc($sql)){
   $userinfo[] = $row_user;
}

foreach($userinfo as $usrinfo){
   echo "Id: ".$usrinfo['id']."<br />";
   echo "Name: ".$usrinfo['name']."<br />";
   echo "Code: ".$usrinfo['code']."<br />";
}

edited Jan 18 '11 at 21:52

answered Jan 18 '11 at 21:41

Phill Pafford

83,471
91
263
383

2

No need to create a new array. Use mysql_fetch_assoc or pass MYSQL_ASSOC to mysql_fetch_array to get just the array you ar ebuilding. And strings (your array indices) belong in single quotes. Your code would throw 3 E_NOTICE notices per loop. – ThiefMaster Jan 18 '11 at 21:44
why u update ur first answer i think the first way is better than second way but both solution pleas – Kareem Nour Emam Jan 18 '11 at 21:58

score 4 · Answer 3 · answered Oct 17 '13 at 11:28

4

I found this code and I save my day:

<?php
$sql=mysql_query("select * from table1");

/*every time it fetches the row, adds it to array...*/
while($r[]=mysql_fetch_array($sql));

echo "<pre>";
// Prints $r as array 
print_r ($r);
echo "</pre>";
?>

answered Oct 17 '13 at 11:28

Christos Papoulas

2,469
3
27
43

score -4 · Answer 4 · answered Jan 18 '11 at 22:23

-4

   while($row_user = mysql_fetch_array($sql)){
    $row_id = $row_user ["id"];
        $row_author = $row_user ["author"];
        $row_code = $row_user ["code"];
       $userinfo[] = array("id"=> $row_id , "author"=> $row_author, "code"=> $row_code);
    }
foreach ($userinfo as $user) {
    echo "Id: {$user[id]}\n"
       . "Name: {$user[name]}\n"
       . "Code: {$user[code]}\n\n";
}

answered Jan 18 '11 at 22:23

Kareem Nour Emam

1,054
4
14
27

17

Congratulations, you flew around the moon to get to the corner store. – jasonbar Jan 18 '11 at 22:26

Selecting MySql table data into an array

4 Answers4

Linked