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); }
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; }