SJSU Secure File Upload and Storage Web Application

You need to implement a web application that is split into three parts, namely,

Webpage

,

PHP

, and

MySQL

. Each of them will be used concurrently to solve the simple problem described below. Remember to implement the logic in the most secure way of your knowledge.

Webpage

• The user must be able to upload a text file (no other format)
• Users should be able to input a string via a text box. The string can represent various things, but to simplify understanding, it can be the title of the uploaded document. For instance, if a user uploads a research paper, the text entered in this box will serve as the title of the paper, typed by the user for reference.
• The webpage shows the content of the database, that is, the content of each file with the specified nameThis should happen every time the page loads, even if the user has accessed the page for the first time

PHP

• Implement a PHP function that reads in inputs a string from the user and stores it in a table (in a field called “Title”)
• The function should be able to read the content of the file and store it in a table too (in a field called “Content”)

MySQL

• You need to create a database, including at least one table for storing the information entered on the webpage. While you don’t need to submit SQL code like “SHOW DATABASE” or “CREATE TABLE,” it’s essential to prepare the necessary queries, such as INSERT and SELECT, within your PHP application. Your web application depends on these queries to function properly.

You are required to submit your web application in the form of two or more .php files, and no other formats are accepted. In addition, you must include two screenshots of your webpage to demonstrate the file uploading process and display the database content (the screenshots must show entire webpage):

• The first screenshot should depict two records, with the user’s input visible in a text box and an uploaded file. Please note that at this stage, the information is displayed as a placeholder in the text box, and the upload button has not been clicked yet.
• The second screenshot should showcase the placeholder inputs being stored in the database and printed on the website. This occurs after the user has clicked the upload button and the data has been successfully processed.