php009

<?php

MYSQL_CONNECT("localhost","root","");
MYSQL_SELECT_DB("lexicon");

if(isset($_POST["name"]) && isset($_POST["text"]) && isset($_POST["pflanze"])) {
    MYSQL_QUERY("INSERT INTO lex_name (name, pflanze) VALUES ('" . $_POST["name"] ."','" . isPflanze() ."')");
    $res = MYSQL_QUERY("SELECT id FROM lex_name WHERE name = '" . $_POST["name"] ."' AND pflanze = '" . isPflanze() ."'");
    $id = MYSQL_FETCH_OBJECT($res);
    MYSQL_QUERY("INSERT INTO lex_text (for_id,text) VALUES ('" . $id->id ."', '" . $_POST["text"] ."')");
    echo mysql_error();
}

function isPflanze() {
    if($_POST["pflanze"] == "on") return 1;
    else if($_POST["pflanze"] == "off") return 0;
    else return 0;
}
?>

<!DOCTYPE HTML>
<title>Lexicon</title>
<meta charset="utf-8">
<link rel="stylesheet" href="style.css">

<?php

$names = MYSQL_QUERY("SELECT * FROM lex_name");

while($rowfromname = MYSQL_FETCH_OBJECT($names)) {
    $text = MYSQL_QUERY("SELECT * FROM lex_text WHERE for_id = '" . $rowfromname->id ."' LIMIT 1");
    $name = $rowfromname->name;
    echo "<section><h1>Begriff: " . $name . "</h1>";
    echo "<p>" . $text ."</p></section>";
}

?>

<form action="" method="post">
    <table>
    <tr><td>Begriff : </td><td><input type="text" name="name"></td></tr>
    <tr><td>Erklährung : </td><td><textarea name="text"></textarea></td></tr>
    <tr><td>Pflanze &lt;Ja / Nein&gt; : </td><td><input checked type="checkbox" name="pflanze"></td></tr>
    <tr><td></td><td><input type="submit"></td></tr>
    </table>
</form>