/application/model/DB.php - Komentovat - Databáze slov a jejich tvarů (KČJ FPE) - Mr. Proper - Redmine

aswi2021mr-proper-gitlab/application/model/DB.php @ 82f8d4ca

-b343aea
+<?php
 class DB {
     // (A) CONNECT TO DATABASE
     public $error = "";
     private $pdo = null;
     private $stmt = null;
     function __construct () {
         try {
             $this->pdo = new PDO(
                 "pgsql:host=".DB_HOST.";dbname=".DB_NAME,
                 DB_USER, DB_PASSWORD, [
                     PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
                     PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
+                ]
             );
         } catch (Exception $ex) { die($ex->getMessage()); }
+    }
     // (B) CLOSE CONNECTION
     function __destruct(){
         if ($this->stmt!==null) { $this->stmt = null; }
         if ($this->pdo!==null) { $this->pdo = null; }
+    }
     // (C) RUN A SELECT QUERY
     function select($sql, $cond=null){
         $result = false;
         try {
             $this->stmt = $this->pdo->prepare($sql);
-a99773b
+            if (array_key_exists("lemma", $params)) {
                 $this->stmt->bindParam(':lemma',$params['lemma'], PDO::PARAM_STR);
+            }
             if (array_key_exists("word", $params)) {
                 $this->stmt->bindParam(':word',$params['word'], PDO::PARAM_STR);
+            }
             if (array_key_exists("position1", $params)) {
                 $this->stmt->bindParam(':position1',$params['position1'], PDO::PARAM_INT);
+            }
             if (array_key_exists("position2", $params)) {
                 $this->stmt->bindParam(':position2',$params['position2'], PDO::PARAM_INT);
+            }
             if (array_key_exists("positiondetail", $params)) {
                 $this->stmt->bindParam(':positiondetail',$params['positiondetail'], PDO::PARAM_INT);
+            }
             if (array_key_exists("tag", $params)) {
                 $this->stmt->bindParam(':tag',$params['tag'], PDO::PARAM_STR);
+            }
             if (array_key_exists("tag", $params)) {
                 $this->stmt->bindParam(':tag',$params['tag'], PDO::PARAM_STR);
+            }
             if (array_key_exists("finished", $params)) {
                 $this->stmt->bindParam(':finished',$params['finished']);
+            }
             if (array_key_exists("manuscript", $params)) {
                 for ($x = 0; $x < count($params["manuscript"]); $x += 1) {
                     $this->stmt->bindParam(':manuscript'.$x,$params["manuscript"][$x], PDO::PARAM_INT);
+                }
+            }
             $this->stmt->execute();
-b343aea
+            $result = $this->stmt->fetchAll();
             return $result;
         } catch (Exception $ex) {
             $this->error = $ex->getMessage();
             return false;
+        }
+    }
-a99773b
+            Milan Vacek
 function update(){
-f8d4ca
+    $query = "SELECT id FROM dd_lemma
               WHERE lemma = :lemma;";
     $this->stmt = $this->pdo->prepare($query);
         if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
             $this->stmt->bindParam(':lemma', $_POST['lemma'], PDO::PARAM_STR);
+        }
     $this->stmt->execute();
     $lemma = $this->stmt->fetch(PDO::FETCH_ASSOC);
     $query = "SELECT id FROM dd_tag
               WHERE tag = :tag;";
     $this->stmt = $this->pdo->prepare($query);
         if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
             $this->stmt->bindParam(':tag', $_POST['tag'], PDO::PARAM_STR);
+        }
     $this->stmt->execute();
     $tag = $this->stmt->fetch(PDO::FETCH_ASSOC);
     // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_lemma |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
     if($lemma == null){
         $query = "SELECT MAX(id) FROM dd_lemma;";
         $this->stmt = $this->pdo->prepare($query);
         $this->stmt->execute();
         $result = $this->stmt->fetchAll();
         $result[0]["max"]+=1;
         $query = "INSERT INTO dd_lemma ( id, ";
         $values = "VALUES (" . $result[0]["max"] . ", ";
             if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
                 $query .= " lemma, ";
                 $values .= " :lemma, ";
+            }
             if (array_key_exists("pos", $_POST) && $_POST['pos'] != "") {
                 $query .= " pos ) ";
                 $values .= " :pos ); ";
+            }
         $query .= $values;
         $this->stmt = $this->pdo->prepare($query);
             if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
                 $this->stmt->bindParam(':lemma', $_POST['lemma'], PDO::PARAM_STR);
+            }
             if (array_key_exists("pos", $_POST) && $_POST['pos'] != "") {
                 $this->stmt->bindParam(':pos', $_POST['pos'], PDO::PARAM_INT);
+            }
         $this->stmt->execute();
         $query = "SELECT id FROM dd_lemma
                   WHERE lemma = :lemma;";
         $this->stmt = $this->pdo->prepare($query);
             if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
                 $this->stmt->bindParam(':lemma', $_POST['lemma'], PDO::PARAM_STR);
+            }
         $this->stmt->execute();
         $lemma = $this->stmt->fetch(PDO::FETCH_ASSOC);
+    }
     $query = "UPDATE dd_lemma
                  SET ";
     if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
         $query .= " lemma = :lemma , ";
+    }
     if (array_key_exists("pos", $_POST) && $_POST['pos'] != "") {
         $query .= " pos = :pos  ";
+    }
     $query .= "WHERE ";
     if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
         $query .= " id = :lemma_id ;";
+    }
-a99773b
+            Milan Vacek
-f8d4ca
+    $this->stmt = $this->pdo->prepare($query);
     if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
         $this->stmt->bindParam(':lemma', $_POST['lemma'], PDO::PARAM_STR);
+    }
     if (array_key_exists("pos", $_POST) && $_POST['pos'] != "") {
         $this->stmt->bindParam(':pos', $_POST['pos'], PDO::PARAM_INT);
+    }
     if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
         $this->stmt->bindParam(':lemma_id', $lemma["id"], PDO::PARAM_INT);
+    }
     $this->stmt->execute();
     // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_tag |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
     if($tag == null){
      $query = "SELECT MAX(id) FROM dd_tag;";
         $this->stmt = $this->pdo->prepare($query);
         $this->stmt->execute();
         $result = $this->stmt->fetchAll();
         $result[0]["max"]+=1;
         $query = "INSERT INTO dd_tag (id, ";
         $values = "VALUES (" . $result[0]["max"] . ", ";
             if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
                 $query .= " tag ) ";
                 $values .= " :tag ); ";
+            }
         $query .= $values;
         $this->stmt = $this->pdo->prepare($query);
             if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
                 $this->stmt->bindParam(':tag', $_POST['tag'], PDO::PARAM_STR);
+            }
         $this->stmt->execute();
         $query = "SELECT id FROM dd_tag
                   WHERE tag = :tag;";
         $this->stmt = $this->pdo->prepare($query);
             if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
                 $this->stmt->bindParam(':tag', $_POST['tag'], PDO::PARAM_STR);
+            }
         $this->stmt->execute();
         $tag = $this->stmt->fetch(PDO::FETCH_ASSOC);
+    }
     $query = "UPDATE dd_tag
                  SET ";
     if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
         $query .= " tag = :tag  ";
+    }
     $query .= "WHERE ";
     if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
         $query .= " id = :tag_id ;";
+    }
     $this->stmt = $this->pdo->prepare($query);
     if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
         $this->stmt->bindParam(':tag', $_POST['tag'], PDO::PARAM_STR);
+    }
     if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
         $this->stmt->bindParam(':tag_id', $tag["id"], PDO::PARAM_INT);
+    }
     $this->stmt->execute();
     // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_wordform |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
