public function salvarTurma(modelben $o) { $id = @$o->get('funcod'); if (empty($id)) { $exec = "insert into funcionarios(funtel,funend,funnome,funadm,funfuncao)\n\t\tvalues('" . $o->get('funtel') . "','" . $o->get('funend') . "','" . $o->get('funnome') . "','" . $o->get('funadm') . "','" . $o->get('funfuncao') . "')"; } else { $exec = "update funcionarios set funnome='" . $o->get('funnome') . "',\n\t\tfuntel='" . $o->get('funtel') . "',\n\t\tfunend='" . $o->get('funend') . "',\n\t\tfunadm='" . $o->get('funadm') . "',\n\t\tfunfuncao='" . $o->get('funfuncao') . "'\n\t\twhere funcod={$id}"; } try { $this->o_db->exec($exec); } catch (PDOException $e) { throw $e; } }
public function salvarAluno(modelben $o) { $id = @$o->get('idFun'); if (empty($id)) { // recebe um id gerado $o->set('idFun', UUID::v4()); $exec = "insert into Aluno(id, nome, endereco, data_nasc, sexo)\n\t\t\tvalues('" . $o->get('idFun') . "', '" . $o->get('funnome') . "', '" . $o->get('funend') . "', '" . $o->get('funadm') . "', '" . $o->get('sexo') . "')"; //echo "$exec"; // $exec="insert into Aluno(id) // values('".$o->get('idFun')."')"; } else { $exec = "update funcionarios set funnome='" . $o->get('funnome') . "',\n\t\t\tfuntel='" . $o->get('funtel') . "',\n\t\t\tfunend='" . $o->get('funend') . "',\n\t\t\tfunadm='" . $o->get('funadm') . "',\n\t\t\tfunfuncao='" . $o->get('funfuncao') . "'\n\t\t\twhere funcod={$id}"; } try { $this->o_db->exec($exec); } catch (PDOException $e) { throw $e; } }