JSON encode MySQL results then read using jQuery
- by silentw
I have a database table with some rows that I want to fetch using PHP and then encode them using JSON.
Currently, my database structure is the following:
idcomponente | quantidade
After fetching the values in PHP, I want to know how can I encode them using JSON (with multiple rows, using the same names) so I can read them using jQuery.post().
$.post('test.php',{id:id},function(data){
//READ data HERE
});
Thanks in advance
Edit:
So far, I made this:
$.post('edit/producomponentes.php',{id:id},function(data){
console.log(data);
});
Logs this:
[Object { componente="1", quantidade="2"}, Object { componente="3", quantidade="3"}]
Now how can I go through each row and fetch their properties? (data.componente, data.quantidade)
