Untitled

<html>
<body>
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("hc", $con);
$result = mysql_query("SELECT * FROM hc");

//while($row = mysql_fetch_array($result))
//{
 // echo " <table border=1>
//		<tr>
 $id=$_POST['ID'];
 $nume=$_POST['Nume'];
 $prenume=$_POST['Prenume'];
 $varsta=$_POST['Varsta'];
 $cnp=$_POST['CNP'];
 $ocupatie=$_POST['Ocupatie'];
 $dom=$_POST['Domiciliu'];
 $tel=$_POST['Telefon'];
 $pm=$_POST['PM'];
 $cm=$_POST['CM'];
 $det_cm=$_POST['Det_CM'];
 $dvs=$_POST['DVS'];
 $nps=$_POST['NPS'];
 $n=$_POST['N'];
 $ab=$_POST['AB'];
 $met_contr1=$_POST['Met_Contr1'];
 $met_contr2=$_POST['Met_Contr2'];
 $met_contr3=$_POST['Met_Contr3'];
 $ant1=$_POST['Ant1'];
 $ant2=$_POST['Ant2'];
 $tutun=$_POST['Tutun'];
 $det_tutun=$_POST['Det_tutun'];
 $cafea=$_POST['Cafea'];
 $det_cafea=$_POST['Det_Cafea'];
 $alcool=$_POST['Alcool'];
 $det_alcool=$_POST['Det_Alcool'];
 $droguri=$_POST['Droguri'];
 $det_droguri=$_POST['Det_Droguri'];
 $medicatie=$_POST['Medicatie'];
 $istoric=$_POST['Istoric'];

foreach ($_POST as $key => $value) {
	$$key = $value;
}
print_r($_POST);
mysql_query("UPDATE hc
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'
WHERE ID='$id'");
/*
echo "UPDATE hc
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'
WHERE ID='$id'";
//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)
//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')");
*/
?>

Datele au fost salvate!
<br />
<a href='pag1.php'>Inapoi la rapoarte</a>
</body>
</html>