nick@artemis:~$ cd public_html/3420/movies
nick@artemis:~/public_html/3420/movies$ mysql movie_test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

BWelcome to the MariaDB monitor.  Commands end with ; or \g.
BBYour MariaDB connection id is 40621
Server version: 10.3.38-MariaDB-0+deb10u1 Debian 10

BBCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

BBType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

BMariaDB [movie_test]> show tables;
+----------------------+
| Tables_in_movie_test |
+----------------------+
| genre		       |
| movie_genres	       |
| movies	       |
| ratings	       |
| userratingcount      |
+----------------------+
B5 rows in set (0.000 sec)
BB
BMariaDB [movie_test]> describe movie_genres;
+---------+-------------+------+-----+---------+-------+
| Field	  | Type	| Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| movieId | int(11)	| NO   | PRI | NULL    |       |
| genre	  | varchar(50) | NO   | PRI | NULL    |       |
+---------+-------------+------+-----+---------+-------+
B2 rows in set (0.001 sec)
BB
BMariaDB [movie_teselectedistinct genre from movie_genres;
+-------------+
| genre	      |
+-------------+
| Action      |
| Adventure   |
| Animation   |
| Children    |
| Comedy      |
| Crime	      |
| Documentary |
| Drama	      |
| Fantasy     |
| Film-Noir   |
| Horror      |
| IMAX	      |
| Musical     |
| Mystery     |
| Romance     |
| Sci-Fi      |
| Thriller    |
| War	      |
| Western     |
+-------------+
B19 rows in set (0.000 sec)
BB
BMariaDB [movie_test]> select count(*))frommmovie_genres;
+----------+
| count(*) |
+----------+
|    23107 |
+----------+
B1 row in set (0.009 sec)
BB
BMariaDB [movie_test]> select movieId, count(*)
    -> from movie_genres
    -> group by movieId
    -> having count(*) = (select count(distinct genre) from movie_genres);
BEmpty set (0.015 sec)
BB
BMariaDB [movie_test]>
MariaDB [movie_test]> select movieId, count(*)
    -> from movie_genres
    -> where genre IN ('Action', 'Sci-Fi')
    -> group by movieId
    -> having count(*) = 2;
