-
Notifications
You must be signed in to change notification settings - Fork 0
/
process-create-gallery-order.php
29 lines (22 loc) · 1.07 KB
/
process-create-gallery-order.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
<?php
session_start();
// create a connection to the db
$mysqli = require __DIR__ . '/database.php';
// collect the session data from the tickets.php
$_SESSION['user_id'] = $_POST['user_id'];
$_SESSION['user_name'] = $_POST['user_name'];
$_SESSION['gallery_id'] = $_POST['gallery_id'];
$_SESSION['artist_id'] = $_POST['gallery_artist_id'];
$_SESSION['gallery_title'] = $_POST['gallery_title'];
$_SESSION['gallery_fee'] = $_POST['gallery_fee'];
$ticket_total = 1 * $_SESSION['gallery_fee'];
// insert the data into the gallery_orders table
$sql = "INSERT INTO gallery_orders (user_id, user_name, gallery_id, artist_id, gallery_title, gallery_fee, ticket_total) VALUES ('$_SESSION[user_id]', '$_SESSION[user_name]', '$_SESSION[gallery_id]', '$_SESSION[artist_id]', '$_SESSION[gallery_title]', '$_SESSION[gallery_fee]', $ticket_total)";
// execute insert query
if ($mysqli->query($sql) === TRUE) {
// redirect to order.php?id={$_SESSION['user_id']}
header("Location: gallery-orders.php?id=$_SESSION[user_id]");
exit;
} else {
echo "Error: " . $sql . "<br>" . $mysqli->error;
}