I have question regarding search on webpage with textbox and dropdown box.
I have table with fields:
ID First name Last name Company name Occupation Description
Now i need to make search form which will be populated from database (field Occupation) and textbox where I can put whatever I want, and then get results from database based on those on web page.
I am really sorry but i am totally begginer and only need some examples of such kind of code and much help :)
Thank you
分享 Create a form with a search input textbox.
Then on the page where the form submits (I like to post back to the same page) you need to execute a select query to get the list of the occupations based on that search.
example: in index.php
<?php
?>
<html>
<body>
<form action="<?php echo htmlentities($PHP_SELF); ?>"
<?php
if (isset($_POST['submit'])){
// Insert code to connect to DB HERE
$searchText = htmlentities($_POST['search']);
$query = "SELECT * FROM table_name WHERE Occupation LIKE '%$searchText%'";
$results = mysql_query($query) or die(mysql_query());
echo "<select name=\"occupations\">";
while($row=mysql_fetch_array($results)){
echo "<option>$row[Occupation];</option>";
}
echo "</select>";
}
?>
<input type="text" name="search"/>
<input type="submit" name="submit"/>
</form>
</body>
</html>
