Example #1
0
// html output increment
$output = NULL;
// set the menu based on tables
if (count($_GET) >= 1) {
    $ordre = ["", "B", "T", "I", "A"];
    $lien = "";
    for ($i = 0; $i != count($_GET); $i++) {
        if ($i != 0) {
            $lien .= "&";
            $lien .= $ordre[$i] . "=" . $_GET[$ordre[$i]];
        }
    }
    echo '<a href="index.php?' . $lien . '">Retour</a><br/>';
}
if (isset($_GET['B']) || isset($_GET['T'])) {
    $model->Use_BDD($_GET['B']);
}
if (isset($_GET['A'])) {
    if ($_GET['A'] == "S") {
        $model->Suppr_Donnee($_GET['T'], $_GET['I']);
        header("Location: index.php?B=" . $_GET['B'] . "&T=" . $_GET['T']);
    }
} elseif (isset($_GET['T'])) {
    $output .= View::MenuDonnee($_GET['B'], $_GET['T'], $model->List_Donnee($_GET['T']));
} elseif (isset($_GET['B'])) {
    $output .= View::MenuTable($_GET['B'], $model->List_Table());
} else {
    $output .= View::MenuBase($model->List_Base());
}
// output echo screen rendering
View::HTML($config['MODULE_NAME'], $output);
Example #2
0
/* 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 #3
0
/* 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']));