current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite
1

From my experience, when I json_encode data from a mysql table, the output is an object containing each row as an object within. What I want to do is to get each row as an array, like the example below (don't need the column names in there). How can I do that?

{ "Data": [
    ["1","Internet Explorer 4.0","Win 95+","4","X","1"],
    ["2","Internet Explorer 5.0","Win 95+","5","C","2"],
    ["3","Internet Explorer 5.5","Win 95+","5.5","A","3"],
    ["4","Internet Explorer 6","Win 98+","6","A","4"],
] }
share|improve this question

2 Answers 2

up vote 3 down vote accepted

Use mysql_fetch_row [docs] to get each row. This will get a row as a numerical array and those are also encoded as JSON arrays:

$data = array();

while(($row = mysql_fetch_row($result))) {
    $data[] = $row;
}

echo json_encode(array('Data' => $data));
share|improve this answer
    
Thank you, it works. –  Chad Jul 10 '11 at 22:52
up vote 0 down vote

NOT CHECKED in interpreter: You can change the type of variable by simple types convertion:

$data = DB::get('SELECT * FROM `table` WHERE 1');
echo json_encode(array('Data' => (array)$data));

Also you can use next function: array mysql_fetch_array ( resource $result [, int $result_type ] )

share|improve this answer
    
What is DB::get ? –  Felix Kling Jul 10 '11 at 22:44
    
DB abstraction. You can use it as $data = mysql_fetch_array($mysql_result, MYSQL_NUM); Just convert object to array. It must help. –  dobriy_santa Jul 10 '11 at 22:48

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.