-
Notifications
You must be signed in to change notification settings - Fork 0
/
edit-camper.php
62 lines (45 loc) · 1.65 KB
/
edit-camper.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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
<?php ob_start();
//store the form inputs in variables
$name = $_POST['name'];
$alchol_content = $_POST['alchol_content'];
$domestic = $_POST['domestic'];
$light = $_POST['light'];
$price = $_POST['price'];
$beer_id = $_POST['beer_id'];
//Display the name
echo $name . '<br/>';
echo $alchol_content . '<br/>';
echo $domestic . '<br/>';
echo $light . '<br/>';
echo $price . '<br/>';
//connect to the db
$conn = new PDO('mysql:host=sql.computerstudi.es;dbname=gc200322556','gc200322556', '-eDuY9YB');
//setup the SQL command to save the data
if (empty($beer_id)){
$sql = "INSERT INTO beers (name, alchol_content, domestic, light, price)
VALUES (:name, :alchol_content, :domestic, :light, :price)";
}
else {
$sql = "UPDATE beers SET name = :name, alchol_content = :alchol_content, domestic = :domestic, light = :light, price = :price WHERE beer_id = :beer_id";
}
//create command object
$cmd = $conn->prepare($sql);
//put each input value into the proper field
$cmd -> bindParam(':name', $name, PDO::PARAM_STR);
$cmd -> bindParam(':alchol_content', $alchol_content, PDO::PARAM_INT);
$cmd -> bindParam(':domestic', $domestic, PDO::PARAM_BOOL);
$cmd -> bindParam(':light', $light, PDO::PARAM_BOOL);
$cmd -> bindParam(':price', $price, PDO::PARAM_INT);
// add the beer id if we have one for an update
if (!empty ($beer_id)){
$cmd -> bindParam(':beer_id', $beer_id, PDO::PARAM_INT);
}
//execute the save
$cmd -> execute();
//disconnect
$conn = null;
//echo 'beer saved';
//redirect back to the updated page
header('location:beers-table.php');
ob_flush();
?>