static function add($username, $passwordRaw, $type, $name, $age, $club)
{
//
$db = new DB();
$usernameAvailable = User::usernameExists($username);
$clubnameAvailable = Club::clubnameExists($club);
$password = hash('md5', $passwordRaw);
if ($usernameAvailable == FALSE) {
$res = $db->queryIns("INSERT INTO user(username,password,type) VALUES('{$username}','{$password}','{$type}')");
$u_id = $db->query("SELECT user_id FROM user WHERE username='******'")->fetch(PDO::FETCH_ASSOC);
//->fetch(PDO::FETCH_ASSOC)
$c_id = $db->query("SELECT club_id FROM club WHERE name = '{$club}'")->fetch(PDO::FETCH_ASSOC);
$user_id = (int) $u_id['user_id'];
$club_id = (int) $c_id['club_id'];
$agein = (int) $age;
var_dump($clubnameAvailable);
if ($type == "player" and $clubnameAvailable == TRUE) {
$res = $db->queryIns("INSERT INTO player (player_id,club_id,name,age) VALUES ({$user_id},{$club_id},'{$name}',{$agein})");
//
}
if ($type = "manager") {
$res = $db->queryIns("INSERT INTO manager (manager_id,name,age) VALUES ({$user_id},'{$name}',{$agein})");
// this is ok.
$result = $db->query("INSERT INTO club (manager_id,name) VALUES ({$user_id},'{$club}')");
var_dump($name);
}
} else {
echo 0;
}
}
static function addMatch($verses)
{
$db = new DB();
$sql = "INSERT INTO game (match_date,verses) VALUES(CURDATE(),'{$verses}')";
$res = $db->queryIns($sql);
var_dump($res);
}
static function addClub($clubname, $managerName)
{
$db = new DB();
var_dump($clubname);
var_dump($managerName);
$clubNameAvailable = Club::clubnameExists($clubname);
//var_dump($clubNameAvailable);echo "<br>";
$m_id = $db->query("SELECT user_id FROM user WHERE username='******' AND type='manager'")->fetch(PDO::FETCH_ASSOC);
//var_dump($m_id);echo "<br>";
$manager_id = (int) $m_id["user_id"];
var_dump($manager_id);
if ($clubNameAvailable == FALSE) {
// if club name is not available then can add as the manager.
$res = $db->queryIns("INSERT INTO club (manager_id,name) VALUES ({$manager_id},'{$clubname}')");
}
var_dump($res);
}
