Registration & Login:
<?php
session_start();
$_SESSION['UN'] = "";
if(isset($_POST['btnSave']))
{
$UN = $_POST['txtUName'];
$PW = $_POST['txtPass'];
$SQ = $_POST['Secret'];
$AN = $_POST['txtAns'];
$BD = $_POST['BDay'];
$A = mysql_connect("localhost","root","") or die ("error in sql connection");
mysql_select_db("HotelDB",$A) or die ("error in database");
mysql_query("insert into tblUsers values('$UN','$PW','$SQ','$AN','$BD')",$A) or die ("error in insert query");
mysql_close($A);
echo "<meta http-equiv='Refresh'; content='0; URL=Index.php';>";
}
?>
<?php
if(isset($_POST['btnLogin']))
{
$UN = $_POST['txtUName'];
$PW = $_POST['txtPass'];
$A = mysql_connect("localhost","root","") or die ("error in sql connection");
mysql_select_db("HotelDB",$A) or die ("error in database");
$B = mysql_query("Select UserName from tblUsers Where UserName='$UN' and UPassword='$PW'",$A) or die ("Error in Select query");
if(mysql_num_rows($B) > 0 )
{
$_SESSION['UN'] = $UN;
echo "<meta http-equiv='Refresh'; content='0; URL=Hotel.php';>";
}
else
{ echo "<h3 Style=Color:Red>Error: UserName or Password is Wrong!</h3>"; }
mysql_close($A);
}
?>
<html>
<head>
<Title>:: Login Please ... </title>
<link href="calendar/calendar.css" rel="stylesheet" type="text/css" />
<script language="javascript" src="calendar/calendar.js"></script>
</head>
<body>
<h3 align=right Style=Color:Blue>Login Please ...</h3>
<form action="Index.php" METHOD="POST">
<table border=1 cellspacing=5 cellpadding=5 align=Right>
<tr>
<td>UserName</td>
<td><input type=text Name=txtUName placeholder="User Name" required=required></td>
</tr>
<tr>
<td>Password</td>
<td><input type=Password Name=txtPass placeholder="Enter Password" required=required></td>
</tr>
<tr>
<td>.</td>
<td align=right><input type=Submit Name=btnLogin value=Login></td>
</tr>
</table>
</form>
<br><br><br><br><br><br><br><br>
<hr>
<h3 align=right Style=Color:Blue>Signup Please ...</h3>
<form action="Index.php" METHOD="POST">
<table border=1 cellspacing=5 cellpadding=5 align=Right>
<tr>
<td>UserName</td>
<td><input type=text Name=txtUName placeholder="User Name" required=required></td>
</tr>
<tr>
<td>Password</td>
<td><input type=Text Name=txtPass placeholder="Enter Password" required=required></td>
</tr>
<tr>
<td> Secret Question </td>
<td><select name=Secret Style=Width:145;>
<option>Favourite Book</option>
<option>Your Birth Place</option>
<option>First School</option>
<option>First Lover name</option>
</select></td>
</tr>
<tr>
<td>Answer</td>
<td><input type=text Name=txtAns placeholder="Secret Answer" required=required></td>
</tr>
<tr>
<td>Birth Date</td>
<td><?php
require_once('calendar/classes/tc_calendar.php');
$myCalendar = new tc_calendar("BDay", true, false);
$myCalendar->setIcon("calendar/images/iconCalendar.gif");
$myCalendar->setDate(date('d'), date('m'), date('Y'));
$myCalendar->setPath("calendar/");
$myCalendar->setYearInterval(1970, 2015);
//$myCalendar->dateAllow('2008-05-13', '2015-03-01');
$myCalendar->setDateFormat('j F Y');
$myCalendar->setHeight(350);
$myCalendar->autoSubmit(true, "form1");
$myCalendar->setAlignment('left', 'bottom');
$myCalendar->writeScript();
?></td>
</tr>
<tr>
<td>.</td>
<td align=right><input type=Submit Name=btnSave value=Save></td>
</tr>
</table>
</form>
</body>
</html>
Hotel Registration & Searching:
<?php
session_start();
if($_SESSION['UN'] == "")
{ echo "<meta http-equiv='Refresh'; content='0; URL=Index.php';>"; }
else
{
$P = $_SESSION['UN'];
echo "<table border=1 cellspacing=5 cellpadding=5 align=Right>";
echo "<tr>";
echo "<td><img src='Users/$P.jpg' width=50 height=50></td>";
echo "</td> <td>Welcome to $P</td>";
echo "</td> <td><a href='Index.php'>Logout</a></td>";
echo "</tr>";
echo "</table>";
}
?>
<?php
if(isset($_GET['A']))
{
$P = $_GET['A'];
$A = mysql_connect("localhost","root","") or die ("error in sql connection");
mysql_select_db("HotelDB",$A) or die ("error in database");
mysql_query("Update tblHotel Set ACTION='False' Where HID=$P",$A) or die ("error in insert query");
mysql_close($A);
}
?>
<?php
if(isset($_POST['btnSave']))
{
$HN = $_POST['Hotel'];
$PH = $_POST['txtPhone'];
$RN = $_POST['Room'];
$RR = $_POST['txtHRent'];
$BD = $_POST['txtBDate'];
$EM = $_POST['txtEmail'];
$A = mysql_connect("localhost","root","") or die ("error in sql connection");
mysql_select_db("HotelDB",$A) or die ("error in database");
mysql_query("insert into tblHotel values('','$HN','$PH','$RN','$RR','$BD','$EM','True')",$A) or die ("error in insert query");
mysql_close($A);
echo "<meta http-equiv='Refresh'; content='0; URL=Hotel.php';>";
}
?>
<form action="hotel.php" METHOD="POST">
<table border=1 cellspacing=10 cellpadding=1>
<tr>
<td> Hotel Name </td>
<td><select name=Hotel Style=Width:145;>
<option> Sheraton </option>
<option> Marriot </option>
<option> Perl Continental </option>
<option> Haji Khan</option>
<option> Charpai Hotel </option>
</select></td>
</tr>
<tr>
<td> Phone </td>
<td><input type=text Name=txtPhone placeholder="Phone Number" required=required></td>
</tr>
<tr>
<td> Room Number </td>
<td><select name=Room Style=Width:145;>
<option> Business Class </option>
<option> Superem Class</option>
<option> Delux Class </option>
<option> Economy Class</option>
<option> Normal Class </option>
</select></td>
</tr>
<tr>
<td> Room Rent </td>
<td><input type=text Name=txtHRent placeholder="Room Rent" required=required></td>
</tr>
<tr>
<td> Book Date </td>
<td><input type=text Name=txtBDate placeholder="Booking Date" required=required></td>
</tr>
<tr>
<td> Email Adres</td>
<td><input type=text Name=txtEmail placeholder="Email Adres" required=required></td>
</tr>
<tr>
<td>.</td>
<td><input type=Submit Name=btnSave value=Save></td>
</tr>
</table>
</form>
<Form action="hotel.php" Method="POST">
<table border=1 cellspacing=5 cellpadding=5>
<tr>
<td>Search by Name</td>
<td><input type=Text name=txtSearch PlaceHolder="hotel Name" Required=Required></td>
<td><input type="Submit" name=btnSearch value=Search></td>
<td><a href="hotel.php">Show All</a></td>
</tr>
</table>
</Form>
<table border=1 cellspacing=5 cellpadding=5>
<tr bgcolor=aqua> <th>HID</th> <th>HotelName</th> <th>PHONE</th> <th>Room</th> <th>Rent</th> <th>Booking</th> <th>EMAIL</th> <th>DELETE</th> <th>UPDATE</th> </tr>
<?php
$A = mysql_connect("localhost","root","") or die ("error in sql connection");
mysql_select_db("HotelDB",$A) or die ("error in database");
if(isset($_POST['btnSearch']))
{
$SR = $_POST['txtSearch'];
$B = mysql_query("select * from tblHotel where action ='true' and HotelName like '%$SR%'",$A) or die ("error in select query");
}
else
{
$B = mysql_query("select * from tblHotel where action ='true'",$A) or die ("error in select query");
}
$T = mysql_num_rows($B);
for($a=0; $a<$T; $a++)
{
$R = mysql_fetch_array($B);
echo "<tr>";
echo "<td> $R[0] </td>";
echo "<td> $R[1] </td>";
echo "<td> $R[2] </td>";
echo "<td> $R[3] </td>";
echo "<td> $R[4] </td>";
echo "<td> $R[5] </td>";
echo "<td> $R[6] </td>";
echo "<td><a href='hotel.php?A=$R[0]'><img src='abcd.jpg' width=50 height=50 Title='Delete'></a></td>";
echo "<td><a class='various3' href='hotel.php?hd=$R[0]&N=$R[1]&C=$R[2]&D=$R[3]'&E=$R[4]&F=$R[5]'&H=$R[6]'>Update</a></td>";
echo "</tr>";
}
mysql_close($A);
?>
</body>
</html>
Updation of Hotel Registration:
<?php
if(isset($_POST['btnUpdate']))
{
$N = $_POST['txtHName'];
$C = $_POST['txtPhone'];
$D = $_POST['txtRNumber'];
$E = $_POST['txtHRent'];
$F = $_POST['txtBDate'];
$H = $_POST['txtEmail'];
$A = mysql_connect("LocalHost","root","") or die ("Error in MySQL Connection");
mysql_select_db("hotel",$A) or die("Error in DataBase");
mysql_query("Update Farm set HName='$N',Phone='$C',RNumber='$D',HRent='$E',BDate='$F',Email='$H' Where ID='$HID'",$A) or die ("Error in Update Query");
mysql_close($A);
echo "Data updated";
}
?>
<html>
<body>
<h3 align=center>Update Hotel Information </h3>
<Form action="hotel.php" Method="POST">
<table border=1 Align=center CellSpacing=5 CellPaddgin=5>
<tr>
<td>ID</td>
<td><input Type=Text name=txtID Value="<?php echo $_GET['A']; ?>" readonly></td>
</tr>
<tr>
<td>HName</td>
<td><input Type=Text name=txtHName Value="<?php echo $_GET['N']; ?>"></td>
</tr>
<tr>
<td>Phone</td>
<td><input Type=Text name=txtPhone Value="<?php echo $_GET['C']; ?>" ></td>
</tr>
<tr>
<td>RNumber</td>
<td><input Type=Text name=txtRNumber Value="<?php echo $_GET['D']; ?>" ></td>
</tr>
<tr>
<td>HRent</td>
<td><input Type=Text name=txtHRent Value="<?php echo $_GET['E']; ?>" ></td>
</tr>
<tr>
<td>BDate</td>
<td><input Type=Text name=txtBDate Value="<?php echo $_GET['F']; ?>" ></td>
</tr>
<tr>
<td>Email</td>
<td><input Type=Text name=txtEmail Value="<?php echo $_GET['H']; ?>" ></td>
</tr>
<tr>
<td><a href="hotel.php">Back</a></td>
<td><input Type=Submit name=btnUpdate Value=Update></td>
</tr>
</table>
</Form>
</body>
</html>
No comments:
Post a Comment