Array of associative arrays in PHP

Question

I have a function to use but I don't know the content of this function. The only thing I know is that the function returns an array of associative arrays and the keys for the arrays. The data that the function returns come from a database. Can you help in how to read the data from this array? I am confused with the arrays. For now I am doing this:

$array = myfunction($var);
if(!empty($array))
{
    while($row = mysql_fetch_array($array))
    {
        print"$row[elem1]
        $row[elem2]";
    }
}

I take the error: Warning: mysql_fetch_array() expects parameter 1 to be resource, array given in... I know that something is missing, but I till now I can't fix it.

Your version is so unnecessarily perplexed, I really have no idea where to start from... — Dr.Kameleon
– Dr.Kameleon, Commented Apr 6, 2012 at 11:52
Hi @Dr.Kameleon it is the same for me. I wrote what exactly I know. The part of code I know that is not correct but it is just a try. — anna
– anna, Commented Apr 6, 2012 at 12:15

Muhammad Raheel · Accepted Answer · 2012-04-06 11:53:43Z

2

If the function is returning an array then why are you using it in mysql_fetch_array. It is useless. Instead use this

foreach($array as $key => $value){

   echo $key;
   echo '<br>';
   echo $value;
}

This will print the whole array. Or a short method is

echo '<pre>';
print_r($array);
echo '</pre>';

answered Apr 6, 2012 at 11:53

Muhammad Raheel

19.9k7 gold badges69 silver badges106 bronze badges

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

Comments

user1191247 · Accepted Answer · 2012-04-06 12:00:50Z

1

Something like -

$array = myfunction($var);
foreach($array as $key => $row) {
    print"{$row['elem1']} {$row['elem2']}";
}

edited Apr 6, 2012 at 12:00

answered Apr 6, 2012 at 11:52

user1191247

13k2 gold badges25 silver badges33 bronze badges

7 Comments

s.webbandit Over a year ago

"The data that the function returns come from a database"

Jim Over a year ago

@webbandit it is not clear however whether or not the data has already been fetched. The asker has an array and seems to want to iterate over it.

user1191247 Over a year ago

@webbandit - OP clearly states that the function returns an array of arrays!

s.webbandit Over a year ago

@nnichols no too clearly :) It states that "The data that the function returns come from a database" and uses mysql_fetch_array() function from one side and "an array of associative arrays and the keys for the arrays" from another. Not too clearly...

user1191247 Over a year ago

@webbandit - "The only thing I know is that the function returns an array of associative arrays" - seems quite clear to me.

|

s.webbandit · Accepted Answer · 2012-04-06 11:53:01Z

0

You have to pass Resource Identifier to mysql_fetch_array() function.

Something like:

$sql = mysql_query('SELECT * FROM `table`');
if(!empty($array)) {

 while($row = mysql_fetch_array($array)) {
        print"$row[elem1]
        $row[elem2]";
 }
}

answered Apr 6, 2012 at 11:53

s.webbandit

17.2k17 gold badges60 silver badges83 bronze badges

Comments

Baba · Accepted Answer · 2013-04-26 10:21:11Z

0

The error is correct .. the issue is not associative arrays in php but you are not using a valid mysql resource

Please see http://php.net/manual/en/function.mysql-fetch-array.php for documentation

Examples

$mysqli = new mysqli("localhost","root","","test");
$result = $mysqli->query("SELECT * FROM test");
$row = array() ;
echo "<pre>" ;
if($result->num_rows > 0)
{
    while($row = $result->fetch_array(MYSQLI_NUM))
    {
            print implode (",", $row) . PHP_EOL;

    }

}

Or

$array = myfunction($var);
if(!empty($array))
{
    foreach($array as $key => $row)
    {
        if(is_array($row))
        {
            print implode (",", $row) . PHP_EOL;
        }
        else
        {
            print $row . PHP_EOL ;
        }
    }

}

edited Apr 26, 2013 at 10:21

answered Apr 6, 2012 at 11:52

Baba

95.3k29 gold badges172 silver badges222 bronze badges

Collectives™ on Stack Overflow

Array of associative arrays in PHP

4 Answers 4

Comments

7 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

7 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related