-a99773b
+    $query = "UPDATE dd_wordform
                 SET ";
     if (array_key_exists("context", $_POST) && $_POST['context'] != "") {
         $query .= " context = :context, ";
+    }
         $query .= " date = CURRENT_DATE,";
     if (array_key_exists("description", $_POST) && $_POST['description'] != "") {
         $query .= " description = :description, ";
+    }
     if (array_key_exists("description2", $_POST) && $_POST['description2'] != "") {
         $query .= " description2 = :description2, ";
+    }
     if (array_key_exists("description3", $_POST) && $_POST['description3'] != "") {
         $query .= " description3 = :description3, ";
+    }
     if (array_key_exists("ending", $_POST) && $_POST['ending'] != "") {
         $query .= " ending = :ending, ";
+    }
     if (array_key_exists("finished", $_POST) && $_POST['finished'] != "") {
         $query .= " finished = :finished, ";
+    }
     if (array_key_exists("namedentity", $_POST) && $_POST['namedentity'] != "") {
         $query .= " namedentity = :namedentity, ";
+    }
     if (array_key_exists("position1", $_POST) && $_POST['position1'] != "") {
         $query .= " position1 = :position1, ";
+    }
     if (array_key_exists("position2", $_POST) && $_POST['position2'] != "") {
         $query .= " position2 = :position2, ";
+    }
     if (array_key_exists("positiondetail", $_POST) && $_POST['positiondetail'] != "") {
         $query .= " positiondetail = :positiondetail ,";
+    }
     if (array_key_exists("prefix", $_POST) && $_POST['prefix'] != "") {
         $query .= " prefix = :prefix, ";
+    }
     if (array_key_exists("suffix", $_POST) && $_POST['suffix'] != "") {
         $query .= " suffix = :suffix, ";
+    }
     if (array_key_exists("word", $_POST) && $_POST['word'] != "") {
         $query .= " word = :word, ";
+    }
-f8d4ca
+    if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
-a99773b
+        $query .= " lemma_id = :lemma_id, ";
+    }
-f8d4ca
+    if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
-a99773b
+        $query .= " tag_id = :tag_id ";
+    }
     $query .= " WHERE ";
     if (array_key_exists("id", $_POST) && $_POST['id'] != "") {
         $query .= " id = :id ;";
+    }
     $this->stmt = $this->pdo->prepare($query);
     if (array_key_exists("context", $_POST) && $_POST['context'] != "") {
         $this->stmt->bindParam(':context', $_POST['context'], PDO::PARAM_STR);
+    }
     if (array_key_exists("description", $_POST) && $_POST['description'] != "") {
         $this->stmt->bindParam(':description', $_POST['description'], PDO::PARAM_STR);
+    }
     if (array_key_exists("description2", $_POST) && $_POST['description2'] != "") {
         $this->stmt->bindParam(':description2', $_POST['description2'], PDO::PARAM_STR);
+    }
     if (array_key_exists("description3", $_POST) && $_POST['description3'] != "") {
         $this->stmt->bindParam(':description3', $_POST['description3'], PDO::PARAM_STR);
+    }
     if (array_key_exists("ending", $_POST) && $_POST['ending'] != "") {
         $this->stmt->bindParam(':ending', $_POST['ending'], PDO::PARAM_STR);
+    }
     if (array_key_exists("finished", $_POST) && $_POST['finished'] != "") {
         $this->stmt->bindParam(':finished', $_POST['finished']);
+    }
     if (array_key_exists("namedentity", $_POST) && $_POST['namedentity'] != "") {
         $this->stmt->bindParam(':namedentity', $_POST['namedentity'], PDO::PARAM_INT);
+    }
     if (array_key_exists("position1", $_POST) && $_POST['position1'] != "") {
         $this->stmt->bindParam(':position1', $_POST['position1'], PDO::PARAM_STR);
+    }
     if (array_key_exists("position2", $_POST) && $_POST['position2'] != "") {
         $this->stmt->bindParam(':position2', $_POST['position2'], PDO::PARAM_STR);
+    }
     if (array_key_exists("positiondetail", $_POST) && $_POST['positiondetail'] != "") {
         $this->stmt->bindParam(':positiondetail', $_POST['positiondetail'], PDO::PARAM_STR);
+    }
     if (array_key_exists("prefix", $_POST) && $_POST['prefix'] != "") {
         $this->stmt->bindParam(':prefix', $_POST['prefix'], PDO::PARAM_STR);
+    }
     if (array_key_exists("suffix", $_POST) && $_POST['suffix'] != "") {
         $this->stmt->bindParam(':suffix', $_POST['suffix'], PDO::PARAM_STR);
+    }
     if (array_key_exists("word", $_POST) && $_POST['word'] != "") {
         $this->stmt->bindParam(':word', $_POST['word'], PDO::PARAM_STR);
+    }
-f8d4ca
+    if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
         $this->stmt->bindParam(':lemma_id', $lemma["id"], PDO::PARAM_INT);
-a99773b
+            Milan Vacek
-f8d4ca
+    if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
         $this->stmt->bindParam(':tag_id', $tag["id"], PDO::PARAM_INT);
-a99773b
+            Milan Vacek
     if (array_key_exists("id", $_POST) && $_POST['id'] != "") {
         $this->stmt->bindParam(':id', $_POST['id'], PDO::PARAM_INT);
+    }
     $this->stmt->execute();
     // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_manuscript |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
     if (array_key_exists("wordform_id", $_POST) && $_POST['wordform_id'] != "") {
         $query = "SELECT * FROM dd_manuscript WHERE ";
         $query .= " wordform_id = :wordform_id ;";
+    }
     $this->stmt = $this->pdo->prepare($query);
     if (array_key_exists("wordform_id", $_POST) && $_POST['wordform_id'] != "") {
         $this->stmt->bindParam(':wordform_id', $_POST['wordform_id'], PDO::PARAM_INT);
+    }
     $this->stmt->execute();
     $result = $this->stmt->fetchAll();
     $to_insert = [];
     $to_delete = [];
     $contained = [];
     $found = false;
-f8d4ca
+    $integerIDs = [];
-a99773b
+            Milan Vacek
     foreach ($result as $res) {
         $integerIDs = array_map('intval', explode(',', $_POST['manuscript']));
         foreach ($integerIDs as $new_value){
             if($new_value == $res['manuscript']){
                 $found = true;
                 array_push($contained, $new_value);
+            }
+        }
         if($found == false){
             array_push($to_delete, $res);
+        }
         $found = false;
+    }
     $to_insert = array_diff($integerIDs, $contained);
     foreach ($to_delete as $id_to_delete){
         $query = "DELETE FROM dd_manuscript WHERE ";
         $query .= "manuscript = " . $id_to_delete['manuscript'] . " AND ";
         $query .= " wordform_id = :wordform_id ;";
         $this->stmt = $this->pdo->prepare($query);
         if (array_key_exists("wordform_id", $_POST) && $_POST['wordform_id'] != "") {
             $this->stmt->bindParam(':wordform_id', $_POST['wordform_id'], PDO::PARAM_INT);
+        }
         //
         $this->stmt->execute();
         var_dump($query);
+    }
     foreach ($to_insert as $id_to_insert){
         $query = "INSERT INTO dd_manuscript VALUES ( ";
         $query .= " :wordform_id , ";
         $query .= " " . $id_to_insert . " ); ";
         $this->stmt = $this->pdo->prepare($query);
         if (array_key_exists("wordform_id", $_POST) && $_POST['wordform_id'] != "") {
             $this->stmt->bindParam(':wordform_id', $_POST['wordform_id'], PDO::PARAM_INT);
+        }
         $this->stmt->execute();
+    }
-f8d4ca
+            Milan Vacek
-a99773b
+            Milan Vacek
-f8d4ca
+function insert(){
 // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_lemma |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
     $query = "SELECT id FROM dd_lemma
               WHERE lemma = :lemma;";
     $this->stmt = $this->pdo->prepare($query);
         if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
             $this->stmt->bindParam(':lemma', $_POST['lemma'], PDO::PARAM_STR);
+        }
     $this->stmt->execute();
     $lemma = $this->stmt->fetch(PDO::FETCH_ASSOC);
-a99773b
+            Milan Vacek
-f8d4ca
+    if($lemma == null){
         $query = "SELECT MAX(id) FROM dd_lemma;";
         $this->stmt = $this->pdo->prepare($query);
         $this->stmt->execute();
         $result = $this->stmt->fetchAll();
         $result[0]["max"]+=1;
         $query = "INSERT INTO dd_lemma ( id, ";
         $values = "VALUES (" . $result[0]["max"] . ", ";
             if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
                 $query .= " lemma, ";
                 $values .= " :lemma, ";
+            }
             if (array_key_exists("pos", $_POST) && $_POST['pos'] != "") {
                 $query .= " pos ) ";
                 $values .= " :pos ); ";
+            }
-a99773b
+            Milan Vacek
-f8d4ca
+        $query .= $values;
         $this->stmt = $this->pdo->prepare($query);
             if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
                 $this->stmt->bindParam(':lemma', $_POST['lemma'], PDO::PARAM_STR);
+            }
             if (array_key_exists("pos", $_POST) && $_POST['pos'] != "") {
                 $this->stmt->bindParam(':pos', $_POST['pos'], PDO::PARAM_INT);
+            }
         $this->stmt->execute();
-a99773b
+            Milan Vacek
-f8d4ca
+    // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_tag |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
     $query = "SELECT id FROM dd_tag
               WHERE tag = :tag;";
-a99773b
+    $this->stmt = $this->pdo->prepare($query);
-f8d4ca
+        if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
             $this->stmt->bindParam(':tag', $_POST['tag'], PDO::PARAM_STR);
+        }
-a99773b
+    $this->stmt->execute();
-f8d4ca
+    $tag = $this->stmt->fetch(PDO::FETCH_ASSOC);
-            b315cd75
+            Milan Vacek
-f8d4ca
+    if($tag == null){
      $query = "SELECT MAX(id) FROM dd_tag;";
         $this->stmt = $this->pdo->prepare($query);
         $this->stmt->execute();
         $result = $this->stmt->fetchAll();
         $result[0]["max"]+=1;
         $query = "INSERT INTO dd_tag (id, ";
         $values = "VALUES (" . $result[0]["max"] . ", ";
             if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
                 $query .= " tag ) ";
                 $values .= " :tag ); ";
+            }
         $query .= $values;
         $this->stmt = $this->pdo->prepare($query);
             if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
                 $this->stmt->bindParam(':tag', $_POST['tag'], PDO::PARAM_STR);
+            }
         $this->stmt->execute();
+    }
-            b315cd75
+            Milan Vacek
-f8d4ca
+    // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_wordform |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
-            b315cd75
+    $query = "SELECT MAX(id) FROM dd_wordform;";
     $this->stmt = $this->pdo->prepare($query);
     $this->stmt->execute();
     $result = $this->stmt->fetchAll();
     $result[0]["max"]+=1;
-f8d4ca
+    $query = "SELECT id FROM dd_lemma
               WHERE lemma = :lemma;";
     $this->stmt = $this->pdo->prepare($query);
         if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
             $this->stmt->bindParam(':lemma', $_POST['lemma'], PDO::PARAM_STR);
+        }
     $this->stmt->execute();
     $lemma = $this->stmt->fetch(PDO::FETCH_ASSOC);
     $query = "SELECT id FROM dd_tag
               WHERE tag = :tag;";
     $this->stmt = $this->pdo->prepare($query);
         if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
             $this->stmt->bindParam(':tag', $_POST['tag'], PDO::PARAM_STR);
+        }
     $this->stmt->execute();
     $tag = $this->stmt->fetch(PDO::FETCH_ASSOC);
-            b315cd75
+            Milan Vacek
     $query = "INSERT INTO dd_wordform ( id, ";
     $values = "VALUES (" . $result[0]["max"] . ", ";
      if (array_key_exists("context", $_POST) && $_POST['context'] != "") {
             $query .= " context, ";
             $values .= " :context, ";
+        }
             $query .= " date, ";
             $values .=  " CURRENT_DATE, ";
         if (array_key_exists("description", $_POST) && $_POST['description'] != "") {
             $query .= " description, ";
             $values .= " :description, ";
+        }
         if (array_key_exists("description2", $_POST) && $_POST['description2'] != "") {
             $query .= " description2, ";
             $values .= " :description2, ";
+        }
         if (array_key_exists("description3", $_POST) && $_POST['description3'] != "") {
             $query .= " description3, ";
             $values .= " :description3, ";
+        }
         if (array_key_exists("ending", $_POST) && $_POST['ending'] != "") {
             $query .= " ending, ";
             $values .= " :ending, ";
+        }
         if (array_key_exists("finished", $_POST) && $_POST['finished'] != "") {
             $query .= " finished, ";
             $values .= " :finished, ";
+        }
         if (array_key_exists("namedentity", $_POST) && $_POST['namedentity'] != "") {
             $query .= " namedentity, ";
             $values .= " :namedentity, ";
+        }
         if (array_key_exists("position1", $_POST) && $_POST['position1'] != "") {
             $query .= " position1, ";
             $values .= " :position1, ";
+        }
         if (array_key_exists("position2", $_POST) && $_POST['position2'] != "") {
             $query .= " position2, ";
             $values .= " :position2, ";
+        }
         if (array_key_exists("positiondetail", $_POST) && $_POST['positiondetail'] != "") {
             $query .= " positiondetail, ";
             $values .= " :positiondetail, ";
+        }
         if (array_key_exists("prefix", $_POST) && $_POST['prefix'] != "") {
             $query .= " prefix, ";
             $values .= " :prefix, ";
+        }
         if (array_key_exists("suffix", $_POST) && $_POST['suffix'] != "") {
             $query .= " suffix, ";
             $values .= " :suffix, ";
+        }
         if (array_key_exists("word", $_POST) && $_POST['word'] != "") {
             $query .= " word, ";
             $values .= " :word, ";
+        }
-f8d4ca
+        if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
-            b315cd75
+            $query .= " lemma_id, ";
             $values .= " :lemma_id, ";
