function Sql_delete($id)
{
$link = Sql_connect();
$id = (int) $id;
$sql = "delete from news where id=" . $id;
$res = $link->query($sql);
return $res;
}
function Sql_query($query_str)
{
Sql_connect();
$res = mysql_query($query_str);
$ret = [];
while (false !== ($row = mysql_fetch_assoc($res))) {
$ret[] = $row;
}
return $ret;
}
function Sql_query($sql)
{
//выполнять любые запросы
Sql_connect();
$res = mysql_query($sql);
//print_r($res);
$ret = array();
//созд. пустой массив
while (false !== ($row = mysql_fetch_assoc($res))) {
//mysql_fetch_assoc индексы- названия столбцов
$ret[] = $row;
//print_r($row);//в пустой массив добавляем значения из Б.Д. по одному
}
return $ret;
//возвр. результат
}
function Sql_exec($sql)
{
Sql_connect();
mysql_query($sql) or die(mysql_error());
}
//==================================================================================
// pre.php est systematiquement appelé
// Il effectue le chargement des bibliotheques de travail et ouvre un acces a la base de donnees
// qui sera ferme par post.php
//==================================================================================
//==================================================================================
// Chargement de la configuration de base
// et chargement des bibliotheques de base
//==================================================================================
include "../dilasys/conf.php";
include "../dilasys/biblio/lib.inc.php";
include "../dilasys/biblio/sql.inc.php";
include "../dilasys/biblio/collection.inc.php";
include "../dilasys/biblio/element.inc.php";
include "../dilasys/biblio/sessions.inc.php";
$db_link = Sql_connect();
$lang = isset($data_in['lang']) ? $data_in['lang'] : 'fr';
//==================================================================================
// Rien ne sera affiché sur le client avant l'appel a end_flush dans post.php
// Lib_prepareAffichage est appelé pour remplacer les tags %%tag%% situés dans les pages HTML
// avant affichage final (utilisé principalement pour les messages pouvant être en plusieurs langues)
//==================================================================================
ob_start("Lib_prepareAffichage");
//==================================================================================
// Vérification de securité diverses
//==================================================================================
unset($session);
// On récupère l'identifiant de session
$session = $_COOKIE[$GLOBALS['instance'] . '_session'];
// Oblige d'initialiser action ici ou sinon le return empechera l'action d'etre connu dans actions.php
foreach ($_GET as $key => $value) {
function Sql_putData($sql)
{
Sql_connect();
mysql_query($sql);
}
function Photo_getAll()
{
Sql_connect();
$sql = 'SELECT * FROM images';
return Sql_query($sql);
}
<?php
session_start();
require __DIR__ . '/../functions/const.php';
require FUNCTIONS_ROOT . '/sql.php';
require MODELS_ROOT . '/Phones.php';
require MODELS_ROOT . '/Categories.php';
Sql_connect();
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="../css/admin.css">
<script type="text/javascript" src="../js/jquery-2.0.3.min.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script>
<script type="text/javascript">
function slideNewArtDiv(){ $('#new_art').slideToggle("slow"); }
function slideNewCatDiv(){ $('#new_cat').slideToggle("slow"); }
function slideAllUsersDiv(){ $('#all_users').slideToggle("slow"); }
function slidePrograms(){ $('#Programs').slideToggle(500); }
function slideWpapers(){ $('#Wpapers').slideToggle(500); }
function slideGames(){ $('#Games').slideToggle(500); }
function slideBooks(){ $('#Books').slideToggle(500); }
</script>
<script type="text/javascript" src="../ckeditor/ckeditor.js">
</script>
<script>
function Sql_exec($sql)
{
Sql_connect();
$res = mysql_query($sql);
return $res;
}
function Article_getAll()
{
Sql_connect();
$sql = 'SELECT * FROM articles';
return sql_query($sql);
}
function rating_bar($id, $units = '', $static = '')
{
Sql_connect();
$rating_tableName = 'ratings';
$rating_path_db = '';
$rating_path_rpc = '';
$rating_unitwidth = 30;
$ip = $_SERVER['REMOTE_ADDR'];
if (!$units) {
$units = 10;
}
if (!$static) {
$static = false;
}
$query = mysql_query("SELECT total_votes, total_value, used_ips FROM " . $rating_tableName . " WHERE id='" . $id . "' ") or die(" Error: " . mysql_error());
if (mysql_num_rows($query) == 0) {
$sql = "INSERT INTO " . $rating_tableName . " (`id`,`total_votes`, `total_value`, `used_ips`) VALUES ('" . $id . "', '0', '0', '')";
$result = mysql_query($sql);
}
$numbers = mysql_fetch_assoc($query);
if ($numbers['total_votes'] < 1) {
$count = 0;
} else {
$count = $numbers['total_votes'];
}
$current_rating = $numbers['total_value'];
$tense = $count == 1 ? "vote" : "votes";
$voted = mysql_num_rows(mysql_query("SELECT used_ips FROM " . $rating_tableName . " WHERE used_ips LIKE '%" . $ip . "%' AND id='" . $id . "' "));
$rating_width = @number_format($current_rating / $count, 2) * $rating_unitwidth;
$rating1 = @number_format($current_rating / $count, 1);
$rating2 = @number_format($current_rating / $count, 2);
if ($static == 'static') {
$static_rater = array();
$static_rater[] .= "\n" . '<div class="ratingblock">';
$static_rater[] .= '<div id="unit_long' . $id . '">';
$static_rater[] .= '<ul id="unit_ul' . $id . '" class="unit-rating" style="width:' . $rating_unitwidth * $units . 'px;">';
$static_rater[] .= '<li class="current-rating" style="width:' . $rating_width . 'px;">Текущий ' . $rating2 . '/' . $units . '</li>';
$static_rater[] .= '</ul>';
$static_rater[] .= '<p class="static">' . $id . '. Рейтинг: <strong> ' . $rating1 . '</strong>/' . $units . ' (' . $count . ' ' . $tense . ' cast) <em>This is \'static\'.</em></p>';
$static_rater[] .= '</div>';
$static_rater[] .= '</div>' . "\n\n";
return join("\n", $static_rater);
} else {
$rater = '';
$rater .= '<div class="ratingblock">';
$rater .= '<div id="unit_long' . $id . '">';
$rater .= ' <ul id="unit_ul' . $id . '" class="unit-rating" style="width:' . $rating_unitwidth * $units . 'px;">';
$rater .= ' <li class="current-rating" style="width:' . $rating_width . 'px;">Текущий ' . $rating2 . '/' . $units . '</li>';
for ($ncount = 1; $ncount <= $units; $ncount++) {
if (!$voted) {
$rater .= '<li><a href="rating/db.php?j=' . $ncount . '&q=' . $id . '&t=' . $ip . '&c=' . $units . '" title="' . $ncount . ' out of ' . $units . '" class="r' . $ncount . '-unit rater" rel="nofollow">' . $ncount . '</a></li>';
}
}
$ncount = 0;
$rater .= ' </ul>';
$rater .= ' <p';
if ($voted) {
$rater .= ' class="voted"';
}
$rater .= '> Rating: <strong> ' . $rating1 . '</strong>/' . $units . ' (' . $count . ' votes)';
// . $tense . ' cast)'
$rater .= ' </p>';
$rater .= '</div>';
$rater .= '</div>';
return $rater;
}
}
