maideen Posted June 18, 2013 Share Posted June 18, 2013 Hi I have one problem , I need to search any string data . Below my code. When I click, no results as well as no error Index.php <?php include_once '../templete/header.php'; ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Search</title> <link href="style.css" rel="stylesheet" type="text/css" /> </head> <body> <form action="search.php" method="get" > <table border="0" cellpadding="0" cellspacing="0"> <tr> <td><input type="text" name="query" id="text" /> </td> <td><input type="submit" name="submit" id="search" value="Search" /></td> </form> </body> </html> Search.php <?php include_once '../templete/header.php'; include_once '../inc/connection.inc.php'; ?> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Search</title> <link href="style.css" rel="stylesheet" type="text/css" /> </head> <body> <table> <tr> <td>Name</td> <td>Address</td> </tr> <?php $query = $_GET['query']; $stmt = $dbh->prepare("SELECT * FROM CompanyInfo WHERE (Name LIKE '%".$query."%') OR (Address LIKE '%".$query."%')"); $stmt->setFetchMode(PDO::FETCH_ASSOC); //$stmt->execute(); if(isset($stmt)) { while($row = $stmt->fetch()); ?> <tr> <td><?php echo $row['Name'];?></td> <td><?php echo $row['Address'];?></td> </tr> <?php } ?> </table> </body> </html> Pls help me Maideen Link to comment https://forums.phpfreaks.com/topic/279315-search-string-in-data-base/ Share on other sites More sharing options...
AbraCadaver Posted June 18, 2013 Share Posted June 18, 2013 Uhhhhh.... Why is this commented? //$stmt->execute(); Link to comment https://forums.phpfreaks.com/topic/279315-search-string-in-data-base/#findComment-1436655 Share on other sites More sharing options...
maideen Posted June 19, 2013 Author Share Posted June 19, 2013 Hi I have tried this command too. Nothing happend. pls maideen Link to comment https://forums.phpfreaks.com/topic/279315-search-string-in-data-base/#findComment-1436773 Share on other sites More sharing options...
maideen Posted June 19, 2013 Author Share Posted June 19, 2013 hi Thank you of you to give the suggestion to solve the problem. there was wrong in Search.php Here is the code working fine <?php $query = $_GET['query']; echo $query; $stmt = $dbh->query("SELECT * FROM CompanyInfo WHERE (Name LIKE '%".$query."%' OR Address LIKE '%".$query."%')"); $stmt->setFetchMode(PDO::FETCH_ASSOC); if(isset($stmt)) { while($row = $stmt->fetch()){ ?> <tr> <td><?php echo $row['Name'];?></td> <td><?php echo $row['Address'];?></td> </tr> <?php echo $row['Name']; } }?> Thank you very much once again Link to comment https://forums.phpfreaks.com/topic/279315-search-string-in-data-base/#findComment-1436781 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.