PHP Model::Exec_request Examples

Example #1

File: index.php Project: Aurel08160/DBZ

// 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']));
        } elseif (isset($_POST["Modif"])) {
            $sql = "UPDATE " . $_GET['T'] . " SET ";
            $first_key = null;
            $first_val = null;