function create() { $users = user::all(); $data['users'] = $users; $sites = site::all(); $data['sites'] = $sites; $this->view('sites/create_view.php', $data, 'main_template.php'); }
function create() { $user_id = $_GET['user_id']; $user = user::from_id($user_id); $user->accounts = account::from_user($user->user_id); $sites = site::all(); foreach ($sites as $key => $site) { foreach ($user->accounts as $account) { if ($account->site_id == $site->site_id) { unset($sites[$key]); } } } $data['sites'] = $sites; $this->view('accounts/create_view.php', $data, 'main_template.php'); }
function home() { $masters = master::all(); $data['masters'] = $masters; $data['total'] = 0; foreach ($masters as $master) { $data['total'] += $master->cash; } $users = user::all(); foreach ($users as $user) { $user->accounts = account::from_user($user->user_id); $bets = array(); $user->calculation['cash_in'] = 0; $user->calculation['cash_out'] = 0; $user->calculation['bonus'] = 0; foreach ($user->accounts as $account) { # räkna ut alla pengar $account->transactions = transaction::from_account($account->account_id); foreach ($account->transactions as $transaction) { $transactions[] = $transaction; if ($transaction->type == "cash_in") { $user->calculation['cash_in'] += $transaction->amount; } elseif ($transaction->type == "bonus") { $user->calculation['bonus'] += $transaction->amount; } elseif ($transaction->type == "cash_out") { $user->calculation['cash_out'] -= $transaction->amount; } } $account->cash(); } } $data['users'] = $users; $sites = site::all(); $data['sites'] = $sites; $matches = match::all_active(); $data['matches'] = $matches; $this->view('index_view.php', $data, 'main_template.php'); }
$stmt->execute(); $row = $stmt->fetchall(PDO::FETCH_CLASS, 'site'); return $row; } catch (PDOException $e) { echo 'ERROR: ' . $e->getMessage(); } } function create() { try { $conn = new PDO(PDOCONNECT, PDOUSERNAME, PDOPASSWORD, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8')); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $conn->prepare('INSERT INTO sites SET name=:name,comment=:comment'); $stmt->execute(array("name" => $this->name, "comment" => $this->comment)); return $conn->lastInsertId(); } catch (PDOException $e) { echo 'ERROR: ' . $e->getMessage(); } } } if (isset($_GET['c']) && $_GET['c'] == "create") { $site = new site(); $site->name = $_POST['name']; $site->comment = $_POST['comment']; $id = $site->create(); return $id; } elseif (isset($_GET['c']) && $_GET['c'] == "all") { $sites = site::all(); echo json_encode($sites); exit; }