How to fetch all the matched rows from a Mysql table in a PHP array

Question

I am trying to get the matched rows from a table and save it in a Global Array so that I can use it in different functions.

But when I do print_r of that array it shows only last row.

Here is my code

function setCampoFeed()
 {

        echo $sql = "SELECT campofeed.tag,campofeed.registro,campofeed.valor FROM campofeed ".
        "INNER JOIN registrofeed ON registrofeed.id = campofeed.registro ".
        "WHERE registrofeed.feed='".$this->idFeed."'";

        $result= $this->localDb->execute($sql);
        $this->campoFeed= mysql_fetch_array($result)) 

 }

So here campoFeed is the array that should have all the rows of the match, but now its just having the last row.

Thanks in advance

@vivek you mean something like this while($row= mysql_fetch_array($result)) { $this->campoFeed[]=$row; } — Vikram Anand Bhushan
– Vikram Anand Bhushan, Commented Mar 20, 2015 at 6:54
mysql_fetch_array needs while loop to fetch. Also I don't think $this->campoFeed or $this->campoFeed[] can actually push data into array. I would suggest setup a array like $resultArray = array();. When inside while loop, $resultArray[] = $row;. Finally $this->compoFeed = $resultArray;. — AkiEru
– AkiEru, Commented Mar 20, 2015 at 6:54
@AkiEru actually $this->campoFeed is already set as array in the beginning — Vikram Anand Bhushan
– Vikram Anand Bhushan, Commented Mar 20, 2015 at 6:56
If $this->campoFeed[] works, you can use while($row = mysql_fetch_array($result)) { $this->campoFeed[] = $row; } instead of creating a new array. — AkiEru
– AkiEru, Commented Mar 20, 2015 at 6:59

I'm Geeker · Accepted Answer · 2015-03-20 06:58:53Z

1

Use

$this->campoFeed[] = mysql_fetch_array($result);"

insted of

 $this->campoFeed= mysql_fetch_array($result);

You will get all data in array

edited Mar 20, 2015 at 6:58

I'm Geeker

4,6575 gold badges25 silver badges42 bronze badges

answered Mar 20, 2015 at 6:58

Ishan Shah

1,6862 gold badges20 silver badges43 bronze badges

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

1 Comment

Vikram Anand Bhushan Over a year ago

sorry bro just tested again , its the same won't work shows only the last row

Narendrasingh Sisodia · Accepted Answer · 2015-03-20 07:22:13Z

0

Try this one if it works for you..

$resultArray = array();
$campoFeed = array();
$resultArray = mysql_fetch_array($result);

foreach($resultArray as $key => $value){
    $campoFeed[$key] = $value;
}

print_r($campoFeed);

answered Mar 20, 2015 at 7:22

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

Comments

I'm Geeker · Accepted Answer · 2015-03-20 07:09:10Z

0

Use this

$mergedArray=array();
while($data= mysql_fetch_array($result)) {
    $final_array = unserialize($data['data']);
    $mergedArray=array_merge($mergedArray,$final_array);
}

array_unique($mergedArray, SORT_REGULAR);

answered Mar 20, 2015 at 7:09

I'm Geeker

4,6575 gold badges25 silver badges42 bronze badges

Collectives™ on Stack Overflow

How to fetch all the matched rows from a Mysql table in a PHP array

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related