From e9e8767bfa3a4e8a13bc367c895eafb4b4ab9291 Mon Sep 17 00:00:00 2001
From: xf0r3m <jakubstasinski@protonmail.com>
Date: Tue, 23 Jul 2024 09:00:10 +0200
Subject: [PATCH] =?utf8?q?Dodanie=20mo=C5=BCliwo=C5=9Bci=20przeniesienia?=
 =?utf8?q?=20stron=20mi=C4=99dzy=20kategoriami=20-=20BT=20#186.?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 index.php | 26 +++++++++++++++++++++++++-
 style.css | 14 ++++++++++++++
 2 files changed, 39 insertions(+), 1 deletion(-)

diff --git a/index.php b/index.php
index 2f68564..0d09b73 100644
--- a/index.php
+++ b/index.php
@@ -122,6 +122,13 @@
           </div>
           <ul class="list-group list-group-flush">
             <?php
+              #Przeniesienie strony do innej kategorii
+              if ( isset($_POST['newCateId']) ) {
+                $tableName = "sites";
+                $setValue = "cateId = " . mysqli_real_escape_string($connection, $_POST['newCateId']);
+                $whereValue = "id = " . mysqli_real_escape_string($connection, $_POST['movedSiteId']);
+                $result = dbUpdate($connection, $tableName, $setValue, $whereValue); 
+              }
               #Usunięcie strony
               if ( isset($_POST['siteId']) ) {
                 $tableName = "sites";
@@ -151,7 +158,24 @@
                   <input type=\"hidden\" name=\"siteId\" value=\"" . $row[0] . "\">
                   <button type=\"submit\" class=\"btn btn-danger deleteButton\" title=\"Usuń\">&times;</button>
                   </form>
-                  <a href=\"" . $row[2] . "\">". $row[1] . "</a></li>";
+                  <a href=\"" . $row[2] . "\">". $row[1] . "</a>";
+                  echo "<form class=\"moveForm\" action=\"" . $_SERVER['REQUEST_URI'] . "\" method=\"post\">";
+                  echo "<input type=\"hidden\" name=\"movedSiteId\" value=\"" . $row[0] . "\">";
+                  echo "<select class=\"form-select moveSelect\" name=\"newCateId\">";
+                  echo "<option></option>";
+                    $tableName = 'categories';
+                    $columnScheme = "id,name";
+                    $whereValue = "1=1";
+                    $result2 = dbQuery($connection, $tableName, $columnScheme, $whereValue);
+                    if ( ! is_null($result2) ) {
+                      while ( $row2 = mysqli_fetch_row($result2) ) {
+                        echo "<option value=\"" . $row2[0] . "\">" . $row2[1] . "</option>";
+                      }
+                    }
+                  echo "</select>";
+                  echo "<button type=\"submit\" class=\"btn btn-warning moveButton\">Przenieś</button>";
+                  echo "</form>";
+                  echo "</li>";
                   } else {
                     echo "<li class=\"list-group-item\">
                     <a href=\"" . $row[2] . "\">" . $row[1] . "</a></li>";
diff --git a/style.css b/style.css
index daa7f3f..d6313d8 100644
--- a/style.css
+++ b/style.css
@@ -37,3 +37,17 @@
 .delForms {
   display: inline;
 }
+
+.moveSelect {
+  display: inline;
+  width: 37%;
+  margin-right: 20px;
+}
+
+.moveButton {
+  margin-bottom: 5px;
+}
+
+.moveForm {
+  margin-top: 16px;
+}
-- 
2.39.5