scenario: trying add fields in sql table form using php, it's not working , can't figure out why, i've searched whole web , on forums nothing seems working, can me?
form:
<form id="myform" class="fs-form fs-form-full" method="post" action="core/insert-contato.php" autocomplete="off"> <ol class="fs-fields"> <li> <label class="fs-field-label fs-anim-upper" for="q1">nome</label> <input class="fs-anim-lower" id="q1" name="name" type="text" placeholder="insira seu nome aqui" required/> </li> <li> <label class="fs-field-label fs-anim-upper" for="q2" data-info="preencha com atenção, senão não poderei te responder!">endereço de email</label> <input class="fs-anim-lower" id="q2" name="email" type="email" placeholder="seuemail@email.com" required/> </li> <li data-input-trigger> <label class="fs-field-label fs-anim-upper" style="color: #fff"for="q3" data-info="isso me ajuda muito na organização dos pedidos, acredite">por qual tipo de serviço você se interessa?</label> <div class="fs-radio-group fs-radio-custom clearfix fs-anim-lower"> <span><input id="q3b" name="service" type="radio" value="1"/><label for="q3b" class="radio-conversion" style="color: #fff;">website</label></span> <span><input id="q3c" name="service" type="radio" value="2"/><label for="q3c" class="radio-social" style="color: #fff;">seo</label></span> <span><input id="q3a" name="service" type="radio" value="3"/><label for="q3a" style="color: #fff;" class="radio-mobile">design</label></span> </div> </li> <li> <label class="fs-field-label fs-anim-upper" for="q4">descreva de maneira breve o que você deseja:</label> <textarea class="fs-anim-lower" id="q4" name="description" placeholder="uma breve descrição" style="background-color:#101010; height: 30%"></textarea> </li> <li> <label class="fs-field-label fs-anim-upper" for="q5">orçamento disponível:</label> <input class="fs-mark fs-anim-lower" id="q5" name="orcamento" type="number" step="100" min="100"/> </li> </ol><!-- /fs-fields --> <button class="fs-submit" type="submit">enviar</button> insert-contato.php <?php include_once 'dbconect.php'; $name = $_post['name']; $email = $_post['email']; $description = $_post['description']; $service = $_post['service']; $orcamento = $_post['orcamento']; switch ($service){ case '1': $service = 'website'; break(); case '2': $service = 'seo'; break(); case '3': $service = 'design'; break(); } $stmt = $dbh->prepare("insert contact (name, email, description, service, orcamento) values ( ?, ?, ?, ?, ?)"); try{ $stmt->bindparam(1, $name); $stmt->bindparam(2, $email); $stmt->bindparam(3, $description); $stmt->bindparam(4, $service); $stmt->bindparam(5, $orcamento); $stmt->execute(); } catch(pdoexception $e){ echo $e->getmessage(); } header('location: ../'); ?> dbconect.php
<?php try { $dbh = new pdo('mysql:host=127.0.0.1;dbname=info', 'root', 'pass'); } catch (pdoexception $e) { print "error!: " . $e->getmessage() . "<br/>"; die(); } ?> table:
id int pk name varchar(50 email varchar(50) description varchar(255) service varchar(11) orcamento smallint data datetime project directory:
contato ├── core │ ├── dbconect.php │ ├──insert-contato.php │ └──select-contato.php ├── readme.m └── index.php
for binding variable :
replace with
$stmt = $dbh->prepare("insert contact (name, email, description, service, orcamento) values (:name,:email,:description,:service,:orcamento)"); try{ $stmt->bindparam(:name, $name, pdo::param_str); $stmt->bindparam(:email, $email, pdo::param_str); $stmt->bindparam(:description, $description, pdo::param_str); $stmt->bindparam(:service, $service, pdo::param_str); $stmt->bindparam(:orcamento, $orcamento, pdo::param_str); } 
Comments
Post a Comment