nick@Vaxis:~$ ssh artemis Linux artemis 5.10.0-28-amd64 #1 SMP Debian 5.10.209-2 (2024-01-31) x86_64 The programs included with the Debian GNU/Linux system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright. Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law. Last login: Mon Nov 18 11:52:33 2024 from 136.168.38.41 nick@artemis:~$ cd public_html/3420/companyf24 nick@artemis:~/public_html/3420/companyf24$ mysql companyf24 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 100997 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 [companyf24]> select *ffrom Employee order by rand() limit 1; +-------------+---------+-------+-------+--------+-------------+-------------------------+--------+---------------+---------------+--------------------------------------------------------------+ | SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN | PasswordPlain | PasswordHashed | +-------------+---------+-------+-------+--------+-------------+-------------------------+--------+---------------+---------------+--------------------------------------------------------------+ | 519-05-5719 | 5 | Jim | E | Maling | 1961-04-03 | 210 Londonderry Terrace | 79479 | 784-79-6956 | zaym90Mroz | $2y$10$eHMGdLoxuOhbGexkFOhD7Opcbmr.qAIvOmJ/h2ABW8RcCeV3LFYMy | +-------------+---------+-------+-------+--------+-------------+-------------------------+--------+---------------+---------------+--------------------------------------------------------------+ B1 row in set (0.001 sec) BB BEmployee)corderyby4rand()elimitf1;m Employee where SSNrINd(selecttSupervisorSSN from BEmpty set (0.013 sec) BB BEmployee)corderyby4rand()elimitf1;m Employee where SSN IN (select SupervisorSSN from select SupervisorSSN from Employee; +---------------+ | SupervisorSSN | +---------------+ | 104-32-3426 | | 111-45-2255 | | 113-64-7826 | | 133-67-7775 | | 137-87-4928 | | 138-18-7914 | | 140-25-1949 | | 140-38-1442 | | 141-11-6100 | | 142-37-2034 | | 151-21-5386 | | 152-34-5278 | | 160-02-1988 | | 161-34-3372 | | 167-27-4761 | | 167-34-9728 | | 172-09-5735 | | 187-30-9096 | | 199-78-3996 | | 205-81-9032 | | 231-18-6332 | | 249-29-3206 | | 251-54-7935 | | 257-13-3187 | | 260-53-9920 | | 265-64-9915 | | 269-10-4989 | | 274-15-6294 | | 280-01-2353 | | 291-38-7811 | | 293-97-5018 | | 311-64-9456 | | 322-73-6741 | | 328-48-4448 | | 349-14-1435 | | 349-15-4190 | | 374-36-0897 | | 375-65-5664 | | 384-08-1551 | | 384-60-5206 | | 387-52-8103 | | 390-11-4874 | | 408-65-8026 | | 412-70-8841 | | 413-39-0863 | | 461-47-9056 | | 461-62-7430 | | 472-81-9344 | | 482-80-6452 | | 501-31-5094 | | 555-36-9606 | | 556-22-2198 | | 556-94-7372 | | 557-14-8462 | | 558-69-9395 | | 590-47-1306 | | 616-06-1786 | | 628-77-9563 | | 641-81-3222 | | 650-05-1171 | | 651-22-3782 | | 658-05-4163 | | 711-47-5728 | | 717-17-8602 | | 717-69-4965 | | 726-81-4206 | | 730-43-0531 | | 731-06-2333 | | 738-51-8411 | | 744-95-2396 | | 751-62-8627 | | 755-17-4433 | | 757-98-9036 | | 768-75-2105 | | 771-03-0333 | | 782-72-3994 | | 784-07-2436 | | 784-79-6956 | | 789-96-1423 | | 792-36-3050 | | 793-91-4225 | | 797-90-0158 | | 798-38-4457 | | 800-16-1267 | | 801-72-0598 | | 802-91-0489 | | 811-81-3656 | | 817-64-5529 | | 827-56-3174 | | 849-63-2877 | | 850-66-9042 | | 851-47-2030 | | 854-35-5680 | | 856-12-7860 | | 864-54-8908 | | 869-58-2221 | | 876-77-3630 | | 877-83-0052 | +---------------+ B98 rows in set (0.000 sec) BB sdistinct[companyf24]> select SupervisorSSN from Employee; +---------------+ | SupervisorSSN | +---------------+ | 104-32-3426 | | 111-45-2255 | | 113-64-7826 | | 133-67-7775 | | 137-87-4928 | | 138-18-7914 | | 140-25-1949 | | 140-38-1442 | | 141-11-6100 | | 142-37-2034 | | 151-21-5386 | | 152-34-5278 | | 160-02-1988 | | 161-34-3372 | | 167-27-4761 | | 167-34-9728 | | 172-09-5735 | | 187-30-9096 | | 199-78-3996 | | 205-81-9032 | | 231-18-6332 | | 249-29-3206 | | 251-54-7935 | | 257-13-3187 | | 260-53-9920 | | 265-64-9915 | | 269-10-4989 | | 274-15-6294 | | 280-01-2353 | | 291-38-7811 | | 293-97-5018 | | 311-64-9456 | | 322-73-6741 | | 328-48-4448 | | 349-14-1435 | | 349-15-4190 | | 374-36-0897 | | 375-65-5664 | | 384-08-1551 | | 384-60-5206 | | 387-52-8103 | | 390-11-4874 | | 408-65-8026 | | 412-70-8841 | | 413-39-0863 | | 461-47-9056 | | 461-62-7430 | | 472-81-9344 | | 482-80-6452 | | 501-31-5094 | | 555-36-9606 | | 556-22-2198 | | 556-94-7372 | | 557-14-8462 | | 558-69-9395 | | 590-47-1306 | | 616-06-1786 | | 628-77-9563 | | 641-81-3222 | | 650-05-1171 | | 651-22-3782 | | 658-05-4163 | | 711-47-5728 | | 717-17-8602 | | 717-69-4965 | | 726-81-4206 | | 730-43-0531 | | 731-06-2333 | | 738-51-8411 | | 744-95-2396 | | 751-62-8627 | | 755-17-4433 | | 757-98-9036 | | 768-75-2105 | | 771-03-0333 | | 782-72-3994 | | 784-07-2436 | | 784-79-6956 | | 789-96-1423 | | 792-36-3050 | | 793-91-4225 | | 797-90-0158 | | 798-38-4457 | | 800-16-1267 | | 801-72-0598 | | 802-91-0489 | | 811-81-3656 | | 817-64-5529 | | 827-56-3174 | | 849-63-2877 | | 850-66-9042 | | 851-47-2030 | | 854-35-5680 | | 856-12-7860 | | 864-54-8908 | | 869-58-2221 | | 876-77-3630 | | 877-83-0052 | +---------------+ B98 rows in set (0.001 sec) BB BorderDby[rand()ylimit110;ate temporaryStableisupervisors aspselect SSN from Employee BQuery OK, 10 rows affected (0.001 sec) BBRecords: 10 Duplicates: 0 Warnings: 0 BB BMariaDB [companyf24]> update Employee set SupervisorSSN = (select SSN from supersvis rssorder by rand() limit 1); ERROR 4025 (23000): CONSTRAINT `Employee.SupervisorSSN` failed for `companyf24`.`Employee` BBMariaDB [companyf24]> select * from supervisors; +-------------+ | SSN | +-------------+ | 504-74-1709 | | 198-51-1274 | | 837-38-2747 | | 511-73-5142 | | 592-42-2417 | | 160-21-7388 | | 498-11-3068 | | 305-95-2520 | | 700-84-6055 | | 102-09-0721 | +-------------+ B10 rows in set (0.000 sec) BB );ariaDB [companyf24]> select * from Employee where SSN in (select * from supervisors +-------------+---------+---------+-------+------------+-------------+-------------------------+--------+---------------+---------------+--------------------------------------------------------------+ | SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN | PasswordPlain | PasswordHashed | +-------------+---------+---------+-------+------------+-------------+-------------------------+--------+---------------+---------------+--------------------------------------------------------------+ | 504-74-1709 | 5 | Nickola | R | Andric | 1984-07-10 | 94786 Village Way | 69938 | 160-02-1988 | Mun73tadm | $2y$10$CgSGlECs3kEjDaiOeqHPiOIy3hNd0iycs1hP0HOtJy/4yYn9Zg4V2 | | 198-51-1274 | 6 | Agnes | M | Pagram | 1958-07-01 | 27 Goodland Lane | 38433 | 556-94-7372 | bros~3Wow | $2y$10$Ue6XwY/mfTk3vJlwhK/SVO/mrzqx.iwc0AhQGAqmhIB6NRSZKH08e | | 837-38-2747 | 10 | Averyl | J | Goman | 1984-12-16 | 505 Northfield Hill | 128429 | 349-15-4190 | Kadl93vas | $2y$10$wC/H/2Gxu6S7cYh0WfsL8Oezpj93GQAXdcXOSaMp8T.y/3ddkCUv6 | | 511-73-5142 | 1 | Janka | R | Hitchens | 1993-01-07 | 223 Macpherson Place | 212165 | 557-14-8462 | Plav7~hyem | $2y$10$K0hC4enute6Bu5PkQCd1Yu39DDcYc8UnqPgKWpiKluqnI/UmcOoEm | | 592-42-2417 | 9 | Gibby | S | Beldam | 1990-08-30 | 6 Veith Hill | 34221 | 265-64-9915 | comt9Wpuh | $2y$10$nFP9ghbsbD.WWBYhnZgbWuK/CGakEN/YHhUNZA8besurPti9O06Ky | | 160-21-7388 | 8 | Mercy | B | Bryant | 1969-09-05 | 3 Shoshone Hill | 165390 | 231-18-6332 | lem6Gaj | $2y$10$cZWn5kn5U.0qk42CsbkvjeR6sm4DJzO6T76k/ri/qINWQjK4WY0s2 | | 498-11-3068 | 5 | Lonny | K | Ughelli | 1952-07-19 | 041 High Crossing Drive | 248734 | 322-73-6741 | xew41Vuw | $2y$10$rSAcqn6QUXmjWRYhpy0.we.FRsqmchcwbo0LNt4bdZFQNsCaPRN8O | | 305-95-2520 | 4 | Lucita | M | Vasiljevic | 1979-06-28 | 94 Arrowood Way | 75388 | 133-67-7775 | Ngin>8Nit | $2y$10$s6eH3FR9pmgjiXLYN6trluCwKyKa5nbLeZ7iVXBpIuiNeHw.z4P3O | | 700-84-6055 | 4 | Genna | H | Eunson | 1993-04-05 | 05919 Golf View Terrace | 188564 | 113-64-7826 | Pmops%8Quf | $2y$10$zG1zBsrNHZ0yerJpg.0elezAtrPl7ma9c7kuuiZ.v667kEoadQP5i | | 102-09-0721 | 10 | Hershel | P | Gellier | 1963-08-22 | 80 Homewood Street | 183801 | 387-52-8103 | Vet53nifx | $2y$10$nd1NyBDyJVKGJGkCj1eeCOeNp6BDabIFjlkHmuW/i4Zcik/EJ2miK | +-------------+---------+---------+-------+------------+-------------+-------------------------+--------+---------------+---------------+--------------------------------------------------------------+ B10 rows in set (0.001 sec) BB BMariaDB [companyf24]> updaterEmployee_setcSupervisorSSN = null; BQuery OK, 98 rows affected (0.007 sec) BBRows matched: 98 Changed: 98 Warnings: 0 BB );supervisors;Employee whereeSSNpiny(selectS*pfromssupervisors); rsdordermbyorand()tlimitr1);orSSN = (select SSN from supervisor ERROR 4025 (23000): CONSTRAINT `Employee.SupervisorSSN` failed for `companyf24`.`Employee` BBMariaDB [companyf24]> show createttable Employee; +----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Employee | CREATE TABLE `Employee` ( `SSN` varchar(12) NOT NULL, `Dnumber` int(11) NOT NULL, `Fname` varchar(50) DEFAULT NULL, `Minit` char(1) DEFAULT NULL, `Lname` varchar(50) NOT NULL CHECK (`Lname` <> ''), `DateOfBirth` date DEFAULT NULL, `Address` varchar(255) DEFAULT NULL, `Salary` int(10) unsigned DEFAULT NULL CHECK (`Salary` > 20000), `SupervisorSSN` varchar(12) DEFAULT NULL CHECK (`SupervisorSSN` <> `SSN`), `PasswordPlain` varchar(60) DEFAULT NULL, `PasswordHashed` varchar(60) DEFAULT NULL, PRIMARY KEY (`SSN`), KEY `SupervisorSSN` (`SupervisorSSN`), KEY `Dnumber` (`Dnumber`), CONSTRAINT `Employee_ibfk_1` FOREIGN KEY (`SupervisorSSN`) REFERENCES `Employee` (`SSN`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `Employee_ibfk_2` FOREIGN KEY (`Dnumber`) REFERENCES `Department` (`Dnumber`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci `ENCRYPTION_KEY_ID`=100 | +----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ B1 row in set (0.000 sec) BB BMariaDB [companyf24]> updateeEmployee set SupervisorSSN = "nothing"; ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`companyf24`.`Employee`, CONSTRAINT `Employee_ibfk_1` FOREIGN KEY (`SupervisorSSN`) REFERENCES `Employee` (`SSN`) ON DELETE SET NULL ON UPDATE CASCADE) rsdordermbyorand()tlimitr1);orSSNp=o(select SSNefromosupervisorthing"; where Emplyee.SSN != supervisrs.SSN BQuery OK, 98 rows affected (0.013 sec) BBRows matched: 98 Changed: 98 Warnings: 0 BB BMariaDB [companyf24]> select * from Department; +---------+----------------------+-------------+------------------+---------------+ | Dnumber | Dname | ManagerSSN | ManagerStartDate | EmployeeCount | +---------+----------------------+-------------+------------------+---------------+ | 1 | Accounting | 401-65-8167 | 2007-05-30 | 7 | | 2 | Human Resources | 489-29-5492 | 2007-12-20 | 7 | | 3 | Marketing | 553-65-7982 | 2013-05-27 | 15 | | 4 | Business Development | 160-21-7388 | 2006-12-16 | 6 | | 5 | Engineering | 868-66-3401 | 2014-08-18 | 7 | | 6 | Services | 176-57-7749 | 2024-07-01 | 11 | | 7 | Sales | 716-15-9852 | 2003-01-12 | 9 | | 8 | Legal | 709-53-2589 | 2014-12-30 | 8 | | 9 | Business Development | 103-43-6534 | 2024-07-22 | 13 | | 10 | SUPER Sales | 618-35-0602 | 2005-04-09 | 15 | +---------+----------------------+-------------+------------------+---------------+ B10 rows in set (0.000 sec) BB partment);companyf24]> select * from Employee where SSN IN (select ManagerSSN from De +-------------+---------+---------+-------+---------------+-------------+-----------------------+--------+---------------+---------------+--------------------------------------------------------------+ | SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN | PasswordPlain | PasswordHashed | +-------------+---------+---------+-------+---------------+-------------+-----------------------+--------+---------------+---------------+--------------------------------------------------------------+ | 103-43-6534 | 10 | Kippar | N | Ommanney | 1966-04-09 | 32 Lighthouse Bay Way | 228764 | 837-38-2747 | cip6!Djotc | $2y$10$TnGH2moS5tD3yUUdlsBwQuiXBSMd1e8/7gEnuZo8vq83beXRK6uki | | 160-21-7388 | 8 | Mercy | B | Bryant | 1969-09-05 | 3 Shoshone Hill | 165390 | 198-51-1274 | lem6Gaj | $2y$10$cZWn5kn5U.0qk42CsbkvjeR6sm4DJzO6T76k/ri/qINWQjK4WY0s2 | | 176-57-7749 | 3 | Jane | M | O' Hogan | 1960-03-22 | 4158 Schmedeman Hill | 101593 | 700-84-6055 | ziw.4Qluvz | $2y$10$hkd4wbMLSey33AuqKx.vk.pqT8AK8sOVvnvfL/6gRrhwvJ4Q0E5vm | | 401-65-8167 | 9 | Levy | C | Knolles-Green | 1963-04-16 | 61 Mayer Drive | 148960 | 511-73-5142 | jnegd5Jet | $2y$10$phDqMWbwxZQAqF/mQzaKZeEhdZL7u2lt./F7RlbhuZCVri9N4Xl8C | | 489-29-5492 | 2 | Ward | J | Edgson | 1987-12-07 | 4956 School Pass | 205083 | 592-42-2417 | Fov56cikg | $2y$10$O0ZIuWbBJTITk45DcfrAXO2OskJjYO8vyhhUKvMJsEeHM6ZM3HgWm | | 553-65-7982 | 10 | Kliment | G | Adamek | 1971-07-14 | 78927 Oxford Junction | 216573 | 592-42-2417 | Hod-8muv | $2y$10$BD0ZELPszP5wPsmq43uAw.wT2CyqFNVQY.AfVFXRAIamjjnmNctmq | | 618-35-0602 | 10 | Durand | L | Gori | 1986-12-29 | 2274 Vernon Plaza | 33041 | 102-09-0721 | gity!3Mkuf | $2y$10$kTXGXfX8Uavsng2JgQC6t.27367A/qycbJpvH5yL2gxYs3RGgHiC2 | | 709-53-2589 | 3 | Tallie | D | Areles | 1998-01-25 | 3 Marquette Junction | 117645 | 498-11-3068 | Fig_1Hod | $2y$10$BWMua7MkD1BnUgtXwOGC5OhBWPzRKnWOieWHNFtGFMVgR2hl3QFbC | | 716-15-9852 | 8 | Clem | B | Neary | 1957-08-28 | 87194 Lake View Road | 42177 | 837-38-2747 | Ram87zuk | $2y$10$umbY9R/l.29w3xlXPDe58u4DFjsCH38CF2vXbZaki00wrA4bd7e1K | | 868-66-3401 | 7 | Siffre | A | Moffat | 1977-02-09 | 8 Manufacturers Road | 63385 | 102-09-0721 | Gaq15guz | $2y$10$1jbKSuhbTK3ECgko0.QWXuJ5zWafPJY2OnnE0H.4Vfmz8q7YKeeYa | +-------------+---------+---------+-------+---------------+-------------+-----------------------+--------+---------------+---------------+--------------------------------------------------------------+ B10 rows in set (0.001 sec) BB );ariaDB [companyf24]> select * from EmployeeewhereeSSN in (select * from supervisors +-------------+---------+---------+-------+------------+-------------+-------------------------+--------+---------------+---------------+--------------------------------------------------------------+ | SSN | Dnumber | Fname | Minit | Lname | DateOfBirth | Address | Salary | SupervisorSSN | PasswordPlain | PasswordHashed | +-------------+---------+---------+-------+------------+-------------+-------------------------+--------+---------------+---------------+--------------------------------------------------------------+ | 504-74-1709 | 5 | Nickola | R | Andric | 1984-07-10 | 94786 Village Way | 69938 | 498-11-3068 | Mun73tadm | $2y$10$CgSGlECs3kEjDaiOeqHPiOIy3hNd0iycs1hP0HOtJy/4yYn9Zg4V2 | | 198-51-1274 | 6 | Agnes | M | Pagram | 1958-07-01 | 27 Goodland Lane | 38433 | 592-42-2417 | bros~3Wow | $2y$10$Ue6XwY/mfTk3vJlwhK/SVO/mrzqx.iwc0AhQGAqmhIB6NRSZKH08e | | 837-38-2747 | 10 | Averyl | J | Goman | 1984-12-16 | 505 Northfield Hill | 128429 | 498-11-3068 | Kadl93vas | $2y$10$wC/H/2Gxu6S7cYh0WfsL8Oezpj93GQAXdcXOSaMp8T.y/3ddkCUv6 | | 511-73-5142 | 1 | Janka | R | Hitchens | 1993-01-07 | 223 Macpherson Place | 212165 | 305-95-2520 | Plav7~hyem | $2y$10$K0hC4enute6Bu5PkQCd1Yu39DDcYc8UnqPgKWpiKluqnI/UmcOoEm | | 592-42-2417 | 9 | Gibby | S | Beldam | 1990-08-30 | 6 Veith Hill | 34221 | 837-38-2747 | comt9Wpuh | $2y$10$nFP9ghbsbD.WWBYhnZgbWuK/CGakEN/YHhUNZA8besurPti9O06Ky | | 160-21-7388 | 8 | Mercy | B | Bryant | 1969-09-05 | 3 Shoshone Hill | 165390 | 198-51-1274 | lem6Gaj | $2y$10$cZWn5kn5U.0qk42CsbkvjeR6sm4DJzO6T76k/ri/qINWQjK4WY0s2 | | 498-11-3068 | 5 | Lonny | K | Ughelli | 1952-07-19 | 041 High Crossing Drive | 248734 | 102-09-0721 | xew41Vuw | $2y$10$rSAcqn6QUXmjWRYhpy0.we.FRsqmchcwbo0LNt4bdZFQNsCaPRN8O | | 305-95-2520 | 4 | Lucita | M | Vasiljevic | 1979-06-28 | 94 Arrowood Way | 75388 | 102-09-0721 | Ngin>8Nit | $2y$10$s6eH3FR9pmgjiXLYN6trluCwKyKa5nbLeZ7iVXBpIuiNeHw.z4P3O | | 700-84-6055 | 4 | Genna | H | Eunson | 1993-04-05 | 05919 Golf View Terrace | 188564 | 511-73-5142 | Pmops%8Quf | $2y$10$zG1zBsrNHZ0yerJpg.0elezAtrPl7ma9c7kuuiZ.v667kEoadQP5i | | 102-09-0721 | 10 | Hershel | P | Gellier | 1963-08-22 | 80 Homewood Street | 183801 | 837-38-2747 | Vet53nifx | $2y$10$nd1NyBDyJVKGJGkCj1eeCOeNp6BDabIFjlkHmuW/i4Zcik/EJ2miK | +-------------+---------+---------+-------+------------+-------------+-------------------------+--------+---------------+---------------+--------------------------------------------------------------+ B10 rows in set (0.001 sec) BB BMariaDB [companyf24]> [1]+ Stopped mysql companyf24 nick@artemis:~/public_html/3420/companyf24$ ls -l ~/public_html/ total 308 drwxr-xr-x 17 nick nick 4096 Nov 7 11:23 3420 drwx------ 4 nick nick 4096 Feb 1 2023 4420 -rw-r--r-- 1 nick nick 0 May 2 2024 admin.php -rw-r--r-- 1 nick nick 54432 Apr 12 2023 asciinema-player.css -rw-r--r-- 1 nick nick 140087 Apr 12 2023 asciinema-player.min.js -rw-r--r-- 1 nick nick 3146 Mar 13 2023 cast.php -rw-r--r-- 1 nick nick 154 Apr 8 2024 config.php -rw-r--r-- 1 nick nick 152 May 2 2024 curl_api.php drwxr-xr-x 2 nick nick 4096 Feb 14 2023 ehsan_demo -rw-r--r-- 1 nick nick 14064 Feb 9 2023 FormBuilder.php drwx------ 2 nick nick 4096 Nov 4 13:38 hellodb_examples -rw-r--r-- 1 nick nick 14 Apr 8 2024 hello.html -rw-r--r-- 1 nick nick 1141 Nov 6 13:49 hello.php drwx------ 2 nick nick 4096 Feb 16 2023 misc drwx------ 3 nick nick 4096 May 11 2023 old -rw-r--r-- 1 nick nick 12967 Apr 17 2024 PhpFormBuilder.php drwxr-xr-x 3 nick nick 4096 May 23 2023 ptk -rw-r--r-- 1 nick nick 689 Dec 5 2022 tablemaker.php -rw-r--r-- 1 nick nick 1308 Apr 10 2023 template.php -rw-r--r-- 1 nick nick 530 Apr 8 2024 temptest.php -rw-r--r-- 1 nick nick 344 Apr 8 2024 test.php -rw-r--r-- 1 nick nick 1313 Apr 30 2024 thousandiq_categories.html drwx------ 2 nick nick 4096 May 6 2024 tmp drwx------ 2 nick nick 4096 Nov 13 14:16 useraccounts drwxr-xr-x 2 nick nick 4096 Oct 29 17:01 useraccounts_dev nick@artemis:~/public_html/3420/companyf24$ ls -l ~/public_html/3420 total 60 lrwxrwxrwx 1 nick nick 23 Jan 16 2023 asciinema-player.css -> ../asciinema-player.css lrwxrwxrwx 1 nick nick 26 Jan 16 2023 asciinema-player.min.js -> ../asciinema-player.min.js drwxr-xr-x 4 nick nick 4096 Nov 13 14:23 casts drwxr-xr-x 2 nick nick 4096 Sep 17 15:09 casts-s24 drwx------ 2 nick nick 4096 Mar 30 2023 company drwx------ 2 nick nick 4096 Apr 17 2024 companyf23 drwxr-xr-x 3 nick nick 4096 Nov 18 13:27 companyf24 drwxr-xr-x 2 nick nick 4096 Feb 19 2024 company_query drwx------ 2 nick nick 4096 Apr 25 2024 companys24 drwxr-xr-x 2 nick nick 4096 Sep 3 16:13 day1_demo drwx------ 2 nick nick 4096 Oct 19 2022 division drwx------ 6 nick nick 4096 May 6 2024 examples drwx------ 3 nick nick 4096 Oct 19 2023 lab6 drwxr-xr-x 2 nick nick 4096 Nov 7 11:30 lab8_f24 drwx------ 4 nick nick 4096 Jan 25 2024 old drwxr-xr-x 3 nick nick 4096 Oct 10 12:49 sql_lab drwx------ 8 nick nick 4096 Oct 9 2023 students nick@artemis:~/public_html/3420/companyf24$ ls -l ~/public_html/3420/lab8_f24/ total 40 -rw-r--r-- 1 nick nick 2380 Nov 7 13:27 config.php -rw-r--r-- 1 nick nick 439 Nov 7 11:55 delete.php -rw-r--r-- 1 nick nick 56 Nov 7 12:49 index.php -rw-r--r-- 1 nick nick 1236 Nov 7 12:50 insert.php -rw-r--r-- 1 nick nick 364 Nov 7 11:40 main.php -rw-r--r-- 1 nick nick 163 Nov 7 11:23 nav.php -rw-r--r-- 1 nick nick 2283 Nov 7 13:24 select.php -rw-r--r-- 1 nick nick 276 Nov 7 11:23 style.css -rw-r--r-- 1 nick nick 689 Nov 7 11:23 tablemaker.php -rw-r--r-- 1 nick nick 439 Nov 7 12:50 update.php nick@artemis:~/public_html/3420/companyf24$ cp ../lab8_f24/tablemaker.php . nick@artemis:~/public_html/3420/companyf24$ php index.php array(0) { } Company database website

Welcome to Companyf24

The only company that assigns projects to employees
PHP Notice: Undefined index: isSupervisor in /home/fac/nick/public_html/3420/companyf24/index.php on line 26 PHP Notice: Undefined index: ssn in /home/fac/nick/public_html/3420/companyf24/index.php on line 32 
Array
(
)
Enter a name:
nick@artemis:~/public_html/3420/companyf24$ eexit -bash: eexit: command not found nick@artemis:~/public_html/3420/companyf24$ nick@artemis:~/public_html/3420/companyf24$ nick@artemis:~/public_html/3420/companyf24$ nick@artemis:~/public_html/3420/companyf24$ nick@artemis:~/public_html/3420/companyf24$ mysql 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 101118 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 [nick]> show grants -> exit -> ; 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 'exit' at line 2 BBMariaDB [nick]> exit BBye Bnick@artemis:~/public_html/3420/companyf24$ exit logout There are stopped jobs. nick@artemis:~/public_html/3420/companyf24$ exit logout Connection to artemis.cs.csub.edu closed. nick@Vaxis:~$ exit exit