Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <title>Suchfeld</title>
- <body>
- <form action="" method="post" target="_self">
- <div style="float:left;margin-left:35px">
- <input type="text" name="searchfield" style="border: 1px solid #c8c8c8;width:185px">
- <input type="image" src="img/search.gif" name="enter_search" alt="Suche" >
- <!-- <input type="submit" name="enter_search" value="Suche"> -->
- </div>
- <br>
- </form>
- <?php
- // Post-Variable bei der Suche im Feld
- if(isset($_POST['enter_search']))
- {
- $DBHOST = "localhost";
- $DBUSER = "tom";
- $DBPW = "djtom751";
- $con = mysql_connect($DBHOST,$DBUSER,$DBPW) or die("Verbindungsversuch fehlgeschlagen" . mysql_error());
- mysql_select_db("alchemie",$con) or die("Konnte die Datenbank nicht waehlen" . mysql_error());
- $searchresult = trim(htmlentities(stripslashes(mysql_real_escape_string($_POST['searchfield']))));
- $wsearch = "SELECT * FROM CSV_Gemeindeverzeichnis
- WHERE WName LIKE '%searchresult%'";
- $post = mysql_query($wsearch);
- while($lpost = mysql_fetch_array($post))
- {
- echo "<td align='center' valign='middle' style='width:16%'><h2>".$lpost['*']."</h2></td>";
- }
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement