Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $nname = $_POST['input1'];
- $vname = $_POST['input2'];
- $title = $_POST['input3'];
- $verlag = $_POST['input4'];
- $year = $_POST['input5'];
- ?>
- <html>
- <head>
- <meta name="author" content="Tom Pöschmann">
- <link rel="stylesheet" type="text/css" href="css/css.css">
- <title>Bücherregal</title>
- <meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
- </head>
- <body>
- <h1 align="center">Buch hinzufügen</h1>
- <form name="Buch hinzufuegen" action="" method="post">
- <table align="center">
- <tr><td>Nachname des Autors</td></tr>
- <tr><td><input type="text" size="40" name="input1" </td></tr>
- <tr><td>Vorname des Autors</td></tr>
- <tr><td><input type="text" size="40" name="input2" </td></tr>
- <tr><td>Titel des Buches</td></tr>
- <tr><td><input type="text" size="40" name="input3" </td></tr>
- <tr><td>Verlag</td></tr>
- <tr><td><input type="text" size="40" name="input4" </td></tr>
- <tr><td>Erscheinungsjahr</td></tr>
- <tr><td><input type="text" size="40" name="input5" </td></tr>
- <tr><td><input type="submit" value="Eintragen"</td></tr>
- </table>
- </form>
- <p align="center" valign="bottom"><a href="Hauptsite.html"
- target="_self">zurück</a></p>
- <?php
- // Die Connect-Werte werden hier bestimmt
- $host = "localhost";
- $port = 3306;
- $user = "zxmqg66";
- $pass = "xxx";
- $db = "zxmqg66_db";
- // Die Verbindung herstellen
- $dbh = mysql_connect("$host","$user","$pass")
- or die("Verbindung fehlgeschlagen");
- // Die Buchdatenbank auswählen
- mysql_select_db($db,$dbh)
- or die("Datenbankzugriffsfehler");
- // Ein Buch einfügen
- $query = "INSERT INTO books(nachname,vorname,title,verlag,jahr)
- VALUES ('$nname','$vname','$title','$verlag','$year')";
- $sth = mysql_query($query,$dbh);
- // Verbindung schließen
- mysql_close($dbh);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement