i have json file php, , want remove last comma, because causes error. code following:
{ "data": [ <?php require_once("../../config.php"); $qtodos = $mysqli->query("select * negocios"); while($todos = $qtodos -> fetch_assoc()) { ?> { "id": <?php echo $todos['idnegocios']; ?>, "category": "real_estate", "title": "<?php echo $todos['nombre']; ?>", "location": "<?php echo $todos['direccion']; ?>", "latitude": 51.541599, "longitude": -0.112588, "url": "item-detail.html", "type": "apartment", "type_icon": "assets/icons/store/apparel/umbrella-2.png", "rating": 4, "gallery": [ "assets/img/items/1.jpg", "assets/img/items/5.jpg", "assets/img/items/4.jpg" ], "features": [ "free parking", "cards accepted", "wi-fi", "air condition", "reservations", "teambuildings", "places seat" ], "date_created": "2014-11-03", "price": "$2500", "featured": 0, "color": "", "person_id": 1, "year": 1980, "special_offer": 0, "item_specific": { "bedrooms": 4, "bathrooms": 2, "rooms": 4, "garages": 1, "area": 240 }, "description": "asasasas odio nibh, luctus non pulvinar a, ultricies ac diam. donec neque massa, viverra interdum eros ut, imperdiet pellentesque mauris. proin sit amet scelerisque risus. donec semper semper erat ut mollis. curabitur suscipit, justo eu dignissim lacinia, ante sapien pharetra duin consectetur eros augue sed ex. donec odio rutrum, hendrerit sapien vitae, euismod arcu.", "last_review": "curabitur odio nibh, luctus non pulvinar a, ultricies ac diam. donec neque massa, viverra interdum eros ut, imperdiet", "last_review_rating": 5 }, <?php } ?> ] } i tried lots of solutions never works in code. don't know when last itineration of loop, , can't remove it.
get query row count , create counter know row iterating in loop, add comma if counter different total rows:
{ "data": [ <?php require_once("../../config.php"); $qtodos = $mysqli->query("select * negocios"); $totalrcount = $qtodos->num_rows; // <<<< row count $counter = 0; while($todos = $qtodos -> fetch_assoc()) { $counter++ // <<<< add counter ?> { "id": <?php echo $todos['idnegocios']; ?>, "category": "real_estate", "title": "<?php echo $todos['nombre']; ?>", "location": "<?php echo $todos['direccion']; ?>", "latitude": 51.541599, "longitude": -0.112588, "url": "item-detail.html", "type": "apartment", "type_icon": "assets/icons/store/apparel/umbrella-2.png", "rating": 4, "gallery": [ "assets/img/items/1.jpg", "assets/img/items/5.jpg", "assets/img/items/4.jpg" ], "features": [ "free parking", "cards accepted", "wi-fi", "air condition", "reservations", "teambuildings", "places seat" ], "date_created": "2014-11-03", "price": "$2500", "featured": 0, "color": "", "person_id": 1, "year": 1980, "special_offer": 0, "item_specific": { "bedrooms": 4, "bathrooms": 2, "rooms": 4, "garages": 1, "area": 240 }, "description": "asasasas odio nibh, luctus non pulvinar a, ultricies ac diam. donec neque massa, viverra interdum eros ut, imperdiet pellentesque mauris. proin sit amet scelerisque risus. donec semper semper erat ut mollis. curabitur suscipit, justo eu dignissim lacinia, ante sapien pharetra duin consectetur eros augue sed ex. donec odio rutrum, hendrerit sapien vitae, euismod arcu.", "last_review": "curabitur odio nibh, luctus non pulvinar a, ultricies ac diam. donec neque massa, viverra interdum eros ut, imperdiet", "last_review_rating": 5 }<?php if($totalrcount != $counter) { echo ','}; // <<<< add comma when counter different total rows } ?> ] } 
Comments
Post a Comment