Question: Using your Student DB table ( from mySQL ) . I would like you to create two pieces of code one where SQL Injections are

Using your Student DB table (from mySQL). I would like you to create two pieces of code one where SQL Injections are allowed one which contains the code that prevents SQL Injections You can use the form from the "put into practice" for Week Eleven. Instead of entering a student's ID for this assignment you will have the user enter in the name of the student. Once entered the record for that student should be printed out in a table. Please view the following screenshots for an accurate depiction of the assignment and how the two codes should result in. FIRST CODE SECOND CODE Student Name LI Submit<> Student Name Move SutiyetSELECT * FROM Student WHERE Name="Maeve Student Name Student ID Major Maeve 3456 Biology Student Name Maeve SubmitSELECT * FROM Student WHERE Name="Maeve' Maeve Student Name Maeve' or ' SubmitSELECT * FROM Student WHERE Name="Maeve' or 'T='1' Student Name Student ID Major Chloe 1234 Computer Science Maeve 3456 Biology Raphael 5678 Electrical Engineering Francisco 9012 Architecture Student Name Maeve' or 'Ta' Submit<> Student Name Move SutiyetSELECT * FROM Student WHERE Name="Maeve' Maeve Student Name Maeve' or ' SubmitSELECT * FROM Student WHERE Name="Maevel' or VIV=Wl' Student Name Maeve' or Submit Student Name Student ID Major

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!