function call_projects($data)
{
$ret = array();
$sql = build_query($data);
$result = call_db($sql);
if ($result) {
$i = 0;
while ($row = $result->fetch_assoc()) {
$ret[$i] = $row;
// add tags
$tags = call_db("SELECT tags.name FROM tags, item_tags WHERE tags.id = item_tags.tag_id AND item_tags.item_id = '{$row['id']}'");
while ($tag = $tags->fetch_assoc()) {
$ret[$i]['tags'][] = $tag['name'];
}
$i++;
}
return ret_success($ret);
} else {
return ret_error(410, 'One or more keywords are not recognized');
}
}
<?php require_once 'functions.inc.php'; $url = "http://127.0.0.1:5984/tempest_hikes/_design/tempest_hikes/_view/hike_summaries"; $hikes = json_decode(call_db($url)); $hikes = json_encode($hikes); // echo gettype($hikes); // print_r($hikes); echo $hikes;
$lat = $_GET["lat"];
}
if (isset($_GET["lng"])) {
$lng = $_GET["lng"];
}
switch ($view) {
case 'hike_summaries':
$url = "http://127.0.0.1:5984/tempest_hikes/_design/tempest_hikes/_view/hike_summaries";
break;
case 'hike_feed':
$url = "http://127.0.0.1:5984/tempest_hikes/_design/tempest_hikes/_view/hike_feed?descending=true";
break;
case 'full_hike_info':
$url = "http://127.0.0.1:5984/tempest_hikes/_design/tempest_hikes/_view/full_hike_info?key={\"lat\":";
$url .= $lat;
$url .= ",\"lng\":";
$url .= $lng;
$url .= "}";
break;
case 'weather':
$url = "http://api.wunderground.com/api/" . $weather_key . "/forecast10day/q/" . $lat . "," . $lng . ".json";
break;
case 'admin_list':
$url = "http://127.0.0.1:5984/tempest_hikes/_design/admin/_view/admin_list";
break;
default:
# code...
break;
}
$result = call_db($url);
echo $result;