uMA12igU

1$conn = mysqli_connect("localhost", "root", "", "bus");
2
3if($conn === false){
4
5 die("ERROR: Could not connect. " . mysqli_connect_error());
6
7}
8
9$full_name = mysqli_real_escape_string($conn, $_REQUEST['full_name']);
10$email = mysqli_real_escape_string($conn, $_REQUEST['email']); 
11$m_no = mysqli_real_escape_string($conn, $_REQUEST['m_no']);
12$source = mysqli_real_escape_string($conn, $_REQUEST['source']);
13$destination = mysqli_real_escape_string($conn, $_REQUEST['destination']);
14$age = mysqli_real_escape_string($conn, $_REQUEST['age']);
15$gender = mysqli_real_escape_string($conn, $_REQUEST['gender']);
16$c_no = mysqli_real_escape_string($conn, $_REQUEST['c_no']);
17$c_cvc = mysqli_real_escape_string($conn, $_REQUEST['c_cvc']);
18$end_date_month = mysqli_real_escape_string($conn, $_REQUEST['end_date_month']);
19$end_date_year = mysqli_real_escape_string($conn, $_REQUEST['end_date_year']);
20$cost = mysqli_real_escape_string($conn, $_REQUEST['cost']);
21
22
23
24
25$sql = ("INSERT INTO customer (full_name, email, m_no, source, destination, age, gender, c_no, c_cvc, end_date_month, end_date_year, cost) VALUES ('$full_name', '$email', '$m_no', '$source', '$destination', '$age', '$gender', '$c_no', '$c_cvc', '$end_date_month', '$end_date_year', '$cost')");
26
27if(mysqli_query($conn,$sql)){
28
29    echo "Records added successfully.";
30
31} else{
32
33    echo "ERROR: Could not able destination execute $sql. " .    mysqli_error($conn);
34
35}
36
37
38
39
40
41mysqli_close($conn);
42
43?>
44	
45// Check connection
46if (mysqli_connect_errno()) {
47  echo "Failed to connect to MySQL: " . mysqli_connect_error();
48}
49?>
50	
51USE bus;
52
53 CREATE TABLE IF NOT EXISTS `customer` (
54 `full_name` varchar(50) NOT NULL,
55 `email` varchar(50) NOT NULL,
56  `m_no`int(11) NOT NULL AUTO_INCREMENT,
57   `source` varchar(50) NOT NULL,
58 `destination` varchar(50) NOT NULL,
59
60
61 `Age` int(5) NOT NULL,
62 `gender` varchar(50) NOT NULL,
63   `c_no`int(10) NOT NULL,
64  `c_cvc`int(10) NOT NULL,
65 `end_date_month` int(10) NOT NULL,
66 `end_date_year`int(10) NOT NULL,
67 `cost`int(10) NOT NULL,
68PRIMARY KEY (`m_no`)
69 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ;
70
71
72 INSERT INTO customer (`full_name`, `email`, `m_no`, `source`,                 `destination`, `age`, `gender`, `c_no`, `c_cvc`,`end_date_month`, `end_date_year`, `cost`) VALUES
73 (1, 'manohar patil', 4467895321, 'panvel', 'kharghar', 22,'male',   334422332233, 323, 12, 2022, 10);