摘要:function getArea($pid){ $conn = mysqli_connect('127.0.0.1','root','root','php',3306); if(!$conn){ echo '數據庫錯誤',mysqli_connect_error();
function getArea($pid){ $conn = mysqli_connect('127.0.0.1','root','root','php',3306); if(!$conn){ echo '數據庫錯誤',mysqli_connect_error(); } $sql = "select area_id,area_pid,area_name from php_area where area_pid={$pid}"; $res = mysqli_query($conn,$sql); $data = []; while($row=mysqli_fetch_assoc($res)){ $data[] = $row; } mysqli_close($conn); return json_encode($data); }
標題:省市區(qū)接口文檔 地址:http://localhost/test/a.php 傳參:int $pid 返回值:該id下所有下級地區(qū) 代碼: function getArea($pid){ $conn = mysqli_connect('127.0.0.1','root','root','php',3306); if(!$conn){ echo '數據庫錯誤',mysqli_connect_error(); } $sql = "select area_id,area_pid,area_name from php_area where area_pid={$pid}"; $res = mysqli_query($conn,$sql); $data = []; while($row=mysqli_fetch_assoc($res)){ $data[] = $row; } mysqli_close($conn); return json_encode($data); } 返回值示例: [ { "area_id": "3", "area_pid": "2", "area_name": "東城區(qū)" }, { "area_id": "4", "area_pid": "2", "area_name": "西城區(qū)" }, { "area_id": "5", "area_pid": "2", "area_name": "崇文區(qū)" }, { "area_id": "6", "area_pid": "2", "area_name": "宣武區(qū)" } ]
批改老師:查無此人批改時間:2019-03-04 09:07:10
老師總結:完成的不錯。接口文檔,一般不寫代碼,前端人員也看不懂,以免別人發(fā)現代碼中有漏洞,進行攻擊。