Search the Community
Showing results for tags 'php search'.
Found 3 results
-
Hi everybody, this is NOT me in the picture. I would like to tell you that I am so pleased that I can be a registered member of this site. But all I registered for is to get help. As you could have found out from the title. For what I do need your help? Yes, I'm not kidding, I really need a good brain, but I do not want to take your brain literally. No, I just need you to tell me how to create the following easy php script. What should it do? The php script should be able to find things I'm searching for. For example: - I type in: used apple iphone pink with hello kitty scrandguru (I don't know what does scrandguru mean, don't ask me) and it searches immediately on ebay, amazon.com, google etcetera, all the sites I just want it to search on. The Structure: A simple html and css made page, with the script. I type in "something", hit enter, it submits the data and sends it to the php script, the php script connects to internet, no database used for this so far, it searches on ebay, amazon etc etc.. The Dilemma: How..can.. I.. make.. THIS?! Thanks for good and smart replies in advance, I hope you can help me out. Best wishes, Micky
-
I have a search page that is working but is generating an error despite working. The error is Notice: Undefined index: var1 in C:\Program Files\EasyPHP-DevServer-13.1VC9\data\localweb\my portable files\air\search.php on line 58 Invalid form value: The code that i have is here below. The first line in the code below is the line 58 $var1 = str_replace(array('%','_'),'',$_POST['var1']); if (!$var1) { exit('Invalid form value: '.$var1); } $query = "SELECT * FROM holder WHERE Surname LIKE :search OR FirstName LIKE :search OR Variable Like :search OR Number Like :search GROUP BY holder.EmployeeID"; $statement = $db->prepare($query); $statement->bindValue(':search', '%' . $var1 . '%', PDO::PARAM_INT); echo "<table border='1' cellpadding='10'>"; echo "<tr> <th>Surname</th> <th>First Name</th> <th>Rank</th> <th>Number</th></tr>"; $statement->execute(); /* Fetch all of the remaining rows in the result set */ print("Here are the results of your search Sir:\n"); $statement->setFetchMode(PDO::FETCH_ASSOC); // Set the fetch mode. while ($row = $statement->fetch()) { $Surname = $row['Surname']; $FirstName = $row['FirstName']; $Variable = $row['Variable']; $Variable = $row['Number']; echo "<tr>"; echo '<td>' . $row['Surname'] . '</td>'; echo '<td>' . $row['FirstName'] . '</td>'; echo '<td>' . $row['Variable'] . '</td>'; echo '<td>' . $row['Number'] . '</td>'; echo '<td><a href="details.php?EmployeeID=' . $row['EmployeeID'] . '">Details</a></td>';
-
Hi I have small search php code in this i want to display the result in vertical. i have mentioned the code below. Can anyone help me to get the result. Thanks in advance!! <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "[url=http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd]http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd[/url]"> <?php include ("menu.php"); ?> <div id="content"> <div id="primaryContentContainer"> <div id="primaryContent"> <h2>Search Results<span></span></h2> <?php //capture search term and remove spaces at its both ends if the is any $searchTerm = trim($_GET['keyname']); //check whether the name parsed is empty if($searchTerm == "") { echo "Enter key word you are searching for."; exit(); } //database connection info $host = "localhost"; //server $db = "market_codes"; //database name $user = "root"; //dabases user name $pwd = ""; //password //connecting to server and creating link to database $link = mysqli_connect($host, $user, $pwd, $db); //MYSQL search statement $query = "SELECT * FROM allo WHERE description LIKE '%$searchTerm%'"; $results = mysqli_query($link, $query); /* check whethere there were matching records in the table by counting the number of results returned */ if(mysqli_num_rows($results) >= 1) { $output = ""; while($row = mysqli_fetch_array($results)) { $output .= "Sl No: " . $row['sl_no'] . "<br />"; $output .= "Category: " . $row['category'] . "<br />"; $output .= "Description: " . $row['description'] . "<br />"; $output .= "Outlet: " . $row['outlet'] . "<br />"; $output .= "Trading Area: " . $row['ta'] . "<br />"; $output .= "Food CSI: " . $row['food'] . "<br />"; $output .= "Drug CSI: " . $row['drug'] . "<br />"; $output .= "Mass Census: " . $row['mass'] . "<br />"; $output .= "xAOC Co: " . $row['xaoc'] . "<br />"; $output .= "Deca Census: " . $row['deca'] . "<br />"; $output .= "Sam's Census: " . $row['sma_s'] . "<br />"; $output .= "BJ's Census: " . $row['bj_s'] . "<br />"; $output .= "Dollar Gen Cen: " . $row['dollar'] . "<br />"; $output .= "Family Dol Cen: " . $row['family'] . "<br />"; $output .= "Fred Dol Cen: " . $row['fred'] . "<br />"; $output .= "Walmart Mass Cen: " . $row['walmart_mass'] . "<br />"; $output .= "Walmart Food Cen: " . $row['walmart_food'] . "<br /><br />"; } echo $output; } else echo "There was no matching record for the query " . $searchTerm; ?>
