Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $db_name = "testwz";
- $mysql_user = "root";
- $mysql_pass = "";
- $server_name = "localhost";
- $con = mysqli_connect($server_name,$mysql_user,$mysql_pass,$db_name);
- $sql = "
- SELECT
- verbrauchsstelle.ID,
- adressen.Ort,
- adressen.Ortsteil,
- adressen.PLZ,
- adressen.Strasse,
- adressen.Hausnummer,
- zaehler.Nummer
- FROM verbrauchsstelle
- LEFT JOIN adressen ON
- verbrauchsstelle.adressen_id = adressen.ID
- LEFT JOIN zaehler ON
- zaehler.Verbrauchsstelle_id = verbrauchsstelle.ID ;";
- $result = mysqli_query($con,$sql);
- $response = array();
- while($row = mysqli_fetch_array($result))
- {
- array_push($response,array(
- "vID"=>$row[0],
- "Ort"=>$row[1],
- "Ortsteil"=>$row[2],
- "PLZ"=>$row[3],
- "Strasse"=>$row[4],
- "Hausnummer"=>$row[5],
- "zNr"=>[6]
- ));
- }
- echo json_encode(array("server_response"=>$response));
- mysqli_close($con);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement