How to create search form using php and mysql

Question

<form name="myForm" id="search" action="search.php?searching=true" method="post" >
    <table cellspacing="2px" cellpadding="2px"><br/><br/>   
        <tr>
            <td><?php if(!empty($row1)){ ?>
                <input type="hidden" name="id" value="<?php echo (!empty($row1['id']))?$row1['id']:""?>">
                <?php }else{ ?>
                <input type="hidden" name="save" value='1'>
                <?php } ?>  
                <th style="float:left">First Name:&emsp;&emsp;&emsp;&emsp;&emsp;</th>
            </td>
            <td>
                &emsp;&emsp;&emsp;&emsp;
                <select name="salute" class="select" value="<?php echo (!empty($row1['salute']))?$row1['salute']:""?>">
                    <option>Mr.</option>
                    <option>Ms.</option>
                    <option>Mrs.</option>
                    <option>Dr.</option>
                    <option>Prof.</option>
                </select>
                <input type="text" id="fname" name="fname" class="text"  placeholder="Name is..." onblur="return validName();" onfocus="document.getElementById('fname_error').innerHTML=''"/><br/>
                <label id="fname_error"></label>
            </td>
        </tr>
        <tr>
            <td>
                <th style="float:left">
                    <span><sup>*</sup></span>Last Name:&emsp;&emsp;&emsp;&emsp;&emsp;&emsp;&emsp;&emsp;&emsp;&emsp;&emsp;&emsp;&emsp;
                </th>
            </td>
            <td>
                <input type="text" name="lname" class="text" id="lastname" value="<?php echo (!empty($row1['lname']))?$row1['lname']:""?>" onblur="return validLname();" onfocus="document.getElementById('lastname_error').innerHTML=''"/> <br/>
                <label id="lastname_error"></label>
            </td>
        </tr>
    </table>
    <table align="center" cellspacing="2px" cellpadding="2px"><br/><br/>
        <tr>
            <td>
                <input type="submit" value="Search" name="search" id="search" />&emsp;&emsp;&emsp;&emsp;
            </td>
        </tr>
    </table>
    <table align="center" border="2" bgcolor="white" cellspacing="1px" cellpadding="20px"><br/><br/>
        <tr bgcolor="#4d7fea">
            <th>Id</th>
            <th>Name</th>
            <th>Email</th>
            <th>Age</th>
            <th>Mobile</th>
            <th>Gender</th>
            <th>City</th>
            <th>State</th>
            <th>Country</th>
            <th>Pin</th>
            <th>City</th>
            <th>State</th>
            <th>Country</th>
            <th>Pin</th><th>Actions</th>
        </tr>
        <?php
            if (!empty($_REQUEST['fname'])){
                $params['name']=$_REQUEST['salute']." ".$_REQUEST['fname']." ".$_REQUEST['lname'];
                $sql="SELECT * FROM test WHERE Name LIKE '%".trim($params['name'])."%'";
                $records=$db->mysqli_fetch_assoc($sql);
                while($row=mysqli_fetch_assoc($records)){
        ?>
        <tr>
            <td><?php echo $row['id']; ?></td>
            <td><?php echo $row['name']; ?></td>
            <td><?php echo $row['email']; ?></td>
            <td><?php echo $row['age']; ?></td>
            <td><?php echo $row['mobile']; ?></td>
            <td><?php echo $row['gender']; ?></td>
            <td><?php echo $row['city']; ?></td>
            <td><?php echo $row['state']; ?></td>
            <td><?php echo $row['country']; ?></td>
            <td><?php echo $row['pin']; ?></td>
            <td><?php echo $row['city1']; ?></td>
            <td><?php echo $row['state1']; ?></td>
            <td><?php echo $row['country1']; ?></td>
            <td><?php echo $row['pin1']; ?></td>
            <td><a href="index.php?edit=<?php echo $row['id']; ?>"><span style='color:Purple'><b>Edit</b></span>&emsp;
            <a href="index.php?delete=<?php echo $row['id']; ?>" onclick="return confirm('Are you Sure?')"><span style="color:Red"><b>Delete</b></span>&emsp;</td>
        </tr>
        <?php }  }else{ ?>
        <tr><b>No Data Found</b></tr>
        <?php } ?>
    </table>
    <br/><br/><br/><br/>

what's the issue? what re you actually doing? also where is search form code? — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Dec 21, 2016 at 6:20
i create a form with all above details and insert data in database. now i want to search by name. i want if i enter name then the row will come. — Himani
– Himani, Commented Dec 21, 2016 at 6:21
try to run that query directly in phpmyadmin with hardcoded value and check what is coming? — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Dec 21, 2016 at 6:24

Amit Kumar Sahu · Accepted Answer · 2016-12-23 11:42:10Z

2

search string anywhere in text useing '%':

$sql="SELECT * FROM test WHERE Name LIKE '%".trim($params['name'])."%'";

edited Dec 23, 2016 at 11:42

answered Dec 21, 2016 at 6:21

Amit Kumar Sahu

4956 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Himani · Accepted Answer · 2017-01-14 06:23:07Z

0

<?php   if (!empty($_REQUEST['fname'])){
                    $params['name']=$_REQUEST['salute']." ".$_REQUEST['fname']." ".$_REQUEST['lname'];
                    $sql="SELECT * FROM test WHERE Name LIKE '%".trim($params['name'])."%'";  

                    $records=mysqli_query($db->conn,$sql);
                            while($row=mysqli_fetch_assoc($records)){ ?>

edited Jan 14, 2017 at 6:23

answered Dec 21, 2016 at 6:59

Himani

1718 bronze badges

Comments

Himani · Accepted Answer · 2019-06-24 06:05:32Z

0

To Search you have to add % tag in your query:

$sql="SELECT * FROM test WHERE Name LIKE '%".trim($params['name'])."%'";

This worked.

edited Jun 24, 2019 at 6:05

answered Nov 25, 2018 at 8:54

Himani

1718 bronze badges

Collectives™ on Stack Overflow

How to create search form using php and mysql

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest