Mysql Query output into var data [,,,] array

Question

How do i go ahead to output mysql row to a var array like this

 var data = [

            {"name" : "mysql data", "hvalue" : mysql data number },

        ];

all the possible mysql rows not just 1

use json to convert your php arrays – madalinivascu Dec 08 '16 at 06:22 — madalinivascu, Dec 08 '16 at 06:22

score 0 · Answer 1 · edited May 23 '17 at 11:45

0

Sounds like just altering the array you are building out... So you can encode your db result

$sth = mysqli_query("SELECT ...");
$rows = array();
while($r = mysqli_fetch_assoc($sth)) {
    $rows[] = $r;
}
print json_encode($rows);//will return your desired data

The function json_encode needs PHP >= 5.2 and the php-json package - as mentioned here

NOTE: mysql is deprecated as of PHP 5.5.0, use mysqli extension instead http://php.net/manual/en/migration55.deprecated.php.

edited May 23 '17 at 11:45

Community

1
1

answered Dec 08 '16 at 06:25

Hudhaifa Yoosuf

869
2
12
28

the mysql row has more columns than needed about 10 columns but i only need the "username" and for the chance it is calculated in php with – Brad M Dec 08 '16 at 06:29
$chance=round(100*$sumvalue/$cb,1); – Brad M Dec 08 '16 at 06:29
i hope changing your select query to get only those specific columns you need would do the job – Hudhaifa Yoosuf Dec 08 '16 at 06:32
$rs = mysql_query("SELECT * FROM `game".$cg."` GROUP BY `userid` ORDER BY `id` DESC"); is my query – Brad M Dec 08 '16 at 06:33
why are you selecting all, change it to get only the name and hvalue. – Hudhaifa Yoosuf Dec 08 '16 at 06:35
because I need more than that to calculate the percentage $chance=round(100*$sumvalue/$cb,1); $sumvalue = $row["value"]; $sumvalue=round($sumvalue,2); $cb = fetchinfo("cost","games","id",$cg); – Brad M Dec 08 '16 at 06:37
its better if you can do the calculation in db query itself. you can open a new question if you need to get help in building the query. thanks – Hudhaifa Yoosuf Dec 08 '16 at 06:47
how do i then get that $rows into my original var data – Brad M Dec 08 '16 at 07:09
json_encode($rows); this will return it, you can assign it any where you want – Hudhaifa Yoosuf Dec 08 '16 at 07:10
any chance you could help with the query? – Brad M Dec 08 '16 at 07:15
i made my sql query but now how do i get the sql query into the actual var data, and format it – Brad M Dec 08 '16 at 09:22
$sth = mysql_query("SELECT username, (SUM(value)/COUNT(value))*100 FROM game".$cg." GROUP BY userid ORDER BY id DESC"); – Brad M Dec 08 '16 at 09:22

Mysql Query output into var data [,,,] array

1 Answers1