File "home-notification-list.php"
Full path: /home/eshuaesb/public_html/www.mhawaterpark.com/admin/home-notification-list.php
File
size: 0.01 KB (5.35 KB bytes)
MIME-type: text/x-php
Charset: utf-8
Download Open Edit Advanced Editor Back
<?php include("auth.php") ?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta content="width=device-width, initial-scale=1.0" name="viewport">
<title>Notification List</title>
<meta content="" name="description">
<meta content="" name="keywords">
<?php include("templates/inc.php"); ?>
<script src="scripts/home-notification.js" type="text/javascript" language="javascript"></script>
</head>
<body>
<!-- ======= Header ======= -->
<?php
include("templates/header.php");
?>
<!-- End Header -->
<!-- ======= Sidebar ======= -->
<?php
include("templates/sidebar.php");
?>
<!-- End Sidebar-->
<main id="main" class="main">
<div class="pagetitle">
<h1>Notification List</h1>
<nav>
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
<li class="breadcrumb-item">Notification</li>
</ol>
</nav>
<hr>
</div><!-- End Page Title -->
<section class="section">
<a href="home-notification.php">
<button type="button" class="btn btn-primary"><i class="bi bi-plus me-1"></i> Add New Notification</button>
</a></br></br>
<section class="section">
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-body table-responsive" id="records">
<h5 class="card-title">Notification List</h5>
<!-- Table with stripped rows -->
<table class="table datatable table-striped">
<thead>
<tr>
<th scope="col">Sl</th>
<th scope="col">UserName</th>
<th scope="col">Mobile</th>
<th scope="col">Notification</th>
<!-- <th scope="col">Status</th> -->
<th scope="col" colspan="2">Action</th>
</tr>
</thead>
<tbody>
<?php
require "conn.php";
$sl = 1;
function getUserName($uid)
{
require "conn.php";
$res="";
$sql = "select * from tbl_user where mobile='$uid'";
$rs = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($rs);
if($row['uname'])
$res=$row['uname'];
return($res);
}
$sql = "select * from tbl_notification where deleted_at is NULL order by id desc";
$rs = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($rs)) {
echo "<tr>";
echo '<td>' . $sl . '</td>';
echo '<td>' . getUserName($row['uid']) . '</td>';
echo '<td>' . $row['uid'] . '</td>';
echo '<td>' . $row['notification'] . '</td>';
// echo '<td>' . $row['url_link'] . '</td>';
// echo '<td>' . $row['status'] . '</td>';
echo '<td><a href="home-notification.php?action=' . base64_encode("Edit") . '&id=' . base64_encode($row['id']) . '" class="btn btn-primary"><i class="bi bi-pencil"></i></a>
<button id=' . $row['id'] . ' class="btn btn-danger delete"><i class="bi bi-trash"></i></button></td>';
echo "</tr>";
$sl++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</section>
</main><!-- End #main -->
<!-- ======= Footer ======= -->
<?php
include("templates/footer.php");
?>
<!-- End Footer -->
<?php include("templates/vendors.php"); ?>
</body>
</html>