PHP filter_column Examples

Example #1

File: liste.php Project: fedecbn/codex

 $onglet = $_GET['onglet'];
 $class = $onglet == 'fsd' ? 'edit' : 'fsd';
 //------------------------------------------------------------------------------ PARMS.
 /*Droit sur les boutons de la dernière colonne*/
 $typ_droit = 'd2';
 $rubrique = $id_page;
 $droit = ref_droit($id_user, $typ_droit, $rubrique, $onglet);
 //------------------------------------------------------------------------------ CONNEXION SERVEUR PostgreSQL
 $db = sql_connect(SQL_base);
 if (!$db) {
     fatal_error("Impossible de se connecter au serveur PostgreSQL.", false);
 }
 //------------------------------------------------------------------------------ REF.
 ref_colonne_et_valeur($onglet);
 //------------------------------------------------------------------------------ FILTERS
 $filters = filter_column($aColumns[$onglet]);
 $sLimit = $filters['sLimit'];
 $sOrder = $filters['sOrder'];
 $sWhere = $filters['sWhere'];
 //------------------------------------------------------------------------------ QUERY
 $query = $query_liste[$_GET['onglet']] . $sWhere . " " . $sOrder . " " . $sLimit;
 // echo "<br>".$query;
 $result = pg_query($db, $query) or die("Erreur pgSQL : " . pg_result_error($result));
 if (pg_num_rows($result)) {
     $aResultTotal = pg_result($result, 0, "total_count");
 } else {
     $aResultTotal = 0;
 }
 $iTotal = $aResultTotal;
 $sOutput = '{';
 $sOutput .= '"sEcho": ' . intval($_GET['sEcho']) . ', ';

Example #2

File: user-liste.php Project: fedecbn/codex

//----------------------------------------------------------------------------- INIT.
require_once "../../_INCLUDE/config_sql.inc.php";
require_once "../../_INCLUDE/fonctions.inc.php";
require_once "../../_INCLUDE/constants.inc.php";
include_once "commun.inc.php";
//------------------------------------------------------------------------------ VAR.
// $niveau=$_SESSION['niveau'];
$table = $id_page = "utilisateur";
$aColumns = array('id_user', 'prenom', 'nom', 'lib_cbn', 'email', 'tel_bur', 'niveau_lr', 'niveau_eee', 'niveau_catnat', 'niveau_refnat', 'niveau_lsi', 'niveau_fsd', 'ref_lr', 'ref_eee', 'ref_catnat', 'ref_refnat', 'ref_lsi', 'ref_fsd');
$sIndexColumn = "id_user";
$ouinon_txt = array("", "<b>X</b>");
//------------------------------------------------------------------------------ REF.
global $aColumns, $ref, $champ_ref;
ref_colonne_et_valeur($id_page);
//------------------------------------------------------------------------------ MAIN
$filters = filter_column($aColumns[$id_page]);
$sLimit = $filters['sLimit'];
$sOrder = $filters['sOrder'];
$sWhere = $filters['sWhere'];
//------------------------------------------------------------------------------ QUERY
/*id_cbn du USER*/
$query = "SELECT id_cbn FROM applications.utilisateur WHERE id_user = '******'";
$result = pg_query($db, $query) or die("Erreur pgSQL : " . pg_result_error($result));
$row = pg_fetch_row($result);
$id_cbn = $row[0];
if ($ref['all'] === 'f' and $niveau['all'] < 255) {
    $where1 = "WHERE id_cbn = {$id_cbn}";
} elseif ($ref['all'] === 't' and $niveau['all'] < 255) {
    $where1 = "WHERE id_cbn = {$id_cbn}";
} else {
    $where1 = "WHERE 1=1";

Example #3

File: liste_user.php Project: fedecbn/codex

//  Version 1.07  24/09/14 - MaJ columnFilter                                   //
//------------------------------------------------------------------------------//
//------------------------------------------------------------------------------ INIT.
include "commun.inc.php";
//------------------------------------------------------------------------------ VAR.
//------------------------------------------------------------------------------ PARMS.
//------------------------------------------------------------------------------ CONNEXION SERVEUR PostgreSQL
$db = sql_connect(SQL_base);
if (!$db) {
    fatal_error("Impossible de se connecter au serveur PostgreSQL.", false);
}
//------------------------------------------------------------------------------ REF.
global $aColumns, $ref, $champ_ref;
ref_colonne_et_valeur("droit_{$id_page}");
//------------------------------------------------------------------------------ MAIN
$filters = filter_column($aColumns["droit_{$id_page}"]);
$sLimit = $filters['sLimit'];
$sOrder = $filters['sOrder'];
$sWhere = $filters['sWhere'];
//------------------------------------------------------------------------------ QUERY
$query = $query_user . " " . $sWhere . " " . $sOrder . " " . $sLimit;
// echo "<br>".$query;
$result = pg_query($db, $query) or die("Erreur pgSQL : " . pg_result_error($result));
if (pg_num_rows($result)) {
    $aResultTotal = pg_result($result, 0, "total_count");
} else {
    $aResultTotal = 0;
}
$iTotal = $aResultTotal;
$sOutput = '{';
$sOutput .= '"sEcho": ' . intval($_GET['sEcho']) . ', ';