if(!isset($mane)&&!isset($mal))
{
//Navstevnik musi zadat uzivatelske meno a mail
?>
Insert your surname and e-mail:
}
else
{
// connect to mysql
$spojeni = mysql_connect( 'localhost', 'dagmar', 'dejt' );
if(!$spojeni)
{
echo 'Nepodarilo sa pripojiť k databáze.';
exit;
}
// Vyber databazy
$mysql = mysql_select_db( 'scg' );
if(!$mysql)
{
echo 'Nepodarilo sa vybrať databazu.';
exit;
}
// oznamenie, ze pozna meno a heslo
$query = "select count(*) from prihlaska23 where
Priezvisko = '$name' and
Email = '$mal'";
$result = mysql_query( $query );
if(!$result)
{
echo 'Cannot run query.';
exit;
}
$count = mysql_result( $result, 0, 0 );
if ( $count > 0 )
{
$vysledek = MySQL_DB_Query("scg", "SELECT * FROM prihlaska23 WHERE (Priezvisko = '$name' and Email = '$mal')", $spojeni);
if (!$vysledek):
echo "Chyba pri prehľadávaní zoznamu účastnikov.\n";
break;
endif;
while ($zaznam = MySQL_Fetch_Array($vysledek))
{
// echo $zaznam["Pasw"];
if (Mail("$mal", "$name - Help",
// if (Mail("$mal", "$name",
$zaznam['Pasw'].
"\n \n This Information was sent You on Your request.\n \n",
"From: scg@sjf.stuba.sk\n". "Bcc: szarkova@sjf.stuba.sk; scg@sjf.stuba.sk")):
echo "Your password has been sent to the introduced e-mail address.
";
echo "" ;
else:
echo "It was unable to send You Your password.\n Contact please preparatory committee.";
endif;
} while (false);
}
else
{
// spatna kombinacia priezviska a mailu
echo "In the registration form You have entered another e-mail,
or You are not registered, yet.
";
echo "" ;
echo "" ;
echo "If Your e-mail address has changed and You have forgot Your password,
write us on this address: ", "scg@sjf.stuba.sk";
}
}
?>