How to create search form using php and mysql
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
1
<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:     </th>
</td>
<td>
    
<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:             
</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" />    
</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> 
<a href="index.php?delete=<?php echo $row['id']; ?>" onclick="return confirm('Are you Sure?')"><span style="color:Red"><b>Delete</b></span> </td>
</tr>
<?php } }else{ ?>
<tr><b>No Data Found</b></tr>
<?php } ?>
</table>
<br/><br/><br/><br/>
php mysql
edited Dec 21 '16 at 6:41
Logan Wayne
5,512142545
asked Dec 21 '16 at 6:17
himanihimani
255
|
show 4 more comments
1
<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:     </th>
</td>
<td>
    
<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:             
</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" />    
</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> 
<a href="index.php?delete=<?php echo $row['id']; ?>" onclick="return confirm('Are you Sure?')"><span style="color:Red"><b>Delete</b></span> </td>
</tr>
<?php } }else{ ?>
<tr><b>No Data Found</b></tr>
<?php } ?>
</table>
<br/><br/><br/><br/>
php mysql
edited Dec 21 '16 at 6:41
Logan Wayne
5,512142545
asked Dec 21 '16 at 6:17
himanihimani
255
What is the issue?
– Hassaan
Dec 21 '16 at 6:19
what's the issue? what re you actually doing? also where is search form code?
– Alive to Die
Dec 21 '16 at 6:20
this query is not working
– himani
Dec 21 '16 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
Dec 21 '16 at 6:21
try to run that query directly in phpmyadmin with hardcoded value and check what is coming?
– Alive to Die
Dec 21 '16 at 6:24
|
show 4 more comments
1
1
1
1
<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:     </th>
</td>
<td>
    
<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:             
</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" />    
</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> 
<a href="index.php?delete=<?php echo $row['id']; ?>" onclick="return confirm('Are you Sure?')"><span style="color:Red"><b>Delete</b></span> </td>
</tr>
<?php } }else{ ?>
<tr><b>No Data Found</b></tr>
<?php } ?>
</table>
<br/><br/><br/><br/>
php mysql
edited Dec 21 '16 at 6:41
Logan Wayne
5,512142545
asked Dec 21 '16 at 6:17
himanihimani
255
<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:     </th>
</td>
<td>
    
