PHP Database::GetAll Examples

Example #1

File: mail.php Project: NikoVonLas/RaptorGameEngine

		<form method="POST" action="" role="form">
			<div class="form-group">
				<label>Тема письма</label>
				<input class="form-control" name="subject" placeholder="Тема письма">
			</div>
			<div class="form-group">
				<label>Сообщение</label>
				<textarea class="form-control" name="message" rows="3"></textarea>
			</div>
			<button type="submit" class="btn btn-default">Отправить сообщение</button>
		</form>';
        break;
    case "masscript":
        if (isset($_POST['eval'])) {
            $mail = new Mail();
            $players = Database::GetAll('players');
            foreach ($players as $a) {
                $player = new Player(__toString($a['_id']));
                if (!eval($_POST['eval'])) {
                    unset($player);
                    continue;
                }
                if ($mail->sendMail(array('to' => $a['email'], 'subject' => $_POST['subject'], 'message' => $_POST['message']))) {
                    $count += 1;
                } else {
                    echo '<div class="alert alert-danger">Ошибка при отправке на <b>' . $a['email'] . '</b> (' . $a['login'] . ')</div>';
                }
                unset($player);
            }
            echo '<div class="alert alert-success">Сообщение отправлено на <b>' . $count . '</b> адресов</div>';
        }

Example #2

File: index.php Project: NikoVonLas/RaptorGameEngine

    <div class="col-lg-4">
        <div class="panel panel-default">
            <div class="panel-heading">
                <h3 class="panel-title"><i class="fa fa-money fa-fw"></i> Последние платежи</h3>
            </div>
            <div class="panel-body">
                <div class="table-responsive">
                    <table class="table table-bordered table-hover table-striped">
                        <thead>
                            <tr>
                                <th>ID</th>
                                <th>Аккаунт</th>
                                <th>Дата платежа</th>
                                <th>Оплачено</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php 
$u = Database::GetAll("payments")->limit(5)->sort(array("dateCreate" => -1));
foreach ($u as $array) {
    echo '<tr><td>' . $array['unitpayId'] . '</td><td>' . $array['account'] . '</td><td>' . $array['dateCreate'] . '</td><td>' . $array['sum'] . '</td>';
}
?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
<!-- /.row -->

Example #3

File: scripts.php Project: NikoVonLas/RaptorGameEngine

<?php 
if (isset($_POST['file'])) {
    Database::Edit('scripts', array('name' => $_POST['file']), array('code' => base64_encode($_POST['edit'])));
    Cache::set("script_" . $_POST['file'], base64_encode($_POST['edit']), 86400);
    echo '<div class="alert alert-success">Скрипт успешно отредактирован. Кэш обновлен.</div>';
}
if (isset($_GET['edit'])) {
    $content = isset($_POST['edit']) ? $_POST['edit'] : base64_decode(Database::GetOne('scripts', array('name' => $_GET['edit']))['code']);
    echo "<form action='' method='POST'>\n        <input type='hidden' name='file' value='" . $_GET['edit'] . "'>\n        <textarea rows=15 cols=105 name='edit'>" . $content . "</textarea> <br>\n        <button type='submit' class='btn btn-default'>Сохранить</button>\n        </form>\n        <hr>";
}
?>
<div class="table-responsive">
<table class="table table-bordered table-hover table-striped">
<thead>
<tr>
    <td>Скрипт</td>
    <td></td>
</tr>
</thead>
<tbody>

<?php 
$files = Database::GetAll('scripts');
foreach ($files as $file) {
    echo "<tr><td> <b><font size=3>" . $file['name'] . "</font></b> </td><td> <a href='?edit=" . $file['name'] . "'>Редактировать</a> </td></tr>";
}
?>

</tbody>
</table>
</div>