Advertisement
valodia

PDO

Feb 16th, 2016
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. <?php
  2. $user='root';
  3. $pass='';
  4.  
  5. try {
  6. //mysql:host=192.168.0.1
  7. $conn = new PDO('mysql:host=localhost;dbname=vpdes897_pesquisa', $user, $pass);
  8. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  9.  
  10.  
  11. $idescola= '77';
  12. $programa= 'Novo Programa';
  13. $instituicao= 'Nova Instituicao';
  14. $site= 'Novo Site';
  15. $coordenador= 'Novo Coordenador';
  16. $secretario= 'Novo Secretario';
  17. $telefone= 'Novo Telefone';
  18. $email= 'Novo Email';
  19. $esta_coordenando_desde= 'Nova Administracao';
  20.  
  21. $query_insert = $conn->prepare('INSERT INTO escola VALUES(
  22. :idescola,:programa,:instituicao,:site,:coordenador,:secretario,:telefone,:email,:esta_coordenando_desde)'
  23. );
  24. $query_insert->execute(array(
  25. ':idescola' => $idescola,
  26. ':programa' => $programa,
  27. ':instituicao' => $instituicao,
  28. ':site' => $site,
  29. ':coordenador' => $coordenador,
  30. ':secretario' => $secretario,
  31. ':telefone' => $telefone,
  32. ':email' => $email,
  33. ':esta_coordenando_desde' => $esta_coordenando_desde,
  34.  
  35. ));
  36.  
  37. echo $query_insert->rowCount();
  38.  
  39. $conn = NULL;
  40. } catch (PDOException $e) {
  41. print "Error!: " . $e->getMessage() . "<br/>";
  42. die();
  43. }
  44.  
  45. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement