Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions