<?php
$id=$_GET['id'];
#zęby
$rightuppereight=$_GET['18'];
$rightupperseven=$_GET['17'];
$rightuppersix=$_GET['16'];
$rightupperfive=$_GET['15'];
$rightupperfour=$_GET['14'];
$rightupperthree=$_GET['13'];
$rightuppertwo=$_GET['12'];
$rightupperone=$_GET['11'];
$leftupperone=$_GET['21'];
$leftuppertwo=$_GET['22'];
$leftupperthree=$_GET['23'];
$leftupperfour=$_GET['24'];
$leftupperfive=$_GET['25'];
$leftuppersix=$_GET['26'];
$leftupperseven=$_GET['27'];
$leftuppereight=$_GET['28'];
$rightlowereight=$_GET['48'];
$rightlowerseven=$_GET['47'];
$rightlowersix=$_GET['46'];
$rightlowerfive=$_GET['45'];
$rightlowerfour=$_GET['44'];
$rightlowerthree=$_GET['43'];
$rightlowertwo=$_GET['42'];
$rightlowerone=$_GET['41'];
$leftlowerone=$_GET['31'];
$leftlowertwo=$_GET['32'];
$leftlowerthree=$_GET['33'];
$leftlowerfour=$_GET['34'];
$leftlowerfive=$_GET['35'];
$leftlowersix=$_GET['36'];
$leftlowerseven=$_GET['37'];
$leftlowereight=$_GET['38'];
#stany
$rightuppereights=$_GET['18s'];
$rightuppersevens=$_GET['17s'];
$rightuppersixs=$_GET['16s'];
$rightupperfives=$_GET['15s'];
$rightupperfours=$_GET['14s'];
$rightupperthrees=$_GET['13s'];
$rightuppertwos=$_GET['12s'];
$rightupperones=$_GET['11s'];
$leftupperones=$_GET['21s'];
$leftuppertwos=$_GET['22s'];
$leftupperthrees=$_GET['23s'];
$leftupperfours=$_GET['24s'];
$leftupperfives=$_GET['25s'];
$leftuppersixs=$_GET['26s'];
$leftuppersevens=$_GET['27s'];
$leftuppereights=$_GET['28s'];
$rightlowereights=$_GET['48s'];
$rightlowersevens=$_GET['47s'];
$rightlowersixs=$_GET['46s'];
$rightlowerfives=$_GET['45s'];
$rightlowerfours=$_GET['44s'];
$rightlowerthrees=$_GET['43s'];
$rightlowertwos=$_GET['42s'];
$rightlowerones=$_GET['41s'];
$leftlowerones=$_GET['31s'];
$leftlowertwos=$_GET['32s'];
$leftlowerthrees=$_GET['33s'];
$leftlowerfours=$_GET['34s'];
$leftlowerfives=$_GET['35s'];
$leftlowersixs=$_GET['36s'];
$leftlowersevens=$_GET['37s'];
$leftlowereights=$_GET['38s'];
if ( ! $id) {
die('brakuje id pacjenta'); }
?>
<?php
function connect()
{
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "gabinet";
// Create connection
$conn = new mysqli
($dbhost, $dbuser, $dbpass, $dbname) or
die($conn->connect_error);
return $conn;
}
$conn = connect();
$query = "SELECT * FROM diagram WHERE pacjent = $id";
$polacz = $conn->query($query);
$row = $polacz->fetch_array();
#18
if ($polacz and $row['pacjent'] == $id) {
if ($row['zab'] == '18') {
$update18 = "UPDATE diagram SET stan ='$rightuppereight', info = '$rightuppereights' WHERE zab='18'";
$q = $conn->query($update18);
}
else {
}
#17
if ($row['zab'] == '17') {
$update17 = "UPDATE diagram SET stan ='$rightupperseven', info = '$rightuppersevens' WHERE zab='17'";
$q = $conn->query($update17);
}
else {
}
$update16 = "UPDATE diagram SET stan ='$rightuppersix', info = '$rightuppersixs' WHERE zab='16'";
$q = $conn->query($update16);
echo "diagram zmieniony";
}
else {
$sqlsave18 = "INSERT INTO diagram VALUES ('', '$id', '18', '$rightuppereight', '$rightuppereights')";
$sqlsave17 = "INSERT INTO diagram VALUES ('', '$id', '17', '$rightupperseven', '$rightuppersevens')";
$q = $conn->query($sqlsave18);
$q = $conn->query($sqlsave17);
}
$polacz->close();
?>