+        }
-f8d4ca
+        if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
-            b315cd75
+            $query .= " tag_id ) ";
             $values .= " :tag_id ); ";
+        }
         $query .= $values;
         $this->stmt = $this->pdo->prepare($query);
             if (array_key_exists("context", $_POST) && $_POST['context'] != "") {
                 $this->stmt->bindParam(':context', $_POST['context'], PDO::PARAM_STR);
+            }
             if (array_key_exists("description", $_POST) && $_POST['description'] != "") {
                 $this->stmt->bindParam(':description', $_POST['description'], PDO::PARAM_STR);
+            }
             if (array_key_exists("description2", $_POST) && $_POST['description2'] != "") {
                 $this->stmt->bindParam(':description2', $_POST['description2'], PDO::PARAM_STR);
+            }
             if (array_key_exists("description3", $_POST) && $_POST['description3'] != "") {
                 $this->stmt->bindParam(':description3', $_POST['description3'], PDO::PARAM_STR);
+            }
             if (array_key_exists("ending", $_POST) && $_POST['ending'] != "") {
                 $this->stmt->bindParam(':ending', $_POST['ending'], PDO::PARAM_STR);
+            }
             if (array_key_exists("finished", $_POST) && $_POST['finished'] != "") {
                 $this->stmt->bindParam(':finished', $_POST['finished']);
+            }
             if (array_key_exists("namedentity", $_POST) && $_POST['namedentity'] != "") {
                 $this->stmt->bindParam(':namedentity', $_POST['namedentity'], PDO::PARAM_INT);
+            }
             if (array_key_exists("position1", $_POST) && $_POST['position1'] != "") {
                 $this->stmt->bindParam(':position1', $_POST['position1'], PDO::PARAM_STR);
+            }
             if (array_key_exists("position2", $_POST) && $_POST['position2'] != "") {
                 $this->stmt->bindParam(':position2', $_POST['position2'], PDO::PARAM_STR);
+            }
             if (array_key_exists("positiondetail", $_POST) && $_POST['positiondetail'] != "") {
                 $this->stmt->bindParam(':positiondetail', $_POST['positiondetail'], PDO::PARAM_STR);
+            }
             if (array_key_exists("prefix", $_POST) && $_POST['prefix'] != "") {
                 $this->stmt->bindParam(':prefix', $_POST['prefix'], PDO::PARAM_STR);
+            }
             if (array_key_exists("suffix", $_POST) && $_POST['suffix'] != "") {
                 $this->stmt->bindParam(':suffix', $_POST['suffix'], PDO::PARAM_STR);
+            }
             if (array_key_exists("word", $_POST) && $_POST['word'] != "") {
                 $this->stmt->bindParam(':word', $_POST['word'], PDO::PARAM_STR);
+            }
-f8d4ca
+            if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
                 $this->stmt->bindParam(':lemma_id', $lemma["id"], PDO::PARAM_INT);
-            b315cd75
+            Milan Vacek
-f8d4ca
+            if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
                 $this->stmt->bindParam(':tag_id', $tag["id"], PDO::PARAM_INT);
