Dat zag er zo uit:
Spoiler
<?php
session_start();
if (!isset($_SESSION['logIn']))
{
exit('Je moet ingelogd zijn');
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Blog Toevoegen - Bart`s Blog</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<h2>Blog Toevoegen</h2>
<form method='post' class="form-horizontal" action='BSblog2.php' role="form">
<div class="form-group">
<label class="control-label col-sm-2" for="titel">titel:</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="titel" name="titel" placeholder="Enter titel">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="auteur">auteur:</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="auteur" name="auteur" placeholder="Enter auteur">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="tags">tags:</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="tags" name="tags" placeholder="Enter tags">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="inhoud">inhoud:</label>
<div class="col-sm-10">
<textarea name="inhoud" cols="40" rows="5" id="inhoud"></textarea>
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-10">
<button type="submit" class="btn btn-default" name="addrecords">Blog Toevoegen</button>
</div>
</div>
</form>
</div>
</body>
</html>
</body>
</html>
<?php
if(isset($_POST['addrecords'])) {
$link = mysqli_connect("localhost", "root", "superbart", "blog");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Escape user inputs for security
$titel = mysqli_real_escape_string($link, $_POST['titel']);
$auteur = mysqli_real_escape_string($link, $_POST['auteur']);
$inhoud = mysqli_real_escape_string($link, $_POST['inhoud']);
$tags = mysqli_real_escape_string($link, $_POST['tags']);
// attempt insert query execution
$sql = "INSERT INTO artikel (titel, auteur, inhoud) VALUES ('$titel', '$auteur', '$inhoud')";
$sql2 = "INSERT INTO tags (naam) VALUES ('$tags')";
if(mysqli_query($link, $sql)){
$artikel_id = mysqli_insert_id($link);
echo $titel. " added successfully.".$artikel_id;
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
?><p></p><?php
if(mysqli_query($link, $sql2)){
$tag_id = mysqli_insert_id($link);
echo $tags. " added successfully.".$tag_id;
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// close connection
mysqli_close($link);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset=utf-8>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<div class="btn-group-vertical">
<a class="btn btn-primary" href="BSblog.php" role="button">klik hier om naar het blog te gaan</a>
</div>
</div>Nu wil ik een formulier maken waarin ik informatie dat in de database staat, ook kan wijzigen. In dit geval is het voor een formulier voor het wijzigen van een wachtwoord van je account.
Weet iemand hoe ik dit het beste kan doen?
