gratis enkelt kontaktformulär med mysql-databas sökes.

CREATE TABLE IF NOT EXISTS `anmälda` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `namn` varchar(255) NOT NULL,
  `tele` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `kommentar` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

<?php
  
$mysql_server = "localhost";
$mysql_user = "root"; /// databas användare
$mysql_password = "lösenord"; /// databas lösenord
$mysql_database = "bröllop"; /// databas
 
$conn = mysql_connect($mysql_server, $mysql_user, $mysql_password);
mysql_select_db($mysql_database, $conn);


if (isset($_POST['submit'])) { 
if (!empty($_POST['namn'])) { 

$namn = mysql_real_escape_string($_POST['namn']);
$tele = mysql_real_escape_string($_POST['tele']);
$email = mysql_real_escape_string($_POST['email']);
$kommentar = mysql_real_escape_string($_POST['kommentar']);

$notes = "INSERT INTO anmälda (namn, tele, email, kommentar) VALUES ('$namn', '$tele', '$email', '$kommentar')";
mysql_query($notes);
echo "<b>Du är nu anmäld till bröllopet</b>";
}else{
echo "<b>Du måste skriva in ett namn</b>";
}
}

?>

<form action="#" method="post">
Namn:<br> 
<input type="text" name="namn"><br />
telefonnummer:<br />
<input type="text" name="tele"><br />
e-post:<br />
<input type="text" name="email"><br />

Kommentar:<br>
<textarea name="kommentar" style="width: 320px; height: 129px"></textarea>

<br>
<input type="submit" name="submit" value="Skicka" /> 
</form>

<?php
$mysql_server = "localhost";
$mysql_user = "root"; /// databas användare
$mysql_password = "lösenord"; /// databas lösenord
$mysql_database = "bröllop"; /// databas
 
$conn = mysql_connect($mysql_server, $mysql_user, $mysql_password);
mysql_select_db($mysql_database, $conn);

$sql = "SELECT * FROM anmälda ORDER BY id DESC";
$result = mysql_query($sql); 

  
while($show = mysql_fetch_array($result))
{
echo "<a href=\"sreg.php?id=".$show['id']."\" >".strip_tags($show['namn'])." </a><br />";
}
?>

<?php
$mysql_server = "localhost";
$mysql_user = "root"; /// databas användare
$mysql_password = "lösenord"; /// databas lösenord
$mysql_database = "bröllop"; /// databas
 
$conn = mysql_connect($mysql_server, $mysql_user, $mysql_password);
mysql_select_db($mysql_database, $conn);

$id = mysql_real_escape_string($_GET['id']); 


if(!is_numeric($id)) die('Felaktig indata');


$sql = "SELECT * FROM anmälda WHERE id = $id";
$result1 = mysql_query($sql); 
$row = mysql_fetch_assoc($result1);


if(isset($_GET['radera-a'])) {
 
echo "Är du säker på att du vill radera den här anmälningen? ";
echo "<a href='sreg.php?id=";
echo $id;
echo "&radera-a=";
echo $id;
echo "&delete'>Ja</a> / <a href='sreg.php?id=";
echo $id;
echo "'>Nej</a>";
}

if(isset($_GET['delete'])) {
    mysql_query("DELETE FROM anmälda WHERE id='$id'");
    echo '<meta http-equiv="Refresh" content="0; url=registrerade.php">';

 }

echo "<br />";
echo "<b>Namn:</b> ";
echo $row['namn']; 
echo "<br />";

echo "<b>Telefon:</b> ";
echo $row['tele']; 
echo "<br />";

echo "<b>e-mail:</b> ";
echo $row['email'];
echo "<br />";

echo "<b>Kommentar:</b> ";
echo $row['kommentar'];
?>
<br />
<a href="sreg.php?id=<?php echo $id; ?><?php echo "&radera-a=";?><?php echo $id; ?>">Radera</a>