Új hozzászólás Aktív témák
-
papa019
senior tag
Jelenleg így generálom a JSON-t (ajaxLoad.php):
$result = $DB->prepare("SELECT * FROM places");
$result->execute();
$result->setFetchMode(PDO::FETCH_ASSOC);
while($row = $result->fetch())
{
$rows[]=$row;
}
//var_dump($rows);
echo json_encode($rows, JSON_UNESCAPED_UNICODE);A jelenlegi adatbázis alapján pontosan ezt az adatot generálja (nem tudom, hogy ez szabványos JSON formátum-e, nekem annak tűnik):
[{"id":"1","name":"a","description":"a","address":"a","wikipedia":"a","points":"","category":"62","parent_area":"7","parent_has_parent":"1"},
{"id":"2","name":"123213","description":"123123","address":"123","wikipedia":"123123","points":"","category":"70","parent_area":"0","parent_has_parent":"0"},
{"id":"4","name":"as","description":"as","address":"as","wikipedia":"as","points":"","category":"69","parent_area":"0","parent_has_parent":"1"},
{"id":"5","name":"asd","description":"asd","address":"asd","wikipedia":"asd","points":"","category":"70","parent_area":"4","parent_has_parent":"0"},
{"id":"6","name":"asfd","description":"asd","address":"sad","wikipedia":"asd","points":"","category":"70","parent_area":"4","parent_has_parent":"0"},
{"id":"7","name":"asfd","description":"asd","address":"asd","wikipedia":"sad","points":"","category":"70","parent_area":"4","parent_has_parent":"0"},
{"id":"8","name":"asfd","description":"asd","address":"asd","wikipedia":"sad","points":"","category":"62","parent_area":"4","parent_has_parent":"0"},
{"id":"9","name":"1","description":"1","address":"1","wikipedia":"1","points":"","category":"68","parent_area":"1","parent_has_parent":"0"},
{"id":"10","name":"1","description":"1","address":"1","wikipedia":"1","points":"","category":"70","parent_area":"9","parent_has_parent":"0"},
{"id":"11","name":"1","description":"1","address":"1","wikipedia":"1","points":"","category":"69","parent_area":"1","parent_has_parent":"0"},
{"id":"12","name":"1","description":"1","address":"1","wikipedia":"1","points":"","category":"69","parent_area":"9","parent_has_parent":"0"},
{"id":"13","name":"1","description":"2","address":"34","wikipedia":"4","points":"","category":"70","parent_area":"4","parent_has_parent":"1"},
{"id":"14","name":"1","description":"11","address":"1","wikipedia":"1","points":"","category":"70","parent_area":"4","parent_has_parent":"0"},
{"id":"15","name":"1","description":"11","address":"1","wikipedia":"1","points":"","category":"62","parent_area":"1","parent_has_parent":"1"},
{"id":"16","name":"","description":"","address":"","wikipedia":"","points":"","category":"70","parent_area":"1","parent_has_parent":"1"}]És jelenleg mint gyors "megoldás", megpróbáltam Sk8erPeter kolléga korábbi kódját használni a feldolgozásra (pár hónapja segített egy másik json fájl feldolgozásában):
$.getJSON(json_file_path, function(data) {
var items = [],
list_html = '';
$.each(data.folder, function(key, val) {
var list_item_actual = '',
list_inner = {};
list_item_actual += '<li id="' + id + '">' + '<u><b>' + name + '</b></u>' + '<u><b>' + description + '</b></u>' + ',<br />' + 'address: ' + address + ',<br />' + 'wikipedia: ' + wikipedia + ',<br />' + 'points: ' + points + ',<br />' + 'cat: ' + category + ',<br />' + 'parent: ' + parent_area + ',<br />' + 'par: ' + parent_has_parent + ',<br />';
list_inner = $('<ul/>', {
'id': 'my-polygon-list-' + key,
'class': 'my-polygon-list',
html: list_items_inner.join('')
});
list_item_actual += list_inner.html();
list_item_actual += '</li>';
items.push(list_item_actual);
});
list_html = $('<ul/>', {
'id': 'my-location-list',
'class': 'my-new-list',
html: items.join('')
});
$('#get_informations').html(list_html.html());
});Szinte biztos voltam benne, hogy nem fog működni itt, de azért próba szerencse alapon megpróbáltam.
[ Szerkesztve ]
Új hozzászólás Aktív témák
- Diablo IV
- Autós topik
- Házi barkács, gányolás, tákolás, megdöbbentő gépek!
- Telekom otthoni szolgáltatások (TV, internet, telefon)
- Aliexpress tapasztalatok
- Intel Core i3 / i5 / i7 8xxx "Coffee Lake" és i5 / i7 / i9 9xxx “Coffee Lake Refresh” (LGA1151)
- Politika
- Bivalyerős lett a Poco F6 és F6 Pro
- Parkside szerszám kibeszélő
- Computex 2024: Itt az új ROG Ally
- További aktív témák...
Állásajánlatok
Cég: Ozeki Kft.
Város: Debrecen
Cég: Alpha Laptopszerviz Kft.
Város: Pécs