-            b315cd75
+            Milan Vacek
             $this->stmt->execute();
 // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_manuscript |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
     if (array_key_exists("wordform_id", $_POST) && $_POST['wordform_id'] != "") {
         $query = "SELECT * FROM dd_manuscript WHERE ";
         $query .= " wordform_id = :wordform_id ;";
+    }
     $this->stmt = $this->pdo->prepare($query);
     if (array_key_exists("wordform_id", $_POST) && $_POST['wordform_id'] != "") {
         $this->stmt->bindParam(':wordform_id', $_POST['wordform_id'], PDO::PARAM_INT);
+    }
     $this->stmt->execute();
     $result = $this->stmt->fetchAll();
     $to_insert = [];
     $contained = [];
     $found = false;
-f8d4ca
+    $integerIDs = [];
-            b315cd75
+            Milan Vacek
     foreach ($result as $res) {
         $integerIDs = array_map('intval', explode(',', $_POST['manuscript']));
         foreach ($integerIDs as $new_value){
             if($new_value == $res['manuscript']){
                 $found = true;
                 array_push($contained, $new_value);
+            }
+        }
         if($found == false){
             array_push($to_delete, $res);
+        }
         $found = false;
+    }
     $to_insert = array_diff($integerIDs, $contained);
     foreach ($to_insert as $id_to_insert){
         $query = "INSERT INTO dd_manuscript VALUES ( ";
         $query .= " :wordform_id , ";
         $query .= " " . $id_to_insert . " ); ";
         $this->stmt = $this->pdo->prepare($query);
         if (array_key_exists("wordform_id", $_POST) && $_POST['wordform_id'] != "") {
             $this->stmt->bindParam(':wordform_id', $_POST['wordform_id'], PDO::PARAM_INT);
+        }
         $this->stmt->execute();
+    }
+}
-c140ee
+function remove(){
     // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_wordform |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
     $query = "DELETE FROM dd_wordform WHERE";
         if (array_key_exists("id", $_POST) && $_POST['id'] != "") {
             $query .= " id = :id ;";
+        }
     $this->stmt = $this->pdo->prepare($query);
         if (array_key_exists("id", $_POST) && $_POST['id'] != "") {
             $this->stmt->bindParam(':id', $_POST['id'], PDO::PARAM_INT);
+        }
     $this->stmt->execute();
     // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_lemma |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
     $query = "DELETE FROM dd_lemma WHERE";
-f8d4ca
+        if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
-c140ee
+            $query .= " id = :lemma_id ;";
+        }
     $this->stmt = $this->pdo->prepare($query);
-f8d4ca
+        if (array_key_exists("lemma", $_POST) && $_POST['lemma'] != "") {
             $this->stmt->bindParam(':lemma_id', $lemma["id"], PDO::PARAM_INT);
-c140ee
+            Milan Vacek
     $this->stmt->execute();
     // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_manuscript |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
     if (array_key_exists("wordform_id", $_POST) && $_POST['wordform_id'] != "") {
         $query = "DELETE FROM dd_manuscript WHERE";
         $query .= " wordform_id = :wordform_id ;";
+    }
     $this->stmt = $this->pdo->prepare($query);
     if (array_key_exists("wordform_id", $_POST) && $_POST['wordform_id'] != "") {
         $this->stmt->bindParam(':wordform_id', $_POST['wordform_id'], PDO::PARAM_INT);
+    }
     $this->stmt->execute();
     // ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Tabulka dd_tag |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
     $query = "DELETE FROM dd_tag WHERE";
-f8d4ca
+        if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
-c140ee
+            $query .= " id = :tag_id ;";
+        }
     $this->stmt = $this->pdo->prepare($query);
-f8d4ca
+        if (array_key_exists("tag", $_POST) && $_POST['tag'] != "") {
             $this->stmt->bindParam(':tag_id', $tag["id"], PDO::PARAM_INT);
-c140ee
+            Milan Vacek
     $this->stmt->execute();
+}
-            b315cd75
+            Milan Vacek
-b343aea
+            Tomáš Pašek
 // (D) DATABASE SETTINGS - CHANGE TO YOUR OWN!
 define('DB_HOST', 'localhost');
-a99773b
+define('DB_NAME', 'dalim2');
-b343aea
+define('DB_CHARSET', 'utf8');
 define('DB_USER', 'postgres');
-c140ee
+define('DB_PASSWORD', 'a');

Projekt

Obecné

Profil

ASWI - Pokročilé softwarové inženýrství » ASWI 2021 » Databáze slov a jejich tvarů (KČJ FPE) - Mr. Proper