/
testConnect2.php
51 lines (44 loc) · 1.33 KB
/
testConnect2.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
<?php
$servername = "";
$username = "";
$password = "";
$dbname = "";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// sql to create table
$sql = "CREATE TABLE IF NOT EXISTS weddingguests (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
accept VARCHAR(30),
partynum SMALLINT,
dietneeds VARCHAR(150),
songreq VARCHAR(150),
reg_date TIMESTAMP
)";
if ($conn->query($sql) === TRUE) {
echo "Table MyGuests created successfully";
} else {
echo "Error creating table: " . $conn->error;
}
$_POST['dietneeds']
foreach ($_POST['dietneeds'] as $dietneeds => $value) {
echo $dietneeds;
}
$insertSQL = "INSERT INTO weddingguests (firstname, lastname, email, accept, partynum, dietneeds, songreq)
VALUES (
GetSQLValueString($_POST['fname'],"text"),
GetSQLValueString($_POST['lname'],"text"),
GetSQLValueString($_POST['email'],"text"),
GetSQLValueString($_POST['accept'],"text"),
GetSQLValueString($_POST['guestnum'],"text"),
$dietneeds,
GetSQLValueString($_POST['songreq'],"text"),
)";
$conn->close();
?>