Advertisement
Guest User

Untitled

a guest
Sep 26th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. function marcar_consulta(id_paciente,id_horario, data_consulta )
  2. {
  3. $.ajax
  4. ({
  5. type:'post',
  6. url:'insert_consulta.php',
  7. data:{marcar_consulta:'marcar_consulta', pid_paciente:id_paciente, pid_horario:id_horario , pdata_consulta:data_consulta,},
  8. success:function(response)
  9. {
  10. if(response=="success")
  11. {
  12. window.alert('Inserido com SUCESSO');
  13. }
  14. else
  15. {
  16. window.alert(response);
  17. }
  18. }
  19. });
  20.  
  21.  
  22. }
  23.  
  24. <?php
  25. $user = "maria";
  26. $pass = "1111";
  27. $host = "192.168.25.4";
  28. $banco = "base";
  29.  
  30. $conexao = mysql_connect($host, $user, $pass) or die(mysql_error());
  31. mysql_select_db($banco);
  32.  
  33. mysql_query("SET NAMES 'utf8'");
  34. mysql_query('SET character_set_connection=utf8');
  35. mysql_query('SET character_set_client=utf8');
  36. mysql_query('SET character_set_results=utf8');
  37.  
  38. if(isset($_POST['marcar_consulta']))
  39. {
  40. $pid_paciente=$_POST['pid_paciente'];
  41. $pid_horario=$_POST['pid_horario'];
  42. $pdata_consulta = $_POST['pdata_consulta'];
  43.  
  44.  
  45. $sql = " Insert into consulta " .
  46. " ( id_paciente_fk, id_m_h_fk, id_convenio_fk, data_consulta)" .
  47. " values " .
  48. " ( ".$pid_paciente.",".$pid_horario.", 0,'" .$pdata_consulta. "')";
  49.  
  50.  
  51. $resultado = mysql_query($sql, $conexao) or die(mysql_error());
  52.  
  53. echo "success";
  54.  
  55. mysql_close($conexao);
  56.  
  57. }
  58.  
  59. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement