Primeur
|
// set all needed variables to connect with MySQL database $user = "user_naam"; $pass = "password"; $host = "localhost"; $dbdb = "database_naam"; // connect to MySQL database if (!mysql_select_db($dbdb, mysql_connect($host, $user, $pass))) // give error message if the connection could not be established echo "Sorry, de database kan niet geopend worden."; // unset all variables unset($user); unset($pass); unset($host); unset($dbdb); $table = "tabel_naam"; //-- insert reaction to database if ($_POST['at'] && ($_POST['door'] && $_POST['msg'])) { $sql3 = "INSERT INTO " . $table . " (id, door, email, msg, at, tid, ip, fid) VALUES ('', '" . stripslashes($_POST['door']) . "', '" . stripslashes($_POST['email']) . "', '" . stripslashes($_POST['msg']) . "', '" . $_POST['at'] . "', '" . $_POST['id'] . "', '" . $_SERVER['$REMOTE_ADDR'] . "', '" . $fid . "')"; $res3 = mysql_query($sql3); if ($res3) { if ($fid) $insert = "
Bedankt voor het reageren!
"; else $insert = "Bedankt voor het reageren $door!
"; } else { $insert = "Sorry, je reactie is niet opgeslagen, probeer het opnieuw of neem contact met ons op.
"; } $fid = ""; $door = ""; $email = ""; $msg = ""; } //-- not enough data elseif ($_POST['at']) { $insert = "Je bent je naam of bericht vergeten.
"; } //-- recieve reacties from database $sql2 = "SELECT * FROM " . $table . " WHERE tid = " . $id . " order by id"; $res2 = mysql_query($sql2); echo "
";
echo "
";
echo $insert;
//-- show reactions
if (mysql_num_rows($res2) >= 1)
{
while ($row2 = mysql_fetch_array($res2))
{
if ($row2[fid])
{
$fsql = "SELECT id, name FROM $table WHERE id = $row2[fid]";
$fres = mysql_query($fsql);
$frow = mysql_fetch_array($fres);
}
$row2['door'] = htmlentities($row2['door']);
$row2['email'] = htmlentities($row2['email']);
$row2['msg'] = htmlentities($row2['msg']);
$row2['msg'] = nl2br($row2['msg']);
if ($row2[email])
echo "Reactie door " . $row2['door'] . " @ " . $row2['at'] . " (" . $row2['ip'] . ") "; else echo "Gepost door " . $row2['door'] . " @ " . $row2['at'] . " (" . $row2['ip'] . ") "; echo "$row2[msg] "; } } else { echo "Er zijn nog geen reacties."; } echo " "; echo " "; // door email at tid $at = date('d-m-Y'); //echo " "; echo " "; echo " | ";
echo "
";
?>