How to get query result into an array in PHP

Question

I have written a query on database the result is given in this form

Apples-100
Grapes-200
Oranges-50
Bananas-30

now i need to store the data in an array like this

[['Apples',100],['Grapes',200],['Oranges',50],['Bananas',30]]

how can I acheive this i tried this

while($row = mysql_fetch_assoc($getdatagraoh)){ 
    $plotgraphs[] = array(
        $row['Compliancestatus'],
        $row['value']
    );
}
header('ContentType: application/json; charset=utf-8');
$data= json_encode($plotgraphs);

I am not able to acheive that.Please help me in this regard.

mysql is obsolete. Please consider using mysqli or pdo instead. — CodeTrooper, Dec 24 '13 at 06:46

score 2 · Answer 1 · answered Dec 24 '13 at 06:58

First do not use mysql_* as its depcrated instead use mysqli_* or PDO.

Back to your question once you have stored values in $plotgraphs then explode like this and you will get the required result

foreach ( $array as $k => $v ) {
    $seprated = explode ( '-', $v );

    //echo '<pre>';
    //print_r ( $seprated );
    echo json_encode(( $seprated ));
}

Output

["Apples","100"]["Grapes","200"]["Oranges","50"]["Bananas","30"]

score 1 · Answer 2 · edited May 23 '17 at 12:11

1

while($row = mysql_fetch_assoc($getdatagraoh)){ 
  $plotgraphs[] =$row;
}

Side note: Why shouldn't I use mysql_* functions in PHP?

edited May 23 '17 at 12:11

Community

1
1

answered Dec 24 '13 at 06:45

Emilio Gort

3,450
3
28
44

score 0 · Answer 3 · edited Dec 24 '13 at 06:50

0

Try this:

<?php
$plotgraphs = array();

while($row = mysql_fetch_assoc($getdatagraoh)){ 
    $plotgraphs[] = $row;
}
?>

Here $row array is assigned to $plotgraphs.

edited Dec 24 '13 at 06:50

Dipesh Parmar

26,601
7
57
86

answered Dec 24 '13 at 06:48

Anand Solanki

3,370
4
15
27

score 0 · Answer 4 · answered Dec 24 '13 at 06:51

0

var $plotgraphs = [];  
  while( $row = mysql_fetch_assoc( $getdatagraoh)){
        $plotgraphs[] = $row; // Inside while loop
        //or
        $plotgraphs[ $row['id']] = $row;
    }

answered Dec 24 '13 at 06:51

Prateek

6,629
2
23
37

Mahmood Rehman · Answer 5 · 2013-12-24T07:19:31.833

Try like this : Since you have change question you can try this one :

$arrayName = array('Apples-100','Grapes-200','Oranges-50','Bananas-30');



foreach($arrayName as $value)
{
     $plotgraphs = explode("-",$value);
   echo  json_encode( $plotgraphs);
}

OUTPUT: ["Apples","100"]["Grapes","200"]["Oranges","50"]["Bananas","30"]

OR

foreach($arrayName as $value)
{
     $plotgraphs[] = explode("-",$value);

}
echo json_encode( $plotgraphs);

How to get query result into an array in PHP

5 Answers5