EDIT - Formulář
php
<?php
include 'database.php';
if(isset($_REQUEST['id'])) {
$idRequest = $_REQUEST['id'];
$conn = new mysqli($server, $username, $password, $database);
if($conn->connect_error) {
die('Chyba s připojením na server');
} else {
$sql = "SELECT * FROM web_Novinky WHERE id = '$idRequest'";
$vysledek = $conn->query($sql);
if ($vysledek->num_rows > 0) {
while($query = $vysledek->fetch_assoc()) {
$id = $query['id'];
$author = $query['author'];
$name = $query['novinka'];
$description = $query['popisek'];
$text = $query['notify_Value'];
$footer = $query['footer'];
}
}
}
} else
if(isset($_REQUEST['edit_Sumbit'])) {
$edit_Author = $_REQUEST['edit_Author'];
$edit_Description = $_REQUEST['edit_Description'];
$edit_Footer = $_REQUEST['edit_Footer'];
$edit_Value = $_REQUEST['edit_Value'];
$edit_Name = $_REQUEST['edit_Name'];
//Tu jsem byl uz zoufaly a udelal novy connect
$link = mysqli_connect("localhost", "root", "Heslo", "web");
// Check connection
if($link === false){
die("ERROR:" . mysqli_connect_error());
}
$update = "UPDATE web_Novinky SET author = '$edit_Author' WHERE id='$idRequest'";
if(mysqli_query($link, $update)){
echo $edit_Author;
echo "Novinka byla upravena";
} else {
echo "ERROR: $sql. " . mysqli_error($link);
}
// Close connection
mysqli_close($link);
} else {
die('Nelze ziskat data, zřejmě špatně napsano ID');
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Upravit</title>
</head>
<body>
<form action="edit.php" method="post">
<label>Autor:</label><br>
<input value="<?=$author?>" type="text" name="edit_Author"><br>
<label>Název novinky</label><br>
<input value="<?=$name?>" type="text" name="edit_Name"><br>
<label>Popisek</br>
<input value="<?=$description?>" type="text" name="edit_Description"><br>
<label>Text (Novinka)</label><br>
<textarea name="edit_Value" value="trsdgihshiogohjdg"><?=$text?></textarea><br>
<label>Patička</label><br>
<input value="<?=$footer?>" type="text" name="edit_Footer"><br>
<button name="edit_Sumbit" type="sumbit">Odeslat</button>
</form>
</body>
</html>Neformátovaný
Přidáno: 20.4.2021
Expirace: Neuvedeno
Autor: Maty