<?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"]); } }