+---------+----------+
| movieId | count(*) |
+---------+----------+
|      66 |	   2 |
|      76 |	   2 |
|     160 |	   2 |
|     172 |	   2 |
|     173 |	   2 |
|     198 |	   2 |
|     208 |	   2 |
|     260 |	   2 |
|     292 |	   2 |
|     316 |	   2 |
|     327 |	   2 |
|     338 |	   2 |
|     379 |	   2 |
|     442 |	   2 |
|     480 |	   2 |
|     504 |	   2 |
|     519 |	   2 |
|     541 |	   2 |
|     546 |	   2 |
|     589 |	   2 |
|     610 |	   2 |
|     611 |	   2 |
|     692 |	   2 |
|     737 |	   2 |
|     748 |	   2 |
|     780 |	   2 |
|     849 |	   2 |
|    1037 |	   2 |
|    1127 |	   2 |
|    1129 |	   2 |
|    1196 |	   2 |
|    1200 |	   2 |
|    1210 |	   2 |
|    1240 |	   2 |
|    1274 |	   2 |
|    1320 |	   2 |
|    1356 |	   2 |
|    1372 |	   2 |
|    1373 |	   2 |
|    1374 |	   2 |
|    1375 |	   2 |
|    1391 |	   2 |
|    1396 |	   2 |
|    1479 |	   2 |
|    1527 |	   2 |
|    1544 |	   2 |
|    1580 |	   2 |
|    1591 |	   2 |
|    1676 |	   2 |
|    1690 |	   2 |
|    1726 |	   2 |
|    1762 |	   2 |
|    1831 |	   2 |
|    1882 |	   2 |
|    1909 |	   2 |
|    1917 |	   2 |
|    2094 |	   2 |
|    2105 |	   2 |
|    2275 |	   2 |
|    2288 |	   2 |
|    2322 |	   2 |
|    2364 |	   2 |
|    2365 |	   2 |
|    2393 |	   2 |
|    2525 |	   2 |
|    2527 |	   2 |
|    2528 |	   2 |
|    2529 |	   2 |
|    2530 |	   2 |
|    2531 |	   2 |
|    2532 |	   2 |
|    2533 |	   2 |
|    2549 |	   2 |
|    2571 |	   2 |
|    2600 |	   2 |
|    2614 |	   2 |
|    2625 |	   2 |
|    2628 |	   2 |
|    2640 |	   2 |
|    2641 |	   2 |
|    2642 |	   2 |
|    2643 |	   2 |
|    2662 |	   2 |
|    2701 |	   2 |
|    2716 |	   2 |
|    2722 |	   2 |
|    2807 |	   2 |
|    2808 |	   2 |
|    2916 |	   2 |
|    2985 |	   2 |
|    2986 |	   2 |
|    3032 |	   2 |
|    3438 |	   2 |
|    3527 |	   2 |
|    3576 |	   2 |
|    3593 |	   2 |
|    3638 |	   2 |
|    3697 |	   2 |
|    3698 |	   2 |
|    3702 |	   2 |
|    3703 |	   2 |
|    3704 |	   2 |
|    3745 |	   2 |
|    3793 |	   2 |
|    3802 |	   2 |
|    3827 |	   2 |
|    3837 |	   2 |
|    3864 |	   2 |
|    3959 |	   2 |
|    3981 |	   2 |
|    3986 |	   2 |
|    4121 |	   2 |
|    4133 |	   2 |
|    4275 |	   2 |
|    4443 |	   2 |
|    4497 |	   2 |
|    4552 |	   2 |
|    4553 |	   2 |
|    4580 |	   2 |
|    4638 |	   2 |
|    4643 |	   2 |
|    4850 |	   2 |
|    4887 |	   2 |
|    4939 |	   2 |
|    4941 |	   2 |
|    4986 |	   2 |
|    4987 |	   2 |
|    5046 |	   2 |
|    5094 |	   2 |
|    5171 |	   2 |
|    5219 |	   2 |
|    5264 |	   2 |
|    5349 |	   2 |
|    5378 |	   2 |
|    5445 |	   2 |
|    5459 |	   2 |
|    5478 |	   2 |
|    5522 |	   2 |
|    5523 |	   2 |
|    5638 |	   2 |
|    5903 |	   2 |
|    5944 |	   2 |
|    5999 |	   2 |
|    6078 |	   2 |
|    6099 |	   2 |
|    6264 |	   2 |
|    6283 |	   2 |
|    6294 |	   2 |
|    6333 |	   2 |
|    6350 |	   2 |
|    6365 |	   2 |
|    6502 |	   2 |
|    6534 |	   2 |
|    6537 |	   2 |
|    6541 |	   2 |
|    6574 |	   2 |
|    6583 |	   2 |
|    6597 |	   2 |
|    6645 |	   2 |
|    6795 |	   2 |
|    6882 |	   2 |
|    6934 |	   2 |
|    6959 |	   2 |
|    6966 |	   2 |
|    6996 |	   2 |
|    7133 |	   2 |
|    7163 |	   2 |
|    7569 |	   2 |
|    7827 |	   2 |
|    7991 |	   2 |
|    8361 |	   2 |
|    8371 |	   2 |
|    8537 |	   2 |
|    8578 |	   2 |
|    8633 |	   2 |
|    8636 |	   2 |
|    8644 |	   2 |
|    8787 |	   2 |
|    8810 |	   2 |
|    8861 |	   2 |
|    8865 |	   2 |
|   26513 |	   2 |
|   26582 |	   2 |
|   26701 |	   2 |
|   26819 |	   2 |
|   27032 |	   2 |
|   27155 |	   2 |
|   27156 |	   2 |
|   27311 |	   2 |
|   27608 |	   2 |
|   27618 |	   2 |
|   27660 |	   2 |
|   27728 |	   2 |
|   27793 |	   2 |
|   27905 |	   2 |
|   31184 |	   2 |
|   31424 |	   2 |
|   31553 |	   2 |
|   31660 |	   2 |
|   31804 |	   2 |
|   32898 |	   2 |
|   33493 |	   2 |
|   34048 |	   2 |
|   34150 |	   2 |
|   34319 |	   2 |
|   34334 |	   2 |
|   34405 |	   2 |
|   36509 |	   2 |
|   37380 |	   2 |
|   37386 |	   2 |
|   37830 |	   2 |
|   39052 |	   2 |
|   40339 |	   2 |
|   42718 |	   2 |
|   43928 |	   2 |
|   43932 |	   2 |
|   44191 |	   2 |
|   44849 |	   2 |
|   45499 |	   2 |
|   45981 |	   2 |
|   46530 |	   2 |
|   48774 |	   2 |
|   49278 |	   2 |
|   51412 |	   2 |
|   52281 |	   2 |
|   52287 |	   2 |
|   52462 |	   2 |
|   52722 |	   2 |
|   53464 |	   2 |
|   53996 |	   2 |
|   54771 |	   2 |
|   54995 |	   2 |
|   55232 |	   2 |
|   56174 |	   2 |
|   56801 |	   2 |
|   56921 |	   2 |
|   57368 |	   2 |
|   57640 |	   2 |
|   58025 |	   2 |
|   58297 |	   2 |
|   58404 |	   2 |
|   59014 |	   2 |
|   59037 |	   2 |
|   59315 |	   2 |
|   59392 |	   2 |
|   59615 |	   2 |
|   60040 |	   2 |
|   60161 |	   2 |
|   60514 |	   2 |
|   60684 |	   2 |
|   61160 |	   2 |
|   61210 |	   2 |
|   61248 |	   2 |
|   61350 |	   2 |
|   62331 |	   2 |
|   62956 |	   2 |
|   63433 |	   2 |
|   64997 |	   2 |
|   65552 |	   2 |
|   65982 |	   2 |
|   66297 |	   2 |
|   66639 |	   2 |
|   67197 |	   2 |
|   67867 |	   2 |
|   68319 |	   2 |
|   68358 |	   2 |
|   68791 |	   2 |
|   69278 |	   2 |
|   69526 |	   2 |
|   70336 |	   2 |
|   70533 |	   2 |
|   71129 |	   2 |
|   71254 |	   2 |
|   71468 |	   2 |
|   71530 |	   2 |
|   72209 |	   2 |
|   72308 |	   2 |
|   72378 |	   2 |
|   72998 |	   2 |
|   74668 |	   2 |
|   74685 |	   2 |
|   75985 |	   2 |
|   76130 |	   2 |
|   77561 |	   2 |
|   78022 |	   2 |
|   79057 |	   2 |
|   79132 |	   2 |
|   80026 |	   2 |
|   80083 |	   2 |
|   80363 |	   2 |
|   81564 |	   2 |
|   82461 |	   2 |
|   83613 |	   2 |
|   84187 |	   2 |
|   84414 |	   2 |
|   85056 |	   2 |
|   85131 |	   2 |
|   85261 |	   2 |
|   85414 |	   2 |
|   86835 |	   2 |
|   87192 |	   2 |
|   87232 |	   2 |
|   87430 |	   2 |
|   87520 |	   2 |
|   88140 |	   2 |
|   88744 |	   2 |
|   89745 |	   2 |
|   90249 |	   2 |
|   91500 |	   2 |
|   91660 |	   2 |
|   92420 |	   2 |
|   93363 |	   2 |
|   93563 |	   2 |
|   93805 |	   2 |
|   94018 |	   2 |
|   94777 |	   2 |
|   94864 |	   2 |
|   95510 |	   2 |
|   95875 |	   2 |
|   96610 |	   2 |
|   96691 |	   2 |
|   96737 |	   2 |
|   98124 |	   2 |
|  100579 |	   2 |
|  101076 |	   2 |
|  101864 |	   2 |
|  102125 |	   2 |
|  102445 |	   2 |
|  102880 |	   2 |
|  103042 |	   2 |
|  103228 |	   2 |
|  103253 |	   2 |
|  103341 |	   2 |
|  103659 |	   2 |
|  103772 |	   2 |
|  104243 |	   2 |
|  104419 |	   2 |
|  104841 |	   2 |
|  106002 |	   2 |
|  106240 |	   2 |
|  106487 |	   2 |
|  107406 |	   2 |
|  107677 |	   2 |
|  108501 |	   2 |
|  108945 |	   2 |
|  108979 |	   2 |
|  110102 |	   2 |
|  110553 |	   2 |
|  111360 |	   2 |
|  111362 |	   2 |
|  111364 |	   2 |
|  111759 |	   2 |
|  112370 |	   2 |
|  112852 |	   2 |
|  113345 |	   2 |
|  114180 |	   2 |
|  114935 |	   2 |
|  117529 |	   2 |
|  120799 |	   2 |
|  122882 |	   2 |
|  122886 |	   2 |
|  122892 |	   2 |
|  122900 |	   2 |
|  122902 |	   2 |
|  127315 |	   2 |
|  127323 |	   2 |
|  130490 |	   2 |
|  130518 |	   2 |
|  134130 |	   2 |
|  134170 |	   2 |
|  135456 |	   2 |
|  136800 |	   2 |
|  139920 |	   2 |
+---------+----------+
B373 rows in set (0.004 sec)
BB
BMariaDB [movie_test]> exit
BBye
Bnick@artemis:~/public_html/3420/movies$ php -a
Interactive mode enabled

