EXER In this project, you will create Python application program…

Question Answered step-by-step EXER In this project, you will create Python application program… EXERIn this project, you will create  Python application program using Python’s MySQL Connector that creates  MySQL database about online food menu which contains food menus and their descriptions (e.g., short description about the menu, restaurant which offers the menu, price, etc.). You will then retrieve menus and descriptions from the database table, update them in the database table, and display a selected menu(s). The followings should be implemented using Python program(s):1. Design your database using 4 tables.2. Create MySQL database using Python.3. Get Data from a user (as text inputs) for MySQL DB insertion.4. Insert Data into the MySQL Database Table.5. Retrieve data from the MySQL Table using Select (provide several meaningful queries) and display the output on the screen.6. Change a table entry using update.7. Create a fully functioning database application.You can give the tables any name but must be at least 4 tables You will be building a simple reverse sha lookup website that uses a database to store and retrieve pairs of passwords and sha hash values.  The website should accept as input a SHA hash value and return the password that corresponds to the SHA hash value. This will be done by precomputing the SHA hash values of over 1000 common passwords (already done for you in the given TXT files). You can read more about SHA here: https://en.wikipedia.org/wiki/Secure_Hash_Algorithms and https://en.wikipedia.org/wiki/SHA-1. Calculating the SHA hash value is easy.  Calculating the input that created a given SHA hash value is non-trivial.The assignment is broken into tasks for you below, but here is the outline of the tasks / programs you must complete:A php script that accomplishes 2 tasks. You will submit queries from your PHP script to accomplish these 2 tasks.Create database with tables appropriate for storing your password / SHA pairsPopulate those tables with the data provided in the three input text files: sha1_list.txt, sha224_list.txt, sha256_list.txt.You may use any arrangement of tables that you want.An HTML page that accepts an input text box for the SHA hash value a user wants to look up.A PHP script that submits queries to the database created in step 1 to search for the SHA hash values submitted by the user.  This PHP script also displays a form to allow the user to search again for a new SHA hash value. Create PHP script called createDB.php that will create  new database with tables appropriate for storing the passwords and sha hash values.  Your PHP script should submit queries to the database to first delete the database (this allows a fresh start each time you run your code), and then create the database and tables.  Name your database “passwords”.   Choose appropriate tables and appropriate columns to store your data.You must read in the data in the given text files: sha1_list.txt, sha224_list.txt, sha256_list.txt. You may not copy and paste the text files’ content into your code – you must read the data in programmatically to generate queries to insert the data into your database created in step 1.Use DBeaver to verify that your database has been created, and that the tables have been populated with the data from the text files. For this task you will create two files, sha_lookup.html, and sha_lookup.php.The first file, sha_lookup.html, should present a form to the user with a single text box that will accept a SHA hash value.  The submit button should activate the sha_lookup.php file and send the SHA hash value to this file.The sha_lookup.php file should validate that the SHA hash value is a valid length.  (Look the text files for the lengths … all SHA1 hash values are the same length. Same goes for SHA224 and SHA256). If the length is invalid, print an error message.If the length is valid, submit a query to your database constructed in Task1. You must use prepared statements to protect against SQL injection. The query should return the password that generated the submitted SHA hash value.  Display an appropriate message to indicate if the hash value was found in the database or not.  (A successful search should include the password that matches the SHA hash value).In all cases (error or not, found or not), your PHP script must also generate a new form that accepts another entry from the user.  Make the “action” of the form the PHP file.  This will create form that triggers the same PHP file so that another search can be performed. Engineering & Technology Computer Science Share QuestionEmailCopy link Comments (0)