PHP Model::Request Examples

Example #1

File: index.php Project: Aurel08160/DBZ

$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;
            $first_get = false;
            foreach ($_POST as $key => $value) {
                if ($key != "Modif") {
                    if (!$first_get) {
                        $first_key = $key;
                        $first_val = $value;
                        $first_get = true;
                    }
                    $val = intval($value);
                    if (gettype($value) == "string" && strval($val) != $value) {
                        $sql .= "{$key} = '{$value}', ";