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 style='margin-top:20px;font-weight:bold;margin-bottom: 10px'>".$mysqli->error."</div>"; 21 }else{ 22 if(is_object($result)){ 23 $data["result_str"].="<table width='100%' border='1px' 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 style='font-weight: bold'>$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 style='margin-top:20px;font-weight:bold;margin-bottom: 10px'>共计 ".$mysqli->affected_rows."行 ".$colums."列</div>"; 46 $result->close(); 47 }else{ 48 $data["result_str"]="更新成功"; 49 $data["total_str"]="<div style='margin-top:20px;font-weight:bold;margin-bottom: 10px'>共计 ".$mysqli->affected_rows."行</div>"; 50 } 51 } 52 $mysqli->close();