Create your own awesome maps

Even on the go

with our free apps for iPhone, iPad and Android

Get Started

Already have an account?
Log In

php Suchformular by Mind Map: php Suchformular
0.0 stars - reviews range from 0 to 5

php Suchformular

Tabelle

Tabelle

Zugriff: http://www.ph-linz.at/zid/phpmyadmin

frameset.htm

frameset

<frameset rows="80,*" frameborder="no" border="0" framespacing="0"> <frame src="10_suchformular.htm" name="topFrame" scrolling="No" noresize="noresize" id="topFrame" title="topFrame" /> <frame src="10_start.htm" name="mainFrame" id="mainFrame" title="mainFrame" /> </frameset> <noframes><body> </body> </noframes></html>

http://www.ph-linz.at/mm-team/schulung/php2010/krma2/10_frameset.htm

ergebnis.php

<body> <?php extract ($_GET); //kann jetzt auf $suchfeld zugreifen $hostname_PHP = "www.ph-linz.at"; $username_PHP = "student"; $password_PHP = "student"; $PHP_CONN = mysql_pconnect($hostname_PHP, $username_PHP, $password_PHP) or die(mysql_error()); $rs_db=mysql_select_db("schulung"); //$sql="SELECT * FROM schueler_krma WHERE plz='$suchfeld';"; $sql="SELECT * FROM schueler_krma WHERE famname LIKE'%$suchfeld%';"; //wichtig!!! soid ma kinna! $rs_daten = mysql_query($sql); echo "<table border='1'>"; echo "<th>Familienname</th><th>Vorname</th><th>Ort</th><th>Bild</th>"; while ($row = mysql_fetch_object($rs_daten)) { echo "<tr>"; echo "<td>".$row->famname."</td>"; echo "<td>".$row->vorname."</td>"; echo "<td>".$row->ort."</td>"; echo "<td><img src='bilder/".$row->dateiname."' width='80'/></td>"; echo "</tr>"; } echo "</table>"; $rs_schliessen = mysql_free_result($rs_daten); ?> </body>

start.htm

Hinweistext auf notwendige Eingabe:

suchformular.htm

<body bgcolor="#FFFFCC"> <form action="10_ergebnis.php" method="get" target="mainFrame"> <table width="600" border="1"> <tr> <td>Familiennamen eingeben </td> <td><input name="suchfeld" type="text" id="suchfeld" size="30" maxlength="30" /></td> <td><input type="submit" name="Submit" value="Suchen" /></td> </tr> </table> </form> </html>

css Stylesheet

... damit es schön wird!