summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
Diffstat
-rw-r--r--Aufgabe04/catalog.sql32
-rw-r--r--Aufgabe04/category.html20
-rw-r--r--Aufgabe04/index.html9
-rw-r--r--Aufgabe04/product.html27
-rw-r--r--Aufgabe04/underline.css4
-rw-r--r--Aufgabe04/user.html20
6 files changed, 67 insertions, 45 deletions
diff --git a/Aufgabe04/catalog.sql b/Aufgabe04/catalog.sql
index a149a4f..0a0941b 100644
--- a/Aufgabe04/catalog.sql
+++ b/Aufgabe04/catalog.sql
@@ -3,7 +3,7 @@
-- http://www.phpmyadmin.net
--
-- Host: localhost
--- Erstellungszeit: 13. Apr 2015 um 11:33
+-- Erstellungszeit: 20. Apr 2015 um 12:45
-- Server-Version: 10.0.17-MariaDB-log
-- PHP-Version: 5.6.7
@@ -27,9 +27,9 @@ SET time_zone = "+00:00";
--
CREATE TABLE IF NOT EXISTS `category` (
- `id` int(11) NOT NULL,
- `name` varchar(100) NOT NULL,
- `description` varchar(1000) DEFAULT NULL
+ `id` int(11) NOT NULL COMMENT 'The primary key of the category.',
+ `name` varchar(100) NOT NULL COMMENT 'The name of the category.',
+ `description` varchar(1000) DEFAULT NULL COMMENT 'The description of the category.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
@@ -39,12 +39,12 @@ CREATE TABLE IF NOT EXISTS `category` (
--
CREATE TABLE IF NOT EXISTS `product` (
- `id` int(11) NOT NULL,
- `name` varchar(100) NOT NULL,
- `price` int(11) NOT NULL,
- `width` int(11) NOT NULL,
- `height` int(11) NOT NULL,
- `description` varchar(1000) DEFAULT NULL
+ `id` int(11) NOT NULL COMMENT 'The primary key for the table.',
+ `name` varchar(100) NOT NULL COMMENT 'The name of the product.',
+ `price` decimal(10,2) NOT NULL COMMENT 'The price of the product in euro (VAT included).',
+ `width` int(11) NOT NULL COMMENT 'The width of the product in millimeter.',
+ `height` int(11) NOT NULL COMMENT 'The height of the product in millimeter.',
+ `description` varchar(1000) DEFAULT NULL COMMENT 'The description of the product.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
@@ -54,8 +54,8 @@ CREATE TABLE IF NOT EXISTS `product` (
--
CREATE TABLE IF NOT EXISTS `product_category` (
- `product_id` int(11) NOT NULL,
- `category_id` int(11) NOT NULL
+ `product_id` int(11) NOT NULL COMMENT 'The product_id from the product table.',
+ `category_id` int(11) NOT NULL COMMENT 'The category_id from the category table.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
@@ -65,8 +65,8 @@ CREATE TABLE IF NOT EXISTS `product_category` (
--
CREATE TABLE IF NOT EXISTS `user` (
- `username` varchar(100) NOT NULL,
- `password` char(40) NOT NULL
+ `username` varchar(100) NOT NULL COMMENT 'The username of the user.',
+ `password` char(40) NOT NULL COMMENT 'The password of the user. (sha-1)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
@@ -106,12 +106,12 @@ ALTER TABLE `user`
-- AUTO_INCREMENT für Tabelle `category`
--
ALTER TABLE `category`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
+ MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'The primary key of the category.';
--
-- AUTO_INCREMENT für Tabelle `product`
--
ALTER TABLE `product`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
+ MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'The primary key for the table.';
--
-- Constraints der exportierten Tabellen
--
diff --git a/Aufgabe04/category.html b/Aufgabe04/category.html
index 5015bd0..462a678 100644
--- a/Aufgabe04/category.html
+++ b/Aufgabe04/category.html
@@ -3,23 +3,23 @@
<head>
<meta charset="UTF-8">
<title>Category</title>
+<link rel="stylesheet" type="text/css" href="underline.css">
</head>
<body>
- <a href="./" accesskey="ü">Zur<em>ü</em>ck
- </a>
+ <a href="./" accesskey="b"><em>B</em>ack </a>
<form action="http://www-in.fh-swf.de/fbp-cgi/showenv.pl" method="post">
<h1>Category</h1>
- <label for="name"><u>N</u>ame:</label><input type="text"
- placeholder="Name" id="name" name="name" accesskey="n"><br>
- <label for="desc"><u>D</u>escription:</label>
+ <label for="name"><u>N</u>ame:</label> <input type="text"
+ placeholder="Name" id="name" name="name" accesskey="n"
+ maxlength="100"><br> <label for="desc"><u>D</u>escription:</label>
<textarea placeholder="Description" id="desc" name="desc"
- accesskey="d"></textarea>
+ accesskey="d" maxlength="1000"></textarea>
<br>
- <button type="submit" accesskey="a">
- <u>A</u>bschicken
+ <button type="submit" accesskey="c">
+ <u>C</u>reate
</button>
- <button type="reset" accesskey="z">
- <u>Z</u>urücksetzen
+ <button type="reset" accesskey="r">
+ <u>R</u>eset
</button>
</form>
</body>
diff --git a/Aufgabe04/index.html b/Aufgabe04/index.html
index ecf747c..f123211 100644
--- a/Aufgabe04/index.html
+++ b/Aufgabe04/index.html
@@ -5,8 +5,11 @@
<title>Manipulate Database</title>
</head>
<body>
- <a href="product.html" accesskey="p"><em>P</em>roducts</a><br>
- <a href="category.html" accesskey="c"><em>C</em>ategroy</a><br>
- <a href="user.html" accesskey="u"><em>U</em>ser</a><br>
+ <a href="product.html" accesskey="p"><em>P</em>roducts</a>
+ <br>
+ <a href="category.html" accesskey="c"><em>C</em>ategroy</a>
+ <br>
+ <a href="user.html" accesskey="u"><em>U</em>ser</a>
+ <br>
</body>
</html> \ No newline at end of file
diff --git a/Aufgabe04/product.html b/Aufgabe04/product.html
index 8a81303..7aa7e1c 100644
--- a/Aufgabe04/product.html
+++ b/Aufgabe04/product.html
@@ -3,19 +3,30 @@
<head>
<meta charset="UTF-8">
<title>Production</title>
+<link rel="stylesheet" type="text/css" href="underline.css">
</head>
<body>
- <a href="./" accesskey="ü">Zur<em>ü</em>ck</a>
+ <a href="./" accesskey="b"><em>B</em>ack </a>
<form action="http://www-in.fh-swf.de/fbp-cgi/showenv.pl" method="post">
<h1>Product</h1>
- <label for="name"><u>N</u>ame:</label><input type="text" placeholder="Name" id="name" name="name" accesskey="n"><br>
- <label for="price"><u>P</u>rice:</label><input type="text" placeholder="Price" id="price" name="price" accesskey="p"><br>
- <label for="width"><u>W</u>idth:</label><input type="text" placeholder="Width" id="width" name="width" accesskey="w"><br>
- <label for="height"><u>H</u>eight:</label><input type="text" placeholder="Height" id="height" name="height" accesskey="h"><br> <label for="desc"><u>D</u>escription:</label>
- <textarea placeholder="Description" id="desc" name="desc" accesskey="d"></textarea>
+ <label for="name"><u>N</u>ame:</label><input type="text"
+ placeholder="Name" id="name" name="name" accesskey="n"
+ maxlength="100"><br> <label for="price"><u>P</u>rice (Euro):</label><input
+ type="text" placeholder="Price (Euro)" id="price" name="price" accesskey="p"
+ maxlength="13"><br> <label for="width"><u>W</u>idth (mm):</label><input
+ type="text" placeholder="Width (mm)" id="width" name="width" accesskey="w"
+ maxlength="11"><br> <label for="height"><u>H</u>eight (mm):</label><input
+ type="text" placeholder="Height (mm)" id="height" name="height"
+ accesskey="h" maxlength="11"><br> <label for="desc"><u>D</u>escription:</label>
+ <textarea placeholder="Description" id="desc" name="desc"
+ accesskey="d" maxlength="1000"></textarea>
<br>
- <button type="submit" accesskey="a"><u>A</u>bschicken</button>
- <button type="reset" accesskey="z"><u>Z</u>urücksetzen</button>
+ <button type="submit" accesskey="c">
+ <u>C</u>reate
+ </button>
+ <button type="reset" accesskey="r">
+ <u>R</u>eset
+ </button>
</form>
</body>
</html> \ No newline at end of file
diff --git a/Aufgabe04/underline.css b/Aufgabe04/underline.css
new file mode 100644
index 0000000..bd4bfcb
--- /dev/null
+++ b/Aufgabe04/underline.css
@@ -0,0 +1,4 @@
+@CHARSET "UTF-8";
+u {
+ text-decoration: underline;
+} \ No newline at end of file
diff --git a/Aufgabe04/user.html b/Aufgabe04/user.html
index 34bd0cb..c647f51 100644
--- a/Aufgabe04/user.html
+++ b/Aufgabe04/user.html
@@ -3,21 +3,25 @@
<head>
<meta charset="UTF-8">
<title>User</title>
+<link rel="stylesheet" type="text/css" href="underline.css">
</head>
<body>
- <a href="./" accesskey="ü">Zur<em>ü</em>ck
+ <a href="./" accesskey="b"><em>B</em>ack
</a>
<form action="http://www-in.fh-swf.de/fbp-cgi/showenv.pl" method="post">
<h1>User</h1>
<label for="username"><u>U</u>sername:</label><input type="text"
- placeholder="Username" id="username" name="username" accesskey="u"><br>
- <label for="password"><u>P</u>assword:</label><input type="password"
- placeholder="Password" id="password" name="password" accesskey="p"><br>
- <button type="submit" accesskey="a">
- <u>A</u>bschicken
+ placeholder="Username" id="username" name="username" accesskey="u"
+ maxlength="100"><br> <label for="password"><u>P</u>assword:</label><input
+ type="password" placeholder="Password" id="password" name="password"
+ accesskey="p"><br> <label for="passwordagain">Reenter P<u>a</u>ssword:</label><input
+ type="password" placeholder="Reenter Password" id="passwordagain" name="passwordagain"
+ accesskey="a"><br>
+ <button type="submit" accesskey="e">
+ R<u>e</u>gister
</button>
- <button type="reset" accesskey="z">
- <u>Z</u>urücksetzen
+ <button type="reset" accesskey="r">
+ <u>R</u>eset
</button>
</form>
</body>
generated by cgit v1.2.3-70-g09d2 (git 2.52.0) at 2025-12-06 07:33:54 +0000