function insertMember($host, $user, $pass, $database, $table)
{
$query = "INSERT INTO {$table} (ime,prezime,adresa,postnum,mjesto,telefon,email,skola,clan,auto,izlet,majica,boja,velicina,user,password) VALUES ('{$this->ime}', '{$this->prezime}', '{$this->adresa}', '{$this->brojPoste}', '{$this->mjesto}', '{$this->telefon}', '{$this->email}', '{$this->skola}', '{$this->clan}', '{$this->auto}', '{$this->izlet}', '{$this->majica}', '{$this->boja}', '{$this->velicina}', '{$this->username}', '" . md5($this->password) . "')";
try {
$conn = new mysqlConnection($host, $user, $pass, $database);
$conn->open();
mysql_query($query);
$success = true;
$conn->close();
unset($conn);
} catch (Exception $e) {
echo $e->getMessage();
$success = false;
}
return $success;
}
}
$sudionik = new sudionik($ime, $prezime, $adresa, $broj_poste, $mjesto, $telefon, $user, $domain, $skola, $clan, $auto, $izlet, $majica, $boja, $velicina);
if ($sudionik->insertMember($dbhostname, $dbusername, $dbpassword, $dbname, $dbtbl) && $sudionik->sendMailToMember() && $sudionik->sendNotification()) {
unset($sudionik);
echo "<SCRIPT LANGUAGE='javascript'>window.alert ('Prijava uspje¹no izvr¹ena! Na email koji ste unijeli stiæi æe vam ostale upute.'); window.open('index.php','_self');</SCRIPT>";
} else {
unset($sudionik);
echo "<SCRIPT LANGUAGE='javascript'>window.alert ('Gre¹ka prilikom prijave!'); window.open('index.php','_self');</SCRIPT>";
}
$tip = NULL;
break;
case "login":
$username = $_REQUEST["txtUserName"];
$password = $_REQUEST["txtPassword"];
$conn = new mysqlConnection($dbhostname, $dbusername, $dbpassword, $dbname);
$conn->open();
if (!validateLoginData($username, $password, $conn->dbconnection)) {
echo "<SCRIPT LANGUAGE='javascript'>window.alert ('Pogre¹no upisani podaci ili niste prijavljeni na skup!'); window.open('index.php','_self');</SCRIPT>";
$conn->close();
unset($conn);
} else {
if (isAdmin($username)) {
$query = "SELECT ime, prezime, adresa, postnum, mjesto, telefon, email, skola, clan, auto, izlet, majica, boja, velicina, user FROM " . $dbtbl;
$result = mysql_query($query);
if (mysql_num_rows($result) <= 0) {
$conn->close();
unset($conn);
echo "<SCRIPT LANGUAGE='javascript'>window.alert ('Nema zapisa!');window.open('index.php','_self');</SCRIPT>";
} else {
echo '
<html>
