1d0
<
9,18d7
< // https://dev.mysql.com/doc/refman/5.7/en/spatial-relation-functions-object-shapes.html
<
< $mfp = "ST_";
< $moref = "";
< $mone="ourmysql_storedprocedure.php";
< $extrasql="";
< $tbits="";
< $tbitstwo="";
<
<
20c9
< $ourhost=htmlspecialchars(urldecode($_POST['host']));
---
> $ourhost=$_POST['host'];
25c14
< $ouruser=htmlspecialchars(urldecode($_POST['user']));
---
> $ouruser=$_POST['user'];
30c19
< $ourpassword=htmlspecialchars(urldecode($_POST['password']));
---
> $ourpassword=$_POST['password'];
35,39d23
< if (isset($_POST['moref'])) {
< $moref=htmlspecialchars(urldecode($_POST['moref']));
< } else {
< $moref="";
< }
54,56d37
<
< echo "\n\n";
<
63,68c44
< } 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;";
<
< }
---
> }
93c69
< mysqli_select_db($con, $_POST['db']);
---
> mysqli_select_db($con, $_POST['db']);
95c71
< }
---
> }
98,99d73
<
<
113,117c87
< if (substr(($moref . " "), 0, 1) == "^") {
< $afs=explode(",", substr($moref,1));
< } else {
< $afs=explode(",", "lngfrom,latfrom,lngto,latto,distance" . $moref);
< }
---
> $afs=explode(",", "lngfrom,latfrom,lngto,latto,distance");
134,168d103
<
< 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('');
< }
< }
< }
<
177,182c112
< \"; " . $tbitstwo . "
\"; \n";
< }
< echo 'Back for more';
< ?>
---
> Back for more