php 版本过低 怎么修改？

Question

自己弄了个小项目 在本地localhost环境下没问题，但放到网络服务器就报错 ，网上查了下是 mysql_connect 已经被高版本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、选择对应的数据库 @mysql_select_db("caiwu"); //3、设置操作编码（可有可无，建议有） mysql_query("set names utf8");//保证是按照utf8码操作的【utf8无-的，有-的是网页版的！！！！！！！】 $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'];//数据长度 $limitSql = ''; $limitFlag = isset($_GET['start']) && $length != -1 ; if ($limitFlag ) { $limitSql = " LIMIT ".intval($start).", ".intval($length); } //定义查询数据总记录数sql $sumSql = "SELECT count(id) as sum FROM financialdata"; //条件过滤后记录数 必要 $recordsFiltered = 0; //表的总记录数 必要 $recordsTotal = 0; $recordsTotalResult = mysql_query($sumSql,$conn); while($row=mysql_fetch_assoc($recordsTotalResult)){ $recordsTotal = $row['sum']; } //搜索//定义过滤条件查询过滤后的记录数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);

Answer 1

只是warning的话，可以设置error_reporting(0);来关闭界面的错误。
或者 将所有的mysql_connect()切换为mysqli_connect()。

Answer 2

使用 mysqli

Answer 3

在服务器上重新装下低版本的php，或者可以的话，多装几个版本，想换的话直接切换。mysql_connect是要php5.5以下的版本。

Answer 4

现在mysql_connect只是即将被废弃了，并没有马上废弃啊。现在是可以用的，但是要尽量更换为mysqli

Answer 5

对的，基本上mysql换成mysqli就好了

Answer 6

看看框架里对mysql连接是怎么处理的，可以借鉴过来

Answer 7

ctrl+f 搜索mysql替换为mysqli