gegevens in databse doen met INSERT
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<?php
ini_set('display_errors', 1); // 0 = uit, 1 = aan
error_reporting(E_ALL);
if (isset($_POST['submit'])) {
$link=mysqli_connect("*","*","*","*");
$ilayout = mysqli_real_escape_string($link, $_POST['inputlayout']);
$iimg = mysqli_real_escape_string($link, $_POST['inputimg']);
$ivideo = mysqli_real_escape_string($link, $_POST['inputvideo']);
// attempt insert query execution
$sql = "INSERT INTO bases (layout, img, video, votes) VALUES ('$ilayout', '$iimg', '$ivideo', 0)";
if(mysqli_query($link, $sql)){
echo "Base for layout $ilayout was added to the database";
} else{
echo "ERROR: Could not execute $sql. " . mysqli_error($link);
}
}
?>
<!DOCTYPE html>
<html>
<head>
</head>
<body>
<center>
<form name="add" method="post" action="" >
<input type="text" name="inputlayout" placeholder="Layout"><br/>
<input type="text" name="inputimg" placeholder="Image location"><br/>
<input type="text" name="inputvideo" placeholder="Unique youtube code"><br/>
<input type="submit">
</form>
</center>
</body>
</html>
ini_set('display_errors', 1); // 0 = uit, 1 = aan
error_reporting(E_ALL);
if (isset($_POST['submit'])) {
$link=mysqli_connect("*","*","*","*");
$ilayout = mysqli_real_escape_string($link, $_POST['inputlayout']);
$iimg = mysqli_real_escape_string($link, $_POST['inputimg']);
$ivideo = mysqli_real_escape_string($link, $_POST['inputvideo']);
// attempt insert query execution
$sql = "INSERT INTO bases (layout, img, video, votes) VALUES ('$ilayout', '$iimg', '$ivideo', 0)";
if(mysqli_query($link, $sql)){
echo "Base for layout $ilayout was added to the database";
} else{
echo "ERROR: Could not execute $sql. " . mysqli_error($link);
}
}
?>
<!DOCTYPE html>
<html>
<head>
</head>
<body>
<center>
<form name="add" method="post" action="" >
<input type="text" name="inputlayout" placeholder="Layout"><br/>
<input type="text" name="inputimg" placeholder="Image location"><br/>
<input type="text" name="inputvideo" placeholder="Unique youtube code"><br/>
<input type="submit">
</form>
</center>
</body>
</html>
Een betere controle is: