PHP Model::Name_DB Examples

Example #1

File: index.php Project: kappucino/DBZ

/* DBZ FRONTAL CONTROLLER
** MVC CMS for database management */
// configuration
require_once "Config/config.script.php";
// connexion db
require_once "Classes/pdo.connexion.class.php";
$PDO = new Pdo_Connexion($CONFIG['DB_INI_FILE']);
// model class
require_once "Classes/model.class.php";
$MODEL = new Model($PDO->CNX);
// view class
require_once "Classes/view.class.php";
// html output increment
$OUTPUT = NULL;
// set the menu based on tables
$OUTPUT .= View::MenuTable($MODEL->Name_DB(), $MODEL->List_Table());
// output echo screen rendering
View::HTML($CONFIG['MODULE_NAME'], $OUTPUT);
$EXPORT = null;
if (isset($_GET['dir']) && !empty($_GET['dir'])) {
    switch ($_GET['dir']) {
        case 1:
            require_once 'ajout.php';
            break;
        case 2:
            require_once 'supp.php';
            break;
        case 3:
            require_once 'montre.php';
            break;
        default:

Example #2

File: index.php Project: SebastienBloesch/DBZ

    }
}
// if a user want to delete an entity in a table
if (isset($_GET['d_ID'])) {
    $MODEL->DeleteEntity($_GET['d_ID'], $_GET['table'], $_GET['champ']);
}
// add a new entity
if (isset($_GET['add'])) {
    $i = 0;
    $sizeOfTab = count($_GET) - 2;
    $finalTab = [];
    foreach ($_GET as $key => $value) {
        if ($i === $sizeOfTab) {
            break;
        } else {
            $finalTab[$key] = $value;
        }
        $i++;
    }
    $MODEL->AddEntity($finalTab, $_GET['T']);
}
// list of databases
$OUTPUT .= View::ListDatabases($MODEL->GetDatabasesList());
// set the menu based on tables
$OUTPUT .= View::MenuTable($MODEL->Name_DB(), $MODEL->List_Table());
// if the user has clicked on a table link
if (isset($_GET['T'])) {
    $OUTPUT .= View::DataListTable($MODEL->Name_DB(), $_GET['T'], $MODEL->ListEntitiesTable($_GET['T']));
}
// output echo screen rendering
View::HTML($CONFIG['MODULE_NAME'], $OUTPUT);

Example #3

File: index.php Project: Aurel08160/DBZ

/* DBZ FRONTAL CONTROLLER
** MVC CMS for database management */
// configuration
require_once "Config/config.script.php";
// connexion db
require_once "Classes/pdo.connexion.class.php";
$PDO = new Pdo_Connexion($CONFIG['DB_INI_FILE']);
// model class
require_once "Classes/model.class.php";
$MODEL = new Model($PDO->CNX);
// view class
require_once "Classes/view.class.php";
// html output increment
$OUTPUT = NULL;
// set the menu based on tabless
$OUTPUT .= View::MenuTable($MODEL->Name_DB(), $MODEL->request("SHOW TABLES"));
if (isset($_GET["T"]) && isset($_GET["req"])) {
    if ($_GET['req'] == "Suppr") {
        if (isset($_GET["key"]) && isset($_GET["val"])) {
            if (!($res = $MODEL->Exec_request("DELETE FROM " . $_GET['T'] . " WHERE " . $_GET['key'] . "=" . $_GET['val']))) {
                $OUTPUT .= "Erreur SQL";
            } else {
                header("Location: index.php?T=" . $_GET['T'] . "&req=List");
                exit;
            }
        } else {
            $OUTPUT .= "<p>Erreur d'arguments</p>";
        }
    } elseif ($_GET["req"] == "Modif") {
        if (isset($_GET["key"]) && isset($_GET["val"])) {
            $OUTPUT .= View::Modif_form($MODEL->Request("SELECT * FROM " . $_GET['T'] . " WHERE " . $_GET['key'] . "=" . $_GET['val']));

Example #4

File: index.php Project: Youriponcelet/DBZ

/* DBZ FRONTAL CONTROLLER
** MVC CMS for database management */
// configuration
require_once "Config/config.script.php";
// connexion db
require_once "Classes/pdo.connexion.class.php";
$PDO = new Pdo_Connexion($CONFIG['DB_INI_FILE']);
// model class
require_once "Classes/model.class.php";
$MODEL = new Model($PDO->CNX);
// view class
require_once "Classes/view.class.php";
// html output increment
$OUTPUT = NULL;
// set the menu based on tables
$OUTPUT .= View::MenuTable($MODEL->Name_DB(), $MODEL->List_Table());
// User click on a table
if (isset($_GET['T'])) {
    $OUTPUT .= View::DataTable($MODEL->Name_DB(), $MODEL->EntitiesTable($_GET['T']));
}
if (isset($_GET['REQ'])) {
    if ($_GET['REQ'] == 'DEL_TABLE') {
        $OUTPUT .= View::DEL_TABLE($MODEL->DeleteTable($_GET['T']));
    } else {
        if ($_GET['REQ'] == 'DEL_DATA') {
            $OUTPUT .= View::DEL_DATA($MODEL->DeleteData($_GET['T'], $_GET['PRIMARY'], $_GET['ID']));
        } else {
            if ($_GET['REQ'] == 'UPDATE_DATA') {
                $OUTPUT .= View::MOD_ENTITIES($MODEL->Name_DB(), $MODEL->EntitiesTable($_GET['T']));
            } else {
                if ($_GET['REQ'] == 'ADD_ENTITIES') {

Example #5

File: index.php Project: N3tuxxxx/DBZ

//récupération de l'ID de la table
// Call config script
require_once "Config/config.script.php";
// Call pdo connexion class
require_once "Classes/pdo.connexion.class.php";
//Instantiate pdo connexion class
$PDO = new Pdo_Connexion($CONFIG['DB_INI_FILE']);
// Call model class
require_once "Classes/model.class.php";
// Instantiate model class
$MODEL = new Model($PDO->CNX);
// Call view class
require_once "Classes/view.class.php";
$OUTPUT = NULL;
if (isset($_GET['DEL']) && !empty($_GET['DEL'])) {
    $id_table = $_GET['T'];
    $id_DEL = $_GET['DEL'];
    $id_nom = $_GET['Nom'];
    $MODEL->Del_occurence($id_DEL, $id_table, $id_nom);
    $OUTPUT .= View::MenuTable($MODEL->Name_DB(), $MODEL->List_Table()) . View::AfficheTable($MODEL->List_Content($id_table), $id_table);
} else {
    if (isset($_GET['T']) && !empty($_GET['T'])) {
        // set tables
        $id_table = $_GET['T'];
        $OUTPUT .= View::MenuTable($MODEL->Name_DB(), $MODEL->List_Table()) . View::AfficheTable($MODEL->List_Content($id_table), $id_table);
    } else {
        $OUTPUT .= View::MenuTable($MODEL->Name_DB(), $MODEL->List_Table());
    }
}
// output echo screen rendering
View::HTML($CONFIG['MODULE_NAME'], $OUTPUT);