コード例 #1
0
 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;
 }
コード例 #2
0
ファイル: edit.php プロジェクト: sarahkekslein/tictactoe
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;
}
コード例 #3
0
ファイル: home.php プロジェクト: VadimGhost/ToDoList
<?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>
コード例 #4
0
ファイル: models.php プロジェクト: b1oki/AnotherShopCMS
function getAllNews()
{
    return Database::get_data('SELECT * FROM `news` ORDER BY `created` DESC;');
}
コード例 #5
0
<?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();