鍍金池/ 問答/PHP  數(shù)據(jù)庫  HTML/ php 版本過低 怎么修改?

php 版本過低 怎么修改?

自己弄了個小項目 在本地localhost環(huán)境下沒問題,但放到網(wǎng)絡(luò)服務(wù)器就報錯 ,網(wǎng)上查了下是 mysql_connect 已經(jīng)被高版本php廢棄了, 我只是個前端菜鳥 怎么改都報錯 求前輩幫忙改一下 以下為項目包 sql文件也在里

https://pan.baidu.com/s/1e7Kx...

<?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、選擇對應(yīng)的數(shù)據(jù)庫
@mysql_select_db("caiwu");
//3、設(shè)置操作編碼(可有可無,建議有)
mysql_query("set names utf8");//保證是按照utf8碼操作的【utf8無-的,有-的是網(wǎng)頁版的?。。。。。?!】

$draw = $_GET['draw']; //第幾次請求
//排序
$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 = '';
    }
}

//分頁
$start = $_GET['start'];//從多少開始
$length = $_GET['length'];//數(shù)據(jù)長度
$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";
//條件過濾后記錄數(shù) 必要
$recordsFiltered = 0;
//表的總記錄數(shù) 必要
$recordsTotal = 0;
$recordsTotalResult = mysql_query($sumSql,$conn);
while($row=mysql_fetch_assoc($recordsTotalResult)){
    $recordsTotal = $row['sum'];
}
//搜索//定義過濾條件查詢過濾后的記錄數(shù)sql
$search = $_GET['search']['value'];//獲取前臺傳過來的過濾條件
// 每列搜索
$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);

clipboard.png

回答
編輯回答
巴扎嘿

ctrl+f 搜索mysql替換為mysqli

2017年4月27日 06:50
編輯回答
空白格

使用 mysqli

2018年6月10日 14:58
編輯回答
茍活

只是warning的話,可以設(shè)置error_reporting(0);來關(guān)閉界面的錯誤。
或者 將所有的mysql_connect()切換為mysqli_connect()

2017年10月5日 20:29
編輯回答
胭脂淚

在服務(wù)器上重新裝下低版本的php,或者可以的話,多裝幾個版本,想換的話直接切換。mysql_connect是要php5.5以下的版本。

2017年3月11日 07:53
編輯回答
久舊酒

對的,基本上mysql換成mysqli就好了

2018年6月29日 15:38
編輯回答
夢囈

現(xiàn)在mysql_connect只是即將被廢棄了,并沒有馬上廢棄啊?,F(xiàn)在是可以用的,但是要盡量更換為mysqli

2018年7月31日 21:34
編輯回答
掛念你

看看框架里對mysql連接是怎么處理的,可以借鑒過來

2018年1月9日 11:47