PHP Projects – Page 7 – Projects Inventory

Construction Company Management System Code download

Code of Construction Company Management System. service.php

<!DOCTYPE html>
<html lang="en">
<head>
    <title>Construction Company Management System</title>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.5.3/dist/css/bootstrap.min.css" integrity="sha384-TX8t27EcRE3e/ihU7zmQxVncDAy5uIKz4rEkgIXeMed4M0jlfIDPvg6uqKI2xXr2" crossorigin="anonymous">
    <link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Raleway">
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
    <link rel="stylesheet" type="text/css" href="bootstrap.min.css">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Raleway">
    <link rel="stylesheet" href="css/custom.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
    <link rel="stylesheet" type="text/css" href="css/servicestyle.css">
    <style>
    </style>
</head>
<body>

<!-- Header start -->
<?php
  // Navigation
  require_once("includes/navbar.php");

  // Hero Seciton
  require_once("includes/hero.php");
?>
<div class="w3-container" style="padding-top:40px; padding-bottom: 40px;" >
    <h3 class="w3-center">SERVICES</h3>
  </div>
<!--Service Part start-->
<div class="service_area add_padding">
    <div class="container">
        <div class="row">
            <?php 
                require_once("includes/connection.php");
                $select_service = "SELECT * FROM `services`";
                $run = mysqli_query($con, $select_service);

                if (mysqli_num_rows($run)>0) {
                    while ($data = mysqli_fetch_array($run)) {
                        $s_name = $data['s_name'];
                        $s_image = $data['s_image'];
            ?>
            <div class="col-md-6 col-lg-4 mb-3">
                <div class="single_service">
                    <div class="thumb">
                        <img src="images/service/<?php echo $s_image?>" alt="">
                    </div>
                    <div class="service_info">
                        <a href="#"><h3><?php echo $s_name?></h3></a>
                    </div>
                </div>
            </div>
            <?php }} ?>
        </div>
    </div>
</div>
<!--service part end-->
<?php require_once("includes/footer.php"); ?>

<!DOCTYPE html>

<head>

<title>Construction Company Management System</title>

<style>

</style>

</head>

<body>

<?php

// Navigation

require_once("includes/navbar.php");

// Hero Seciton

require_once("includes/hero.php");

<h3 class="w3-center">SERVICES</h3>

</div>

<?php

require_once("includes/connection.php");

$select_service = "SELECT * FROM `services`";

$run = mysqli_query($con, $select_service);

if (mysqli_num_rows($run)>0) {

while ($data = mysqli_fetch_array($run)) {

$s_name = $data['s_name'];

$s_image = $data['s_image'];

</div>

</div>

<?php }} ?>

</div>

<?php require_once("includes/footer.php"); ?>

project_details.php

<html>
<head>
  <title style="color: GREEN;">GCC/5-Marla Exective Details</title>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.5.3/dist/css/bootstrap.min.css" integrity="sha384-TX8t27EcRE3e/ihU7zmQxVncDAy5uIKz4rEkgIXeMed4M0jlfIDPvg6uqKI2xXr2" crossorigin="anonymous">
    <link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Raleway">
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
    <link rel="stylesheet" type="text/css" href="bootstrap.min.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<style>
table {
  font-family: arial, sans-serif;
  border-collapse: collapse;
  width: 100%;
}

td, th {
  border: 1px solid #dddddd;
  text-align: center;
  padding: 8px;
}

tr:nth-child(even) {
  background-color: #dddddd;
  text-decoration: bold;
}
th {
  border: 1px solid #dddddd;
  text-align: center;
  padding: 8px;
  background-color: black;
  color: white;
}
.start{
	text-align: center;
}
.button a{
  color: white; 
  text-decoration: none;
}
 button {
        border-radius: 10px;
        border: 4px solid  #f90d53;
        font-size: 28px;
        padding: 20px;
        width: 150px;
        cursor: pointer;
        margin-top: 20px;
        margin-left: 40%;
        margin-bottom: 20px;
      }
  .image-div{
    width: 40%;
    float: left;
  }
  .detail-div{
   width: 400px;
    height: 500px;
    display: flex;
  }
  .an:hover{
        background: #f90D53;
        cursor: pointer;
        color: white;
      }
      .an{
        border:2px solid ;
        border-radius: 10px;
        color: #f90D53;
        width: 20%;
      }
</style>
</head>
<body>

<!-- Header start -->
<?php
  // Navigation
  require_once("includes/navbar.php");
  require_once("includes/connection.php");
?>
<!--cost table start-->
<section style="margin-top: 104px;">
<?php 
    $select_project = "SELECT * FROM project WHERE project_id = '$_GET[project_id]'";
    $run_project = mysqli_query($con, $select_project);

    $project_data = mysqli_fetch_array($run_project);
    $project_title = $project_data['title'];
    $project_type = $project_data['type'];
    $p_size = $project_data['p_size'];
?>
<h2 class="start"><?php echo $project_title." - ".$project_type;?></h2>
<h3 class="start"><b>Detail of material used in costruction with price.</b></h3>
<hr>
<table>
  <tr>
    <th>Product Name</th>
    <th>Retail Price</th>
    <th>Company Price</th>
    <th>Quantity used</th>
    <th>Cost of Quantity</th>
  </tr>
  <?php
    if (isset($_GET['project_id'])) {
        $project_id = $_GET['project_id'];
  
        $select_material = "SELECT * FROM material_detail WHERE project_id = '$project_id'";
        $run_material = mysqli_query($con, $select_material);

        if (mysqli_num_rows($run_material)>0) {
            while ($data = mysqli_fetch_array($run_material)) {
                $p_name = $data['p_name'];
                $r_price = $data['r_price'];
                $c_price = $data['c_price'];
                $q_used = $data['q_used'];
                $project_id = $data['project_id'];
                $q_cost = $data['q_cost'];

                echo "<tr>
                    <td>$p_name</td>
                    <td>$r_price</td>
                    <td>$c_price</td>
                    <td>$q_used</td>
                    <td>$q_cost</td>
                </tr>";
            }
        }
    }
  ?>
</table>
</section>
<!--cost table end-->

<!--Payment plane start-->
<section style="margin-top: 60px;">
	<h2 class="start"><?php echo $project_title." - ".$project_type;?></h2>
<h3 class="start"><b>Payment Plan</b></h3>
<hr>
<table>
<tr>
    <th>Plot Size</th>
    <th><?php echo $p_size;?></th>
  </tr>
<?php
    if (isset($_GET['project_id'])) {
        $project_id = $_GET['project_id'];
  
        $select_payment = "SELECT * FROM payment_plans WHERE project_id = '$project_id'";
        $run_payment = mysqli_query($con, $select_payment);

        if (mysqli_num_rows($run_payment)>0) {
            while ($datapayment = mysqli_fetch_array($run_payment)) {
                $p_title = $datapayment['p_title'];
                $p_detail = $datapayment['p_detail'];

                echo "<tr>
                    <td>$p_title</td>
                    <td>$p_detail</td>
                </tr>";
            }
        }
      }
  ?>
</table>
</section>
<!--payment plan end-->
<section>
  <hr>
  <div class="container-fluid">
    <div class="row mb-2">
      <div class="image-div">
      <div class="col-lg-6 col-md-6 col-sm-12 col-12">
        <h2>Features:</h2>
        <ol>
        <?php
            if (isset($_GET['project_id'])) {
                $project_id = $_GET['project_id'];
          
                $select_features = "SELECT * FROM project_features WHERE project_id = '$project_id'";
                $run_features = mysqli_query($con, $select_features);
        
                if (mysqli_num_rows($run_features)>0) {
                    while ($datafeatures = mysqli_fetch_array($run_features)) {
                        $features = $datafeatures['features'];
                        $image = $datafeatures['image'];
                        $video = $datafeatures['video'];
        
                        echo "<li><b>$features</b></li>";
                    }
                }
            }
        ?>
        </ol>
      </div>
      <hr>
      <div>
        <h3><?php echo $project_title;?> house vedio:</h3>
        <iframe src="images/<?php echo $video;?>"></iframe>
        <p>This vedio belong to our previous project.</p>
      </div>
      </div>
        <div class="detail-div">
          
            <img src="images/<?php echo $image;?>">
        
        </div>
    </div>
  </div>

</section>
        <div>
        <p style="text-align: center;">To buy this project submit you order by clicking on order button given below.</p>
          <button class="an"><a href="orderform.php?project_id=<?php echo $_GET['project_id'];?>">Order</a></button>
        </div>

<!-- Footer start-->
<footer class="w3-center w3-black w3-padding-64">
  <a href="#" class="w3-button w3-light-grey"><i class="fa fa-arrow-up w3-margin-right"></i>To the top</a>
  <div class="w3-xlarge w3-section">
    <i class="fa fa-facebook-official w3-hover-opacity"></i>
    <i class="fa fa-instagram w3-hover-opacity"></i>
    <i class="fa fa-snapchat w3-hover-opacity"></i>
    <i class="fa fa-pinterest-p w3-hover-opacity"></i>
    <i class="fa fa-twitter w3-hover-opacity"></i>
    <i class="fa fa-linkedin w3-hover-opacity"></i>
  </div>
  <p>Copyright@:<a href="https://www.facebook.com/people/Ch-Umair/100008881573133" title="" target="_blank" class="">GCC.2021</a></p>
</footer>
    <!--footer end--->
    <!-- Javascript -->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

<html>

<head>

<title style="color: GREEN;">GCC/5-Marla Exective Details</title>

<style>

table {

font-family: arial, sans-serif;

border-collapse: collapse;

width: 100%;

}

td, th {

border: 1px solid #dddddd;

text-align: center;

padding: 8px;

}

tr:nth-child(even) {

background-color: #dddddd;

text-decoration: bold;

}

th {

border: 1px solid #dddddd;

text-align: center;

padding: 8px;

background-color: black;

color: white;

}

.start{

text-align: center;

}

.button a{

color: white;

text-decoration: none;

}

button {

border-radius: 10px;

border: 4px solid #f90d53;

font-size: 28px;

padding: 20px;

width: 150px;

cursor: pointer;

margin-top: 20px;

margin-left: 40%;

margin-bottom: 20px;

}

.image-div{

width: 40%;

float: left;

}

.detail-div{

width: 400px;

height: 500px;

display: flex;

}

.an:hover{

background: #f90D53;

cursor: pointer;

color: white;

}

.an{

border:2px solid ;

border-radius: 10px;

color: #f90D53;

width: 20%;

}

</style>

</head>

<body>

<?php

// Navigation

require_once("includes/navbar.php");

require_once("includes/connection.php");

<?php

$select_project = "SELECT * FROM project WHERE project_id = '$_GET[project_id]'";

$run_project = mysqli_query($con, $select_project);

$project_data = mysqli_fetch_array($run_project);

$project_title = $project_data['title'];

$project_type = $project_data['type'];

$p_size = $project_data['p_size'];

<h3 class="start"><b>Detail of material used in costruction with price.</b></h3>

<hr>

<table>

<tr>

<th>Product Name</th>

<th>Retail Price</th>

<th>Company Price</th>

<th>Quantity used</th>

<th>Cost of Quantity</th>

</tr>

<?php

