index.php

<?php // File to be executed if the test environment supports PHP

/* Reqs : MySql 5.7.6+ / Create this database on your server:
CREATE DATABASE drawdb;
USE drawdb;
CREATE TABLE drawtable (
  geom geometrycollection NOT NULL,
  id int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (id)
);
INSERT INTO drawtable (geom) VALUES (GeometryCollection(POINT(5,45)));
*/

// Connect to the database
$mysqli = @new mysqli ('localhost', 'root', '', 'drawdb'); // Replace SQL parameters by yours
if ($mysqli->connect_errno) {
	echo $mysqli->connect_error;
	exit;
}

// Upload edition changes to the database
echo ('$_POST = '); var_dump ($_POST);
if ($pgeom = @$_POST['geom'])
	$mysqli->query("UPDATE drawtable SET geom = ST_GeomFromGeoJSON ('$pgeom') where id = 1");

// Get existing data from the database
$result = $mysqli->query("SELECT ST_AsGeoJSON (geom) AS geom FROM drawtable where id = 1");
echo ('$json_sql = '); var_dump ($json_sql = $result->fetch_object()->geom);

include ('index.html');
?>

<script> // Add a save button if we are in PHP
	document.getElementById("save").innerHTML = '<input type="submit" name="post" id="save" value="Save" />';
</script>

<a href="index.html"
   style="position:absolute;top:200px;right:0;text-decoration:none;font-size:large"
   title="Test en mode html">
	&#10144;
</a>