-
Notifications
You must be signed in to change notification settings - Fork 0
/
addtrain2.php
43 lines (36 loc) · 1.25 KB
/
addtrain2.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
<?php
session_start();
require('firstimport.php');
if(isset($_SESSION['name'])){}
else{
header("location:login1.php");
}
require('firstimport.php');
$tbl_name="train_list";
mysqli_select_db($conn,"$db_name")or die("cannot select DB");
$Number=$_POST['Number'];
$Name=$_POST['Name'];
$Origin=$_POST['Origin'];
$Destination=$_POST['Destination'];
$Arrival=$_POST['Arrival'];
$Departure=$_POST['Departure'];
$Mon=$_POST['Mon'];
$Tue=$_POST['Tue'];
$Wed=$_POST['Wed'];
$Thu=$_POST['Thu'];
$Fri=$_POST['Fri'];
$Sat=$_POST['Sat'];
$Sun=$_POST['Sun'];
$FA=$_POST['1A'];
$SA=$_POST['2A'];
$TA=$_POST['3A'];
$SL=$_POST['SL'];
$General=$_POST['General'];
$Ladies=$_POST['Ladies'];
$Tatkal=$_POST['Tatkal'];
$sql= "INSERT INTO $tbl_name(Number, Name, Origin, Destination, Arrival, Departure, Mon, Tue, Wed, Thu, Fri, Sat, Sun, 1A, 2A, 3A, SL, General, Ladies, Tatkal) VALUES('$Number', '$Name', '$Origin', '$Destination', '$Arrival', '$Departure', '$Mon', '$Tue', '$Wed', '$Thu', '$Fri', '$Sat', '$Sun', '$FA', '$SA', '$TA', '$SL', '$General', '$Ladies', '$Tatkal')";
$result = mysqli_query($conn,$sql) or die("Error: " . mysqli_error($conn));;
$message = "TRAIN HAS BEEN ADDED";
echo "<script type='text/javascript'>alert('$message');</script>";
header("location:addtrain.php");
?>