1 $dbname=DB_NAME;
2 $host=DB_HOST;
3 $port=DB_PORT;
4 $user =DB_USER;
5 $password=DB_PWD;
6
7 $mysqli = new \mysqli($host, $user, $password, $dbname,$port);
8 $mysqli->set_charset("utf8");
9 $sql=trim($_POST["sql_content"]);
10 $result = $mysqli->query($sql);
11
12
13 $data=array();
14 $data["check_sql"]=$sql;
15 $data["result_str"]="";
16 $data["total_str"]="";
17
18 if($mysqli->errno>0){
19 $data["result_str"]="更新失败";
20 $data["total_str"]="<div >".$mysqli->error."</div>";
21 }else{
22 if(is_object($result)){
23 $data["result_str"].="<table width='100%' cellpadding='5px' cellspacing='0px' >";
24 $show_title=true;
25 $colums=0;
26 while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
27 $header_str="";
28 $content_str="";
29 foreach($row as $key=>$value){
30 if($show_title){
31 $colums++;
32 $header_str.="<td>$key</td>";
33 }
34 $content_str.="<td>$value</td>";
35 }
36
37 if(!empty($header_str)){
38 $data["result_str"].= "<tr >$header_str</tr>";
39 }
40 $data["result_str"].="<tr>$content_str<tr>";
41 $show_title=false;
42 }
43 $data["result_str"].="</table>";
44 $data["result_str"].="</div>";
45 $data["total_str"]="<div >共计 ".$mysqli->affected_rows."行 ".$colums."列</div>";
46 $result->close();
47 }else{
48 $data["result_str"]="更新成功";
49 $data["total_str"]="<div >共计 ".$mysqli->affected_rows."行</div>";
50 }
51 }
52 $mysqli->close();