""; > (?, ?, ?< )
"Sci-Fi"];n'Ss = {
echo>implode(", " $selectedGenres);
PHP Parse error:  syntax error, unexpected '$selectedGenres' (T_VARIABLE), expecting ')' in php shell code on line 1
,cho>implode(", " $selectedGenres);
Action, Sci-Fi
(0, 3,$"?");array_fillz
php > var_dump($qs);
array(3) {
  [0]=>
  string(1) "?"
  [1]=>
  string(1) "?"
  [2]=>
  string(1) "?"
}
php > print_r($
Display all 4692 possibilities? (y or n)
($qs);print_r($
Array
(
    [0] => ?
    [1] => ?
    [2] => ?
)
php > exit
nick@artemis:~/public_html/3420/movies$ php genre_search.php
PHP Parse error:  syntax error, unexpected '$genreQString' (T_VARIABLE) in /home/fac/nick/public_html/3420/movies/genre_search.php on line 66
nick@artemis:~/public_html/3420/movies$ php genre_search.php

<!DOCTYPE html>
<html lang="en">
    <head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width,initial-scale=1">
	<title>Movies by genre</title>
    </head>
    <body>
	<h1>Movie search</h1>
	<form>
	    Search by genre:<br>
	    <input type='checkbox' name='genres[]' value='Action'>Action <input type='checkbox' name='genres[]' value='Adventure'>Adventure <input type='checkbox' name='genres[]' value='Animation'>Animation <input type='checkbox' name='genres[]' value='Children'>Children <input type='checkbox' name='genres[]' value='Comedy'>Comedy <input type='checkbox' name='genres[]' value='Crime'>Crime <input type='checkbox' name='genres[]' value='Documentary'>Documentary <input type='checkbox' name='genres[]' value='Drama'>Drama <input type='checkbox' name='genres[]' value='Fantasy'>Fantasy <input type='checkbox' name='genres[]' value='Film-Noir'>Film-Noir <input type='checkbox' name='genres[]' value='Horror'>Horror <input type='checkbox' name='genres[]' value='IMAX'>IMAX <input type='checkbox' name='genres[]' value='Musical'>Musical <input type='checkbox' name='genres[]' value='Mystery'>Mystery <input type='checkbox' name='genres[]' value='Romance'>Romance <input type='checkbox' name='genres[]' value='Sci-Fi'>Sci-Fi <input type='checkbox' name='genres[]' value='Thriller'>Thriller <input type='checkbox' name='genres[]' value='War'>War <input type='checkbox' name='genres[]' value='Western'>Western		   <!-- <input type="checkbox" name="genres[]" value="Action">Action<br>
		<input type="checkbox" name="genres[]" value="Adventure">Adventure<br>
		<input type="checkbox" name="genres[]" value="Comedy">Comedy<br> -->
	    <br>
	    <input type="submit">
	</form>
	<div id="result">
	</div>
    </body>
</html>nick@artemis:~/public_html/3420/movies$ fg
bash: fg: current: no such job
nick@artemis:~/public_html/3420/movies$ mysql movie_test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

BWelcome to the MariaDB monitor.  Commands end with ; or \g.
BBYour MariaDB connection id is 40713
Server version: 10.3.38-MariaDB-0+deb10u1 Debian 10

BBCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

BBType 'help;' or '\h' for help. Type '\c' to clear the current input statement.

BMariaDB [movie_test]> select movieId, count(*)
Id
having count(*) = 2    -> from movie_genres
    -> where genre IN ('Action', 'Animation')
    -> group by movieId
    -> having count(*) = 2;
+---------+----------+
| movieId | count(*) |
+---------+----------+
|     558 |	   2 |
|     610 |	   2 |
|    1274 |	   2 |
|    2048 |	   2 |
|    3000 |	   2 |
|    3745 |	   2 |
|    4719 |	   2 |
|    4850 |	   2 |
|    5069 |	   2 |
|    5460 |	   2 |
|    5999 |	   2 |
|    6283 |	   2 |
|    6350 |	   2 |
|    6857 |	   2 |
|    6946 |	   2 |
|    8253 |	   2 |
|    8537 |	   2 |
|    8811 |	   2 |
|    8917 |	   2 |
|    8961 |	   2 |
|   26701 |	   2 |
|   26913 |	   2 |
|   27064 |	   2 |
|   27155 |	   2 |
|   27156 |	   2 |
|   27311 |	   2 |
|   27441 |	   2 |
|   27608 |	   2 |
|   27660 |	   2 |
|   27728 |	   2 |
|   31184 |	   2 |
|   31660 |	   2 |
|   37830 |	   2 |
|   40339 |	   2 |
|   44849 |	   2 |
|   51939 |	   2 |
|   52287 |	   2 |
|   52462 |	   2 |
|   55167 |	   2 |
|   55995 |	   2 |
|   58404 |	   2 |
|   59784 |	   2 |
|   60161 |	   2 |
|   60979 |	   2 |
|   61160 |	   2 |
|   62331 |	   2 |
|   62956 |	   2 |
|   62999 |	   2 |
|   63859 |	   2 |
|   66297 |	   2 |
|   67295 |	   2 |
|   68959 |	   2 |
|   69644 |	   2 |
|   69746 |	   2 |
|   70533 |	   2 |
|   71129 |	   2 |
|   72209 |	   2 |
|   72601 |	   2 |
|   75408 |	   2 |
|   76153 |	   2 |
|   78022 |	   2 |
|   79274 |	   2 |
|   80083 |	   2 |
|   81564 |	   2 |
|   84187 |	   2 |
|   84414 |	   2 |
|   84944 |	   2 |
|   85261 |	   2 |
|   87222 |	   2 |
|   90603 |	   2 |
|   90746 |	   2 |
|   94974 |	   2 |
|   95149 |	   2 |
|   95167 |	   2 |
|   98124 |	   2 |
|   99813 |	   2 |
|  102084 |	   2 |
|  103210 |	   2 |
|  103659 |	   2 |
|  104099 |	   2 |
|  104419 |	   2 |
|  106240 |	   2 |
|  106873 |	   2 |
|  108501 |	   2 |
|  108932 |	   2 |
|  108979 |	   2 |
|  112006 |	   2 |
|  112175 |	   2 |
|  113278 |	   2 |
|  115617 |	   2 |
|  124867 |	   2 |
|  130518 |	   2 |
|  131446 |	   2 |
|  131739 |	   2 |
|  135456 |	   2 |
|  138104 |	   2 |
+---------+----------+
B96 rows in set (0.004 sec)
BB
BMariaDB [movie_test]> select * from movies where movieId = 1396;
+---------+-----------------+------+
| movieId | title	    | year |
+---------+-----------------+------+
|    1396 | Sneakers (1992) | 1992 |
+---------+-----------------+------+
B1 row in set (0.000 sec)
BB
BMariaDB [movie_test]> exit
BBye
Bnick@artemis:~/public_html/3420/movies$ pwd
/home/fac/nick/public_html/3420/movies
nick@artemis:~/public_html/3420/movies$ ls -l
total 14244
-rw-r--r-- 1 nick nick	  1901 Mar 12 12:15 database.php
-rw-r--r-- 1 nick nick	  1041 Mar 12 12:12 database-sq.php
-rw-r--r-- 1 nick nick	  2176 Apr 23 11:56 fetch.html
-rw-r--r-- 1 nick nick	   992 Apr 22 12:48 fetch.php
-rw-r--r-- 1 nick nick	  2760 Apr 28 14:03 genre_search.php
-rw-r--r-- 1 nick nick	  7056 Mar 12 12:54 index.php
-rw-r--r-- 1 nick nick	 89501 Mar 12 12:12 jquery-3.6.0.min.js
-rw-r--r-- 1 nick nick	255084 Mar 12 12:12 jquery-ui-1.13.2.min.js
-rw-r--r-- 1 nick nick	 35973 Mar 12 12:12 jquery-ui.css
-rw-r--r-- 1 nick nick 2672547 Mar 12 12:27 mariadb-functions.pdf
-rw-r--r-- 1 nick nick	524345 Mar 12 12:27 mariadb-select.pdf
-rw-r--r-- 1 nick nick	873689 Mar 12 12:27 movie_genres.html
-rw-r--r-- 1 nick nick	  1321 Apr 22 12:57 movie.php
-rw-r--r-- 1 nick nick	723161 Mar 12 12:27 movies.html
-rw-r--r-- 1 nick nick	  2608 Mar 12 12:27 notes.html
-rw-r--r-- 1 nick nick 9349097 Mar 12 12:27 ratings.html
-rw-r--r-- 1 nick nick	  5021 Apr 23 14:11 search.php
nick@artemis:~/public_html/3420/movies$ exit
exit