if (isset($_GET['project_id'])) {

$project_id = $_GET['project_id'];

$select_material = "SELECT * FROM material_detail WHERE project_id = '$project_id'";

$run_material = mysqli_query($con, $select_material);

if (mysqli_num_rows($run_material)>0) {

while ($data = mysqli_fetch_array($run_material)) {

$p_name = $data['p_name'];

$r_price = $data['r_price'];

$c_price = $data['c_price'];

$q_used = $data['q_used'];

$project_id = $data['project_id'];

$q_cost = $data['q_cost'];

echo "<tr>

<td>$r_price</td>

<td>$c_price</td>

</tr>";

}

</table>

</section>

<h3 class="start"><b>Payment Plan</b></h3>

<hr>

<table>

<tr>

</tr>

<?php

if (isset($_GET['project_id'])) {

$project_id = $_GET['project_id'];

$select_payment = "SELECT * FROM payment_plans WHERE project_id = '$project_id'";

$run_payment = mysqli_query($con, $select_payment);

if (mysqli_num_rows($run_payment)>0) {

while ($datapayment = mysqli_fetch_array($run_payment)) {

$p_title = $datapayment['p_title'];

$p_detail = $datapayment['p_detail'];

echo "<tr>

<td>$p_title</td>

<td>$p_detail</td>

</tr>";

}

</table>

</section>

<hr>

<h2>Features:</h2>

<ol>

<?php

if (isset($_GET['project_id'])) {

$project_id = $_GET['project_id'];

$select_features = "SELECT * FROM project_features WHERE project_id = '$project_id'";

$run_features = mysqli_query($con, $select_features);

if (mysqli_num_rows($run_features)>0) {

while ($datafeatures = mysqli_fetch_array($run_features)) {

$features = $datafeatures['features'];

$image = $datafeatures['image'];

$video = $datafeatures['video'];

echo "<li><b>$features</b></li>";

}

</ol>

</div>

<hr>

<div>

<h3><?php echo $project_title;?> house vedio:</h3>

<p>This vedio belong to our previous project.</p>

</div>

</div>

</section>

<div>

<p style="text-align: center;">To buy this project submit you order by clicking on order button given below.</p>

<button class="an"><a href="orderform.php?project_id=<?php echo $_GET['project_id'];?>">Order</a></button>

</div>

</div>

<p>Copyright@:<a href="https://www.facebook.com/people/Ch-Umair/100008881573133" title="" target="_blank" class="">GCC.2021</a></p>

</footer>

</body>

</html>

order_fun.php

<?php
    require_once("includes/connection.php");
    if (isset($_POST['submit'])) {
        $fname = $_POST['fname'];
        $lname = $_POST['lname'];
        $cnic = $_POST['cnic'];
        $email = $_POST['email'];
        $phone = $_POST['phone'];
        $address = $_POST['address'];
        $project_id = $_POST['project_id'];

        $image = $_FILES['image']['name'];
        $temp_name = $_FILES['image']['tmp_name'];
        $folder = "images/".$image;
        move_uploaded_file($temp_name, $folder);

        $order_id = mt_rand(900, 90000);

        $insert = "INSERT INTO `order_details`(`f_name`, `l_name`, `cnic`, `u_mail`, `u_contact`, `u_address`, `payment_slip`, `status`, `project_id`, `order_id`) VALUES ('$fname','$lname', '$cnic', '$email', '$phone', '$address', '$image', 'Pending', '$project_id', '$order_id')";
        $run = mysqli_query($con, $insert);
        
        if ($run) {
				header('refresh:0;url=index.php');
        } else {
            echo '<script type="text/javascript">
				alert("Error");
				</script>';

				header('refresh:0;url=index.php');
        }
    }
?>

<?php

require_once("includes/connection.php");

if (isset($_POST['submit'])) {

$fname = $_POST['fname'];

$lname = $_POST['lname'];

$cnic = $_POST['cnic'];

$email = $_POST['email'];

$phone = $_POST['phone'];

$address = $_POST['address'];

$project_id = $_POST['project_id'];

$image = $_FILES['image']['name'];

$temp_name = $_FILES['image']['tmp_name'];

$folder = "images/".$image;

move_uploaded_file($temp_name, $folder);

$order_id = mt_rand(900, 90000);

$insert = "INSERT INTO `order_details`(`f_name`, `l_name`, `cnic`, `u_mail`, `u_contact`, `u_address`, `payment_slip`, `status`, `project_id`, `order_id`) VALUES ('$fname','$lname', '$cnic', '$email', '$phone', '$address', '$image', 'Pending', '$project_id', '$order_id')";

$run = mysqli_query($con, $insert);

if ($run) {

header('refresh:0;url=index.php');

} else {

echo '<script type="text/javascript">

alert("Error");

</script>';

header('refresh:0;url=index.php');

}

Download full code of Construction Company Management System Project Construction Company Management System Introduction This project of Construction Company Management System belongs to the construction website in which we provide different services to our clients related to construction. Like Build new houses (from …

Construction Company Management System Code download Read More »

Code of Online Examination System

Leave a Comment / PHP Projects / By Projects Inventory

Online Examination System [Free Code Download]. dash.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="viewport" content="width=device-width, initial-scale=1">

<title>DASHBOARD </title>
<link  rel="stylesheet" href="css/bootstrap.min.css"/>
 <link  rel="stylesheet" href="css/bootstrap-theme.min.css"/>    
 <link rel="stylesheet" href="css/main.css">
 <link  rel="stylesheet" href="css/font.css">
 <script src="js/jquery.js" type="text/javascript"></script>

  <script src="js/bootstrap.min.js"  type="text/javascript"></script>
 	<link href='http://fonts.googleapis.com/css?family=Roboto:400,700,300' rel='stylesheet' type='text/css'>

<script>
$(function () {
    $(document).on( 'scroll', function(){
        console.log('scroll top : ' + $(window).scrollTop());
        if($(window).scrollTop()>=$(".logo").height())
        {
             $(".navbar").addClass("navbar-fixed-top");
        }

        if($(window).scrollTop()<$(".logo").height())
        {
             $(".navbar").removeClass("navbar-fixed-top");
        }
    });
});</script>
</head>

<body  style="background:#eee;">
<div class="header">
<div class="row">
<div class="col-lg-6">
<span class="logo">Online Examination</span></div>
<?php
 include_once 'dbConnection.php';
session_start();
$email=$_SESSION['email'];
  if(!(isset($_SESSION['email']))){
header("location:index.php");

}
else
{
$name = $_SESSION['name'];;

include_once 'dbConnection.php';
echo '<span class="pull-right top title1" ><span class="log1"><span class="glyphicon glyphicon-user" aria-hidden="true"></span>&nbsp;&nbsp;&nbsp;&nbsp;Hello,</span> <a href="account.php" class="log log1">'.$name.'</a>&nbsp;|&nbsp;<a href="logout.php?q=account.php" class="log"><span class="glyphicon glyphicon-log-out" aria-hidden="true"></span>&nbsp;Signout</button></a></span>';
}?>

</div></div>
<!-- admin start-->

<!--navigation menu-->
<nav class="navbar navbar-default title1">
  <div class="container-fluid">
    <!-- Brand and toggle get grouped for better mobile display -->
    <div class="navbar-header">
      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
        <span class="sr-only">Toggle navigation</span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
      </button>
      <a class="navbar-brand" href="dash.php?q=0"><b>Dashboard</b></a>
    </div>
    <!-- Collect the nav links, forms, and other content for toggling -->
    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
      <ul class="nav navbar-nav">
        <li <?php if(@$_GET['q']==0) echo'class="active"'; ?>><a href="dash.php?q=0">Home<span class="sr-only">(current)</span></a></li>
        <li <?php if(@$_GET['q']==1) echo'class="active"'; ?>><a href="dash.php?q=1">User</a></li>
		<li <?php if(@$_GET['q']==2) echo'class="active"'; ?>><a href="dash.php?q=2">Ranking</a></li>
		<li <?php if(@$_GET['q']==3) echo'class="active"'; ?>><a href="dash.php?q=3">Feedback</a></li>
    
        <li class="dropdown <?php if(@$_GET['q']==4 || @$_GET['q']==5) echo'active"'; ?>">
          <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Quiz<span class="caret"></span></a>
          <ul class="dropdown-menu">
            <li><a href="dash.php?q=4">Add Quiz</a></li>
            <li><a href="dash.php?q=5">Remove Quiz</a></li>
			
          </ul>
        </li><li class="pull-right"> <a href="logout.php?q=account.php"><span class="glyphicon glyphicon-log-out" aria-hidden="true"></span>&nbsp;&nbsp;&nbsp;&nbsp;Signout</a></li>
		
      </ul>
          </div><!-- /.navbar-collapse -->
  </div><!-- /.container-fluid -->
</nav>
<!--navigation menu closed-->
<div class="container"><!--container start-->
<div class="row">
<div class="col-md-12">
<!--home start-->

<?php if(@$_GET['q']==0) {

$result = mysqli_query($con,"SELECT * FROM quiz ORDER BY date DESC") or die('Error');
echo  '<div class="panel"><div class="table-responsive"><table class="table table-striped title1">
<tr><td><b>S.N.</b></td><td><b>Topic</b></td><td><b>Total question</b></td><td><b>Marks</b></td><td><b>Time limit</b></td><td></td></tr>';
$c=1;
while($row = mysqli_fetch_array($result)) {
	$title = $row['title'];
	$total = $row['total'];
	$sahi = $row['sahi'];
    $time = $row['time'];
	$eid = $row['eid'];
$q12=mysqli_query($con,"SELECT score FROM history WHERE eid='$eid' AND email='$email'" )or die('Error98');
$rowcount=mysqli_num_rows($q12);	
if($rowcount == 0){
	echo '<tr><td>'.$c++.'</td><td>'.$title.'</td><td>'.$total.'</td><td>'.$sahi*$total.'</td><td>'.$time.'&nbsp;min</td>
	<td><b><a href="account.php?q=quiz&step=2&eid='.$eid.'&n=1&t='.$total.'" class="pull-right btn sub1" style="margin:0px;background:#99cc32"><span class="glyphicon glyphicon-new-window" aria-hidden="true"></span>&nbsp;<span class="title1"><b>Start</b></span></a></b></td></tr>';
}
else
{
echo '<tr style="color:#99cc32"><td>'.$c++.'</td><td>'.$title.'&nbsp;<span title="This quiz is already solve by you" class="glyphicon glyphicon-ok" aria-hidden="true"></span></td><td>'.$total.'</td><td>'.$sahi*$total.'</td><td>'.$time.'&nbsp;min</td>
	<td><b><a href="update.php?q=quizre&step=25&eid='.$eid.'&n=1&t='.$total.'" class="pull-right btn sub1" style="margin:0px;background:red"><span class="glyphicon glyphicon-repeat" aria-hidden="true"></span>&nbsp;<span class="title1"><b>Restart</b></span></a></b></td></tr>';
}
}
$c=0;
echo '</table></div></div>';

}

//ranking start
if(@$_GET['q']== 2) 
{
$q=mysqli_query($con,"SELECT * FROM rank  ORDER BY score DESC " )or die('Error223');
echo  '<div class="panel title"><div class="table-responsive">
<table class="table table-striped title1" >
<tr style="color:red"><td><b>Rank</b></td><td><b>Name</b></td><td><b>Gender</b></td><td><b>College</b></td><td><b>Score</b></td></tr>';
$c=0;
while($row=mysqli_fetch_array($q) )
{
$e=$row['email'];
$s=$row['score'];
$q12=mysqli_query($con,"SELECT * FROM user WHERE email='$e' " )or die('Error231');
while($row=mysqli_fetch_array($q12) )
{
$name=$row['name'];
$gender=$row['gender'];
$college=$row['college'];
}
$c++;
echo '<tr><td style="color:#99cc32"><b>'.$c.'</b></td><td>'.$name.'</td><td>'.$gender.'</td><td>'.$college.'</td><td>'.$s.'</td><td>';
}
echo '</table></div></div>';}

?>


<!--home closed-->
<!--users start-->
<?php if(@$_GET['q']==1) {

$result = mysqli_query($con,"SELECT * FROM user") or die('Error');
echo  '<div class="panel"><div class="table-responsive"><table class="table table-striped title1">
<tr><td><b>S.N.</b></td><td><b>Name</b></td><td><b>Gender</b></td><td><b>College</b></td><td><b>Email</b></td><td><b>Mobile</b></td><td></td></tr>';
$c=1;
while($row = mysqli_fetch_array($result)) {
	$name = $row['name'];
	$mob = $row['mob'];
	$gender = $row['gender'];
    $email = $row['email'];
	$college = $row['college'];

	echo '<tr><td>'.$c++.'</td><td>'.$name.'</td><td>'.$gender.'</td><td>'.$college.'</td><td>'.$email.'</td><td>'.$mob.'</td>
	<td><a title="Delete User" href="update.php?demail='.$email.'"><b><span class="glyphicon glyphicon-trash" aria-hidden="true"></span></b></a></td></tr>';
}
$c=0;
echo '</table></div></div>';

}?>
<!--user end-->

<!--feedback start-->
<?php if(@$_GET['q']==3) {
$result = mysqli_query($con,"SELECT * FROM `feedback` ORDER BY `feedback`.`date` DESC") or die('Error');
echo  '<div class="panel"><div class="table-responsive"><table class="table table-striped title1">
<tr><td><b>S.N.</b></td><td><b>Subject</b></td><td><b>Email</b></td><td><b>Date</b></td><td><b>Time</b></td><td><b>By</b></td><td></td><td></td></tr>';
$c=1;
while($row = mysqli_fetch_array($result)) {
	$date = $row['date'];
	$date= date("d-m-Y",strtotime($date));
	$time = $row['time'];
	$subject = $row['subject'];
	$name = $row['name'];
	$email = $row['email'];
	$id = $row['id'];
	 echo '<tr><td>'.$c++.'</td>';
	echo '<td><a title="Click to open feedback" href="dash.php?q=3&fid='.$id.'">'.$subject.'</a></td><td>'.$email.'</td><td>'.$date.'</td><td>'.$time.'</td><td>'.$name.'</td>
	<td><a title="Open Feedback" href="dash.php?q=3&fid='.$id.'"><b><span class="glyphicon glyphicon-folder-open" aria-hidden="true"></span></b></a></td>';
	echo '<td><a title="Delete Feedback" href="update.php?fdid='.$id.'"><b><span class="glyphicon glyphicon-trash" aria-hidden="true"></span></b></a></td>

	</tr>';
}
echo '</table></div></div>';
}
?>
<!--feedback closed-->

<!--feedback reading portion start-->
<?php if(@$_GET['fid']) {
echo '<br />';
$id=@$_GET['fid'];
$result = mysqli_query($con,"SELECT * FROM feedback WHERE id='$id' ") or die('Error');
while($row = mysqli_fetch_array($result)) {
	$name = $row['name'];
	$subject = $row['subject'];
	$date = $row['date'];
	$date= date("d-m-Y",strtotime($date));
	$time = $row['time'];
	$feedback = $row['feedback'];
	
echo '<div class="panel"<a title="Back to Archive" href="update.php?q1=2"><b><span class="glyphicon glyphicon-level-up" aria-hidden="true"></span></b></a><h2 style="text-align:center; margin-top:-15px;font-family: "Ubuntu", sans-serif;"><b>'.$subject.'</b></h1>';
 echo '<div class="mCustomScrollbar" data-mcs-theme="dark" style="margin-left:10px;margin-right:10px; max-height:450px; line-height:35px;padding:5px;"><span style="line-height:35px;padding:5px;">-&nbsp;<b>DATE:</b>&nbsp;'.$date.'</span>
<span style="line-height:35px;padding:5px;">&nbsp;<b>Time:</b>&nbsp;'.$time.'</span><span style="line-height:35px;padding:5px;">&nbsp;<b>By:</b>&nbsp;'.$name.'</span><br />'.$feedback.'</div></div>';}
}?>
<!--Feedback reading portion closed-->

<!--add quiz start-->
<?php
if(@$_GET['q']==4 && !(@$_GET['step']) ) {
echo ' 
<div class="row">
<span class="title1" style="margin-left:40%;font-size:30px;"><b>Enter Quiz Details</b></span><br /><br />
 <div class="col-md-3"></div><div class="col-md-6">   <form class="form-horizontal title1" name="form" action="update.php?q=addquiz"  method="POST">
<fieldset>


<!-- Text input-->
<div class="form-group">
  <label class="col-md-12 control-label" for="name"></label>  
  <div class="col-md-12">
  <input id="name" name="name" placeholder="Enter Quiz title" class="form-control input-md" type="text">
    
  </div>
</div>



<!-- Text input-->
<div class="form-group">
  <label class="col-md-12 control-label" for="total"></label>  
  <div class="col-md-12">
  <input id="total" name="total" placeholder="Enter total number of questions" class="form-control input-md" type="number">
    
  </div>
</div>

<!-- Text input-->
<div class="form-group">
  <label class="col-md-12 control-label" for="right"></label>  
  <div class="col-md-12">
  <input id="right" name="right" placeholder="Enter marks on right answer" class="form-control input-md" min="0" type="number">
    
  </div>
</div>

<!-- Text input-->
<div class="form-group">
  <label class="col-md-12 control-label" for="wrong"></label>  
  <div class="col-md-12">
  <input id="wrong" name="wrong" placeholder="Enter minus marks on wrong answer without sign" class="form-control input-md" min="0" type="number">
    
  </div>
</div>

<!-- Text input-->
<div class="form-group">
  <label class="col-md-12 control-label" for="time"></label>  
  <div class="col-md-12">
  <input id="time" name="time" placeholder="Enter time limit for test in minute" class="form-control input-md" min="1" type="number">
    
  </div>
</div>

<!-- Text input-->
<div class="form-group">
  <label class="col-md-12 control-label" for="tag"></label>  
  <div class="col-md-12">
  <input id="tag" name="tag" placeholder="Enter #tag which is used for searching" class="form-control input-md" type="text">
    
  </div>
</div>


<!-- Text input-->
<div class="form-group">
  <label class="col-md-12 control-label" for="desc"></label>  
  <div class="col-md-12">
  <textarea rows="8" cols="8" name="desc" class="form-control" placeholder="Write description here..."></textarea>  
  </div>
</div>


<div class="form-group">
  <label class="col-md-12 control-label" for=""></label>
  <div class="col-md-12"> 
    <input  type="submit" style="margin-left:45%" class="btn btn-primary" value="Submit" class="btn btn-primary"/>
  </div>
</div>

</fieldset>
</form></div>';



}
?>
<!--add quiz end-->

<!--add quiz step2 start-->
<?php
if(@$_GET['q']==4 && (@$_GET['step'])==2 ) {
echo ' 
<div class="row">
<span class="title1" style="margin-left:40%;font-size:30px;"><b>Enter Question Details</b></span><br /><br />
 <div class="col-md-3"></div><div class="col-md-6"><form class="form-horizontal title1" name="form" action="update.php?q=addqns&n='.@$_GET['n'].'&eid='.@$_GET['eid'].'&ch=4 "  method="POST">
<fieldset>
';
 
 for($i=1;$i<=@$_GET['n'];$i++)
 {
echo '<b>Question number&nbsp;'.$i.'&nbsp;:</><br /><!-- Text input-->
<div class="form-group">
  <label class="col-md-12 control-label" for="qns'.$i.' "></label>  
  <div class="col-md-12">
  <textarea rows="3" cols="5" name="qns'.$i.'" class="form-control" placeholder="Write question number '.$i.' here..."></textarea>  
  </div>
</div>
<!-- Text input-->
<div class="form-group">
  <label class="col-md-12 control-label" for="'.$i.'1"></label>  
  <div class="col-md-12">
  <input id="'.$i.'1" name="'.$i.'1" placeholder="Enter option a" class="form-control input-md" type="text">
    
  </div>
</div>
<!-- Text input-->
<div class="form-group">
  <label class="col-md-12 control-label" for="'.$i.'2"></label>  
  <div class="col-md-12">
  <input id="'.$i.'2" name="'.$i.'2" placeholder="Enter option b" class="form-control input-md" type="text">
    
  </div>
</div>
<!-- Text input-->
<div class="form-group">
  <label class="col-md-12 control-label" for="'.$i.'3"></label>  
  <div class="col-md-12">
  <input id="'.$i.'3" name="'.$i.'3" placeholder="Enter option c" class="form-control input-md" type="text">
    
  </div>
</div>
<!-- Text input-->
<div class="form-group">
  <label class="col-md-12 control-label" for="'.$i.'4"></label>  
  <div class="col-md-12">
  <input id="'.$i.'4" name="'.$i.'4" placeholder="Enter option d" class="form-control input-md" type="text">
    
  </div>
</div>
<br />
<b>Correct answer</b>:<br />
<select id="ans'.$i.'" name="ans'.$i.'" placeholder="Choose correct answer " class="form-control input-md" >
   <option value="a">Select answer for question '.$i.'</option>
  <option value="a">option a</option>
  <option value="b">option b</option>
  <option value="c">option c</option>
  <option value="d">option d</option> </select><br /><br />'; 
 }
    
echo '<div class="form-group">
  <label class="col-md-12 control-label" for=""></label>
  <div class="col-md-12"> 
    <input  type="submit" style="margin-left:45%" class="btn btn-primary" value="Submit" class="btn btn-primary"/>
  </div>
</div>

</fieldset>
</form></div>';



}
?><!--add quiz step 2 end-->

<!--remove quiz-->
<?php if(@$_GET['q']==5) {

$result = mysqli_query($con,"SELECT * FROM quiz ORDER BY date DESC") or die('Error');
echo  '<div class="panel"><div class="table-responsive"><table class="table table-striped title1">
<tr><td><b>S.N.</b></td><td><b>Topic</b></td><td><b>Total question</b></td><td><b>Marks</b></td><td><b>Time limit</b></td><td></td></tr>';
$c=1;
while($row = mysqli_fetch_array($result)) {
	$title = $row['title'];
	$total = $row['total'];
	$sahi = $row['sahi'];
    $time = $row['time'];
	$eid = $row['eid'];
	echo '<tr><td>'.$c++.'</td><td>'.$title.'</td><td>'.$total.'</td><td>'.$sahi*$total.'</td><td>'.$time.'&nbsp;min</td>
	<td><b><a href="update.php?q=rmquiz&eid='.$eid.'" class="pull-right btn sub1" style="margin:0px;background:red"><span class="glyphicon glyphicon-trash" aria-hidden="true"></span>&nbsp;<span class="title1"><b>Remove</b></span></a></b></td></tr>';
}
$c=0;
echo '</table></div></div>';

}
?>


</div><!--container closed-->
</div></div>
</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>DASHBOARD </title>

$(function () {

$(document).on( 'scroll', function(){

console.log('scroll top : ' + $(window).scrollTop());

if($(window).scrollTop()>=$(".logo").height())

{

$(".navbar").addClass("navbar-fixed-top");

}

if($(window).scrollTop()<$(".logo").height())

{

$(".navbar").removeClass("navbar-fixed-top");

}

});

});</script>

</head>

<span class="logo">Online Examination</span></div>

<?php

include_once 'dbConnection.php';

session_start();

$email=$_SESSION['email'];

if(!(isset($_SESSION['email']))){

header("location:index.php");

}

else

{

$name = $_SESSION['name'];;

include_once 'dbConnection.php';

echo '<span class="pull-right top title1" ><span class="log1"><span class="glyphicon glyphicon-user" aria-hidden="true"></span>    Hello,</span> <a href="account.php" class="log log1">'.$name.'</a> | <a href="logout.php?q=account.php" class="log"><span class="glyphicon glyphicon-log-out" aria-hidden="true"></span> Signout</button></a></span>';

}?>

</div></div>

<span class="sr-only">Toggle navigation</span>

</button>

<a class="navbar-brand" href="dash.php?q=0"><b>Dashboard</b></a>

</div>

<li <?php if(@$_GET['q']==0) echo'class="active"'; ?>><a href="dash.php?q=0">Home<span class="sr-only">(current)</span></a></li>

<li <?php if(@$_GET['q']==2) echo'class="active"'; ?>><a href="dash.php?q=2">Ranking</a></li>

<li <?php if(@$_GET['q']==3) echo'class="active"'; ?>><a href="dash.php?q=3">Feedback</a></li>

<li><a href="dash.php?q=5">Remove Quiz</a></li>

</ul>

</li><li class="pull-right"> <a href="logout.php?q=account.php"><span class="glyphicon glyphicon-log-out" aria-hidden="true"></span>    Signout</a></li>

</ul>

</div>

</div>

</nav>

<?php if(@$_GET['q']==0) {

$result = mysqli_query($con,"SELECT * FROM quiz ORDER BY date DESC") or die('Error');

echo '<div class="panel"><div class="table-responsive"><table class="table table-striped title1">

<tr><td><b>S.N.</b></td><td><b>Topic</b></td><td><b>Total question</b></td><td><b>Marks</b></td><td><b>Time limit</b></td><td></td></tr>';

$c=1;

while($row = mysqli_fetch_array($result)) {

$title = $row['title'];

$total = $row['total'];

$sahi = $row['sahi'];

$time = $row['time'];

$eid = $row['eid'];

$q12=mysqli_query($con,"SELECT score FROM history WHERE eid='$eid' AND email='$email'" )or die('Error98');

$rowcount=mysqli_num_rows($q12);

if($rowcount == 0){

echo '<tr><td>'.$c++.'</td><td>'.$title.'</td><td>'.$total.'</td><td>'.$sahi*$total.'</td><td>'.$time.' min</td>

<td><b><a href="account.php?q=quiz&step=2&eid='.$eid.'&n=1&t='.$total.'" class="pull-right btn sub1" style="margin:0px;background:#99cc32"><span class="glyphicon glyphicon-new-window" aria-hidden="true"></span> <span class="title1"><b>Start</b></span></a></b></td></tr>';

}

else

{

echo '<tr style="color:#99cc32"><td>'.$c++.'</td><td>'.$title.' <span title="This quiz is already solve by you" class="glyphicon glyphicon-ok" aria-hidden="true"></span></td><td>'.$total.'</td><td>'.$sahi*$total.'</td><td>'.$time.' min</td>

<td><b><a href="update.php?q=quizre&step=25&eid='.$eid.'&n=1&t='.$total.'" class="pull-right btn sub1" style="margin:0px;background:red"><span class="glyphicon glyphicon-repeat" aria-hidden="true"></span> <span class="title1"><b>Restart</b></span></a></b></td></tr>';

}

$c=0;

echo '</table></div></div>';

}

//ranking start

if(@$_GET['q']== 2)

{

$q=mysqli_query($con,"SELECT * FROM rank ORDER BY score DESC " )or die('Error223');

echo '<div class="panel title"><div class="table-responsive">

<tr style="color:red"><td><b>Rank</b></td><td><b>Name</b></td><td><b>Gender</b></td><td><b>College</b></td><td><b>Score</b></td></tr>';

$c=0;

while($row=mysqli_fetch_array($q) )

{

$e=$row['email'];

$s=$row['score'];

$q12=mysqli_query($con,"SELECT * FROM user WHERE email='$e' " )or die('Error231');

while($row=mysqli_fetch_array($q12) )

{

$name=$row['name'];

$gender=$row['gender'];

$college=$row['college'];

}

$c++;

echo '<tr><td style="color:#99cc32"><b>'.$c.'</b></td><td>'.$name.'</td><td>'.$gender.'</td><td>'.$college.'</td><td>'.$s.'</td><td>';

}

echo '</table></div></div>';}

<?php if(@$_GET['q']==1) {

$result = mysqli_query($con,"SELECT * FROM user") or die('Error');

echo '<div class="panel"><div class="table-responsive"><table class="table table-striped title1">

<tr><td><b>S.N.</b></td><td><b>Name</b></td><td><b>Gender</b></td><td><b>College</b></td><td><b>Email</b></td><td><b>Mobile</b></td><td></td></tr>';

$c=1;

while($row = mysqli_fetch_array($result)) {

$name = $row['name'];

$mob = $row['mob'];

$gender = $row['gender'];

$email = $row['email'];

$college = $row['college'];

echo '<tr><td>'.$c++.'</td><td>'.$name.'</td><td>'.$gender.'</td><td>'.$college.'</td><td>'.$email.'</td><td>'.$mob.'</td>

<td><a title="Delete User" href="update.php?demail='.$email.'"><b><span class="glyphicon glyphicon-trash" aria-hidden="true"></span></b></a></td></tr>';

}

$c=0;

echo '</table></div></div>';

}?>

<?php if(@$_GET['q']==3) {

$result = mysqli_query($con,"SELECT * FROM `feedback` ORDER BY `feedback`.`date` DESC") or die('Error');

echo '<div class="panel"><div class="table-responsive"><table class="table table-striped title1">

<tr><td><b>S.N.</b></td><td><b>Subject</b></td><td><b>Email</b></td><td><b>Date</b></td><td><b>Time</b></td><td><b>By</b></td><td></td><td></td></tr>';

$c=1;

while($row = mysqli_fetch_array($result)) {

$date = $row['date'];

$date= date("d-m-Y",strtotime($date));

$time = $row['time'];

$subject = $row['subject'];

$name = $row['name'];

$email = $row['email'];

$id = $row['id'];

echo '<tr><td>'.$c++.'</td>';

echo '<td><a title="Click to open feedback" href="dash.php?q=3&fid='.$id.'">'.$subject.'</a></td><td>'.$email.'</td><td>'.$date.'</td><td>'.$time.'</td><td>'.$name.'</td>

<td><a title="Open Feedback" href="dash.php?q=3&fid='.$id.'"><b><span class="glyphicon glyphicon-folder-open" aria-hidden="true"></span></b></a></td>';

echo '<td><a title="Delete Feedback" href="update.php?fdid='.$id.'"><b><span class="glyphicon glyphicon-trash" aria-hidden="true"></span></b></a></td>

</tr>';

}

echo '</table></div></div>';

}

<?php if(@$_GET['fid']) {

echo '<br />';

$id=@$_GET['fid'];

$result = mysqli_query($con,"SELECT * FROM feedback WHERE id='$id' ") or die('Error');

while($row = mysqli_fetch_array($result)) {

$name = $row['name'];

$subject = $row['subject'];

$date = $row['date'];

$date= date("d-m-Y",strtotime($date));

$time = $row['time'];

$feedback = $row['feedback'];

echo '<div class="panel"<a title="Back to Archive" href="update.php?q1=2"><b><span class="glyphicon glyphicon-level-up" aria-hidden="true"></span></b></a><h2 style="text-align:center; margin-top:-15px;font-family: "Ubuntu", sans-serif;"><b>'.$subject.'</b></h1>';

echo '<div class="mCustomScrollbar" data-mcs-theme="dark" style="margin-left:10px;margin-right:10px; max-height:450px; line-height:35px;padding:5px;"><span style="line-height:35px;padding:5px;">- <b>DATE:</b> '.$date.'</span>

<span style="line-height:35px;padding:5px;"> <b>Time:</b> '.$time.'</span><span style="line-height:35px;padding:5px;"> <b>By:</b> '.$name.'</span><br />'.$feedback.'</div></div>';}

}?>

<?php

if(@$_GET['q']==4 && !(@$_GET['step']) ) {

echo '

<span class="title1" style="margin-left:40%;font-size:30px;"><b>Enter Quiz Details</b></span><br /><br />

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</div>

</fieldset>

</form></div>';

}

<?php

if(@$_GET['q']==4 && (@$_GET['step'])==2 ) {

echo '

<span class="title1" style="margin-left:40%;font-size:30px;"><b>Enter Question Details</b></span><br /><br />

for($i=1;$i<=@$_GET['n'];$i++)

{

echo '<b>Question number '.$i.' :</><br />

</div>

</div>

</div>

</div>

</div>

<br />

<b>Correct answer</b>:<br />

<option value="a">Select answer for question '.$i.'</option>

<option value="a">option a</option>

<option value="b">option b</option>

<option value="c">option c</option>

<option value="d">option d</option> </select><br /><br />';

}

echo '<div class="form-group">

</div>

</fieldset>

</form></div>';

}

?>

<?php if(@$_GET['q']==5) {

$result = mysqli_query($con,"SELECT * FROM quiz ORDER BY date DESC") or die('Error');

echo '<div class="panel"><div class="table-responsive"><table class="table table-striped title1">

<tr><td><b>S.N.</b></td><td><b>Topic</b></td><td><b>Total question</b></td><td><b>Marks</b></td><td><b>Time limit</b></td><td></td></tr>';

$c=1;

while($row = mysqli_fetch_array($result)) {

$title = $row['title'];

$total = $row['total'];

$sahi = $row['sahi'];

$time = $row['time'];

$eid = $row['eid'];

echo '<tr><td>'.$c++.'</td><td>'.$title.'</td><td>'.$total.'</td><td>'.$sahi*$total.'</td><td>'.$time.' min</td>

<td><b><a href="update.php?q=rmquiz&eid='.$eid.'" class="pull-right btn sub1" style="margin:0px;background:red"><span class="glyphicon glyphicon-trash" aria-hidden="true"></span> <span class="title1"><b>Remove</b></span></a></b></td></tr>';

}

$c=0;

echo '</table></div></div>';

}

</div>

</div></div>

</body>

</html>

update.php

<?php
// include_once 'dbConnection.php';

$connection = mysqli_connect("localhost","root","","online_examination");

session_start();
$email=$_SESSION['email'];
//delete feedback
if(isset($_SESSION['key'])){
if(@$_GET['fdid']) {
$id=@$_GET['fdid'];
$result = mysqli_query($connection,"DELETE FROM feedback WHERE id='$id' ") or die('Error');
header("location:dash.php?q=3");
}
}

//delete user
if(isset($_SESSION['key'])){
if(@$_GET['demail']) {
$demail=@$_GET['demail'];
$r1 = mysqli_query($connection,"DELETE FROM rank WHERE email='$demail' ") or die('Error');
$r2 = mysqli_query($connection,"DELETE FROM history WHERE email='$demail' ") or die('Error');
$result = mysqli_query($connection,"DELETE FROM user WHERE email='$demail' ") or die('Error');
header("location:dash.php?q=1");
}
}
//remove quiz
if(isset($_SESSION['key'])){
if(@$_GET['q']== 'rmquiz') {
$eid=@$_GET['eid'];
$result = mysqli_query($connection,"SELECT * FROM questions WHERE eid='$eid' ") or die('Error');
while($row = mysqli_fetch_array($result)) {
	$qid = $row['qid'];
$r1 = mysqli_query($connection,"DELETE FROM options WHERE qid='$qid'") or die('Error');
$r2 = mysqli_query($connection,"DELETE FROM answer WHERE qid='$qid' ") or die('Error');
}
$r3 = mysqli_query($connection,"DELETE FROM questions WHERE eid='$eid' ") or die('Error');
$r4 = mysqli_query($connection,"DELETE FROM quiz WHERE eid='$eid' ") or die('Error');
$r4 = mysqli_query($connection,"DELETE FROM history WHERE eid='$eid' ") or die('Error');

header("location:dash.php?q=5");
}
}

//add quiz
if(isset($_SESSION['key'])){
if(@$_GET['q']== 'addquiz') {
$name = $_POST['name'];
$name= ucwords(strtolower($name));
$total = $_POST['total'];
$sahi = $_POST['right'];
$wrong = $_POST['wrong'];
$time = $_POST['time'];
$tag = $_POST['tag'];
$desc = $_POST['desc'];
$id=uniqid();
$q3=mysqli_query($connection,"INSERT INTO quiz VALUES  ('$id','$name' , '$sahi' , '$wrong','$total','$time' ,'$desc','$tag', NOW())");

header("location:dash.php?q=4&step=2&eid=$id&n=$total");
}
}

//add question
if(isset($_SESSION['key'])){
if(@$_GET['q']== 'addqns') {
$n=@$_GET['n'];
$eid=@$_GET['eid'];
$ch=@$_GET['ch'];

for($i=1;$i<=$n;$i++)
 {
 $qid=uniqid();
 $qns=$_POST['qns'.$i];
$q3=mysqli_query($connection,"INSERT INTO questions VALUES  ('$eid','$qid','$qns' , '$ch' , '$i')");
  $oaid=uniqid();
  $obid=uniqid();
$ocid=uniqid();
$odid=uniqid();
$a=$_POST[$i.'1'];
$b=$_POST[$i.'2'];
$c=$_POST[$i.'3'];
$d=$_POST[$i.'4'];
$qa=mysqli_query($connection,"INSERT INTO options VALUES  ('$qid','$a','$oaid')") or die('Error61');
$qb=mysqli_query($connection,"INSERT INTO options VALUES  ('$qid','$b','$obid')") or die('Error62');
$qc=mysqli_query($connection,"INSERT INTO options VALUES  ('$qid','$c','$ocid')") or die('Error63');
$qd=mysqli_query($connection,"INSERT INTO options VALUES  ('$qid','$d','$odid')") or die('Error64');
$e=$_POST['ans'.$i];
switch($e)
{
case 'a':
$ansid=$oaid;
break;
case 'b':
$ansid=$obid;
break;
case 'c':
$ansid=$ocid;
break;
case 'd':
$ansid=$odid;
break;
default:
$ansid=$oaid;
}


$qans=mysqli_query($connection,"INSERT INTO answer VALUES  ('$qid','$ansid')");

 }
header("location:dash.php?q=0");
}
}

//quiz start
if(@$_GET['q']== 'quiz' && @$_GET['step']== 2) {
$eid=@$_GET['eid'];
$sn=@$_GET['n'];
$total=@$_GET['t'];
$ans=$_POST['ans'];
$qid=@$_GET['qid'];
$q=mysqli_query($connection,"SELECT * FROM answer WHERE qid='$qid' " );
while($row=mysqli_fetch_array($q) )
{
$ansid=$row['ansid'];
}
if($ans == $ansid)
{
$q=mysqli_query($connection,"SELECT * FROM quiz WHERE eid='$eid' " );
while($row=mysqli_fetch_array($q) )
{
$sahi=$row['sahi'];
}
if($sn == 1)
{
$q=mysqli_query($connection,"INSERT INTO history VALUES('$email','$eid' ,'0','0','0','0',NOW())")or die('Error');
}
$q=mysqli_query($connection,"SELECT * FROM history WHERE eid='$eid' AND email='$email' ")or die('Error115');

while($row=mysqli_fetch_array($q) )
{
$s=$row['score'];
$r=$row['sahi'];
}
$r++;
$s=$s+$sahi;
$q=mysqli_query($connection,"UPDATE `history` SET `score`=$s,`level`=$sn,`sahi`=$r, date= NOW()  WHERE  email = '$email' AND eid = '$eid'")or die('Error124');

} 
else
{
$q=mysqli_query($connection,"SELECT * FROM quiz WHERE eid='$eid' " )or die('Error129');

while($row=mysqli_fetch_array($q) )
{
$wrong=$row['wrong'];
}
if($sn == 1)
{
$q=mysqli_query($connection,"INSERT INTO history VALUES('$email','$eid' ,'0','0','0','0',NOW() )")or die('Error137');
}
$q=mysqli_query($connection,"SELECT * FROM history WHERE eid='$eid' AND email='$email' " )or die('Error139');
while($row=mysqli_fetch_array($q) )
{
$s=$row['score'];
$w=$row['wrong'];
}
$w++;
$s=$s-$wrong;
$q=mysqli_query($connection,"UPDATE `history` SET `score`=$s,`level`=$sn,`wrong`=$w, date=NOW() WHERE  email = '$email' AND eid = '$eid'")or die('Error147');
}
if($sn != $total)
{
$sn++;
header("location:account.php?q=quiz&step=2&eid=$eid&n=$sn&t=$total")or die('Error152');
}
else if( $_SESSION['key']!='imymalik2938@')
{
$q=mysqli_query($connection,"SELECT score FROM history WHERE eid='$eid' AND email='$email'" )or die('Error156');
while($row=mysqli_fetch_array($q) )
{
$s=$row['score'];
}
$q=mysqli_query($connection,"SELECT * FROM rank WHERE email='$email'" )or die('Error161');
$rowcount=mysqli_num_rows($q);
if($rowcount == 0)
{
$q2=mysqli_query($connection,"INSERT INTO rank VALUES('$email','$s',NOW())")or die('Error165');
}
else
{
while($row=mysqli_fetch_array($q) )
{
$sun=$row['score'];
}
$sun=$s+$sun;
$q=mysqli_query($connection,"UPDATE `rank` SET `score`=$sun ,time=NOW() WHERE email= '$email'")or die('Error174');
}
header("location:account.php?q=result&eid=$eid");
}
else
{
header("location:account.php?q=result&eid=$eid");
}
}

//restart quiz
if(@$_GET['q']== 'quizre' && @$_GET['step']== 25 ) {
$eid=@$_GET['eid'];
$n=@$_GET['n'];
$t=@$_GET['t'];
$q=mysqli_query($connection,"SELECT score FROM history WHERE eid='$eid' AND email='$email'" )or die('Error156');
while($row=mysqli_fetch_array($q) )
{
$s=$row['score'];
}
$q=mysqli_query($connection,"DELETE FROM `history` WHERE eid='$eid' AND email='$email' " )or die('Error184');
$q=mysqli_query($connection,"SELECT * FROM rank WHERE email='$email'" )or die('Error161');
while($row=mysqli_fetch_array($q) )
{
$sun=$row['score'];
}
$sun=$sun-$s;
$q=mysqli_query($connection,"UPDATE `rank` SET `score`=$sun ,time=NOW() WHERE email= '$email'")or die('Error174');
header("location:account.php?q=quiz&step=2&eid=$eid&n=1&t=$t");
}

?>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

<?php

// include_once 'dbConnection.php';

$connection = mysqli_connect("localhost","root","","online_examination");

session_start();

$email=$_SESSION['email'];

//delete feedback

if(isset($_SESSION['key'])){

if(@$_GET['fdid']) {

$id=@$_GET['fdid'];

$result = mysqli_query($connection,"DELETE FROM feedback WHERE id='$id' ") or die('Error');

header("location:dash.php?q=3");

}

//delete user

if(isset($_SESSION['key'])){

if(@$_GET['demail']) {

$demail=@$_GET['demail'];

$r1 = mysqli_query($connection,"DELETE FROM rank WHERE email='$demail' ") or die('Error');

$r2 = mysqli_query($connection,"DELETE FROM history WHERE email='$demail' ") or die('Error');

$result = mysqli_query($connection,"DELETE FROM user WHERE email='$demail' ") or die('Error');

header("location:dash.php?q=1");

}

//remove quiz

if(isset($_SESSION['key'])){

if(@$_GET['q']== 'rmquiz') {

$eid=@$_GET['eid'];

$result = mysqli_query($connection,"SELECT * FROM questions WHERE eid='$eid' ") or die('Error');

while($row = mysqli_fetch_array($result)) {

$qid = $row['qid'];

$r1 = mysqli_query($connection,"DELETE FROM options WHERE qid='$qid'") or die('Error');

$r2 = mysqli_query($connection,"DELETE FROM answer WHERE qid='$qid' ") or die('Error');

}

$r3 = mysqli_query($connection,"DELETE FROM questions WHERE eid='$eid' ") or die('Error');

$r4 = mysqli_query($connection,"DELETE FROM quiz WHERE eid='$eid' ") or die('Error');

$r4 = mysqli_query($connection,"DELETE FROM history WHERE eid='$eid' ") or die('Error');

header("location:dash.php?q=5");

}

//add quiz

if(isset($_SESSION['key'])){

if(@$_GET['q']== 'addquiz') {

$name = $_POST['name'];

$name= ucwords(strtolower($name));

$total = $_POST['total'];

$sahi = $_POST['right'];

$wrong = $_POST['wrong'];

$time = $_POST['time'];

$tag = $_POST['tag'];

$desc = $_POST['desc'];

$id=uniqid();

$q3=mysqli_query($connection,"INSERT INTO quiz VALUES ('$id','$name' , '$sahi' , '$wrong','$total','$time' ,'$desc','$tag', NOW())");

header("location:dash.php?q=4&step=2&eid=$id&n=$total");

}

//add question

if(isset($_SESSION['key'])){

if(@$_GET['q']== 'addqns') {

$n=@$_GET['n'];

$eid=@$_GET['eid'];

$ch=@$_GET['ch'];

for($i=1;$i<=$n;$i++)

{

$qid=uniqid();

$qns=$_POST['qns'.$i];

$q3=mysqli_query($connection,"INSERT INTO questions VALUES ('$eid','$qid','$qns' , '$ch' , '$i')");

$oaid=uniqid();

$obid=uniqid();

$ocid=uniqid();

$odid=uniqid();

$a=$_POST[$i.'1'];

$b=$_POST[$i.'2'];

$c=$_POST[$i.'3'];

$d=$_POST[$i.'4'];

$qa=mysqli_query($connection,"INSERT INTO options VALUES ('$qid','$a','$oaid')") or die('Error61');

$qb=mysqli_query($connection,"INSERT INTO options VALUES ('$qid','$b','$obid')") or die('Error62');

$qc=mysqli_query($connection,"INSERT INTO options VALUES ('$qid','$c','$ocid')") or die('Error63');

$qd=mysqli_query($connection,"INSERT INTO options VALUES ('$qid','$d','$odid')") or die('Error64');

$e=$_POST['ans'.$i];

switch($e)

{

case 'a':

$ansid=$oaid;

break;

case 'b':

$ansid=$obid;

break;

case 'c':

$ansid=$ocid;

break;

case 'd':

$ansid=$odid;

break;

default:

$ansid=$oaid;

}

$qans=mysqli_query($connection,"INSERT INTO answer VALUES ('$qid','$ansid')");

}

header("location:dash.php?q=0");

}

//quiz start

if(@$_GET['q']== 'quiz' && @$_GET['step']== 2) {

$eid=@$_GET['eid'];

$sn=@$_GET['n'];

$total=@$_GET['t'];

$ans=$_POST['ans'];

$qid=@$_GET['qid'];

$q=mysqli_query($connection,"SELECT * FROM answer WHERE qid='$qid' " );

while($row=mysqli_fetch_array($q) )

{

$ansid=$row['ansid'];

}

if($ans == $ansid)

{

$q=mysqli_query($connection,"SELECT * FROM quiz WHERE eid='$eid' " );

while($row=mysqli_fetch_array($q) )

{

$sahi=$row['sahi'];

}

if($sn == 1)

{

$q=mysqli_query($connection,"INSERT INTO history VALUES('$email','$eid' ,'0','0','0','0',NOW())")or die('Error');

}

$q=mysqli_query($connection,"SELECT * FROM history WHERE eid='$eid' AND email='$email' ")or die('Error115');

while($row=mysqli_fetch_array($q) )

{

$s=$row['score'];

$r=$row['sahi'];

}

$r++;

$s=$s+$sahi;

$q=mysqli_query($connection,"UPDATE `history` SET `score`=$s,`level`=$sn,`sahi`=$r, date= NOW() WHERE email = '$email' AND eid = '$eid'")or die('Error124');

}

else

{

$q=mysqli_query($connection,"SELECT * FROM quiz WHERE eid='$eid' " )or die('Error129');

while($row=mysqli_fetch_array($q) )

{

$wrong=$row['wrong'];

}

if($sn == 1)

{

$q=mysqli_query($connection,"INSERT INTO history VALUES('$email','$eid' ,'0','0','0','0',NOW() )")or die('Error137');

}

$q=mysqli_query($connection,"SELECT * FROM history WHERE eid='$eid' AND email='$email' " )or die('Error139');

while($row=mysqli_fetch_array($q) )

{

$s=$row['score'];

$w=$row['wrong'];

}

$w++;

$s=$s-$wrong;

$q=mysqli_query($connection,"UPDATE `history` SET `score`=$s,`level`=$sn,`wrong`=$w, date=NOW() WHERE email = '$email' AND eid = '$eid'")or die('Error147');

}

if($sn != $total)

{

$sn++;

header("location:account.php?q=quiz&step=2&eid=$eid&n=$sn&t=$total")or die('Error152');

}

else if( $_SESSION['key']!='imymalik2938@')

{

$q=mysqli_query($connection,"SELECT score FROM history WHERE eid='$eid' AND email='$email'" )or die('Error156');

while($row=mysqli_fetch_array($q) )

{

$s=$row['score'];

}

$q=mysqli_query($connection,"SELECT * FROM rank WHERE email='$email'" )or die('Error161');

$rowcount=mysqli_num_rows($q);

if($rowcount == 0)

{

$q2=mysqli_query($connection,"INSERT INTO rank VALUES('$email','$s',NOW())")or die('Error165');

}

else

{

while($row=mysqli_fetch_array($q) )

{

$sun=$row['score'];

}

$sun=$s+$sun;

$q=mysqli_query($connection,"UPDATE `rank` SET `score`=$sun ,time=NOW() WHERE email= '$email'")or die('Error174');

}

header("location:account.php?q=result&eid=$eid");

}

else

{

header("location:account.php?q=result&eid=$eid");

}

//restart quiz

if(@$_GET['q']== 'quizre' && @$_GET['step']== 25 ) {

$eid=@$_GET['eid'];

$n=@$_GET['n'];

$t=@$_GET['t'];

$q=mysqli_query($connection,"SELECT score FROM history WHERE eid='$eid' AND email='$email'" )or die('Error156');

while($row=mysqli_fetch_array($q) )

{

$s=$row['score'];

}

$q=mysqli_query($connection,"DELETE FROM `history` WHERE eid='$eid' AND email='$email' " )or die('Error184');

$q=mysqli_query($connection,"SELECT * FROM rank WHERE email='$email'" )or die('Error161');

while($row=mysqli_fetch_array($q) )

{

$sun=$row['score'];

}

$sun=$sun-$s;

$q=mysqli_query($connection,"UPDATE `rank` SET `score`=$sun ,time=NOW() WHERE email= '$email'")or die('Error174');

header("location:account.php?q=quiz&step=2&eid=$eid&n=1&t=$t");

}

Download code of Online Examination System IMPLEMENTATION Online Examination System is designed from user point of view and user-friendly design of our application helps the user in accomplishing their task with ease. We have made attempt to keep design simple and easy to understand. …

Code of Online Examination System Read More »

Car Parking management System Code in PHP

Leave a Comment / PHP Projects / By Projects Inventory

Source Code in PHP for Car Parking management System. checkparking.php

<?php
include "connect.php";
session_start();
if(!isset($_SESSION['operatorid']))
{
  header("Location:{$hostname}/bps/operator.html");
  }

?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="UTF-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    
    <link rel="stylesheet" href="styledashboard.css" />
    <title>ADMIN DASHBOARD</title>
    <link rel="stylesheet" type="text/css" href="style.css">
    <style>
      body{
        background-color: whitesmoke;
        
      }
      input
      {
        width: 40%;
        height: 5%;
        border: 1px;
        border-radius: 05px;
        padding: 8px 15px 8px 15px;
        margin: 10px 0px 15px 0px;
        box-shadow: 1px 1px  2px 1px gray;
      }
    </style>
      
    
  </head>
  
  <body id="body">
    <div class="container">
      <nav class="navbar">
        <div class="nav_icon" onclick="toggleSidebar()">
          <i class="fa fa-bars" aria-hidden="true"></i>
        </div>
        <div class="navbar__left">
          <a href="#">BIMS PARKING SYSTEM </a>
          
        </div>
        
        <div class="navbar__right">
          
            <img width="30" src="adminpic.PNG" alt="" />
            <!-- <i class="fa fa-user-circle-o" aria-hidden="true"></i> -->
          
        </div>
      </nav>
      <main>
        
        <center>
          <div>
            <video id="preview" width="600px" height="200px"></video>
          </div>
          <form action="operatorautomatic.html" method="POST">
            
            <input type="text" id="search" placeholder="Enter ID To Search" name="search" required/><br>
            <input type="submit" name="Search-Data" value="Search-Data" id="searchh">

          </form>
          <script>
            let scanner = new Instascan.Scanner({ video: document.getElementById('preview')});
            Instascan.Camera.getCameras().then(function(cameras){
                if(cameras.length > 0 ){
                    scanner.start(cameras[0]);
                } else{
                    alert('No cameras found');
                }
 
            }).catch(function(e) {
                console.error(e);
            });
 
            scanner.addListener('scan',function(c){
                document.getElementById('search').value=c;
                document.forms[0].submit();
                
                
            });
 
         </script>

         <!-- <?php
          date_default_timezone_set('Asia/Karachi');
          
          error_reporting(0);
            include "connect.php";
           if(isset($_POST['Search-Data']))
           {
             $id = $_POST['search'];
             $sql1 = "SELECT PID,Name,Vehicle FROM person_tbl WHERE PID = $id";
             $run1 = mysqli_query($conn,$sql1);
             while($row = mysqli_fetch_array($run1))
             {
               ?>
               <form action="<?php $_SERVER['PHP_SELF'];?>" method="POST">
                 <input type="text" name="pid" value="<?php echo $row['PID'] ?>" required/> <br>
                 <input type="text" name="name" value="<?php echo $row['Name'] ?>" required/> <br>
                 <input type="text" name="vehicle" value="<?php echo $row['Vehicle'] ?>" required/> <br>
                <input type="text" name="todaydate" value="<?php echo date('d-M-Y'); ?>"> <br>
                <input type="text" name="timein" value="<?php echo date('h-i-A'); ?>"> <br>
                <input type="text" name="timeout" value="<?php echo date('h-i-A'); ?>"> <br>
                <input type="submit" name="enterparking" value="Submit">
               </form> </center>
               <?php
              
             }

           }
           if(isset($_POST['enterparking']))
           {
            $pid = $_POST['pid'];
            $name = $_POST['name'];
            $vehicle = $_POST['vehicle'];
            $todaydate = $_POST['todaydate'];
            $timein = $_POST['timein'];
            $timeout = $_POST['timeout'];
            $sql5 = "SELECT * FROM parking_tbl WHERE PID ='$pid' AND Name='$name' AND Date ='$todaydate' AND Timeout =''";
            $query=$conn->query($sql5);
            if($query->num_rows>0){
              $sql6="UPDATE parking_tbl SET Timeout='$timeout' WHERE PID ='$pid' AND Name='$name' AND Date ='$todaydate' AND Timeout =''"; 
              $query=$conn->query($sql6);
            }
            else
            {
              $sql2 = "INSERT INTO parking_tbl(PID,Name,Vehicle,Date,Timein) values ($pid,'$name','$vehicle','$todaydate','$timein')";
                     $run2 = mysqli_query($conn,$sql2);
                     if($run2)
                     {
                       echo 'register';
                     }
                     else
                     {
                       echo 'not register';
                     }
            }
            
           }
          ?>  -->
       
        <div class="main__container">
          <!-- MAIN TITLE STARTS HERE -->

          <div class="main__title">
            <img src="adminpic.PNG" alt="" />
            <div class="main__greeting">
              
            
            </div>
          </div>
        </div>
    
        
           
           
            
      </main>
      
      <div id="sidebar">
        <div class="sidebar__title">
          <div class="sidebar__img">
            
            <h1>BIMS PARKING SYSTEM</h1>
            
          </div>
          <i
            onclick="closeSidebar()"
            class="fa fa-times"
            id="sidebarIcon"
            aria-hidden="true"
          ></i>
        </div>

        <div class="sidebar__menu">
          <div class="sidebar__link">
            <i class="fa fa-home"></i>
            <a href="operatordashboard.html">Dashboard</a>
          </div>
          
         
          <div class="sidebar__link active_menu_link">
            <i class=></i>
            <a href="insertparkingdetail.html">Insert Parking Details</a>
          </div>
          
          <div class="sidebar__link">
            <i class=></i>
            <a href="operatorviewpersondetail.html">View Person Details</a>
          </div>
          <div class="sidebar__link">
            <i class=></i>
            <a href="operatorviewparkingdetail.html">View Parking Details</a>
          </div>
          
         
          
          
          <div class="sidebar__logout">
            <i class="fa fa-power-off"></i>
            <a href="operatorlogout.php">Log out</a>
          </div>
        </div>
      </div>
    </div>
    <script src="https://cdn.jsdelivr.net/npm/apexcharts"></script>
    <script src="script.js"></script>
  </body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

<?php

include "connect.php";

session_start();

if(!isset($_SESSION['operatorid']))

{

header("Location:{$hostname}/bps/operator.html");

}

<!DOCTYPE html>

<head>

<title>ADMIN DASHBOARD</title>

<style>

body{

background-color: whitesmoke;

}

input

{

width: 40%;

height: 5%;

border: 1px;

border-radius: 05px;

padding: 8px 15px 8px 15px;

margin: 10px 0px 15px 0px;

box-shadow: 1px 1px 2px 1px gray;

}

</style>

</head>

</div>

<a href="#">BIMS PARKING SYSTEM </a>

</div>

</div>

</nav>

<main>

<div>

</div>

</form>

let scanner = new Instascan.Scanner({ video: document.getElementById('preview')});

Instascan.Camera.getCameras().then(function(cameras){

if(cameras.length > 0 ){

scanner.start(cameras[0]);

} else{

alert('No cameras found');

}

}).catch(function(e) {

console.error(e);

});

scanner.addListener('scan',function(c){

document.getElementById('search').value=c;

document.forms[0].submit();

});

</script>

<!-- <?php

date_default_timezone_set('Asia/Karachi');

error_reporting(0);

include "connect.php";

if(isset($_POST['Search-Data']))

{

$id = $_POST['search'];

$sql1 = "SELECT PID,Name,Vehicle FROM person_tbl WHERE PID = $id";

$run1 = mysqli_query($conn,$sql1);

while($row = mysqli_fetch_array($run1))

{

<form action="<?php $_SERVER['PHP_SELF'];?>" method="POST">

<input type="text" name="pid" value="<?php echo $row['PID'] ?>" required/> <br>

<input type="text" name="name" value="<?php echo $row['Name'] ?>" required/> <br>

<input type="text" name="vehicle" value="<?php echo $row['Vehicle'] ?>" required/> <br>

</form> </center>

<?php

}

if(isset($_POST['enterparking']))

{

$pid = $_POST['pid'];

$name = $_POST['name'];

$vehicle = $_POST['vehicle'];

$todaydate = $_POST['todaydate'];

$timein = $_POST['timein'];

$timeout = $_POST['timeout'];

$sql5 = "SELECT * FROM parking_tbl WHERE PID ='$pid' AND Name='$name' AND Date ='$todaydate' AND Timeout =''";

$query=$conn->query($sql5);

if($query->num_rows>0){

$sql6="UPDATE parking_tbl SET Timeout='$timeout' WHERE PID ='$pid' AND Name='$name' AND Date ='$todaydate' AND Timeout =''";

$query=$conn->query($sql6);

}

else

{

$sql2 = "INSERT INTO parking_tbl(PID,Name,Vehicle,Date,Timein) values ($pid,'$name','$vehicle','$todaydate','$timein')";

$run2 = mysqli_query($conn,$sql2);

if($run2)

{

echo 'register';

}

else

{

echo 'not register';

}

?> -->

</div>

</main>

<h1>BIMS PARKING SYSTEM</h1>

</div>

onclick="closeSidebar()"

class="fa fa-times"

id="sidebarIcon"

aria-hidden="true"

></i>

</div>

<a href="operatordashboard.html">Dashboard</a>

</div>

<a href="insertparkingdetail.html">Insert Parking Details</a>

</div>

<a href="operatorviewpersondetail.html">View Person Details</a>

</div>

<a href="operatorviewparkingdetail.html">View Parking Details</a>

</div>

</div>

</body>

</html>

dashboard.php

<?php
include "connect.php";
session_start();
if(!isset($_SESSION['userid']))
{
  header("Location:{$hostname}/bps/admin_login.html");
  }
  $query = "SELECT PID FROM person_tbl";
  $query_run = mysqli_query($conn,$query);
  $rows = mysqli_num_rows($query_run);

  $dates= date('d-M-Y');
  

  $query2 = "SELECT Timein FROM parking_tbl WHERE Date = '$dates'";
  $query_run2 = mysqli_query($conn,$query2);
  $rows2 = mysqli_num_rows($query_run2); 

   
  $query3 = "SELECT Timeout FROM parking_tbl WHERE Timeout !='' AND Date = '$dates'";
  $query_run3 = mysqli_query($conn,$query3);
  $rows3 = mysqli_num_rows($query_run3); 
  

?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="UTF-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <link
      rel="stylesheet"
      href="https://stackpath.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css"
      integrity="sha384-wvfXpqpZZVQGK6TAh5PVlGOfQNHSoD2xbE+QkPxCAFlNEevoEH3Sl0sibVcOQVnN"
      crossorigin="anonymous"
    />
    <link rel="stylesheet" href="styledashboard.css" />
    <title>ADMIN DASHBOARD</title>
    <link rel="stylesheet" type="text/css" href="style.css">
    <style>
        *{
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }
        body {
            min-height: 100vh;
            //display: flex;
            font-family: sans-serif;
            background: #eee;
        }
        .mycontainer
        {
            margin: auto;
            width: 500px;
            max-width: 90%;
        }
        .mycontainer form{
            width: 100%;
            height: 100%;
            padding: 20px;
            background: white;
            border-radius: 4px;
            box-shadow: 0 8px 16px rgb(0, 0,0,.3);
        } 
        .mycontainer form h1{
            text-align: center;
            margin-bottom: 24px;
            color: #222;
        }
        .mycontainer form .form-control{
            width: 100%;
            height: 40px;
            background: white;
            border-radius: 4px;
            border: 1px solid silver;
            margin: 10px 0 18px 0;
            padding: 0 10px;
        }
        .mycontainer form .btn {
          margin-left: 50%;
          transform: translateX(-50%);
          width: 120px;
          height: 34px;
          border: none;
          outline: none;
          background: #27a327;
          cursor: pointer;
          font-size: 16px;
          color: white;
          text-transform: uppercase;
          border-radius: 4px;
          transition: .3s;
        }
        .mycontainer form .btn:hover
        {
            opacity: .7;
        }
        .mustafa
        {
          
          
          
        }
        .mustafa1
        {
          background-color:#27a327;
          margin: 0px 70px 2px 50px;
          float: left;
          width: 300px;
          height: 150px;
        }

    </style>
  </head>
  
  <body id="body">
    <div class="container">
      <nav class="navbar">
        <div class="nav_icon" onclick="toggleSidebar()">
          <i class="fa fa-bars" aria-hidden="true"></i>
        </div>
        <div class="navbar__left">
          <a href="#">BIMS PARKING SYSTEM </a>
        </div>
        <div class="navbar__right">
          
            <img width="30" src="adminpic.PNG" alt="" />
            <!-- <i class="fa fa-user-circle-o" aria-hidden="true"></i> -->
          
        </div>
      </nav>

      <main>
        <div class="main__container">
          <!-- MAIN TITLE STARTS HERE -->

          <div class="main__title">
            <img src="assets/hello.svg" alt="" />
            <div class="main__greeting">
              <h1>Hello Admin</h1>
              <p>Welcome to your admin dashboard</p>
            </div>
          </div>

          <!-- MAIN TITLE ENDS HERE -->

          <!-- MAIN CARDS STARTS HERE -->
          <div class="main__cards">
            <div class="card">
              <i
                class="fa fa-user-o fa-2x text-lightblue"
                aria-hidden="true"
              ></i>
              <div class="card_inner">
                <?php

                ?>
                <p class="text-primary-p">Number Of Register Person</p>
                <span class="font-bold text-title"><?php echo '<h1>'.$rows.'</h1>';?></span>
              </div>
            </div>

            <div class="card">
              <i class="fa fa-user-o fa-2x text-lightblue" aria-hidden="true"></i>
              <div class="card_inner">
                <p class="text-primary-p">Person Check-In</p>
                <span class="font-bold text-title"><?php echo '<h1>'.$rows2.'</h1>';?></span>
              </div>
            </div>

            <div class="card">
              <i
                class="fa fa-user-o fa-2x text-lightblue"
                aria-hidden="true"
              ></i>
              <div class="card_inner">
                <p class="text-primary-p">Person Check-Out</p>
                <span class="font-bold text-title"><?php echo '<h1>'.$rows3.'</h1>';?></span>
              </div>
            </div>

            
        </div>
        
        
            
      </main>
      
      <div id="sidebar">
        <div class="sidebar__title">
          <div class="sidebar__img">
            
            <h1>BIMS PARKING SYSTEM</h1>
          </div>
          <i
            onclick="closeSidebar()"
            class="fa fa-times"
            id="sidebarIcon"
            aria-hidden="true"
          ></i>
        </div>

        <div class="sidebar__menu">
          <div class="sidebar__link active_menu_link">
            <i class="fa fa-home"></i>
            <a href="dashboard.html">Dashboard</a>
          </div>
          
          <div class="sidebar__link">
            <i class= aria-hidden="true"></i>
            <a href="registerperson.html">Register Person</a>
          </div>
          <div class="sidebar__link">
            <i class=></i>
            <a href="manageperson.html">Manage Person Details</a>
          </div>
          
          <div class="sidebar__link">
            <i class=></i>
            <a href="viewpersondetail.html">View Person Details</a>
          </div>
          <div class="sidebar__link">
            <i class=></i>
            <a href="viewparkingdetail.html">View Parking Details</a>
          </div>
          
         
          
          
          <div class="sidebar__logout">
            <i class="fa fa-power-off"></i>
            <a href="logout.php">Log out</a>
          </div>
        </div>
      </div>
    </div>
    <script src="https://cdn.jsdelivr.net/npm/apexcharts"></script>
    <script src="script.js"></script>
  </body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

<?php

include "connect.php";

session_start();

if(!isset($_SESSION['userid']))

{

header("Location:{$hostname}/bps/admin_login.html");

}

$query = "SELECT PID FROM person_tbl";

$query_run = mysqli_query($conn,$query);

$rows = mysqli_num_rows($query_run);

$dates= date('d-M-Y');

$query2 = "SELECT Timein FROM parking_tbl WHERE Date = '$dates'";

$query_run2 = mysqli_query($conn,$query2);

$rows2 = mysqli_num_rows($query_run2);

$query3 = "SELECT Timeout FROM parking_tbl WHERE Timeout !='' AND Date = '$dates'";

$query_run3 = mysqli_query($conn,$query3);

$rows3 = mysqli_num_rows($query_run3);

<!DOCTYPE html>

<head>

<link

rel="stylesheet"

href="https://stackpath.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css"

integrity="sha384-wvfXpqpZZVQGK6TAh5PVlGOfQNHSoD2xbE+QkPxCAFlNEevoEH3Sl0sibVcOQVnN"

crossorigin="anonymous"

<title>ADMIN DASHBOARD</title>

<style>

margin: 0;

padding: 0;

box-sizing: border-box;

}

body {

min-height: 100vh;

//display: flex;

font-family: sans-serif;

background: #eee;

}

.mycontainer

{

margin: auto;

width: 500px;

max-width: 90%;

}

.mycontainer form{

width: 100%;

height: 100%;

padding: 20px;

background: white;

border-radius: 4px;

box-shadow: 0 8px 16px rgb(0, 0,0,.3);

}

.mycontainer form h1{

text-align: center;

margin-bottom: 24px;

color: #222;

}

.mycontainer form .form-control{

width: 100%;

height: 40px;

background: white;

border-radius: 4px;

border: 1px solid silver;

margin: 10px 0 18px 0;

padding: 0 10px;

}

.mycontainer form .btn {

margin-left: 50%;

transform: translateX(-50%);

width: 120px;

height: 34px;

border: none;

outline: none;

background: #27a327;

cursor: pointer;

font-size: 16px;

color: white;

text-transform: uppercase;

border-radius: 4px;

transition: .3s;

}

.mycontainer form .btn:hover

{

opacity: .7;

}

.mustafa

{

}

.mustafa1

{

background-color:#27a327;

margin: 0px 70px 2px 50px;

float: left;

width: 300px;

height: 150px;

}

</style>

</head>

</div>

<a href="#">BIMS PARKING SYSTEM </a>

</div>

</div>

</nav>

<main>

<h1>Hello Admin</h1>

<p>Welcome to your admin dashboard</p>

</div>

class="fa fa-user-o fa-2x text-lightblue"

aria-hidden="true"

></i>

<?php

<p class="text-primary-p">Number Of Register Person</p>

</div>

<p class="text-primary-p">Person Check-In</p>

</div>

class="fa fa-user-o fa-2x text-lightblue"

aria-hidden="true"

></i>

<p class="text-primary-p">Person Check-Out</p>

</div>

</main>

<h1>BIMS PARKING SYSTEM</h1>

</div>

onclick="closeSidebar()"

class="fa fa-times"

id="sidebarIcon"

aria-hidden="true"

></i>

</div>

<a href="dashboard.html">Dashboard</a>

</div>

<a href="registerperson.html">Register Person</a>

</div>

<a href="manageperson.html">Manage Person Details</a>

</div>

<a href="viewpersondetail.html">View Person Details</a>

</div>

<a href="viewparkingdetail.html">View Parking Details</a>

</div>

</div>

</body>

</html>

insertparkingdetail.php

<?php
include "connect.php";
session_start();
if(!isset($_SESSION['operatorid']))
{
  header("Location:{$hostname}/bps/operator.html");
  }

?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="UTF-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
   
    <link
      rel="stylesheet"
      href="https://stackpath.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css"
      integrity="sha384-wvfXpqpZZVQGK6TAh5PVlGOfQNHSoD2xbE+QkPxCAFlNEevoEH3Sl0sibVcOQVnN"
      crossorigin="anonymous"
    />
    <link rel="stylesheet" href="styledashboard.css" />
    <title>OPERATOR DASHBOARD</title>
    <link rel="stylesheet" type="text/css" href="style.css">
    <style>
      body{
        background-color: whitesmoke;
        
      }
      .form-controls
      {
        width: 300px;
        height: 30px;
      }
      .my-buttonn
      {
        font-size: 18px;
    font-weight: 600;
    text-transform: uppercase;
    padding: 3px 7px;
    color: #ffffff;
    background-color: #009879;
    text-decoration: none;
    border-radius: 3px;
  border-color: #009879;
box-shadow: none;
        width: 100px;
        height: 35px;}
      input
      {
        width: 40%;
        height: 5%;
        border: 1px;
        border-radius: 05px;
        padding: 8px 15px 8px 15px;
        margin: 10px 0px 15px 0px;
        box-shadow: 1px 1px  2px 1px gray;
        font-size: 18px;
      }
    </style>
      
    
  </head>
  
  <body id="body">
    <div class="container">
      <nav class="navbar">
        <div class="nav_icon" onclick="toggleSidebar()">
          <i class="fa fa-bars" aria-hidden="true"></i>
        </div>
        <div class="navbar__left">
          <a href="#">BIMS PARKING SYSTEM </a>
          
        </div>
        
        <div class="navbar__right">
          
            <img width="30" src="adminpic.PNG" alt="" />
            <!-- <i class="fa fa-user-circle-o" aria-hidden="true"></i> -->
          
        </div>
      </nav>
      <main>
        
        <center>
          <div>
            <video id="preview" width="800px" height="300px"></video>
          </div>
          <form action="operatorautomatic.html" method="POST">
            
            <input type="text" id="search" class="form-controls" placeholder="Enter ID To Search" name="search" required/><br>
            <input type="submit" name="Search-Data" value="Search" id="searchh" class="my-buttonn" >

          </form>
          <script>
            let scanner = new Instascan.Scanner({ video: document.getElementById('preview')});
            Instascan.Camera.getCameras().then(function(cameras){
                if(cameras.length > 0 ){
                    scanner.start(cameras[0]);
                } else{
                    alert('No cameras found');
                }
 
            }).catch(function(e) {
                console.error(e);
            });
              
              
            scanner.addListener('scan',function(c){
                document.getElementById('search').value=c;
                document.forms[0].submit();
            
                
                
            });
 
         </script>

         
       
        <div class="main__container">
          <!-- MAIN TITLE STARTS HERE -->

          <div class="main__title">
            <img src="adminpic.PNG" alt="" />
            <div class="main__greeting">
              
            
            </div>
          </div>
        </div>
    
        
           
           
            
      </main>
      
      <div id="sidebar">
        <div class="sidebar__title">
          <div class="sidebar__img">
            
            <h1>BIMS PARKING SYSTEM</h1>
            
          </div>
          <i
            onclick="closeSidebar()"
            class="fa fa-times"
            id="sidebarIcon"
            aria-hidden="true"
          ></i>
        </div>

        <div class="sidebar__menu">
          <div class="sidebar__link">
            <i class="fa fa-home"></i>
            <a href="operatordashboard.html">Dashboard</a>
          </div>
          
         
          <div class="sidebar__link active_menu_link">
            <i class=></i>
            <a href="insertparkingdetail.html">Insert Parking Details</a>
          </div>
          
          <div class="sidebar__link">
            <i class=></i>
            <a href="operatorviewpersondetail.html">View Person Details</a>
          </div>
          <div class="sidebar__link">
            <i class=></i>
            <a href="operatorviewparkingdetail.html">View Parking Details</a>
          </div>
          
         
          
          
          <div class="sidebar__logout">
            <i class="fa fa-power-off"></i>
            <a href="operatorlogout.php">Log out</a>
          </div>
        </div>
      </div>
    </div>
  
    <script src="https://cdn.jsdelivr.net/npm/apexcharts"></script>
    <script src="script.js"></script>
    
   
                      
    
  </body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

<?php

include "connect.php";

session_start();

if(!isset($_SESSION['operatorid']))

{

header("Location:{$hostname}/bps/operator.html");

}

<!DOCTYPE html>

<head>

<link

rel="stylesheet"

href="https://stackpath.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css"

integrity="sha384-wvfXpqpZZVQGK6TAh5PVlGOfQNHSoD2xbE+QkPxCAFlNEevoEH3Sl0sibVcOQVnN"

crossorigin="anonymous"

<title>OPERATOR DASHBOARD</title>

<style>

body{

background-color: whitesmoke;

}

.form-controls

{

width: 300px;

height: 30px;

}

.my-buttonn

{

font-size: 18px;

font-weight: 600;

text-transform: uppercase;

padding: 3px 7px;

color: #ffffff;

background-color: #009879;

text-decoration: none;

border-radius: 3px;

border-color: #009879;

box-shadow: none;

width: 100px;

height: 35px;}

input

{

width: 40%;

height: 5%;

border: 1px;

border-radius: 05px;

padding: 8px 15px 8px 15px;

margin: 10px 0px 15px 0px;

box-shadow: 1px 1px 2px 1px gray;

font-size: 18px;

}

</style>

</head>

</div>

<a href="#">BIMS PARKING SYSTEM </a>

</div>

</div>

</nav>

<main>

<div>

</div>

</form>

let scanner = new Instascan.Scanner({ video: document.getElementById('preview')});

Instascan.Camera.getCameras().then(function(cameras){

if(cameras.length > 0 ){

scanner.start(cameras[0]);

} else{

alert('No cameras found');

}

}).catch(function(e) {

console.error(e);

});

scanner.addListener('scan',function(c){

document.getElementById('search').value=c;

document.forms[0].submit();

});

</script>

</div>

</main>

<h1>BIMS PARKING SYSTEM</h1>

</div>

onclick="closeSidebar()"

class="fa fa-times"

id="sidebarIcon"

aria-hidden="true"

></i>

</div>

<a href="operatordashboard.html">Dashboard</a>

</div>

<a href="insertparkingdetail.html">Insert Parking Details</a>

</div>

<a href="operatorviewpersondetail.html">View Person Details</a>

</div>

<a href="operatorviewparkingdetail.html">View Parking Details</a>

</div>

</div>

</body>

</html>

Download free Car Parking management System Code in PHP More Helping material for project of Car Parking System Non Functional Requirements of Vehicle Parking System Functional Requirements of Car Parking System Non Functional Requirements of Vehicle Parking System Use Case Description …

Car Parking management System Code in PHP Read More »

Code of Live Betting Management System in PHP

Leave a Comment / PHP Projects, SRS Document / By Projects Inventory

Functional Requirements of Live Betting Management System Easy To play Game. Easy to Add Balance System. Easy To Withdraw. The user can modify Profile Photo Automatic Payment Method will be Paypal or credit card. The user can include complete History. ID to ID Balance Transfer. The user must able to work with Affiliation System. The …

Code of Live Betting Management System in PHP Read More »

Exams Question Paper Maker Code in PHP

Leave a Comment / Functional Non Functional Requirements of Projects, PHP Projects, SRS Document / By Projects Inventory

Exams Question Paper Maker Code in PHP This simple Final Year Project for BSCS and BSSE is titles as Exams Question Paper Maker System. This Final Year Project for BSCS and BSSE is a web application and its developed in PHP and by using the MySQL Database in XAMPP. The Final Year Project for BSCS …

Exams Question Paper Maker Code in PHP Read More »

User Authentication code in PHP for Laser marking website

Leave a Comment / PHP Projects / By Projects Inventory

Signup, Login and logout code in PHP for Laser marking website Here i am sharing source code with you in PHP and MySQL. If you are unaware that how laser marking works, then you can check the detail about laser marking provide by LASIT. “LASIT is an international company that works with passion and dedication …

User Authentication code in PHP for Laser marking website Read More »

Code of Content Management System in PHP [Project]

Leave a Comment / PHP Projects / By Projects Inventory

Code of Content Management System in PHP [Project] The Content Management System for content creators is a simple PHP/MySQLi final year project that handles the contents of a simple Blog for bloggers. The Content Management System has an Admin Panel where the administrator can manage the contents of the pages. The “Categories” in this The …

Code of Content Management System in PHP [Project] Read More »

Barcode Generator Code in PHP

Leave a Comment / PHP Projects / By Projects Inventory

Barcode Generator Code in PHP The Barcode Generator in PHP is a final year project for BSCS BSIT and MCS studensts. For this project, Generate a barcode dynamically Generate a barcode in code of your choice. Generate a barcode in desired type of card. Functional requirements of Barcode Generator in PHP We can generate a …

Barcode Generator Code in PHP Read More »

Code of Online E Medicine Store Management System in PHP

Leave a Comment / PHP Projects / By Projects Inventory

Free Code download for Online E Medicine Store Management System in PHP This Online E Medicine Store Management System is a PHP Project that insert, delete, view, update and search the records of a certain clinic. This project stores the list of Patients, Drugs, Diagnoses, and other relevant data for the clinics/hospitals. The system records the patient’s Examination information, Laboratory Results, and Prescriptions. This Online E Medicine Store Management System System has …

Code of Online E Medicine Store Management System in PHP Read More »

Inventory Management System Project in PHP – Source Code

Leave a Comment / PHP Projects / By Projects Inventory

Inventory Management System Project in PHP – Source Code The inventory management system permits to the management of the day-to-day inventory of an organization The inventory management system permits the users to export into xlsx (excel) file or CSV file and also ready to print. The admin can also set up role permission for other members or …

Inventory Management System Project in PHP – Source Code Read More »