Jump to content

Search the Community

Showing results for tags 'php search'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Welcome to PHP Freaks
    • Announcements
    • Introductions
  • PHP Coding
    • PHP Coding Help
    • Regex Help
    • Third Party Scripts
    • FAQ/Code Snippet Repository
  • SQL / Database
    • MySQL Help
    • PostgreSQL
    • Microsoft SQL - MSSQL
    • Other RDBMS and SQL dialects
  • Client Side
    • HTML Help
    • CSS Help
    • Javascript Help
    • Other
  • Applications and Frameworks
    • Applications
    • Frameworks
    • Other Libraries
  • Web Server Administration
    • PHP Installation and Configuration
    • Linux
    • Apache HTTP Server
    • Microsoft IIS
    • Other Web Server Software
  • Other
    • Application Design
    • Other Programming Languages
    • Editor Help (PhpStorm, VS Code, etc)
    • Website Critique
    • Beta Test Your Stuff!
  • Freelance, Contracts, Employment, etc.
    • Services Offered
    • Job Offerings
  • General Discussion
    • PHPFreaks.com Website Feedback
    • Miscellaneous

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Age


Donation Link

Found 3 results

  1. 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
  2. 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>';
  3. 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; ?>
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.