数据查询接口

<?php
//including the Mysql connect parameters.
$link = mysqli_connect('localhost', 'root', 'root', 'data_breach');
if (!$link) {
    die('连接失败: ' . mysqli_connect_error());
}

if (isset($_POST['query-menu']) && isset($_POST['input'])) {
    $name = $_POST['query-menu'];
    if (!empty($link)) {
        $value = mysqli_real_escape_string($link, $_POST['input']);
    }
	// 关闭自动提交 
	mysqli_autocommit($link, FALSE);

	// 获取表名
	$table_sname_query = "SELECT table_sname FROM connection WHERE columns_sname='$name'" ;
	$table_sname_result = mysqli_query($link, $table_sname_query);
	if (!empty($table_sname_result)) {
	    $table_sname_row = mysqli_fetch_assoc($table_sname_result);//将查询结果返回到数组中
	    $table_sname = $table_sname_row['table_sname'];//只获取table_name
	    if($name=="Year" or $name=="Records" or $name=="S_num"){
		    $value=(int)$value;
		    // 查询数据
		    $query_ = "select * from $table_sname where $name=$value";
		    $query_result = mysqli_query($link, $query_);
	    }else{// 查询数据
		    $query_ = "select * from $table_sname where $name='$value' limit 1";
		    $query_result = mysqli_query($link, $query_);
	    }
	    if (!empty($query_result)) {
	        mysqli_commit($link);
	        mysqli_close($link);
	        $data = array();
	        while ($row = mysqli_fetch_assoc($query_result)) {
	            $data[] = $row;
	        }
	        if (!empty($data)) {
	            $query_result_json = json_encode($data);
	            $url = "index.php?query_result=" . urlencode($query_result_json);
	            echo "<script>window.location.href = '$url';</script>";
	        } else {
	            echo "<script>alert('查询结果为空');</script>";
	        }
	    } else {
	        echo  mysqli_affected_rows($link);	
	        echo $query_result;
	        //echo mysqli_affected_rows($link);
	        mysqli_rollback($link);
	        mysqli_close($link);
	        echo 'false';
	        echo gettype($value);
	        echo  $value;
	    }
	} else {
	    mysqli_close($link);
	    echo "<script>alert('表名不存在');</script>";
	    echo "<script>window.location.href = '../welcome/welcome.html';</script>";
	}
}else{
	mysqli_close($link);
	 echo "<script>alert('your input is empty');</script>";
	 echo "<script>window.location.href = '../welcome/welcome.html';</script>";
}
?>