I think I screwed up big time somewhere, have no idea where. I need to get (firstname, lastname, adress, postnummer, stad) to show, I can add and delete it from my database, but I can´t see the text of it.
<?php
//deletebutton works, adds works.
$db = new PDO("sqlite:register.sqlite");
if(isset($_POST['firstname']) && isset($_POST['lastname']) && isset($_POST['adress']) && isset($_POST['postnummer']) && isset($_POST['stad'])){ //addButton
$firstnamePost = htmlspecialchars($_POST['firstname']);
$lastnamePost = htmlspecialchars($_POST['lastname']);
$adressPost = htmlspecialchars($_POST['adress']);
$postnummerPost = htmlspecialchars($_POST['postnummer']);
$stadPost = htmlspecialchars($_POST['stad']);
$stmt = $db->prepare("INSERT INTO register(firstname, lastname, adress, postnummer, stad) VALUES('{$firstnamePost}', '{$lastnamePost}','{$adressPost}','{$postnummerPost}','{$stadPost}')");
$stmt->execute();
}
if(isset($_GET["id"])){
$idGet = htmlspecialchars($_GET["id"]);
}
else{
$idGet = null;
}
// get and handle GET parameter.
if(isset($_POST["delete"])){
$deletePost = htmlspecialchars($_POST["delete"]);
}
else{
$deletePost = null;
}
if($deletePost){
$stmt = $db->prepare("DELETE FROM register WHERE id ='{$deletePost}'");
$stmt->execute(); // här kör vi frågan som vi förberett
}
?>
<doctype html>
<html lang="sv">
<head>
<meta charset="utf-8">
<title> Adressregister</title>
<link rel= "stylesheet" href="register.css">
</head>
<body>
<form action="register.php" method="post">
<p><label>Förnamn</label></p><input type="text" name="firstname" placeholder="firstname"></p>
<p><label>Efternamn</label></p><input type="text" name="lastname" placeholder="lastname"></p>
<p><label>Adress</label></p><input type="text" name="adress" placeholder="adress"></p>
<p><label>Postnummer</label></p><input type="text" name="postnummer" placeholder="zipcode"></p>
<p><label>Ort</label></p><input type="text" name="stad" placeholder="city"></p>
<p><input type="submit" value="skicka"></p>
</form>
</body>
<?php
if(!$idGet){ // if we do not get a value
$stmt = $db->prepare("SELECT id, firstname, lastname, adress, postnummer, stad FROM register");
$stmt->execute();
while($register = $stmt->fetch())
{
echo<<<RegisterDelete
<h2>
<form action='register.php' method='post'>
<input type='hidden' name='delete' value='{$register['id']}'>
<input type='submit' value='radera'>
</form>
</h2>
RegisterDelete;
}
}
else{
$stmt = $db->prepare("SELECT * FROM news WHERE id = '{$idGet}'");
$stmt->execute(); // här kör vi frågan som vi förberett
$news = $stmt->fetch();
echo<<<register
<h2>{$register['id']}</h2>
<h2>{$register['firstname']}</h2>
<h2>{$register['lastname']}</h2>
<h2>{$register['adress']}</h2>
<h2>{$register['postnummer']}</h2>
<h2>{$register['stad']}</h2>
register;
}
?>
</html>
Aucun commentaire:
Enregistrer un commentaire