<?php
$type = $_GET["typeName"];
include_once 'dbConnect.php';
DBConnection();
$type = strtolower($type);
$type = "{$type}%";
try {
$stm = $db->prepare("SELECT `type`.`typeName` FROM `type` WHERE `typeName` LIKE :type ;");
$stm->bindParam(":type", $type);
$stm->execute();
$arr = array();
foreach ($stm as $row) {
$arr[] = $row[0];
}
echo json_encode($arr);
} catch (PDOException $e) {
echo "<p>" . $e->getMessage() . "</p>";
}
</div>
</div>
<a name="FormAnchore"></a>
</section>
<section class="ContactSection center">
<div class="row">
<div class="small-12 columns">
<div class="container">
<?php
if (isset($_POST["submit"])) {
require_once 'emails.php';
require_once 'bd/bd_conection.php';
$ConnDB = DBConnection();
$user = $_POST["name"];
$mail = $_POST["email"];
$comment = $_POST["comment"];
$legal = isset($_POST["legal"]) ? 1 : 0;
$currentDate = date("Y-m-d");
$query = "INSERT INTO contacts (fecha, nombre, email, comentarios, legal) VALUES ('" . $currentDate . "', '" . $user . "', '" . $mail . "', '" . $comment . "', '" . $legal . "');";
$queryResultEvent = $ConnDB->query($query);
Autoresponder($user, $mail);
NewContact($user, $mail, $phone, $web, $comment, $legal);
?>
<h2 class="ContactTitle">¡Estupendo!</h2>
<p>Ya hemos empezado a pensar en tu ramo. En breve nos pondremos en contacto contigo para todo lo demás.</p>
<p>Mira nuestras redes sociales, seguro que puedes encontrar inspiración para cuando te contactemos.</p>
