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; } }