Kod - ładowanie danych:
<?php
echo '
<html>
<head>
<title>Modyfikacja danych Pacjenta</title>
<meta charset="utf-8"></meta>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="style2.css" />
</head>
<body>
<div class="ddpacjent"><br />';
//<!-- SELECT SELECT SELECT !!!!!!!!!!!!!!!!!!!!!!!!! -->
session_start();
require_once "cfgdb.php";
$mysqli = new mysqli($dbhost, $dbuser, $dbpass, $dbpass);
$mysqli -> query ('SET NAMES utf8');
$mysqli -> query ('SET CHARACTER_SET utf8_unicode_ci');
$query = "select id, name, secname, surname, birthday, pesel from pacjent WHERE id=1";
if ($result = $mysqli->query($query)) {
while ($row = $result->fetch_assoc()) {
$fldid = $row['id'];
$fldname = $row["name"];
$fldsecname = $row["secname"];
$fldsurname = $row["surname"];
$fldbirthday = $row["birthday"];
$fldpesel = $row["pesel"];
}
$result->free();
}
if($fldsecname == "/") {
$fldsecname = "";
}
if(empty($fldsecname)) {
$fldsecname = "   ";
}
echo '
<div class="form"><div align="center" class="title">Modyfikacja danych Pacjenta</div><br />
<table width="95%" align="center">
<form class="login-form" action="savemod_pacjent.php" method="post">
<tr><td>Id Pacjenta:</td><td><input required type="text" size="4" maxlength="4" name="id" readonly="readonly" value='.$fldid.' /></td></tr>
<tr><td>Imię Pacjenta:</td><td><input required type="text" size="15" maxlength="20" name="name" value='.$fldname.' /></td></tr>
<tr><td>Drugie imię:</td><td><input type="text" size="25" maxlength="35" name="secname" value='.$fldsecname.' /></td></tr>
<tr><td>Nazwisko:</td><td><input required type="text" size="35" maxlength="35" name="surname" value='.$fldsurname.' /></td></tr>
<tr><td>Dzień urodzenia</td><td><input required type="text" size="10" maxlength="10" name="birthday" value='.$fldbirthday.' /></td></tr>
<tr><td>PESEL:</td><td><input required type="text" size="12" maxlength="12" name="pesel" value='.$fldpesel.' /></td></tr>
<tr><td colspan="2" align="center"><input class="button" type="submit" value="Zmodyfikuj Pacjenta" />
</table>
<br /><br /><br /><br /><br />
</form><br /><br /><br /><br /></div>';
echo '
<br /><br /><br /><br /><br /><br /><br /><br /><br />
<align=right>
<font type="Arial" size="2px"><i>
Wszelkie prawa niezastrzezone ® 2020
</i></font>
</align>
</div>
</body>
</html>
';
?>
Zapisywanie danych:
<?php
echo '
<html>
<head>
<title>Zapisz zmodyfikowanych danych Pacjenta</title>
<meta charset="utf-8"></meta>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
';
session_start();
require_once "cfgdb.php";
try {
$db = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
} catch (PDOException $e) {
echo "Connection failed : ". $e->getMessage();
}
$id = trim($_POST['id']);
$name = trim($_POST['name']);
$secname = trim($_POST['secname']);
$surname = trim($_POST['surname']);
$birthday = trim($_POST['birthday']);
$pesel = trim($_POST['pesel']);
$_SESSION['sess_user_id'] = $id;
$_SESSION['sess_user_name'] = $name;
$_SESSION['sess_name'] = $pesel;
$msg = "";
if($name == "" OR $surname == "" OR $birthday == "" OR $pesel == ""){
echo "Proszę o wpisanie wszystkich danych - <a href='modify_pacjent.html'>Powrót do strony modyfikowania danych Pacjenta</a>.";
header("refresh:5;url=modify_pacjent.html");
die();
}
try {
$query = "update pacjent set id=?,name=?,secname=?,surname=?,birthday=?,pesel=? WHERE id=$id";
$stmt = $db->prepare($query);
$stmt->bindParam(1, $id, PDO::PARAM_STR);
$stmt->bindParam(2, $name, PDO::PARAM_STR);
$stmt->bindParam(3, $secname, PDO::PARAM_STR);
$stmt->bindParam(4, $surname, PDO::PARAM_STR);
$stmt->bindParam(5, $birthday, PDO::PARAM_STR);
$stmt->bindParam(6, $pesel, PDO::PARAM_STR);
$stmt->execute([$id, $name, $secname, $surname, $birthday, $pesel]);
$color = "<div align='center' style='background-color:green;color:white;padding:1%;'><font size=4px><b>";
$msg = "Dane Pacjenta zostały zmodyfikowane";
$endcolor = "</b></font></div><br />";
echo $color,$msg,$endcolor;
header ("refresh:6, url=lpacjents.php");
} catch (PDOException $e) {
echo "Error :".$e->getMessage();
}
echo '
</body>
</html>
';
?>
Poprawiony post, :)
P.S. A może nie bawić się w takie ładowanie danych tylko skorzystać od razu z jakiegoś AJAXa? Praca z ajaksem czystym relaksem? ;)