Habe da mal ein Script entwickelt für ein gästebuch
Name der Datei INDEX.php
- Code: Select all
<?php
error_reporting(0);
include "mysql_connect.php";
$res = mysql_db_query("$database_name",
"select * from guestbook order by entry_id desc");
$num = mysql_num_rows($res);
?>
<hr color="black" size="1">
<font face="Verdana" size="1">
<a href="guestbook_new.php" style="text-decoration: none">» Neuer Eintrag</a> - <?php echo "$num Einträge"; ?>
</font>
<hr color="black" size="1">
<?php
for ($i=0; $i<$num; $i++)
{
$name = mysql_result($res, $i, "name");
$email = mysql_result($res, $i, "email");
$homepage = mysql_result($res, $i, "homepage");
$text = mysql_result($res, $i, "text");
$datum = mysql_result($res, $i, "datum");
?>
<table>
<tr><td><b><font face="Verdana" size="1">Name:</td><td width="175"><font face="Verdana" size="1"><?php echo "$name"; ?>
</font></font></td><td><b>
<font face="Verdana" size="1">EMail:</td><td><font face="Verdana" size="1"><?php echo "$email"; ?>
</font></font></td></tr>
<tr><td><b><font face="Verdana" size="1">Datum:</td><td width="175"><font face="Verdana" size="1"><?php echo "$datum"; ?>
</font></font></td><td><b>
<font face="Verdana" size="1">Homepage:</font></td><td>
<font face="Verdana" size="1">
<a style="text-decoration: none" href=<?php echo "$homepage"; ?> target="_blank"><?php echo "$homepage"; ?></a></font></td></tr>
</table>
<table>
<tr><td><b><font face="Verdana" size="1">Eintrag:</font></td><td colspan="3"><font face="Verdana" size="1"><?php echo "$text"; ?>
</font></td></tr>
</table>
<hr color="black" size="1">
<?php
}
mysql_close($db);
?>
Name der Datei install.php
- Code: Select all
<?php
include "mysql_connect.php";
$sqlab = 'CREATE TABLE `guestbook` ( `entry_id` INT NOT NULL AUTO_INCREMENT ,'
. ' `name` TEXT NOT NULL ,'
. ' `email` TEXT NOT NULL ,'
. ' `homepage` TEXT NOT NULL ,'
. ' `text` TEXT NOT NULL ,'
. ' `datum` TEXT NOT NULL ,'
. ' PRIMARY KEY ( `entry_id` ) );'
. ' ';
mysql_db_query("$database_name", $sqlab);
echo "<b>Sofern die SQL-Daten richtig eingegeben wurden, sind jetzt alle Tabellen erstellt!</b>";
?>
Name der Datei mysql_connect.php
- Code: Select all
<?php
// Bitte hier Ihre Daten eintragen:
$servername = "192.168.0.1"; // IP-Adresse oder Name des Servers
$username = "Anonym"; // Username für die MySQL-Datenbank
$password = ""; // Passwort für die MySQL-Datenbank
$database_name ="horst123"; // Name der Datenbank auf dem Server
// Ab hier nichts mehr ändern!
$db = mysql_connect("$servername", "$username", "$password");
?>
Name der Datei guestebuch_add.php
- Code: Select all
<?php
error_reporting(0);
$datum = date("d.m.Y");
include "mysql_connect.php";
if ($name == "" || $text == "")
{
echo "<meta http-equiv=\"refresh\" content=\"0; URL=index.php\">";
}
else
{
if ($homepage == "http://")
{
$homepage = "";
}
$sqlab = "insert guestbook";
$sqlab .= "(name, email, homepage, text, datum) values ";
$sqlab .= "('$name', '$email', '$homepage', '$text', '$datum')";
mysql_db_query("$database_name", $sqlab);
$num = mysql_affected_rows();
if ($num>0)
echo "<meta http-equiv=\"refresh\" content=\"0; URL=index.php\">";
mysql_close($db);
}
?>
Name der Datei guestebuch_new.php
- Code: Select all
<html>
<form method="POST" action="guestbook_add.php">
<table>
<tr><td><font face="Verdana" size="1">Name</font></td><td>
<font size="1" face="Verdana"><input type="text" name="name" size="40"></font></td></tr>
<tr><td><font face="Verdana" size="1">Email</font></td><td>
<font face="Verdana" size="1"><input type="text" name="email" size="40"></font></td></tr>
<tr><td><font face="Verdana" size="1">Homepage</font></td><td>
<font face="Verdana" size="1"><input type="text" name="homepage" size="40" value="http://"></font></td></tr>
<tr><td><font face="Verdana" size="1">Text</font></td><td>
<font face="Verdana" size="1"><textarea rows="6" name="text" cols="50"></textarea></font></td></tr>
</table>
<font size="1" face="Verdana">
<input type="submit" value="Abschicken" name="Senden"> </font>
</form>
</html>
Kann mir dabei vielleicht jemand weiter Helden
Mfg apachetester