Next: /media/sda-magnetic/david/Dok-15-2023-11-27/informatik/www-intel-compute-stick-2022-06-13/050/quantity.php Up: vhdl - ttl - Previous: /media/sda-magnetic/david/Dok-15-2023-11-27/informatik/www-intel-compute-stick-2022-06-13/050/output02.txt
david@intel-compute-stick:~$ mysql -u root -p
Enter password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
david@intel-compute-stick:~$ mysql -u root -p
Enter password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
david@intel-compute-stick:~$ mysql -u root -p
Enter password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
david@intel-compute-stick:~$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 145
Server version: 10.5.12-MariaDB-0+deb11u1 Debian 11
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> CREATE DATABASE test050;
Query OK, 1 row affected (0.002 sec)
MariaDB [(none)]> USE test050;
Database changed
MariaDB [test050]> CREATE TABLE abc (name1 VARCHAR (32), name2 VARCHAR (32));
Query OK, 0 rows affected (0.051 sec)
MariaDB [test050]> CREATE TABLE def (name3 VARCHAR (32), name4 VARCHAR (32));
Query OK, 0 rows affected (0.053 sec)
MariaDB [test050]> INSERT INTO abc VALUES ("001", "001");
Query OK, 1 row affected (0.028 sec)
MariaDB [test050]> INSERT INTO abc (name1, name2) VALUES ("001", "002");
Query OK, 1 row affected (0.032 sec)
MariaDB [test050]> INSERT INTO abc (name2, name1) VALUES ("001", "002");
Query OK, 1 row affected (0.033 sec)
MariaDB [test050]> INSERT INTO abc VALUES ("002", "002");
Query OK, 1 row affected (0.030 sec)
MariaDB [test050]> INSERT INTOO def VALUES ("001", "001");
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'def VALUES ("001", "001")' at line 1
MariaDB [test050]> INSERT INTO def VALUES ("001", "001");
Query OK, 1 row affected (0.035 sec)
MariaDB [test050]> INSERT INTO def VALUES ("001", "002");
Query OK, 1 row affected (0.031 sec)
MariaDB [test050]> INSERT INTO def VALUES ("abc", "abc");
Query OK, 1 row affected (0.027 sec)
MariaDB [test050]> SELECT * FROM abc;
+-------+-------+
| name1 | name2 |
+-------+-------+
| 001 | 001 |
| 001 | 002 |
| 002 | 001 |
| 002 | 002 |
+-------+-------+
4 rows in set (0.001 sec)
MariaDB [test050]> SELECT * FROM def;
+-------+-------+
| name3 | name4 |
+-------+-------+
| 001 | 001 |
| 001 | 002 |
| abc | abc |
+-------+-------+
3 rows in set (0.001 sec)
MariaDB [test050]> SELECT * FROM abc JOIN def;
+-------+-------+-------+-------+
| name1 | name2 | name3 | name4 |
+-------+-------+-------+-------+
| 001 | 001 | 001 | 001 |
| 001 | 001 | 001 | 002 |
| 001 | 001 | abc | abc |
| 001 | 002 | 001 | 001 |
| 001 | 002 | 001 | 002 |
| 001 | 002 | abc | abc |
| 002 | 001 | 001 | 001 |
| 002 | 001 | 001 | 002 |
| 002 | 001 | abc | abc |
| 002 | 002 | 001 | 001 |
| 002 | 002 | 001 | 002 |
| 002 | 002 | abc | abc |
+-------+-------+-------+-------+
12 rows in set (0.002 sec)
MariaDB [test050]> SELECT * FROM abc INNER JOIN def ON abc.name1 = def.name3;
+-------+-------+-------+-------+
| name1 | name2 | name3 | name4 |
+-------+-------+-------+-------+
| 001 | 001 | 001 | 001 |
| 001 | 001 | 001 | 002 |
| 001 | 002 | 001 | 001 |
| 001 | 002 | 001 | 002 |
+-------+-------+-------+-------+
4 rows in set (0.002 sec)
MariaDB [test050]> SELECT * FROM abc LEFT JOIN def ON abc.name1 = def.name3;
+-------+-------+-------+-------+
| name1 | name2 | name3 | name4 |
+-------+-------+-------+-------+
| 001 | 001 | 001 | 001 |
| 001 | 002 | 001 | 001 |
| 001 | 001 | 001 | 002 |
| 001 | 002 | 001 | 002 |
| 002 | 001 | NULL | NULL |
| 002 | 002 | NULL | NULL |
+-------+-------+-------+-------+
6 rows in set (0.002 sec)
MariaDB [test050]> SELECT * FROM abc RIGHT JOIN def ON abc.name1 = def.name3;
+-------+-------+-------+-------+
| name1 | name2 | name3 | name4 |
+-------+-------+-------+-------+
| 001 | 001 | 001 | 001 |
| 001 | 001 | 001 | 002 |
| 001 | 002 | 001 | 001 |
| 001 | 002 | 001 | 002 |
| NULL | NULL | abc | abc |
+-------+-------+-------+-------+
5 rows in set (0.002 sec)
MariaDB [test050]> QUIT
Bye
david@intel-compute-stick:~$ cd /var/www/html/050
david@intel-compute-stick:/var/www/html/050$ php database.php > output01.txt
david@intel-compute-stick:/var/www/html/050$ telnet 127.0.0.1 80
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
POST /050/form1.php HTTP/1.1
host: localhost
Cookie: Cookie50a=DIES_IST_COOKIE_50a
Content-Type: application/x-www-form-urlencoded
Content-Length: 19
text1=HALLO_TEXT_50
HTTP/1.1 200 OK
Date: Sun, 22 May 2022 14:45:05 GMT
Server: Apache/2.4.52 (Debian)
Set-Cookie: PHPSESSID=c861vm0spht7bspidko88j10j7; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache
Set-Cookie: Cookie50=DIES_IST_COOKIE_50; expires=Sun, 22-May-2022 15:45:06 GMT; Max-Age=3600
Vary: Accept-Encoding
Content-Length: 201
Content-Type: text/html; charset=UTF-8
<form method="POST" action="./form1.php">
<input type="text" name="text1"></input>
<input type="submit"></input>
</form>
c861vm0spht7bspidko88j10j7<br>
HALLO_TEXT_50<br>
<br>
DIES_IST_COOKIE_50a<br>
Connection closed by foreign host.
david@intel-compute-stick:/var/www/html/050$ php quantity.php > output01.txt
database.php form1.php httprequest01.txt output01.txt quantity.php
david@intel-compute-stick:/var/www/html/050$ php quantity.php > output02.txt
david@intel-compute-stick:/var/www/html/050$ cat *