Beiträge von cookie

<?php
error_reporting(E_ALL);
    // Konfigurationsdatei laden

    define("DB_HOST", "localhost");
    define("DB_USER", "root");
    define("DB_PASSWORD", "");
    define("DB", "hausaufgaben");


    //Zur Datenbank verbinden
    $db = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);


    if($db) {
        echo "Verbindung wurde aufgebaut
\n";
    } else {
        echo "Es konnte keine Verbindung aufgebaut werden";
    }
mysql_select_db("hausaufgaben");

 $sql = "INSERT INTO referate (autor,note,fach,titel,inhalt,Datum) VALUES ('$autor','$note','$fach','$titel','$inhalt',NOW())";
mysql_query($sql);//entweder garkeine "" oder ".$sql."
?>

<?php


if(isset($_POST['name']) AND ($_POST['name'] != "")) {
$datenbank = "forum";
$user = "root";
$pw = "";
$host = "localhost";
@mysql_connect($host, $user,$pw) OR die(mysql_error());
    mysql_select_db($datenbank) OR die(mysql_error());


$sql = "INSERT INTO homed
                (name,email,text)
            VALUES
               ('".addslashes(htmlspecialchars($_POST['name']))."',
                '".addslashes(htmlspecialchars($_POST['email']))."',
                   '".addslashes(htmlspecialchars($_POST['text']))."')";


    mysql_query($sql) OR die(mysql_error());
echo "Daten wurden eingetragen";
}
else {
 @mysql_connect("localhost", "root","") OR die(mysql_error());
    mysql_select_db("forum") OR die(mysql_error());


$sql = "SELECT
                        name,
                        email,
                        text
                    FROM
                        homed";
$result = mysql_query($sql) OR die(mysql_error());
echo "<table border='1'>";
    while($row = mysql_fetch_assoc($result)) {
echo "<tr><td>".$row['name']."</td></tr>";
echo "<tr><td>".$row['email']."</td></tr>";
echo "<tr><td>".$row['text']."</td></tr>
";
}
echo "</table>";
}








?>

<form action="test.php" method="post">
Name:


    <input type="text" name="name" size="41" maxlength="15"  style="background-color: #FFFF00;" onFocus="this.style.backgroundColor='#FFD700'" onblur="this.style.backgroundColor='#FFFF00'">


E-Mail:


   <input type="text" name="email" size="41" maxlength="30"  style="background-color: #FFFF00;" onFocus="this.style.backgroundColor='#FFD700'" onblur="this.style.backgroundColor='#FFFF00'">


Text:


   <textarea name="text" cols="30" rows="10" style="background-color: #FFFF00;" onFocus="this.style.backgroundColor='#FFD700'" onblur="this.style.backgroundColor='#FFFF00'"></textarea>


<input type="submit" name="submit" value="abschicken" />