hmartin2005
Posts: 5
Joined: Mon Dec 24, 2018 2:47 pm
Occupation: Parent

SQL Injection Attack Project

Postby hmartin2005 » Mon Dec 24, 2018 2:50 pm

Hello,

I'm trying complete the Preventing SQL Injection project.

I have figured out how to login without a password and see all users, but I can NOT figure out how to add, remove records into the table. I know it is embedding a subquery into the SQL statement, but I need some help. I know the SQL to INSERT a record, but I can't make this work.

Please help with some ideas.

Thank you.

MadelineB
Moderator
Posts: 634
Joined: Fri Jun 20, 2014 4:42 pm
Occupation: Biostatistician/Data Scientist

Re: SQL Injection Attack Project

Postby MadelineB » Wed Dec 26, 2018 3:53 pm

Hello and welcome to Science Buddies,

Congratulations on being able to access the test website without a password.

The best way to learn how to add, delete records will be to work through the SQL tutorials at the Code Academy and Khan Academy as described in the Background section. Review the other references listed in that section to see how SQL injection works.

https://www.sciencebuddies.org/science- ... background

Let us know if those tutorials and references help! Thank you.

hmartin2005
Posts: 5
Joined: Mon Dec 24, 2018 2:47 pm
Occupation: Parent

Catchy SQL project title idea (due Monday!)

Postby hmartin2005 » Wed Jan 23, 2019 9:13 am

Hi!!

Can someone please help?? It's due Monday!! :!:

i am having trouble coming up with a science fair project title. i finished my project "Preventing SQL injection attacks," but i can't come up with a creative title. it is due on Monday (science fair board and everything to go with it-including my abstract memorized!) so please get back with me quickly!!

Thanks,
Hannah M.
Student

Moderator note: I merged this post with the topic from your previous posts. Please keep your posts in the same thread so the expert who has been helping you can see that you have follow-up questions. Thank you!

MadelineB
Moderator
Posts: 634
Joined: Fri Jun 20, 2014 4:42 pm
Occupation: Biostatistician/Data Scientist

Re: SQL Injection Attack Project

Postby MadelineB » Wed Jan 23, 2019 4:15 pm

Hi Hannah,
Congratulations on completing this project! At the high school science fair level, judges aren't really looking for "catchy" or "creative" titles. They are more interested in a title that describes the goal of your project and what you accomplished.

So a straightforward title would be best - something like: "SQL attacks and how to prevent them."

Hope that helps! Good luck at the fair!

hmartin2005
Posts: 5
Joined: Mon Dec 24, 2018 2:47 pm
Occupation: Parent

Re: SQL Injection Attack Project

Postby hmartin2005 » Thu Jan 24, 2019 8:51 am

MadelineB wrote:Hi Hannah,
Congratulations on completing this project! At the high school science fair level, judges aren't really looking for "catchy" or "creative" titles. They are more interested in a title that describes the goal of your project and what you accomplished.

So a straightforward title would be best - something like: "SQL attacks and how to prevent them."

Hope that helps! Good luck at the fair!



Thank you for responding!! I am actually in 7th grade. i stepped up to this difficult because i love coding and the topic. Part of our grade is creativity, and my classmates are all creating a fun and catchy title for their project.

Any ideas would would help. I know your time is valuable.

Thanks for your help
Hannah M.

AmyCowen
Site Admin
Posts: 207
Joined: Mon Aug 22, 2016 4:39 pm
Occupation: Administrator

Re: SQL Injection Attack Project

Postby AmyCowen » Mon Jan 28, 2019 5:26 pm

Hi Hannah - What ideas have you come up with for your title? Seeing the kinds of titles you are thinking about might help others see if they have any suggestions. I bet you have some really good ideas already. Writing them down can help you see which ones you really like, too.

Amy
Science Buddies

hmartin2005
Posts: 5
Joined: Mon Dec 24, 2018 2:47 pm
Occupation: Parent

Re: SQL Injection Attack Project

Postby hmartin2005 » Tue Jan 29, 2019 6:24 am

AmyCowen wrote:Hi Hannah - What ideas have you come up with for your title? Seeing the kinds of titles you are thinking about might help others see if they have any suggestions. I bet you have some really good ideas already. Writing them down can help you see which ones you really like, too.

Amy
Science Buddies


Thanks for the idea!! Science fair is actually over. it was Monday (yesterday). My official title was "Stopping Attacks Dead in their Tracks" i think the judges liked it because i got 3rd place. thank you so much for responding!!

Much appreciation,
Hannah M.
7th grade

MadelineB
Moderator
Posts: 634
Joined: Fri Jun 20, 2014 4:42 pm
Occupation: Biostatistician/Data Scientist

Re: SQL Injection Attack Project

Postby MadelineB » Tue Jan 29, 2019 3:50 pm

Hi Hannah and congratulations on getting 3rd place!

Like most of the experts here at Science Buddies, I've judged a lot of science fair projects. I am sure that your 3rd place is based on the content and display and your discussion with the judges, not the catchy title!

Congratulations on your winning project!


Return to “Grades 9-12: Math and Computer Science”