CODEWITHSUNDEEP
phpmysql
nitan
nitan

Reputation: 37

PHP/MySQL Search Functionality

I've followed this tutorial thoroughly, and had success with it. However, it leads me to a dead end where I have to pay to access the tutorial on implementing a "Search" functionality to it.

I was wondering if anyone could help me out on how I can implement a search functionality given how the tutorial is constructed? Tutorials seems like they don't work with this.

I've tried this on a separate page so far, but it doesn't seem to work - also I don't know how it can be implemented on my actual site.

<?php
mysql_connect("localhost","root","") or die("could not connect");
mysql_select_db("kkp") or die("could not find db!");
$output ='';

//collect
if (isset($_POST['search'])){
    $searchq = $_POST['search'];
    $searchq = preg_replace("#[^0-9a-z]#i","",$searchq);
    $query = mysql_query("SELECT * FROM personal_info WHERE FirstName LIKE '%$searchq%' OR SurName LIKE '%$searchq%'") or die("could not search");
    $count = mysql_num_rows($query);
    if($count == 0){
        $output = 'There was no search results!';
    }else{
        while($row = mysql_fetch_array($query)){
            $fname = $row['FirstName'];
            $lname = $row['SurName'];
            $id = $row['id'];

            $output .= '<div>'.$fname.''.$lname.'</div>';
        }
    }
}
?>
<!DOCTYPE html>
<html>
<head>
    <title>Search</title>
</head>
<body>
    <form method="post" action="search.php"></form>
        <input type="text" name="search" placeholder="Search for student">
        <input type="submit" value="Submit">
</body>
</html>

<?php print("$output");?>

Also, here's where I'm trying to implement a search functionality. It just displays a table with the entries I've added to the database.

<div class="row">
    <h3>List of Student Volunteers</h3>
</div>
<div class="row">
    <table class="table table-striped table-bordered">
    <thead>
        <tr>
            <td>Name</td>
            <td>Email Address</td>
            <td>Mobile Number</td>
            <td>Action</th>
        </tr>
    </thead>
    <tbody>
    <?php
        include 'database.php';
        $pdo = Database::connect();
        $sql = 'SELECT * FROM personal_info ORDER BY id DESC';
        foreach ($pdo->query($sql) as $row) {
            echo '<tr>';
            echo '<td>'. $row['FirstName'] . '</td>';
            echo '<td>'. $row['EmailAddress'] . '</td>';
            echo '<td>'. $row['MobileNum'] . '</td>';
            echo '<td width=250>';
            echo '<a class="btn" href="read.php?id='.$row['id'].'">Read</a>';
            echo ' ';
            echo '<a class="btn" href="update.php?id='.$row['id'].'">Update</a>';
            echo ' ';
            echo '<a class="btn" href="delete.php?id='.$row['id'].'">Delete</a>';
            echo '</td>';
            echo '</tr>';
        }
        Database::disconnect();
    ?>

Upvotes: 2

Views: 18686

Answers (1)

Kirk Beard
Kirk Beard

Reputation: 9843

Your HTML is incorrect. You're closing your <form> tag too early, so the <input> is not submitted to the PHP file.

For example, change your HTML to this:

<form method="post" action="search.php">
    <input type="text" name="search" placeholder="Search for student">
    <input type="submit" value="Submit">
</form>

To test and debug what data is being submitted to the PHP file, you can use print_r($_POST) to view all the details.

For example, based on your code, add:

<?php
mysql_connect("localhost","root","") or die("could not connect");
mysql_select_db("kkp") or die("could not find db!");
$output ='';
print_r($_POST);
// ...

Based on the code you posted, you should see an empty array. This would have helped you identify the issue.

Edit: Expanding on search functionality...

Your SQL already has the LIKE '%$searchq%' parts, which will filter your SQL results. You just need to update your other SQL query to do something similar:

$sql = 'SELECT * FROM personal_info ORDER BY id DESC';

Should be like:

$sql = "SELECT * FROM personal_info WHERE FirstName LIKE '%$searchq%' OR LastName LIKE '%$searchq%' ORDER BY id DESC";

You just need to customise the SQL to add the appropriate LIKE entries.

Upvotes: 1

Related Questions