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 Quote 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(); Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/279315-search-string-in-data-base/#findComment-1436773 Share on other sites More sharing options...
Solution maideen Posted June 19, 2013 Author Solution 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.