<?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>