Advertisement
Guest User

Untitled

a guest
Jun 27th, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.73 KB | None | 0 0
  1.  
  2. <html>
  3. <body>
  4. <?php
  5. $con = mysql_connect("localhost","root","");
  6. if (!$con)
  7. {
  8. die('Could not connect: ' . mysql_error());
  9. }
  10.  
  11. mysql_select_db("hc", $con);
  12. $result = mysql_query("SELECT * FROM hc");
  13.  
  14. //while($row = mysql_fetch_array($result))
  15. //{
  16. // echo " <table border=1>
  17. // <tr>
  18. $id=$_POST['ID'];
  19. $nume=$_POST['Nume'];
  20. $prenume=$_POST['Prenume'];
  21. $varsta=$_POST['Varsta'];
  22. $cnp=$_POST['CNP'];
  23. $ocupatie=$_POST['Ocupatie'];
  24. $dom=$_POST['Domiciliu'];
  25. $tel=$_POST['Telefon'];
  26. $pm=$_POST['PM'];
  27. $cm=$_POST['CM'];
  28. $det_cm=$_POST['Det_CM'];
  29. $dvs=$_POST['DVS'];
  30. $nps=$_POST['NPS'];
  31. $n=$_POST['N'];
  32. $ab=$_POST['AB'];
  33. $met_contr1=$_POST['Met_Contr1'];
  34. $met_contr2=$_POST['Met_Contr2'];
  35. $met_contr3=$_POST['Met_Contr3'];
  36. $ant1=$_POST['Ant1'];
  37. $ant2=$_POST['Ant2'];
  38. $tutun=$_POST['Tutun'];
  39. $det_tutun=$_POST['Det_tutun'];
  40. $cafea=$_POST['Cafea'];
  41. $det_cafea=$_POST['Det_Cafea'];
  42. $alcool=$_POST['Alcool'];
  43. $det_alcool=$_POST['Det_Alcool'];
  44. $droguri=$_POST['Droguri'];
  45. $det_droguri=$_POST['Det_Droguri'];
  46. $medicatie=$_POST['Medicatie'];
  47. $istoric=$_POST['Istoric'];
  48.  
  49. mysql_query("UPDATE hc
  50. SET Nume='$nume',Prenume='$prenume',Varsta='$varsta',CNP='$cnp',Ocupatie='$ocupatie',Domiciliu='$dom',Ocupatie='$ocupatie',Telefon='$tel',PM='$pm',CM='$cm',Det_CM='$det_cm',DVS='$dvs',NPS='$nps',N='$n',AB='$ab',Met_Contr1='$met_contr1',Met_Contr2='$met_contr2',Met_Contr3='$met_contr3',Ant1='$ant1',Ant2='$ant2',Tutun='$tutun',Det_tutun='$det_tutun',Cafea='$det_cafea',Alcool='$det_alcool',Droguri='$droguri',Det_Droguri='$det_droguri',Medicatie='$medicatie',Istoric='$istoric'
  51. WHERE ID='$id'");
  52.  
  53. echo "UPDATE hc
  54. SET Nume='$nume',Prenume='$prenume',Varsta='$varsta',CNP='$cnp',Ocupatie='$ocupatie',Domiciliu='$dom',Ocupatie='$ocupatie',Telefon='$tel',PM='$pm',CM='$cm',Det_CM='$det_cm',DVS='$dvs',NPS='$nps',N='$n',AB='$ab',Met_Contr1='$met_contr1',Met_Contr2='$met_contr2',Met_Contr3='$met_contr3',Ant1='$ant1',Ant2='$ant2',Tutun='$tutun',Det_tutun='$det_tutun',Cafea='$det_cafea',Alcool='$det_alcool',Droguri='$droguri',Det_Droguri='$det_droguri',Medicatie='$medicatie',Istoric='$istoric'
  55. WHERE ID='$id'";
  56. //mysql_query("INSERT INTO hc(Nume,Prenume,CNP,Domiciliu,Ocupatie,Telefon,PM,CM,Det_CM,DVS,NPS,N,AB,Met_Contr1,Met_Contr2,Met_Contr3,Ant1,Ant2,Tutun,Det_tutun,Cafea,Det_Cafea,Alcool,Det_Alcool,Droguri,Det_Droguri,Medicatie,Istoric)
  57. //VALUES ('$nume','$prenume','$cnp','$ocupatie','$tel','$dom','$pm','$cm','$det_cm','$dvs','$nps','$n','$ab','$met_contr1','$met_contr2','$met_contr3','$ant1','$ant2','$tutun','$det_tutun','$cafea','$det_cafea','$alcool','$det_alcool','$droguri','$det_droguri','$medicatie','$istoric')");
  58. ?>
  59.  
  60. Datele au fost salvate!
  61. <br />
  62. <a href='pag1.php'>Inapoi la rapoarte</a>
  63. </body>
  64. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement