Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.61 KB | None | 0 0
  1. Fatal error: Uncaught Error: Call to undefined function mysql_query() in C:Bitnamiwampstack-7.1.13-1apache2htdocsmvpbxphpcaso.php:28 Stack trace: #0 C:Bitnamiwampstack-7.1.13-1apache2htdocsmvpbxphpadiciona-caso.php(13): Caso->setNumero('1') #1 {main} thrown in C:Bitnamiwampstack-7.1.13-1apache2htdocsmvpbxphpcaso.php on line 28
  2.  
  3. <form action="php/adiciona-caso.php" method="post" >
  4. <li><button type="submit" value="4"
  5. name="perfil_id" id="perfil_id" class="btn btn-success btn-sm">Novo Atendimento</li></a>
  6. <input type="hidden" value="1" name="numero" id="numero">
  7.  
  8. <?php
  9.  
  10. $caso = new caso();
  11. $caso->setNumero($_POST["numero"]);
  12. $caso->setPerfil(new Perfil());
  13. $caso->setPerfil($_POST["perfil_id"]);
  14.  
  15. //var_dump($caso);exit;
  16.  
  17. $dao = new casoDAO($conexao);
  18.  
  19. if ($dao->insereCaso($caso)) {
  20. ?>
  21. <?php $_SESSION["atendimento_logado"] = $atendimento["numero"];?>
  22. <script type="text/javascript">
  23. window.location="../novo-atendimento.php"
  24. </script>
  25. <?php
  26.  
  27. function insereCaso($caso) {
  28.  
  29. $query = "INSERT INTO caso (numero, perfil_id) VALUES ($caso->getNumero()), '{$caso->getPerfil()}')";
  30.  
  31. //var_dump($query);exit;
  32. $resultado = mysqli_query($conexao, $query);
  33. $caso = mysqli_fetch_assoc($resultado);
  34. return $caso;
  35. }
  36.  
  37. public function getNumero()
  38. {
  39. return $this->numero;
  40. }
  41.  
  42. public function setNumero($numero)
  43. {
  44. $query = mysql_query("SELECT * FROM caso ORDER BY numero DESC LIMIT 1");
  45. $array = mysql_fetch_array($query);
  46. $ultimo = $array["numero"];
  47. $numero = $ultimo+1; // Peguei o ultimo numero e somei 1
  48. $this->numero = $numero;
  49. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement