本文實例為大家分享了ajax三級聯動展示的具體代碼,供大家參考,具體內容如下
1. test.php
<script src="../jquery-1.11.2.min.js"></script> <script src="sanji.js"></script> <title>無標題文檔</title> </head> <body> <h1>三級聯動</h1> <p id="sanji"></p> </body> </html>
2. sanji.js
3. chuli.php
<?php //給一個父級代號,返回該父級代號下所有的子地區 require "DBDA.class.php"; $db=new DBDA(); $pcode=$_POST["pcode"]; $sql="select areacode,areaname from chinastates where parentareacode='{$pcode}'"; echo $db->StrQuery($sql);
引用的封裝類里面返回字符串的方法
<?php class DBDA { public $host = "localhost"; public $uid = "root"; public $pwd = "123"; public $dbname = "test_123"; //執行SQL語句返回相應的結果 //$sql 要執行的SQL語句 //$type 代表SQL語句的類型,0代表增刪改,1代表查詢 function query($sql,$type=0) { $db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname); $result = $db->query($sql); if($type) { //如果是查詢,顯示數據 return $result->fetch_all(); } else { //如果是增刪改,返回true或者false return $result; } } //返回字符串的方法 public function strquery($sql,$type=1) { $db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname); $result = $db->query($sql); $arr = $result->fetch_all(); $str=""; foreach($arr as $v) { $str = $str.implode("^",$v)."|"; } $str = substr($str,0,strlen($str)-1); return $str; } //返回JSON function JSONQuery($sql,$type=1) { $db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname); $r = $db->query($sql); if($type==1) { return json_encode($r->fetch_all(MYSQLI_ASSOC)); } else { return $r; } } }
聲明:本網頁內容旨在傳播知識,若有侵權等問題請及時與本網聯系,我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com