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