muss ich mal wie immer selbst ran, was ;-)
(könnte man noch stark verbessern, ist nur mal ein bsp)
PHP Code:
<?
session_start();
$dbhost = ''; //Hostname of the mysql server, can also a ip adress
$dbuser = ''; //Username of the mysql database
$dbpass = ''; //Password of the mysql database
$dbname = ''; //Name of the database you want to use
$db = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname, $db);
$val_name = mysql_real_escape_string($_POST['name']);
$val_email = mysql_real_escape_string($_POST['email']);
$val_wunsch = mysql_real_escape_string($_POST['wunsch']);
$val_gruss = mysql_real_escape_string($_POST['gruss']);
if ($val_name != "")
{
$sql = "INSERT INTO wunschbox (`name` ,`email`, `wunsch`, `gruss`)VALUES ('$val_name','$val_email', '$val_wunsch', '$val_gruss')";
mysql_query($sql);
}
echo '
<html>
<body>
<form action="" method="post">
<table><tr>
<td><p>Name</p></td>
<td><input maxlength="30" type="text" name="name" /></td>
</tr><tr>
<td><p>E-mail</p></td>
<td><input maxlength="30" type="text" name="email" /></td>
</tr><tr>
<td><p>Wunsch</p></td>
<td><input maxlength="30" type="text" name="wunsch" /></td>
</tr><tr>
<td><p>Gruss</p></td>
<td><input maxlength="30" type="text" name="gruss" /></td>
</tr><tr>
<td><input type="submit" name="action" value="Wunsch abschicken" /></td>
</tr></table>
</form>
</body>
</html>';
?>
Code:
CREATE TABLE IF NOT EXISTS `wunschbox` (
`wunschid` int(11) NOT NULL auto_increment,
`name` text collate latin1_german2_ci NOT NULL,
`email` text collate latin1_german2_ci NOT NULL,
`wunsch` text collate latin1_german2_ci NOT NULL,
`gruss` text collate latin1_german2_ci NOT NULL,
PRIMARY KEY (`wunschid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=1 ;
