Can you help me I have a problem in my code when I perform search the first row is always there I get the data I search but the first row is always visible can you help me to know where I went wrong.
Can you help me I have a problem in my code when I perform search the first row is always there I get the data I search but the first row is always visible can you help me to know where I went wrong.
Here is my code.
<?php
session_start();
if (!isset($_SESSION['username']))
header("location: login.php");
{
}
?>
<!DOCTYPE html>
<html>
<head>
<link rel="shortcut icon" href="file/images/favicon.ico" />
<title>View All Records</title>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.2/css/all.min.css"/>
<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>
</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>";
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>
Please help
Step by step
Solved in 2 steps
