Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // POST Request Simulieren...
- // $_POST = array('AMBUL_DST' => true);
- // $_POST = array('nde' => 'Ergo', 'AMBUL_DST' => true, 'MOBSOZDST' => true, 'AMBUL_HOSPIZARBEIT'=>true);
- // $_POST = array('ug' => '52146', 'og' => "bla");
- // MySQL Zugangsdaten
- $database="usr_web279_2";
- $host="localhost";
- $user="web279";
- $password="XXXXXXXXXX";
- $table="BUECHER_GEL";
- // Verbindung zur Datenbank herstellen
- mysql_connect($host,$user,$password);
- mysql_select_db($database) or die( "Unable to select database");
- // POST Variable in eine eigene Variable ueberfuehren.
- $rawdata = $_POST;
- // Datenbank nach Tabellenkoepfen (Feldnamen) fragen
- $query="show columns from $table";
- $result=mysql_query($query);
- // Kann eigentlich nicht schiefgegangen sein...
- if (!$result)
- {
- $message = 'Invalid query: ' . mysql_error() . "\n";
- $message .= 'Whole query: ' . $query;
- die($message);
- }
- $query = "select * from $table where AutorNachname = " . "'" . $_POST["AN"] . "';";
- echo $query;
- $result=mysql_query($query);
- echo $result;
- // Und HTML Ausgabe abschliessen
- echo '
- <p>
- <a href="blog01_query01.html">Zurueck zur Suche</a>
- <p>
- </body>
- </html>
- ';
- // Verbindung schliessen
- mysql_close();
- ?>
Add Comment
Please, Sign In to add comment