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