<?php
$servername = "localhost";
$username = "root";
$password = "";
$unam;
$umail;
$conn = new mysqli($servername, $username, $password);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "use project";
if ($conn->query($sql) === TRUE) {} else {
echo "Error creating database: " . $conn->error;
}
$sql = "SELECT uname,email FROM login";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$uname=$row["uname"];
$umail=$row["email"];
}
} else {
echo "0 results";
}
if($uname==="NULL")
{
header('location: check.php');
}
$conn->close();
?>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$a;
$b;
$c;
$d;
$e;
$conn = new mysqli($servername, $username, $password);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "use project";
if ($conn->query($sql) === TRUE) {} else {
echo "Error creating database: " . $conn->error;
}
$sq= "SELECT Cid ,vanue,Ctime, Cdate, price FROM concerts where band_name='KAPIL' ";
$result = $conn->query($sq);
if ($result->num_rows> 0) {
while($row = $result->fetch_assoc()) {
$a=$row["Cid"];
$b=$row["vanue"];
$c=$row["Ctime"];
$d=$row["Cdate"];
$e=$row["price"];
}
} else {
echo "0 results";
}
if($uname==="NULL")
{
header('location: check.php');
}
$conn->close();
?>
<html >
<head>
<title>Kapil</title>
<link rel="stylesheet" href="css/style.css" type="text/css" media="all" />
</head>
<body><div id="header">
<h3 id="hello"> Hello <?php echo "$uname"; ?> ! </h3>
<div class="shell">
<div id="navigation">
<ul>
<li><a href="index1.php" class="active">HOME</a></li>
<li><a href="aboutus.php">ABOUT US</a></li>
<li><a href="movie.php">MOVIES</a></li>
<li><a href="concert.php">CONCERTS</a></li>
<li><a href="theatre.php">THEATRES</a></li>
<li><a href="fest.php">FESTS</a></li>
<li><a href="profile.php"> PROFILE</a></li>
<li><a href="up.php">SIGN UP</a></li>
<li> <a href="in.php">SIGN IN</a></li>
<li> <a href="out.php">SIGN OUT</a></li>
</ul>
</div>
<div class="cl"> </div>
</div>
</div>
<div id="marq">
<marquee behavior="scroll" scrollamount="10" hspace="10px"><a href="kapil.php"><img src="k.jpg"></a><a href="tamasha.php"><img src="tamasha.jpg"></a><a href="skrillex.php"><img src="Skrillex.jpg"></a><a href="bro.php"><img src="b1.jpg"></a><a href="drishyam.php"><img src="dd.jpg"></a><a href="pkp2.php"><img src="8.jpg"></a><a href="talvar.php"><img src="tl.jpg"></a><a href="kapil.php>"<img src="k.jpg"></a></marquee>
</div>
<div id="main">
<div class="bg-top">
<div class="shell">
<h1> KAPIL SHARMA</h1><br><br>
<div id="brm">
<IMG SRC="k.JPG" align="right">
</div>
<p>
Kapil Sharma is an Indian stand-up comedian, actor, TV host, producer and singer. He had made his place in the Forbes India Celebrity list for the first time in 2013 being ranked 93rd on the list and has moved up to 33rd in 2014. He has also been awarded the CNN-IBN Indian of the Year 2013, in the Entertainment category. He is ranked at no.3 in the Most Admired Indian Personality List by The Economic Times in 2015. Currently he is hosting Indian comedy show Comedy Nights with Kapil.Sharma has been nominated for Swachh Bharat Abhiyan by PM Narendra Modi which he has accepted. A year after in September 2015 he was invited at the Rashtrapati Bhavan by the President Pranab Mukherjee to acknowledge his contribution towards Swachh Bharat Abhiyan.He made his Bollywood debut with Abbas Mustan's romantic-comedy Kis Kisko Pyaar Karoon, which released on 25 Sept 2015.
<h3>event_id: <?php echo "$a"; ?><br> vanue: <?php echo "$b"; ?><br> time: <?php echo "$c"; ?><br> date:<?php echo "$d"; ?><br> cost:<?php echo "$e"; ?></h3>
</p>
<ul type="none">
<li><b><a href="book.php" class="button">BOOK</a></b></li>
</ul>
<br><br>
</div>
</div>
</div>
<div id="footer">
<div class="shell">
<div class="top">
<div id="twitter">
<h2>COMING SOON</h2>
<div class="cl"> </div>
<div class="twitter-posts">
<ul>
<li>
<p><a href="bjr.php">BAJIRAO MASTANI</a> Bajirao Mastani is an Indian historical romance film produced and directed by Sanjay Leela Bhansali</p>
</li>
<li>
<p><a href="airlft.php">AIRLIFT</a> Airlift is an upcoming Indian film directed by Raja Krishna Menon, and starring Akshay Kumar and Nimrat Kaur in lead roles, and is scheduled for release on 22 January 2016.</p>
</li>
<li>
<p><a href="badi.php">World Superseries Finals 2015</a>The 2015 BWF Season is the overall badminton circuit organized by the Badminton World Federation (BWF) for the 2015 badminton season to publish and promote the sport.</p>
</li>
<li>
<p><a href="skrillex.php">Skrillex</a> Sonny John Moore,known professionally as Skrillex, is an American electronic music producer, DJ, singer and songwriter.</a></p>
</li>
</ul>
</div>
</div>
<div id="flickr">
<div class="cl"> </div>
<div class="flickr-pics">
<ul>
<li> <a href="ashwin.php"><img src="ashwin.jpg" alt="Ashwin shines as India clinch series with third Test win" ></a> </li>
<li> <a href="sun.php"><img src="sun.jpg" alt="Sunburn Festival 2015" ></a> </li>
<li class="last"> <a href="rd.php"><img src="rd.jpg" alt="Deepika Padukone, Ranbir Kapoor starrer ‘Tamasha’ earns Rs. 24.04 cr in two days" ></a> </li>
<li> <a href="starc.php"><img src="starc.jpg" alt="Injured Starc unsure when he'll bowl again for Australia" ></a> </li>
<li> <a href="rs.php"><img src="rs.jpg" alt="Why Is Ranveer Singh Not Worried About ‘Dilwale-Bajirao Mastani’ Clash?" ></a> </li>
<li class="last"> <a href="tamasha.php"><img src="tamasha.jpg" alt="Deepika Padukone And Ranbir Kapoor Create More Tamasha At College Festival!" ></a> </li>
<li> <a href="sa.php"><img src="sa.jpg" alt="Awesome threesome have made SA batsmen look club class" ></a> </li>
<li> <a href="narine.php"><img src="narine.jpg" alt="Sunil Narine suspended from international cricket for illegal bowling action" ></a> </li>
<li class="last"> <a href="ns.php"><img src="ns.jpg" alt="Naseeruddin Shah To Be Honoured At Dubai International Film Festival" ></a> </li>
</ul>
</div>
</div>
<div class="cl"> </div>
</div>
</div>
</div>
</body>
</html>