如何使用php web服务在mysql数据库中获取数据

Question

I just start to use php webservice.I want to take all data in 'urun' table just sending 'id' Here is my code and i dont know how to solve it.

if($_GET["function"] == "getUrun"){

    if(isset($_GET["id"]) && $_GET["id"] != ""){
        $id = $_GET["id"];
        $kategoriid =$_GET["kategoriid"];
        $urunadi =$_GET["urunadi"];
        $urunfiyati =$_GET["urunfiyati"];
        $aciklama =$_GET["aciklama"];
        $where="";
        $where = "id='".$id."' AND kategoriid='".$kategoriid."' AND urunadi='".$urunadi."' AND urunfiyati='".$urunfiyati."' AND aciklama='".$aciklama."'";
        $result  = mysql_query("SELECT * FROM urun WHERE ".$where."");
        $rows = array();
        if($r=mysql_fetch_assoc($result))
            {
                $rows[] = $result;
                $data = json_encode($rows);

                echo "{ \"status\":\"OK\", \"getUrun\": ".$data." }";

            }else{
            echo "{ \"status\":\"ERR: Something wrong hepsi\"}";}
    }else{
        echo "{ \"status\":\"ERR: Something wrongs hepsi\"}";}
}   

Answer 1

It should be:

if ($result) {
    $rows = array();
    while ($r = mysql_fetch_assoc($result)) {
        $rows[] = $r;
    }
    echo json_encode(array('status' => 'OK', 'getUrun' => $rows));
} else {
    echo json_encode(array('status' => 'ERR: Something wrong hepsi'));
}

You need to get all the results in an array, and then encode the whole thing. You should also use json_encode for the containing object, don't try to create JSON by hand.