Assignment 4
Part I - Running SQLite3 Command-Line Application
For part one of this assignment, we used SQLite3 along with Putty to create a database of languages in our assignments directory.
English was used as the first language and Spanish was used as the second language. we used the Unix script command to capture the work
and all we typed into the command line while running the SQLite3. The database was saved into a file with a '.bin' for security purposes.
Below are three scripts of the tables being created, inserting data, and selecting the data.
- Script 1 - Table Creation: View
- Script 2 - Insertion: View
- Script 3 - Selection: View
Part II - PHP and SQLite3 (NOT PDO)
For part two of the assignment, we had to incorporate our knowledge of SQLite3 and our knowledge of PHP to create a database.
Instead of typing the databases into the command line by hand, we typed them into a PHP file and ran the commands from a PHP file
to create tables, insert data, and create relations. We the checked each table and insert with SQLite3 manually by using the "select" command.
Below are scripts of the PHP files running and then a check of each one running.
Part III - PHP and SQLite3 (PDO)
For part two of the assignment, we had to incorporate our knowledge of SQLite3 and our knowledge of PHP to create a database.
Instead of typing the databases into the command line by hand, we typed them into a PHP file and ran the commands from a PHP file
to create tables, insert data, and create relations. We the checked each table and insert with SQLite3 manually by using the "select" command.
Below are scripts of the PHP files running and then a check of each one running.
- PHP and SQLite - Table Creation: View
- PHP and SQLite - Insertion1: View
- PHP and SQLite - Insertion2: View
- PHP and SQLite - Terminal Script: View