display and search at the table in the same time and fetch
Can you help me I want to display and search at the table in the same time and fetch those results and show the table but it does not work. I provided my code below to ask if you can help me
<?php
session_start();
if (!isset($_SESSION['username']))
header("location: login.php");
{
//Authentication and Authorization logic here
}
?>
<!DOCTYPE html>
<html>
<head>
<link rel="shortcut icon" href="file/images/favicon.ico" />
<title>View All Records</title>
<link rel="stylesheet" href="/write_font_awesome_url"/>
<link rel="stylesheet" href="file/css/records_style.css">
</head>
<a href="home1.php"><img class="backarrow"src="file/images/backarrow.png" width="30" height="30"></a></br>
<style>
/*write your css code here*/
</style>
<body>
<?php include 'search.php'; ?>
<a href= "add_record.php"><button class="btn"><br>Add New Record</button></a><br>
<div>
<table class="table_style" >
<?php
include 'database_connection.php';
$query="SELECT `id`, `lastname`, `firstname`, `middlename`, `nameextension`, `gender`, `age`, `birthday`, `province`, `city_municipality`, `street`, `address1`, `address2`, `address3`, `category`, `firstdose`, `seconddose` FROM `record`";
$result = mysqli_query($con,$query);
if(mysqli_num_rows($result) > 0){
echo "<tr>
<th>No.</th>
<th>Last Name</th>
<th>First Name</th>
<th>Middle Name</th>
<th>Suffix</th>
<th>Gender</th>
<th>Age</th>
<th>Birth Date</th>
<th>Province</th>
<th>City/Municipality</th>
<th>Street</th>
<th>Address 1</th>
<th>Address 2</th>
<th>Address 3</th>
<th>Category</th>
<th>First Dose</th>
<th>Second Dose</th>
</tr>";
while ($row = mysqli_fetch_array($result)) {
echo "<tr>
<td>".$row['id']."</td>
<td>".$row['lastname']."</td>
<td>".$row['firstname']."</td>
<td>".$row['middlename']."</td>
<td>".$row['nameextension']."</td>
<td>".$row['gender']."</td>
<td>".$row['age']."</td>
<td>".$row['birthday']."</td>
<td>".$row['province']."</td>
<td>".$row['city_municipality']."</td>
<td>".$row['street']."</td>
<td>".$row['address1']."</td>
<td>".$row['address2']."</td>
<td>".$row['address3']."</td>
<td>".$row['category']."</td>
<td>".$row['firstdose']."</td>
<td>".$row['seconddose']."</td>
<td><a href='edit_record.php?id=".$row['id']."'><img src='file/images/edit1.png' width='20' height='20'/></a>
</td>
<td><a href='delete_record.php?id=".$row['id']."'><img src='file/images/delete1.png'width='20' height='20'/></a>
</td>
</tr>";
}
}
else if (isset($_POST["search"])) {
$filtervalues = $_POST["search"];
$query ="SELECT * FROM `record` WHERE CONCAT(firstname,lastname,category) LIKE '%$filtervalues%'";
$result = mysqli_query($con,$query);
$rowcount= mysqli_num_rows($result);
while($row=mysqli_fetch_array($result))
{
echo "<tr>
<td>".$row['id']."</td>
<td>".$row['lastname']."</td>
<td>".$row['firstname']."</td>
<td>".$row['middlename']."</td>
<td>".$row['nameextension']."</td>
<td>".$row['gender']."</td>
<td>".$row['age']."</td>
<td>".$row['birthday']."</td>
<td>".$row['province']."</td>
<td>".$row['city_municipality']."</td>
<td>".$row['street']."</td>
<td>".$row['address1']."</td>
<td>".$row['address2']."</td>
<td>".$row['address3']."</td>
<td>".$row['category']."</td>
<td>".$row['firstdose']."</td>
<td>".$row['seconddose']."</td>
<td><a href='edit_record.php?id=".$row['id']."'><img src='file/images/edit1.png' width='20' height='20'/></a>
</td>
<td><a href='delete_record.php?id=".$row['id']."'><img src='file/images/delete1.png'width='20' height='20'/></a>
</td>
</tr>";
}
}
else
{
echo "<p>No Records Found !</p>";
}
?>
</table>
</div>
</body>
</html>
Step by step
Solved in 3 steps with 3 images
