// 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);
/* 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:
//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);