public function cadastrar(Funcionario $f) { $this->open(); $stmt = $this->con->prepare("insert into funcionario values(NULL,?,?,?,?)"); $stmt->bindParam(1, $f->getNome()); $stmt->bindParam(2, $f->getCpf()); $stmt->bindParam(3, $f->getEmail()); $stmt->bindParam(4, $f->getSalario()); $stmt->execute(); $this->con->commit(); return true; }
public function gravar(Funcionario $f) { $this->open(); //Iniciar transacao no banco $this->con->beginTransaction(); //Preparar o insert no banco $stmt = $this->con->prepare("insert into funcionario values(null,?,?,?,?)"); $stmt->bindParam(1, $f->getNome()); $stmt->bindParam(2, $f->getEmail()); $stmt->bindParam(3, $f->getSalario()); $stmt->bindParam(4, $f->getCpf()); //Executar no banco $stmt->execute(); //Confirmar a gravacao $this->con->commit(); return true; }
<div class="form-group"> <label for="celular" class="col-sm-2 control-label no-padding-right"><strong>Celular:</strong></label> <div class="col-sm-9"> <input type="text" id="celular" class="col-xs-10 col-sm-5 telefone" name="celular" value="<?php echo $colaborador->getCelular(); ?> " maxlength="15" /> </div> </div> <div class="form-group"> <label for="email" class="col-sm-2 control-label no-padding-right"><strong>E-mail:</strong></label> <div class="col-sm-9"> <input type="text" id="email" class="col-xs-10 col-sm-5 obrigatorio" name="email" value="<?php echo $colaborador->getEmail(); ?> " maxlength="50" /> </div> </div> <div class="form-group"> <label for="site" class="col-sm-2 control-label no-padding-right"><strong>Site:</strong></label> <div class="col-sm-9"> <input type="text" id="site" class="col-xs-10 col-sm-5" name="site" value="<?php echo $colaborador->getSite(); ?> " maxlength="50" /> </div> </div> </fieldset> </div>