";
echo "input for mail: ". $_POST['mail'];
echo "
";
echo "input for sex: ". $_POST['sex'];
echo "
===============
";
if (empty($_POST['domain']) || empty($_POST['sex']) || empty($_POST['mail']))
{
$test = "aaaaaaaaaaaa";
//include ('eg007d_form.php');
//include file content, not the best way, but keep variable values
header("Location: eg007d_form.php");
//redirect, need to use session to keep value, or pass value around
}
else
{
$dberror = "";
$ret = add_to_database ($_POST['domain'],$_POST['sex'],$_POST['mail'],$dberror);
if (! $ret)
{
print "Error: $dberror
";
}
else
print "Thank you very much";
}
function add_to_database ($domain, $sex, $mail, &$dberror)
{
$db = "sample";
$user = "harry";
$pass = "elbomonkey";
$link = mysql_connect("localhost", $user, $pass);
if (! $link)
{
$dberror = "Couldn't connect to MySQL server";
return false;
}
if (! mysql_select_db($db, $link))
{
$dberror = mysql_error();
return false;
}
$query = "INSERT INTO domains (domain, sex, mail)
values ('$domain','$sex','$mail')";
if (! mysql_query($query, $link))
{
$dberror = mysql_error();
return false;
}
mysql_close($link);
return true;
}
?>