Example #1
0
function getserviceslist()
{
    $con = DBconnect();
    $getservice = DBfetchall("SELECT serviceid,shopid,name,price FROM Service", $con);
    $Arr = array();
    foreach ($getservice as $row) {
        $row2 = DBfetchone("select name,pic,latitude,longtitude from Shop where shopid=" . $row["shopid"] . ";", $con);
        $a = array("serviceid" => $row["serviceid"], "shopname" => $row2["name"], "servicename" => $row["name"], "price" => $row["price"], "pic" => $row2["pic"], "latitude" => $row2["latitude"], "longtitude" => $row2["longtitude"]);
        //var_dump($row2);
        array_push($Arr, $a);
    }
    echo json_encode($Arr);
}
Example #2
0
function DBselectsUseonekey($parameterarray = "*", $keyarray = null, $keyname = null, $table = null, $con)
{
    //echo "DBselect:";
    //var_dump($parameterarray);
    $para = join(",", $parameterarray);
    //echo $para;
    //echo "para done";
    $results = array();
    foreach ($keyarray as $key) {
        $query = "select {$para} from {$table} where {$keyname} = {$key}";
        //echo $query;
        $result = DBfetchone($query, $con);
        //var_dump($result);
        array_push($results, $result);
    }
    return $results;
}