function show()
{
$configuration = new Config();
$database = new SafeMySQL(array('user' => $configuration->db->username, 'pass' => $configuration->db->password, 'db' => $configuration->db->database, 'charset' => $configuration->db->charset));
$data = $database->getAll('SELECT * FROM students');
$response = new Response();
$response->setContent(json_encode($data));
$response->send();
}
public function userPage($userId)
{
if ($this->accessControl($userId)) {
$db = new SafeMySQL();
$users = $db->getAll('SELECT id,login,name,avatar FROM ?n WHERE id = ?i LIMIT ?i', $this->table, $userId, 1);
$user = array();
if (!empty($users[0]['id'])) {
foreach ($users[0] as $key => $value) {
$user[$key] = $value;
}
}
$userName = empty($user['name']) ? $user['login'] : $user['name'];
$user['page_title'] = "Здравствуйте, " . $userName;
$user['title'] = $userName;
$user['avatar'] = empty($user['avatar']) ? $this->no_avatar : $user['avatar'];
$this->view('user', $user);
} else {
$content['title'] = "УПС!";
$content['message'] = "У вас нет доступа к этой странице. Пожалуйста <a href='/user'>авторизируйтесь</a> чтобы войти!";
$this->view('check', $content);
}
}
<?php
require_once "pass.php";
require_once "lib/safemysql.class.php";
$tableName = "tickets";
echo "Log in MySQL<br>\n";
$db = new SafeMySQL(['host' => $loginData['mysql_host'], 'user' => $loginData['mysql_username'], 'pass' => $loginData['mysql_password'], 'db' => $loginData['mysql_db']]);
echo "<br>List fields in table:<br>\n";
$sql = "SHOW COLUMNS FROM {$tableName}";
$fields = $db->getCol($sql);
//Print table to HTML
?>
<table border="1">
<thead>
<tr>
<?
foreach($fields as $fieldname) {
echo "<td>$fieldname</td>\n";
}
echo "</tr></thead><tbody>";
$data=$db->getAll("SELECT * FROM $tableName ORDER BY dtime DESC LIMIT 100");
foreach($data as $row=>$cols) {
echo"<tr>";
foreach($cols as $col) {
echo " <td>$col</td>\n";
}
echo "</tr>\n";
}
echo "</tbody></table>";
?>
<?php
require '../php/main/SafeMySQL.php';
$string_object = new SafeMySQL();
if ($category === 'all' || !$category) {
$query = $string_object->getAll("SELECT i.v_id, i.user_id, i.title, i.image, i.date, u.nickname FROM posts_videos_in i, users_information u WHERE i.user_id = u.user_id ORDER BY i.v_id DESC LIMIT 0,10");
} else {
$query = $string_object->getAll("SELECT i.v_id, i.user_id, i.title, i.image, i.date, u.nickname FROM posts_videos_in i, users_information u WHERE i.category=?s AND i.user_id = u.user_id ORDER BY i.v_id DESC LIMIT 0,10", $category);
}
$arr = array();
$i = 0;
foreach ($query as $array) {
$image = file_exists('../upload_image/videos/pre_500px/' . $array['image'] . '.jpg') ? $array['image'] : 'default';
$link = $category ? $page . '=' . $category . '&video=' . $array['v_id'] : $page . '&video=' . $array['v_id'];
$res = array('n0' => $array['v_id'], 'n1' => $image, 'n2' => $array['title'], 'n3' => $array['date'], 'n4' => $array['nickname']);
if (!$i) {
$res = array('head' => '<nav id="content_menu">
<a href="vo=all" class="new_local"><p>ВСЕ</p></a>
<a href="vo=review" class="new_local"><p>ОБЗОРЫ</p></a>
<a href="vo=letsplay" class="new_local"><p>ЛЕТСПЛЕИ</p></a>
<a href="vo=vlog" class="new_local"><p>БЛОГИ</p></a>
<div id="lookatme">
<div class="lookatme"></div>
<div class="lookatme"></div>
<div class="lookatme"></div>
</div>
</nav>
<nav id="content_search"></nav><section id="content_block">', 'tmp' => '<a href="vo&video=%n[0]" class="new_modal">
<article class="video" id="%n[0]" style="background:#000 no-repeat center url(upload_image/videos/pre_500px/%n[1].jpg)">
<div class="video_title">
<p>%n[2]</p>
<?php
require '../php/main/db_connect.php';
require 'mm/parser.php';
$arr = array();
if ($last_id && $page && $user_id) {
$string_object = new SafeMySQL();
$writer = new Writer();
$y = $string_object->getRow("SELECT d_id, other_id, pioneer_id,meter FROM users_dialogs WHERE d_id=?i AND pioneer_id=?i OR d_id=?i AND other_id=?i LIMIT 1", $category, $user_id, $category, $user_id);
if ($y['d_id']) {
$dg = $string_object->getAll("SELECT m.text, m.date, m.mes_id, i.avatar, i.category, i.nickname FROM users_messages m, users_information i WHERE m.d_id=?i AND m.mes_id < ?i AND i.user_id = m.user_id ORDER BY m.mes_id DESC LIMIT 10", $y['d_id'], $last_id);
$avatar = $string_object->getOne('SELECT avatar FROM users_information WHERE user_id=?i', $user_id);
$avatar = file_exists('../upload_image/avatars/pre_150px/' . $avatar . '.jpg') ? $avatar : 'default';
$i = 0;
foreach ($dg as $array) {
$res = array('n0' => $y['d_id'], 'n1' => $array['mes_id'], 'n2' => $array['avatar'], 'n3' => $array['nickname'], 'n4' => $array['date'], 'n5' => $writer->main($array['text'], 1));
$i++;
array_push($arr, $res);
}
unset($array);
}
}
print json_encode($arr);
<?php
require '../php/main/SafeMySQL.php';
$o = new SafeMySQL();
$base = $o->getAll('SELECT id,title FROM base_games LIMIT 0,10');
$arr = array();
$i = 0;
foreach ($base as $array) {
$res = array('n0' => $array['id'], 'n1' => $array['title']);
if (!$i) {
$res = array('head' => '<nav id="content_menu">
<a href="be=games" class="new_local"><p>ИГРЫ</p></a>
</nav><nav id="content_search"></nav><section id="content_block">', 'tmp' => '<article id="%n[0]" class="game">
<div class="game_img"></div>
<h4>%n[1]</h4>
</article>', 'footer' => '</section>') + $res;
}
$i++;
array_push($arr, $res);
}
unset($array);
print json_encode($arr);
<?php
require '../php/main/SafeMySQL.php';
$string_object = new SafeMySQL();
if ($category === 'all' || !$category) {
$query = $string_object->getAll("SELECT u.user_id, u.avatar, u.nickname, u.category, o.online FROM users_information u, users_online o WHERE o.user_id = u.user_id ORDER BY user_id DESC LIMIT 0,10");
} else {
$query = $string_object->getAll("SELECT u.user_id, u.avatar, u.nickname, u.category, o.online FROM users_information u, users_online o WHERE o.user_id = u.user_id AND u.category=?s ORDER BY user_id DESC LIMIT 0,10", $category);
}
$arr = array();
$i = 0;
foreach ($query as $array) {
$image = file_exists('../upload_image/avatars/pre_50px/' . $array['avatar'] . '.jpg') ? $array['avatar'] : 'default';
$res = array('n0' => $array['user_id'], 'n1' => $image, 'n2' => $array['nickname'], 'n3' => $array['online'], 'n4' => $array['category'], 'n5' => 'Null');
if (!$i) {
$res = array('head' => '<nav id="content_menu">
<a href="pe=all" class="new_local"><p>ВСЕ</p></a>
<a href="pe=user" class="new_local"><p>ПОЛЬЗОВАТЕЛИ</p></a>
<a href="pe=motiondesign" class="new_local"><p>МОУШЕН-ДИЗАЙНЕРЫ</p></a>
<a href="pe=review" class="new_local"><p>ОБОЗРЕВАТЕЛИ</p></a>
<a href="pe=letsplay" class="new_local"><p>ЛЕТСПЛЕЕРЫ</p></a>
</nav>
<nav id="content_search">
<button class="content_search">
Город
</button>
<button class="content_search">
Пол
</button>
<button class="content_search">
Возраст
<?php
require '../php/main/SafeMySQL.php';
if ($last_id) {
$o = new SafeMySQL();
$base = $o->getAll('SELECT id,title FROM base_games WHERE id>?i LIMIT 0,10', $last_id);
$arr = array();
$i = 0;
foreach ($base as $array) {
$res = array('n0' => $array['id'], 'n1' => $array['title']);
$i++;
array_push($arr, $res);
}
unset($array);
print json_encode($arr);
}
<?php
// TODO убрать/переделать
// выбираем список категорий в зависимости от раздела
// используется для аякс-запроса при добавлении записи
if (!empty($_POST['category_list'])) {
include $_SERVER['DOCUMENT_ROOT'] . '/admin/inc/functions.php';
include $_SERVER['DOCUMENT_ROOT'] . '/admin/inc/mysql.class.php';
check_install();
// проверяем, установлена ли cms
$db = new SafeMySQL(array('user' => DB_LOGIN, 'pass' => DB_PASSWORD, 'db' => DB_NAME, 'charset' => 'utf8'));
$rows = $db->getAll('SELECT * FROM ' . DB_PREFIX . '_catalog_subcategories WHERE pid=?i', $_POST['category_list']);
foreach ($rows as $rows2) {
echo '<option value="' . $rows2['id'] . '">' . $rows2['title'] . '</option>';
}
exit;
}
defined('CAFE') or die(header('Location: /'));
check_error();
include 'config.php';
// сохранение настроек
if ($_POST['update-settings']) {
$w_string = '<?php
define ("DEFAULT_CITY", "' . $_POST['default-city'] . '"); // город по умолчанию
define ("DEFAULT_COORD", "' . $_POST['default-coord'] . '"); // начальные координаты
?>';
$fop = fopen($_SERVER["DOCUMENT_ROOT"] . 'admin/modules/catalog/config.php', 'w');
if ($fwr = fwrite($fop, $w_string)) {
fclose($fop);
$message = 'Настройки обновлены';
} else {
<?php
require '../php/main/db_connect.php';
$string_object = new SafeMySQL();
if ($user_id) {
$arr = array();
$res = array('head' => '<nav id="content_menu">
<a href="hm=subscribes" class="new_local"><p>ПОДПИСКИ</p></a>
<a href="hm=news" class="new_local"><p>НОВОСТИ</p></a>
</nav><div id="material_null">
<p>МАТЕРИАЛОВ НЕТ</p>
</div>');
array_push($arr, $res);
print json_encode($arr);
} else {
$query = $string_object->getAll("SELECT v_id, image, title FROM posts_videos_in ORDER BY v_id DESC LIMIT 0,9");
$arr = array();
$i = 0;
foreach ($query as $array) {
$image = file_exists('../upload_image/videos/pre_500px/' . $array['image'] . '.jpg') ? $array['image'] : 'default';
$res = array('n0' => $array['v_id'], 'n1' => $image, 'n2' => $array['text'], 'n3' => $array['title']);
if (!$i) {
$res = array('head' => '<section id="main_news">', 'tmp' => '<a href="hm&video=%n[0]" class="new_local"><article class="main_news" style="background: no-repeat center url(upload_image/videos/pre_500px/%n[1].jpg)">
<div class="main_news_information">
<p>%n[2]</p>
</div>
<div class="main_title">
<p>%n[3]</p>
</div>
<div class="main_icon" style="background:#000 url(../../img/post_icon/video.png) no-repeat center;">
</div>
<?php
require '../php/main/db_connect.php';
if ($last_id && $page && $user_id) {
$string_object = new SafeMySQL();
$o = $string_object->getAll("SELECT v_id, user_id, title, image, date FROM posts_videos_in WHERE user_id=?i AND v_id<?i ORDER BY v_id DESC LIMIT 0,10", $user_id, $last_id);
$arr = array();
$i = 0;
foreach ($o as $array) {
$image = file_exists('../upload_image/videos/pre_500px/' . $array['image'] . '.jpg') ? $array['image'] : 'default';
$res = array('n0' => $array['v_id'], 'n1' => $image, 'n2' => $array['title'], 'n3' => $array['date']);
array_push($arr, $res);
$i++;
}
print json_encode($arr);
unset($array);
}