<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:             
</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" />    
</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> 
<a href="index.php?delete=<?php echo $row['id']; ?>" onclick="return confirm('Are you Sure?')"><span style="color:Red"><b>Delete</b></span> </td>
</tr>
<?php } }else{ ?>
<tr><b>No Data Found</b></tr>
<?php } ?>
</table>
<br/><br/><br/><br/>
php mysql
php mysql
edited Dec 21 '16 at 6:41
Logan Wayne
5,512142545
asked Dec 21 '16 at 6:17
himanihimani
255
edited Dec 21 '16 at 6:41
Logan Wayne
5,512142545
asked Dec 21 '16 at 6:17
himanihimani
255
edited Dec 21 '16 at 6:41
Logan Wayne
5,512142545
edited Dec 21 '16 at 6:41
Logan Wayne
5,512142545
edited Dec 21 '16 at 6:41
Logan Wayne
5,512142545
5,512142545
asked Dec 21 '16 at 6:17
himanihimani
255
asked Dec 21 '16 at 6:17
himanihimani
255
asked Dec 21 '16 at 6:17
himanihimani
255
255
What is the issue?
– Hassaan
Dec 21 '16 at 6:19
what's the issue? what re you actually doing? also where is search form code?
– Alive to Die
Dec 21 '16 at 6:20
this query is not working
– himani
Dec 21 '16 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
Dec 21 '16 at 6:21
try to run that query directly in phpmyadmin with hardcoded value and check what is coming?
– Alive to Die
Dec 21 '16 at 6:24
|
show 4 more comments
What is the issue?
– Hassaan
Dec 21 '16 at 6:19
what's the issue? what re you actually doing? also where is search form code?
– Alive to Die
Dec 21 '16 at 6:20
this query is not working
– himani
Dec 21 '16 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
Dec 21 '16 at 6:21
try to run that query directly in phpmyadmin with hardcoded value and check what is coming?
– Alive to Die
Dec 21 '16 at 6:24
What is the issue?
– Hassaan
Dec 21 '16 at 6:19
What is the issue?
– Hassaan
Dec 21 '16 at 6:19
what's the issue? what re you actually doing? also where is search form code?
– Alive to Die
Dec 21 '16 at 6:20
what's the issue? what re you actually doing? also where is search form code?
– Alive to Die
Dec 21 '16 at 6:20
this query is not working
– himani
Dec 21 '16 at 6:20
this query is not working
– himani
Dec 21 '16 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
Dec 21 '16 at 6:21
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
Dec 21 '16 at 6:21
try to run that query directly in phpmyadmin with hardcoded value and check what is coming?
– Alive to Die
Dec 21 '16 at 6:24
try to run that query directly in phpmyadmin with hardcoded value and check what is coming?
– Alive to Die
Dec 21 '16 at 6:24
|
show 4 more comments
3 Answers
3
active
oldest
votes
2
search string anywhere in text useing '%':
$sql="SELECT * FROM test WHERE Name LIKE '%".trim($params['name'])."%'";
answered Dec 21 '16 at 6:21
Amit Kumar SahuAmit Kumar Sahu
523614
i try it..not working in search.
– himani
Dec 21 '16 at 6:23
add a comment |
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)){ ?>
answered Dec 21 '16 at 6:59
himanihimani
255
add a comment |
0
To Search you have to add % tag in your query:
$sql="SELECT * FROM test WHERE Name LIKE '%".trim($params['name'])."%'";
Try this, if it works don't forget to mark as right.
answered Nov 25 '18 at 8:54
himanihimani
255
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f41256337%2fhow-to-create-search-form-using-php-and-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
2
search string anywhere in text useing '%':
$sql="SELECT * FROM test WHERE Name LIKE '%".trim($params['name'])."%'";
answered Dec 21 '16 at 6:21
Amit Kumar SahuAmit Kumar Sahu
523614
i try it..not working in search.
– himani
Dec 21 '16 at 6:23
add a comment |
2
search string anywhere in text useing '%':
$sql="SELECT * FROM test WHERE Name LIKE '%".trim($params['name'])."%'";
answered Dec 21 '16 at 6:21
Amit Kumar SahuAmit Kumar Sahu
523614
i try it..not working in search.
– himani
Dec 21 '16 at 6:23
add a comment |
2
2
2
search string anywhere in text useing '%':
$sql="SELECT * FROM test WHERE Name LIKE '%".trim($params['name'])."%'";
answered Dec 21 '16 at 6:21
Amit Kumar SahuAmit Kumar Sahu
523614
search string anywhere in text useing '%':
$sql="SELECT * FROM test WHERE Name LIKE '%".trim($params['name'])."%'";
answered Dec 21 '16 at 6:21
Amit Kumar SahuAmit Kumar Sahu
523614
edited Dec 23 '16 at 11:42
answered Dec 21 '16 at 6:21
Amit Kumar SahuAmit Kumar Sahu
523614
answered Dec 21 '16 at 6:21
Amit Kumar SahuAmit Kumar Sahu
523614
answered Dec 21 '16 at 6:21
Amit Kumar SahuAmit Kumar Sahu
523614
523614
i try it..not working in search.
– himani
Dec 21 '16 at 6:23
add a comment |
i try it..not working in search.
– himani
Dec 21 '16 at 6:23
i try it..not working in search.
– himani
Dec 21 '16 at 6:23
i try it..not working in search.
– himani
Dec 21 '16 at 6:23
add a comment |
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)){ ?>
answered Dec 21 '16 at 6:59
himanihimani
255
add a comment |
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)){ ?>
answered Dec 21 '16 at 6:59
himanihimani
255
add a comment |
0
0
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)){ ?>
answered Dec 21 '16 at 6:59
himanihimani
255
<?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)){ ?>
answered Dec 21 '16 at 6:59
himanihimani
255
edited Jan 14 '17 at 6:23
answered Dec 21 '16 at 6:59
himanihimani
255
answered Dec 21 '16 at 6:59
himanihimani
255
answered Dec 21 '16 at 6:59
himanihimani
255
255
add a comment |
add a comment |
0
To Search you have to add % tag in your query:
$sql="SELECT * FROM test WHERE Name LIKE '%".trim($params['name'])."%'";
Try this, if it works don't forget to mark as right.
answered Nov 25 '18 at 8:54
himanihimani
255
add a comment |
0
To Search you have to add % tag in your query:
$sql="SELECT * FROM test WHERE Name LIKE '%".trim($params['name'])."%'";
Try this, if it works don't forget to mark as right.
answered Nov 25 '18 at 8:54
himanihimani
255
add a comment |
0
0
0
To Search you have to add % tag in your query:
$sql="SELECT * FROM test WHERE Name LIKE '%".trim($params['name'])."%'";
Try this, if it works don't forget to mark as right.
answered Nov 25 '18 at 8:54
himanihimani
255
To Search you have to add % tag in your query:
$sql="SELECT * FROM test WHERE Name LIKE '%".trim($params['name'])."%'";
Try this, if it works don't forget to mark as right.
answered Nov 25 '18 at 8:54
himanihimani
255
answered Nov 25 '18 at 8:54
himanihimani
255
answered Nov 25 '18 at 8:54
himanihimani
255
answered Nov 25 '18 at 8:54
himanihimani
255
255
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f41256337%2fhow-to-create-search-form-using-php-and-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What is the issue?
– Hassaan
Dec 21 '16 at 6:19
what's the issue? what re you actually doing? also where is search form code?
– Alive to Die
Dec 21 '16 at 6:20
this query is not working
– himani
Dec 21 '16 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
Dec 21 '16 at 6:21
try to run that query directly in phpmyadmin with hardcoded value and check what is coming?
– Alive to Die
Dec 21 '16 at 6:24