From 24516c6d29fe03eb7440850be074495cc524e5dc Mon Sep 17 00:00:00 2001 From: xf0r3m Date: Mon, 22 Jul 2024 14:42:47 +0200 Subject: [PATCH 1/1] Synchronizacja public -> priv --- README.md | 5 ++ db_conf.php | 20 +++++ index.php | 192 ++++++++++++++++++++++++++++++++++++++++++++++++ install.sql | 27 +++++++ library.php | 67 +++++++++++++++++ login.php | 50 +++++++++++++ logout.php | 6 ++ newcategory.php | 8 ++ passwd.php | 10 +++ style.css | 39 ++++++++++ 10 files changed, 424 insertions(+) create mode 100644 README.md create mode 100644 db_conf.php create mode 100644 index.php create mode 100644 install.sql create mode 100644 library.php create mode 100644 login.php create mode 100644 logout.php create mode 100644 newcategory.php create mode 100644 passwd.php create mode 100644 style.css diff --git a/README.md b/README.md new file mode 100644 index 0000000..d21b721 --- /dev/null +++ b/README.md @@ -0,0 +1,5 @@ +# SC - SiteCatalogue + +2.0 + +Wymagania: LAMP Stack + jakieś dobre hasło do bazy. diff --git a/db_conf.php b/db_conf.php new file mode 100644 index 0000000..0955910 --- /dev/null +++ b/db_conf.php @@ -0,0 +1,20 @@ +console.log('Połaczenie nie powiodło się'); + console.log(\"Nr błędu: " . mysqli_connect_errno() . "\"); + console.log(\"Błąd: " . mysqli_connect_error() . "\");"; + exit; + } else { + if ( ! isset($_SERVER["SHELL"]) ) { + echo ""; + } + } + +?> diff --git a/index.php b/index.php new file mode 100644 index 0000000..2f68564 --- /dev/null +++ b/index.php @@ -0,0 +1,192 @@ + + + + + + + Site Catalogue - morketsmerke.org + + + + + +
+ +
+
+
+ Kategorie: +
+
    + +
    + + +
    + " . $row[1] . ""; + } else { + echo "
  • + " . $row[1] . "
    • "; + } + } + } + if ( session_status() != 2 ) { session_start(); } + if ( ! empty($_SESSION['username']) ) { + ?> +
  • +
    +
    + +
    +
    + +
    +
    +
    • + +
+
+ +
+
+
+
+ +
+
    + +
    + + +
    + ". $row[1] . ""; + } else { + echo "
  • + " . $row[1] . "
    • "; + } + } + } + if ( session_status() != 2 ) { session_start(); } + if ( ! empty($_SESSION['username']) ) { + ?> +
  • +
    + +
    + + +
    +
    + + +
    + +
    +
    • + + +
+
+
+ +
+ + + + diff --git a/install.sql b/install.sql new file mode 100644 index 0000000..fd424be --- /dev/null +++ b/install.sql @@ -0,0 +1,27 @@ +CREATE USER 'sc'@'localhost' IDENTIFIED BY ''; +CREATE DATABASE sc; +GRANT ALL ON sc.* TO 'sc'@'localhost'; + +USE sc; + +CREATE TABLE users ( + id int AUTO_INCREMENT PRIMARY KEY, + username varchar(30), + hash text +); + +CREATE TABLE categories ( + id int AUTO_INCREMENT PRIMARY KEY, + name text +); + +CREATE TABLE sites ( + id int AUTO_INCREMENT PRIMARY KEY, + cateId int, + name text, + href text, + FOREIGN KEY (cateId) REFERENCES categories(id) +); + +INSERT INTO users (username, hash) VALUES ('', ""); +INSERT INTO categories (name) VALUES ("Bez kategorii"); diff --git a/library.php b/library.php new file mode 100644 index 0000000..893266a --- /dev/null +++ b/library.php @@ -0,0 +1,67 @@ + 0) ) { + if ( ! isset($_SERVER["SHELL"]) ) { + echo ""; + } + return true; + } else { + echo ""; + return false; + } +} + +function dbQuery($connection, $tableName, $columnScheme, $whereValue, $debug=0) { + $query = "SELECT " . $columnScheme . " FROM " . $tableName . " WHERE " . $whereValue; + if ( $debug == 1 ) { var_dump($query); } + $result = mysqli_query($connection, $query); + + if ( mysqliResult($connection, $result) ) { + return $result; + } else { + echo ""; + } + +} + +function getFieldValue($result) { + $row = mysqli_fetch_row($result); + return $row[0]; +} + +function dbUpdate($connection, $tableName, $setValue, $whereValue) { + $query = "UPDATE " . $tableName . " SET " . $setValue . " WHERE " . $whereValue; + $result = mysqli_query($connection, $query); + + if ( mysqliResult($connection, $result) ) { + return $result; + } else { + echo ""; + } + +} + +function dbAdd($connection, $tableName, $columnScheme, $setValues) { + $query = "INSERT INTO " . $tableName . " (" . $columnScheme . ") VALUES (" . $setValues . ");"; + $result = mysqli_query($connection, $query); + + if ( mysqliResult($connection, $result) ) { + return $result; + } else { + echo ""; + } +} + +function dbDel($connection, $tableName, $whereValue) { + $query = "DELETE FROM " . $tableName . " WHERE " . $whereValue; + $result = mysqli_query($connection, $query); + + if ( mysqliResult($connection, $result) ) { + return $result; + } else { + echo ""; + } +} + +?> diff --git a/login.php b/login.php new file mode 100644 index 0000000..c791d00 --- /dev/null +++ b/login.php @@ -0,0 +1,50 @@ + + + + +
+
Logowanie:
+
+
+ + +
+
+ + +
+ +
+
+ diff --git a/logout.php b/logout.php new file mode 100644 index 0000000..172eb7c --- /dev/null +++ b/logout.php @@ -0,0 +1,6 @@ + diff --git a/newcategory.php b/newcategory.php new file mode 100644 index 0000000..fb24706 --- /dev/null +++ b/newcategory.php @@ -0,0 +1,8 @@ + diff --git a/passwd.php b/passwd.php new file mode 100644 index 0000000..855e8a5 --- /dev/null +++ b/passwd.php @@ -0,0 +1,10 @@ + +
+ Password: + +
+" . password_hash($_POST["pass"], PASSWORD_DEFAULT) . ""; + } +?> diff --git a/style.css b/style.css new file mode 100644 index 0000000..daa7f3f --- /dev/null +++ b/style.css @@ -0,0 +1,39 @@ +#categories { + width: 30%; + float: left; +} + +#catalogue { + width: 68%; + float: left; +} + +#main { + margin-top: 1%; +} + +#loginForm { + width: 50%; + margin-left: auto; + margin-right: auto; +} + +.inputs { + padding-left: 5px; + padding-right: 5px; + padding-top: 5px; +} + +.buttons { + margin-left: 5px; + margin-bottom: 5px; +} + +.deleteButton { + margin-left: 5px; + margin-right: 15px; +} + +.delForms { + display: inline; +} -- 2.39.5