-
How to Select specific category by writing PHP code to show lat & lng location in google map using volley library
about 9 years ago
-
almost 9 years ago
Devesh,
Treeid treelatitude treelongitude treeCondition 1 12.33 17.22 Balanced 2 12.33 17.22 Healthy 3 12.33 17.33 Dieseased 4 13.44 17.55 Healthy 5 11.32 17.66 Imbalanced 6 12.33 18.33 Healthy 7 14.44 18.44 Healthy 8 11.22 17.22 Balanced
I have slightly made changes in my code pl follow: I am able to get "Healthy" but If I select "Balanced" it should show only Balanced treeid & lat , long
<?php define('__ROOT__', dirname(dirname(__FILE__))); require_once(__ROOT__.'/public_html/Config.php'); // Connecting to mysql database $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE); // json response array $response = array(); $sq = "SELECT treeid, treelatitude, treelongitude FROM tree WHERE (treecondition = 'Healthy','Balanced')"; if (isset($_POST['treecondition'])) { // receiving the post params $treecondition = $_POST['treecondition']; // get the tree details for google map marker if($stmt = $mysqli->query($sq)){ if ($stmt->num_rows) { while($tree = $stmt->fetch_assoc()) { $treeItem = array(); $treeItem["treeid"] = $tree['treeid']; $treeItem["treelatitude"] = $tree['treelatitude']; $treeItem["treelongitude"] = $tree['treelongitude']; $response[] = $treeItem; } echo json_encode($response); } }else { // user is not found with the credentials $response["error"] = TRUE; $response["error_msg"] = "Tree list view credentials are wrong. Please try again!"; echo json_encode($response); } $mysqli->close(); }
-
-
almost 9 years ago
Devesh,
This is what I am getting!
http://plantnow.net16.net/googlemaplocations.php
[{"treeid":"2","treespecies":"Hatti","treelatitude":"5.5","treelongitude":"5.5"},{"treeid":"1","treespecies":"Kattoda","treelatitude":"15.4030008","treelongitude":"75.0770729"},{"treeid":"99","treespecies":"Halasu","treelatitude":"0","treelongitude":"0"},{"treeid":"21","treespecies":"Sita-Asoka","treelatitude":"15.4037277","treelongitude":"75.0764234"},{"treeid":"3","treespecies":"Nerale","treelatitude":"15.4584114","treelongitude":"74.9921761"},{"treeid":"4","treespecies":"Basavanapada","treelatitude":"15.4584057","treelongitude":"74.992166"}]
-
-
about 9 years ago
Can you post the json you getting from server?
-
3 Answer(s)