/* -------------------------------------------------------------------------- */
/* Zugangsdaten werden festgelegt */
/* -------------------------------------------------------------------------- */
// $host = "217.160.218.99"; /* Host wo Datenbank läuft */
$host = "213.238.36.40"; /* Host wo Datenbank läuft */
$user = "web8"; /* Benutzername für Datenbank */
$passwd = "kd0008"; /* Kennwort für Datenbank */
$db_name = "usr_web8_1"; /* Name der Datenbank */
$table_name = "bronx_gbook"; /* Name der Tabelle */
/* -------------------------------------------------------------------------- */
if ($gbook_eintrag) {
if ($text != "") {
// Erzeugt Datum und Zeit
$date = date(d).".".date(m).".".date(y);
$time = date(H).":".date(i);
// Prüft und konvertiert die E-Mail-Adresse
$check_email = ereg("@", $email);
if ($check_email == 1) {
$name_html = ''.$name.'';
} else {
$name_html = $name;
$email = ''; }
// Prüft und konvertiert die URL
$url = ereg_replace("http://", "", $url);
$check_url = strlen($url);
if ($check_url >= 6) {
$url_html = 'Website';
} else {
$url_html = '-';
$url = ''; }
// DB-Eintrag
$db = mysql_connect($host, $user, $passwd);
mysql_select_db($db_name,$db);
$sql_insert = "INSERT INTO $table_name
( date, time, name, email, url, text, name_html, url_html )
VALUES
( '$date', '$time', '$name', '$email', '$url', '$text', '$name_html', '$url_html' )";
mysql_query($sql_insert,$db);
}}
?>

 
|
G
ä s t e b u c h
$db = mysql_connect($host, $user, $passwd);
mysql_select_db($db_name,$db);
$sql_select = "SELECT * FROM $table_name ORDER BY id DESC";
$result = mysql_query ($sql_select,$db);
if ($result){
while ($eintrag = mysql_fetch_array($result)){
$date = $eintrag[1];
$time = $eintrag[2];
$name_html = $eintrag[7];
$url_html = $eintrag[8];
$text = htmlentities($eintrag[6]);
$text = nl2br($text);
?>
echo ($name_html) ?>
|
echo ($date) ?>, echo ($time) ?> Uhr
|
}}
?>
|
|
|
|