display and search at the table in the same time and fetch

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

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> 

Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY