<?php
/**
* Created by PhpStorm.
* User: kirill
* Date: 28.02.16
* Time: 23:18
*/
require_once '../database/Database.php';
require_once '../handlers/handlers.php';
if (isset($_POST['singup'])) {
// Validation
$requiredFields = ['email', 'username', 'password'];
$formErrors = checkEmptyFields($requiredFields);
$requiredFields = ['username' => 3, 'password' => 5];
$formErrors = array_merge($formErrors, checkMinLength($requiredFields));
$formErrors = array_merge($formErrors, checkEmail($_POST['email']));
if (empty($formErrors)) {
$email = $_POST['email'];
$username = $_POST['username'];
$password = $_POST['password'];
try {
$sqlInsert = "INSERT INTO users (user_name, email, password, join_date) VALUE (:username, :email, :password, now())";
$statmant = $db->prepare($sqlInsert);
$statmant->execute([':username' => $username, ':email' => $email, ':password' => password_hash($password, PASSWORD_DEFAULT)]);
if ($statmant->rowCount() == 1) {
$result = "<p>Registration Successful</p>";
}
} catch (PDOException $e) {
$result = "<p>Registration Error: " . $e->getMessage() . "</p>";
}
function checkVg($str)
{
global $bufferV, $arrayV, $toleranceV, $epsg;
checkMinLength($str);
$sql = "SELECT DISTINCT vg, ";
$sql .= "SRID(the_geom) AS srid, AsGML(Simplify(the_geom," . $toleranceV . ")) AS gml ,";
$sql .= "(xmin(the_geom)-" . $bufferV . ") as minx, ";
$sql .= "(ymin(the_geom)-" . $bufferV . ") as miny, ";
$sql .= "(xmax(the_geom)+" . $bufferV . ") as maxx, ";
$sql .= "(ymax(the_geom)+" . $bufferV . ") as maxy ";
$sql .= "FROM gis.vg_fl WHERE vg ILIKE \$1 ";
if (isset($epsg) && is_numeric($epsg) && intval($epsg) != 31466) {
$sql = str_replace("the_geom", "transform(the_geom," . $epsg . ")", $sql);
}
$v = array("%" . $str . "%");
$t = array('s');
$res = db_prep_query($sql, $v, $t);
while ($row = db_fetch_array($res)) {
stack_it($arrayV, "verbandsgemeinde", encode($row["vg"] . " (Verbandsgemeinde)"), "vg", $row["srid"], $row["minx"], $row["miny"], $row["maxx"], $row["maxy"], $row["gml"]);
}
}
