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>
