Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <div class="searchbox">
- <form action="Search.php" method="get">
- <fieldset>
- <input id="$search" placeholder="Search for a Product" type="text" />
- <input id="submit" type="hidden" />
- </fieldset>
- </form>
- </div>
- <div id="content">
- <ul>
- <?php
- $host = "xxx";
- $user = "xxx";
- $pass = "xxx";
- $db = "xxx";
- mysql_connect($host, $user, $pass);
- mysql_select_db($db);
- unset($host,$user,$pass,$db);
- //$query = "SELECT produkt FROM checklist WHERE id IS "1";
- $query = "SELECT produkt FROM checklist WHERE id LIKE '%$search%'";
- $result = mysql_query($query);
- while ($row = mysql_fetch_array($result))
- {
- echo "<li><span class='name'><b>$row[produkt]</b><br /></span><span class='comment'><i>Tierische Stoffe: </i>$row[tierisch]</span><i> Alkohol: </i>$row[alkohol]</span></span></li>";
- }
- ?>
- <div class="searchbox">
- <form action="Search.php" method="get">
- <fieldset>
- <input id="search" placeholder="Search for a Product" type="text" />
- <input id="submit" type="hidden" />
- </fieldset>
- </form>
- </div>
- <div id="content">
- <ul>
- <?php
- $host = "xxx";
- $user = "xxx";
- $pass = "xxx";
- $db = "xxx";
- mysql_connect($host, $user, $pass);
- mysql_select_db($db);
- unset($host,$user,$pass,$db);
- $search = $_POST['search'];
- $query = "SELECT produkt FROM checklist WHERE id LIKE '%".$_POST['search']."%'";
- //$query = "SELECT produkt FROM checklist WHERE id LIKE '%$search%'";
- $result = mysql_query($query);
- <input id="$search" placeholder="Search for a Product" type="text" />
- <input id="search" placeholder="Search for a Product" type="text" />
- $query = "SELECT produkt FROM checklist WHERE id LIKE '%".$_POST['search']."%'";
- <input id="$search" placeholder
- <input id="search" placeholder
- $query = "SELECT produkt FROM checklist WHERE id LIKE '%{$_GET['search']}%'";
- $search = mysql_real_escape_string($_GET['search']);
- $query = "SELECT produkt FROM checklist WHERE id LIKE '%{$search}%'";
- <input name="search" id="search" placeholder="Search for a Product" type="text" />
- $search = mysql_real_escape_string($_GET['search']);
- $query = "SELECT produkt FROM checklist WHERE id LIKE '%{$search}%'";
- $result = mysql_query($query);
- while ($row = mysql_fetch_array($result)){
- echo "<li><span class='name'><b>{$row['produkt']}</b></span></li>";
- }
- $search = $_GET['search'];
Add Comment
Please, Sign In to add comment