/
sendform.php
75 lines (58 loc) · 1.94 KB
/
sendform.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
63
64
65
66
67
68
69
70
71
72
73
74
75
<?php
// Connect to server and select databse.
require_once("configform.php");
ini_set('display_errors', '1');
$mysqli = new mysqli($db_host, $db_username, $db_password, $db_name);
if($mysqli->connect_error) {
die('Error : ('. $mysqli->connect_errno .') '. $mysqli->connect_error);
}
echo 'DB connect success<br>';
$username= $_POST["username"];
$id1= $_POST["ide"];
$phone= $_POST["phone"];
$email= $_POST["email"];
$donateInfo_City= $_POST["donateInfo_City"];
$donateInfo_Division= $_POST["donateInfo_Division"];
$donateInfo_RecAddress= $_POST["donateInfo_RecAddress"];
$where1= $_POST["where1"];
echo '<pre>',print_r($_POST),'</pre>';
// Insert form to table
if (!empty($username) && !empty($id1) && !empty($phone) && !empty($email) &&
!empty($donateInfo_City) && !empty($donateInfo_Division) && !empty($donateInfo_RecAddress) && !empty($where1)) {
$query = "INSERT INTO formdask (username, id1, phone, donateInfo_City, donateInfo_Division, donateInfo_RecAddress, where1,email)
VALUES('$username','$id1','$phone','$donateInfo_City','$donateInfo_Division',
'$donateInfo_RecAddress','$where1','$email')";
echo "$query<br>";
}
else{
echo 'you need check form again';
}
$result = $mysqli->query($query);
if ($result) {
echo 'Thank you' . ' ' . $username .'<br>';
} else {
echo("Input data is fail<br> check it again");
}
echo "You original db construct<br>";
$table_construct = $mysqli->query("SHOW CREATE TABLE formdask");
$crlf = (IS_WIN ? "\r\n" : "\n");
$create = $table_construct->fetch_array(MYSQLI_NUM);
$tabledump = $create[1];
echo "$tabledump<br>";
// send mail to user
$query = "SELECT * FROM formdask WHERE email = $email";
$result = $mysqli->query($query);
echo "$result";
if($result){
$msg = "this is a test.\n";
$TO = $_POST["email"];
$Form = 'u5431269@gmail.com';
mail( $TO, $msg, 'From:' . $Form);
echo 'Send to: ' . $TO . '<br>';
}
else{
echo "there is something wrong";
}
$mysqli->close();
?>
// Connect to server and select databse.