Exemplos de classListBox em PHP

Exemplo n.º 1

Arquivo: tm0.security.remove_user.php Projeto: jsan4christ/idrc-uganda-site

<?php

include_once "./classes/classListbox.php";
#include_once('./classes/main/security.class.php');
#db users
$usrSQL = "SELECT username FROM sionapros_users WHERE account_status = 'Active' AND username != 'SADMIN'";
$user = new classListBox($db, "users");
$user->set_query($usrSQL, "username", "username");
$user->set_postback(true);
$chUser = $user->display();
$smarty->assign('user', $chUser);
#their profiles
$profSQL = "SELECT user.profile_id,profiles.profile FROM sionapros_user_profiles AS user INNER JOIN sionapros_profiles AS profiles ON";
$profSQL .= " user.profile_id = profiles.profile_id WHERE user.username = '******'";
$profiles = new classListBox($db, "userprofiles");
$profiles->set_query($profSQL, "profile_id", "profile");
$profiles->set_postback(true);
$userProf = $profiles->display();
$smarty->assign('userProf', $userProf);
if ($profiles->get_selectedItemKey() != '') {
    $smarty->assign('button', 'visible');
    unset($_SESSION['userprofiles']);
}
if (!isset($_POST['submit'])) {
    // new form, we (re)set the session data
    SmartyValidate::connect($smarty, true);
    // register our validators
    SmartyValidate::register_validator('usr', 'users', 'notEmpty');
    SmartyValidate::register_validator('prof', 'userprofiles', 'notEmpty');
    // display form
} else {

Exemplo n.º 2

Arquivo: tm0.security.chg_profile.php Projeto: jsan4christ/idrc-uganda-site

<?php

include_once "./classes/classListbox.php";
$profSQL = "SELECT profile,profile_id FROM sionapros_profiles";
$profile = new classListBox($db, "profiles");
$profile->set_query($profSQL, "profile_id", "profile");
#$userMods->set_postback(true);
$profs = $profile->display();
$smarty->assign('profs', $profs);
#check that new name doesnt match an already existing name
function check()
{
    global $_POST, $db;
    $chkSQL = "SELECT * FROM sionapros_profiles WHERE profile = '{$_POST['newname']}'";
    $chkSQL .= " AND profile_id != {$_POST['profiles']}";
    if (count($db->execute($chkSQL)) == 0) {
        return true;
    } else {
        return false;
    }
}
if (empty($_POST)) {
    // new form, we (re)set the session data
    SmartyValidate::connect($smarty, true);
    #register criteria
    SmartyValidate::register_criteria('alreadyExists', 'check');
    // register our validators
    SmartyValidate::register_validator('prof', 'profiles', 'notEmpty');
    SmartyValidate::register_validator('newprof', 'newname', 'notEmpty');
    // display form
} else {

Exemplo n.º 3

Arquivo: tm0.security.user_profile.php Projeto: jsan4christ/idrc-uganda-site

<?php

include_once "./classes/classListbox.php";
include_once './classes/security.class.php';
$usrSQL = "SELECT username FROM sionapros_users WHERE account_status = 'Active' AND username != 'SADMIN'";
$user = new classListBox($db, "dbusers");
$user->set_query($usrSQL, "username", "username");
$user->set_postback(true);
$chUser = $user->display();
$smarty->assign('user', $chUser);
$security = new Security($db);
$profAssigned = $security->userProfiles($user->get_selectedItemKey());
if (count($profAssigned) == 0) {
    $msg = 'none';
}
$smarty->assign('msg', $msg);
$smarty->assign('profiles', $profAssigned);
$content = $smarty->fetch('./security/tm0.security.user_profile.tpl.html');

Exemplo n.º 4

Arquivo: tm0.security.objects_profile.php Projeto: jsan4christ/idrc-uganda-site

<?php

include_once "./classes/classListbox.php";
include_once './classes/security.class.php';
$profSQL = "SELECT profile,profile_id FROM sionapros_profiles";
$profile = new classListBox($db, "profiles");
$profile->set_query($profSQL, "profile_id", "profile");
$profile->set_postback(true);
$profiles = $profile->display();
$smarty->assign('profiles', $profiles);
$security = new Security($db);
$objects = $security->objectProfiles($profile->get_selectedItemKey());
if (count($objects) == 0) {
    $msg = 'none';
}
$smarty->assign('msg', $msg);
$smarty->assign('objects', $objects);
$content = $smarty->fetch('./security/tm0.security.objects_profile.tpl.html');

Exemplo n.º 5

Arquivo: main.del_category.php Projeto: jsan4christ/idrc-uganda-site

<?php

include_once "./classes/classListbox.php";
$SQL = "SELECT value,id FROM sionapros_categories ORDER BY id";
$con = new classListBox($db, "con");
$con->set_query($SQL, "id", "value");
#$userMods->set_postback(true);
$grps = $con->display();
$smarty->assign('cons', $grps);
if (empty($_POST)) {
    // new form, we (re)set the session data
    SmartyValidate::connect($smarty, true);
    // register our validators
    SmartyValidate::register_validator('grp', 'con', 'notEmpty');
    // display form
    #$content = $smarty->fetch('./main/allergy/tm0.allergy.del_allergy_group.tpl.html');
} else {
    // validate after a POST
    SmartyValidate::connect($smarty);
    if (SmartyValidate::is_valid($_POST)) {
        require_once './classes/cats.class.php';
        #get $_POST info
        $id = $con->get_selectedItemKey();
        $SQL = "SELECT * FROM sionapros_faqs WHERE category = '{$id}'";
        $res = $db->execute($SQL);
        $SQL1 = "SELECT * FROM sionapros_news WHERE category = '{$id}'";
        $res1 = $db->execute($SQL1);
        $SQL2 = "SELECT * FROM sionapros_pubs WHERE category = '{$id}'";
        $res2 = $db->execute($SQL2);
        if (count($res) == 0 || count($res1) == 0 || count($res2) == 0) {
            SmartyValidate::disconnect();

Exemplo n.º 6

Arquivo: tm0.security.remove_object.php Projeto: jsan4christ/idrc-uganda-site

<?php

include_once "./classes/classListbox.php";
#db profiles
$profSQL = "SELECT profile_id,profile FROM sionapros_profiles";
$profiles = new classListBox($db, "dbProfiles");
$profiles->set_query($profSQL, "profile_id", "profile");
$profiles->set_postback(true);
$dbProf = $profiles->display();
$smarty->assign('profiles', $dbProf);
#print_r($_POST);
#db users
$obSQL = "SELECT object FROM sionapros_object_profile WHERE profile_id = '{$profiles->get_selectedItemKey()}'";
$object = new classListBox($db, "objectProf");
$object->set_query($obSQL, "object", "object");
$object->set_postback(true);
$obProf = $object->display();
$smarty->assign('objects', $obProf);
if ($object->get_selectedItemKey() != '') {
    $smarty->assign('button', 'visible');
    unset($_SESSION['objectProf']);
}
if (!isset($_POST['submit'])) {
    // new form, we (re)set the session data
    SmartyValidate::connect($smarty, true);
    // register our validators
    SmartyValidate::register_validator('prof', 'dbProfiles', 'notEmpty');
    SmartyValidate::register_validator('obj', 'objectProf', 'notEmpty');
    // display form
} else {
    // validate after a POST