小弟前端菜鳥(niǎo)一枚在做一個(gè)小項(xiàng)目時(shí) <?php header("Content-type: text/html;charset=utf-8");//防止亂碼 //1、獲取鏈接 $conn=@mysql_connect("localhost","root","0123456zp"); if(!$conn){ //mysql_error()是返回mysql的上一次操作 die("連接失敗".mysql_error()); }else{ //echo '連接成功！<br/>'; } //2、選擇對(duì)應(yīng)的數(shù)據(jù)庫(kù) @mysql_select_db("caiwu"); //3、設(shè)置操作編碼（可有可無(wú)，建議有） mysql_query("set names utf8");//保證是按照utf8碼操作的【utf8無(wú)-的，有-的是網(wǎng)頁(yè)版的?。。。。。?！】 $draw = $_GET['draw']; //第幾次請(qǐng)求 //排序 $order_column = $_GET['order']['0']['column']; // 哪一列排序 $order_dir= $_GET['order']['0']['dir']; // ase desc 升序或者降序 //拼接排序sql $orderSql = ""; if(isset($order_column)){ $i = intval($order_column); switch($i){ case 0;$orderSql = " order by id ".$order_dir;break; case 1;$orderSql = " order by kh ".$order_dir;break; case 2;$orderSql = " order by kj ".$order_dir;break; case 3;$orderSql = " order by cpx ".$order_dir;break; case 4;$orderSql = " order by zhd ".$order_dir;break; case 5;$orderSql = " order by afzhd ".$order_dir;break; case 6;$orderSql = " order by afxjd ".$order_dir;break; case 7;$orderSql = " order by zxrq ".$order_dir;break; case 8;$orderSql = " order by xs ".$order_dir;break; case 9;$orderSql = " order by crrq ".$order_dir;break; case 10;$orderSql = " order by skr ".$order_dir;break; case 11;$orderSql = " order by skzh ".$order_dir;break; default;$orderSql = ''; } } //分頁(yè) $start = $_GET['start'];//從多少開(kāi)始 $length = $_GET['length'];//數(shù)據(jù)長(zhǎng)度 $limitSql = ''; $limitFlag = isset($_GET['start']) && $length != -1 ; if ($limitFlag ) { $limitSql = " LIMIT ".intval($start).", ".intval($length); } //定義查詢數(shù)據(jù)總記錄數(shù)sql $sumSql = "SELECT count(id) as sum FROM financialdata"; //條件過(guò)濾后記錄數(shù) 必要 $recordsFiltered = 0; //表的總記錄數(shù) 必要 $recordsTotal = 0; $recordsTotalResult = mysql_query($sumSql,$conn); while($row=mysql_fetch_assoc($recordsTotalResult)){ $recordsTotal = $row['sum']; } //搜索//定義過(guò)濾條件查詢過(guò)濾后的記錄數(shù)sql $search = $_GET['search']['value'];//獲取前臺(tái)傳過(guò)來(lái)的過(guò)濾條件 // 每列搜索 $j = 1; $search_arr =array(); $colSearchSql=''; for($j=0;$j<6;$j++){ $colSearchable = $_GET['columns'][$j]['searchable']; $colSearchVal = $_GET['columns'][$j]['search']['value']; if(strlen($colSearchVal)>0 && $colSearchable == 'true' ){ switch ($j) { case 0: $colSearchVal = "id LIKE '%".$colSearchVal."%'"; array_push($search_arr,$colSearchVal); break; case 1: $colSearchVal = "kh LIKE '%".$colSearchVal."%'"; array_push($search_arr,$colSearchVal); break; case 2: $colSearchVal = "kj LIKE '%".$colSearchVal."%'"; array_push($search_arr,$colSearchVal); break; case 3: $colSearchVal = "cpx LIKE '%".$colSearchVal."%'"; array_push($search_arr,$colSearchVal); break; case 4: $colSearchVal = "zhd LIKE '%".$colSearchVal."%'"; array_push($search_arr,$colSearchVal); break; case 5: $colSearchVal = "afzhd LIKE '%".$colSearchVal."%'"; array_push($search_arr,$colSearchVal); break; case 6: $colSearchVal = "afxjd LIKE '%".$colSearchVal."%'"; array_push($search_arr,$colSearchVal); break; case 7: $colSearchVal = "zxrq LIKE '%".$colSearchVal."%'"; array_push($search_arr,$colSearchVal); break; case 8: $colSearchVal = "xs LIKE '%".$colSearchVal."%'"; array_push($search_arr,$colSearchVal); break; case 9: $colSearchVal = "crrq LIKE '%".$colSearchVal."%'"; array_push($search_arr,$colSearchVal); break; case 10: $colSearchVal = "skr LIKE '%".$colSearchVal."%'"; array_push($search_arr,$colSearchVal); break; case 11: $colSearchVal = "skzh LIKE '%".$colSearchVal."%'"; array_push($search_arr,$colSearchVal); break; default: # code... break; } } } if(empty($search_arr) == false){ $colSearchSql = " WHERE ".implode(" AND ",$search_arr); } // 綜合搜索sql // $zSearchSql =" where teacher_id || teacher_name || teacher_password || teacher_email || teacher_date || teacher_note LIKE '%".$search."%'"; $zSearchSql = " id LIKE '%".$search."%' OR kh LIKE '%".$search."%' OR kj LIKE '%".$search."%' OR cpx LIKE '%".$search."%' OR zhd LIKE '%".$search."%' OR afzhd LIKE '%".$search."%'OR afxjd LIKE '%".$search."%'OR zxrq LIKE '%".$search."%'OR xs LIKE '%".$search."%'OR crrq LIKE '%".$search."%'OR skr LIKE '%".$search."%'OR skzh LIKE '%".$search."%'"; // 拼接搜索SQL $sumSearchSql = ''; if(strlen($colSearchSql)>0 && strlen($search)>0){ $sumSearchSql = $colSearchSql." AND (".$zSearchSql.")"; }else if(strlen($colSearchSql)>0 && strlen($search)==0){ $sumSearchSql = $colSearchSql; }else if(strlen($colSearchSql)==0 && strlen($search)>0){ $sumSearchSql = " WHERE ".$zSearchSql; }else{ $sumSearchSql = ''; } if(strlen($sumSearchSql)>0){ $recordsFilteredResult = mysql_query($sumSql.$sumSearchSql); while ($row = mysql_fetch_assoc($recordsFilteredResult)) { $recordsFiltered = $row['sum']; } }else{ $recordsFiltered = $recordsTotal; } // query data $sql=''; $totalResultSql = "SELECT * FROM financialdata"; $infos = array(); // 拼接最終SQL $sql=$totalResultSql.$sumSearchSql.$orderSql.$limitSql; $dataResult = mysql_query($sql,$conn); while ($row = mysql_fetch_assoc($dataResult)) { // $obj = array($row['teacher_id'], $row['teacher_name'], $row['teacher_password'], $row['teacher_email'], $row['teacher_date'], $row['teacher_note']); // array_push($infos,$obj); array_push($infos,$row); } // return data echo json_encode(array( "draw" => $draw, "recordsTotal" =>$recordsTotal, // necessary "recordsFiltered" =>$recordsFiltered, // necessary "data" =>$infos // necessary ),JSON_UNESCAPED_UNICODE); 本地服務(wù)器環(huán)境可以正常訪問(wèn) 但是一放到網(wǎng)絡(luò)服務(wù)器就報(bào)錯(cuò) mysql_connect ，從網(wǎng)上查了下說(shuō)是mysql_connect 這個(gè)已經(jīng)廢棄，但是我自己改了還是報(bào)錯(cuò) 求前輩幫忙指點(diǎn)下 或者給改下 謝謝 以上為php代碼