private function get_member_data() { $db_connect = Database::getInstance(); $data = Database::get_data("SELECT win, lose, tie FROM statistic WHERE userid={$this->id}", $db_connect); $this->name = Database::get_data("SELECT name FROM user WHERE id={$this->id}", $db_connect)['name']; return $data; }
function get_player_info($id) { $data = array("id" => $id); $db_connection = Database::getInstance(); $data_statistic = Database::get_data('SELECT name, password, email, description FROM user WHERE id=' . $id, $db_connection); $data_user = Database::get_data('SELECT win, lose, tie FROM statistic WHERE userid=' . $id, $db_connection); $data = array_merge($data, $data_statistic, $data_user); $db_connection = null; return $data; }
<?php include 'database.php'; $database = new Database(); $result = $database->get_data("SELECT * FROM `list`", 'get_all'); ?> <!DOCTYPE HTML> <html> <head> <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script> <script src="js/script.min.js"></script> <link rel="stylesheet" href="css/style.min.css"> </head> <body> <input type="text" name="text" id="text"> <input type="button" id="btn-ok" onclick="send();" value="OK"> <div id="content"> <?php while($row=mysql_fetch_array($result)):?> <p <?php if($row['parent'] != null):?> <?='class="sub-tusk"'?> <?php endif?> ><?=$row['id']?>. <?=$row['text']?> <input type="checkbox" <?php if($row['done'] == true):?> <?='checked'?> <?endif?>></p> <?php endwhile?> </div> </body> </html>
function getAllNews() { return Database::get_data('SELECT * FROM `news` ORDER BY `created` DESC;'); }
<?php /** * Created by PhpStorm. * User: Marvin * Date: 23.07.2015 * Time: 21:44 */ require_once './lib/Database.class.php'; session_start(); $db_connect = Database::getInstance(); $data = Database::get_data("SELECT win, lose, tie FROM statistic WHERE userid=" . $_SESSION['user'], $db_connect); $statement = "UPDATE statistic SET win=:win,lose=:lose,tie=:tie WHERE userid=" . $_SESSION['user']; switch ($_POST['content']) { case 0: $data['lose']++; break; case 1: $data['tie']++; break; case 2: $data['win']++; break; } $db_upload = $db_connect->prepare($statement); $db_upload->bindValue(':win', "" . $data['win']); $db_upload->bindValue(':lose', "" . $data['lose']); $db_upload->bindValue(':tie', "" . $data['tie']); $db_upload->execute(); $db_upload->closeCursor();