0) {
$rspes = stripSlashes($_POST['spqy']);
echo "Creation of tables ...
" . str_replace("\r\n","
",$rspes) . "
";
$spres = mysqli_query($con, $rspes);
}
}
if (isset($_POST['spqy2'])) {
if (strlen($_POST['spqy2']) > 0) {
$rspes = stripSlashes($_POST['spqy2']);
echo "CREATE PROCEDURE GetLMax ...
" . str_replace("\r\n","
",$rspes) . "
";
$spres = mysqli_query($con, $rspes);
}
}
if (isset($_POST['spqy3'])) {
if (strlen($_POST['spqy3']) > 0) {
$rspes = stripSlashes($_POST['spqy3']);
echo "CREATE PROCEDURE GetPlaceMax ...
" . str_replace("\r\n","
",$rspes) . "
";
$spres = mysqli_query($con, $rspes);
}
}
if (isset($_POST['spqy4'])) {
if (strlen($_POST['spqy4']) > 0) {
$rspes = stripSlashes($_POST['spqy4']);
echo "CREATE PROCEDURE AddLine ...
" . str_replace("\r\n","
",$rspes) . "
";
$spres = mysqli_query($con, $rspes);
}
}
$res = stripSlashes($_POST['qy']);
echo "" . str_replace("\r\n","
",$res) . "
";
$mres = mysqli_query($con, explode(";", $res)[0]);
if (sizeof(explode(";", $res)) > 1) {
mysqli_close($con);
$con=mysqli_connect($ourhost, $ouruser, $ourpassword);
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
mysqli_select_db($con, $_POST['db']);
$mres = mysqli_query($con, explode(";", $res)[1]);
}
?>
Query results ",$_POST['qy']); ?>
Error: " . mysqli_error($con) . "");
elseif (mysqli_num_rows($mres) == 0):
echo("Query executed successfully");
else:
?>
" . $afs[$ii] . "";
}
?>
");
$r_array = mysqli_fetch_row($mres);
for ($jj = 0; $jj < mysqli_num_fields($mres); $jj++) {
echo("" . $r_array[$jj] . " | ");
}
echo("");
}
?>
Back for more