PHP原生代码操作数据库

PHP原生代码操作数据库

if(!empty($_REQUEST["father"])){
    //连接数据库
    $resData = @mysql_connect("localhost","root","") or die("connect failed");
    //选择数据库
    mysql_select_db("db_place",$resData) or die("select db failed");
    //告诉服务器当前客服端的编码
    mysql_query("set names utf8");
    $selectSql = "select city,cityID from city where father={$_REQUEST["father"]}";
    //执行sql语句
    $resData = mysql_query($selectSql);
    //循环提取数据装到数组
    $arrDataBig = array();
    while($arrData = mysql_fetch_assoc($resData)){
        $arrDataBig[] = $arrData;
        //array( array("city"=>xx,cityID=>x), array("city"=>xx,cityID=>x)  )
    }
    echo json_encode($arrDataBig);
        //[{ctiy:xx,cityID:xx},{ctiy:xx,cityID:xx},{ctiy:xx,cityID:xx}]
}

上一篇：数组两种快速排序方法、数组求最大跟最小值

下一篇：Ajax做三级联动的Jquer代码