-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathquery_trip_oneway.php
111 lines (98 loc) · 3.47 KB
/
query_trip_oneway.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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
<?php
/**
* Created by PhpStorm.
* User: ramu
* Date: 31/12/14
* Time: 11:42 PM
*/
error_reporting(E_ALL);
require('oneway.php');
$start=$_POST['startpoint'];
$end=$_POST['endpoint'];
$date=$_POST['date_travel'];
$time=$_POST['dep_time'];
$checkbox=$_POST['return'];
$host="localhost";
$uname="root";//uname => username
$pwd="";//pwd => password
$dbname="trip_planner";//dbname => database name
$connection = mysqli_connect($host,$uname,$pwd,$dbname);
//check for errors during connection
if(mysqli_connect_error($connection)) {
echo "Failed to establish connection with database. Please try again or contact administrator.";
exit();
}
else{
//proceed to display options
}
?>
<!DOCTYPE HTML>
<html>
<head>
<title>Trip Planner</title>
<!-- Bootstrap CSS -->
<link href = "bootstrap/css/bootstrap.min.css" rel="stylesheet"/>
</head>
<body>
<!-- Navigation bar -->
<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed pull-left" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand " href=".">Trip Planner </a>
</div>
<div id="navbar" class="navbar-collapse collapse" aria-hidden="true">
<ul class="nav navbar-nav">
<li ><a href=".">Home</a></li>
<li><a href="" data-toggle="modal" data-target="#about">About Developer</a></li>
</ul>
</div><!--/.nav-collapse -->
</div>
</nav>
<!-- Navigation bar ends-->
<!--Main Content -->
<div class="container">
<div class="row">
<div class="col-md-10 col-md-offset-1">
<br/><br/><br/><br/><br/>
<?php
getonewaydata($connection,$start,$end);
if($checkbox == 1)
{
echo '<div><hr/><h3> Return Journey Trains</h3>';
getonewaydata($connection,$end,$start);
echo '</div>';
}
?>
<a href="index.php" class="btn btn-lg btn-primary"><span class="glyphicon glyphicon-arrow-left"></span> Go Back </a>
</div>
</div>
</div>
<!-- Modal Window for info about me -->
<div class="modal fade" aria-hidden="true" id="about" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button class="close" aria-hidden="true" data-dismiss="modal"><span class="glyphicon glyphicon-remove"></span> </button>
<h3 class="modal-title">About the developer</h3>
</div>
<div class="modal-body">
<div class="well"><h4 class="h4">Ram Kumar K R</h4> Information Science Branch, <br/> R V College of Engineering</div>
</div>
<div class="modal-footer">
<a role="button" href="mailto:[email protected]" class="btn btn-lg btn-info"><span class="glyphicon glyphicon-envelope"></span> Send a message</a>
</div>
</div>
</div>
</div>
<!-- Modal Window for info about me ends-->
<!--jQuery-->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<!-- Bootstrap Javascript files-->
<script src="bootstrap/js/bootstrap.min.js"></script>
</body>
</html>