0) {
$rspes = stripSlashes($_POST['spqy']);
echo "Creation of tables ...
" . str_replace("\r\n","
",$rspes) . "
";
$spres = mysqli_query($con, $rspes);
}
}
echo "\n\n";
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);
}
} else {
$mone="area_polygon_mysql.php";
$moref="^polyid,mapid,onepolygon";
$extrasql="SELECT CONCAT('If 1 Polygon1 and Polygon2 cross=',CAST((" . $mfp . "CROSSES((SELECT p.onepolygon FROM POLYGONS p WHERE p.polyid=1), (SELECT q.onepolygon FROM POLYGONS q WHERE q.polyid=1))) AS CHAR(1))), CONCAT('If 1 Polygon1 and Polygon2 are disjoint=',CAST((" . $mfp . "DISJOINT((SELECT p.onepolygon FROM POLYGONS p WHERE p.polyid=1), (SELECT q.onepolygon FROM POLYGONS q WHERE q.polyid=1))) AS CHAR(1))), CONCAT('If 1 Polygon1 and Polygon2 are spatially equal=',CAST((" . $mfp . "EQUALS((SELECT p.onepolygon FROM POLYGONS p WHERE p.polyid=1), (SELECT q.onepolygon FROM POLYGONS q WHERE q.polyid=1))) AS CHAR(1))), CONCAT('If 1 Polygon1 and Polygon2 intersect=',CAST((" . $mfp . "INTERSECTS((SELECT p.onepolygon FROM POLYGONS p WHERE p.polyid=1), (SELECT q.onepolygon FROM POLYGONS q WHERE q.polyid=1))) AS CHAR(1))), CONCAT('If 1 Polygon1 and Polygon2 overlap=',CAST((" . $mfp . "OVERLAPS((SELECT p.onepolygon FROM POLYGONS p WHERE p.polyid=1), (SELECT q.onepolygon FROM POLYGONS q WHERE q.polyid=1))) AS CHAR(1))), CONCAT('If 1 Polygon1 and Polygon2 touch=',CAST((" . $mfp . "TOUCHES((SELECT p.onepolygon FROM POLYGONS p WHERE p.polyid=1), (SELECT q.onepolygon FROM POLYGONS q WHERE q.polyid=1))) AS CHAR(1))), CONCAT('If 1 Polygon1 is within Polygon2=',CAST((" . $mfp . "WITHIN((SELECT p.onepolygon FROM POLYGONS p WHERE p.polyid=1), (SELECT q.onepolygon FROM POLYGONS q WHERE q.polyid=1))) AS CHAR(1))) FROM POLYGONS WHERE polyid=1;";
}
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("");
}
if ($extrasql != "") {
if (1 == 1) {
$tbits=" document.getElementById('textrasql').innerHTML=\"
Query results " . str_replace("\r\n","
",$extrasql) . "
";
$tbitstwo=" document.getElementById('textrasqltwo').innerHTML=\"
Query results " . str_replace("\r\n","
",$extrasql) . "
Query results " . str_replace("\r\n","
",$extrasql) . "
";
}
mysqli_select_db($con, $_POST['db']);
$mres = mysqli_query($con, $extrasql);
for ($ii = 0; $ii < mysqli_num_rows($mres); $ii++) {
if (1 == 1) {
$tbits.='';
$tbitstwo.='
';
} else {
echo('
');
}
$r_array = mysqli_fetch_row($mres);
for ($jj = 0; $jj < mysqli_num_fields($mres); $jj++) {
if (1 == 1) {
$tbits.="" . $r_array[$jj] . " | ";
$tbitstwo.="" . $r_array[$jj] . " | ";
} else {
echo("" . $r_array[$jj] . " | ");
}
}
if (1 == 1) {
$tbits.='
';
$tbitstwo.='';
} else {
echo('');
}
}
}
?>
\"; " . $tbitstwo . "
\"; \n";
}
echo 'Back for more';
?>