|
Server IP : 103.191.208.227 / Your IP : 18.219.94.17 Web Server : LiteSpeed System : Linux emphasis.herosite.pro 4.18.0-553.8.1.lve.el8.x86_64 #1 SMP Thu Jul 4 16:24:39 UTC 2024 x86_64 User : mhmsfzcs ( 1485) PHP Version : 8.1.31 Disable Function : show_source, system, shell_exec, passthru, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/mhmsfzcs/vflyorions.com/.well-known/../../www/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include "db.php";
include "job/admin_header.php";
include "admin_sidebar.php";
?>
<main id="main" class="main">
<div class="pagetitle">
<nav>
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="index.php">Home</a></li>
<li class="breadcrumb-item active">Dashboard</li>
</ol>
</nav>
</div>
<!-- End Page Title-->
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper" style="height: 38rem;" >
<!-- Content Header (Page header) -->
<section class="content-header">
<div class="container-fluid">
<div class="card card-primary">
<div class="card-header">
<h3 class="card-title"style="font-family: Times New Roman;font-size: 22px;">
<b>Candidate Form Submission</b>
</h3>
</div>
<?php
$query1 = 'SELECT * FROM profile';
$result = $conn->query($query1);
$sr=1;
?>
<div class="card-body">
<table id="example1" class="table table-bordered table-striped datatable">
<thead>
<tr>
<th>Sr.No</th>
<th>Name</th>
<th>Username</th>
<th>Form Submitted</th>
</tr>
</thead>
<tbody>
<?php while ($row = $result->fetch_assoc()) { $id=$row['id']; ?>
<tr>
<td><?php echo $sr;?></td>
<td><?= $row['fullname']; ?> </td>
<td><?= $row['username']; ?></td>
<?php
$fetch1=("SELECT COUNT(*) as id from forms Where user_id= $id ");
$result1 = $conn->query($fetch1);
while($row1=$result1->fetch_assoc())
{
$sub=$row1['id'];
?>
<td><?php echo $sub;?></td>
<?php
}
?>
</tr>
<?php $sr=$sr+1;} ?>
</tbody>
</table>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</div>
<!-- /.container-fluid -->
</section>
<!-- /.content -->
</div>
</main>
<!-- End #main -->
<?php
include "footer.php";
?>