Need Urgent MySQL Help

Domains4u · 02-10-2006, 03:36 AM

Hi all. Im in some real trouble here.

LINK: http://www.ukgmc.com/radio/add.php

Ive created a database that stores Radio URLs, and displays them in a .php file........all fine and good.

I then placed a form at the top of the page for users to enter there own submissions........all fine a good.

When a user submits a url its adds to the database and Displays 'ADDED TO DATABASE', but if the user then presses refresh it will add it again. I somehow need to stop duplicate entries into the database, becuase this could become a vunrability for hackers or annoying script kiddies who want to flood the databse.

Whats the best way to stop this?
????: NamePros.com http://www.namepros.com/programming/166172-need-urgent-mysql-help.html

Regards.

weblord · 02-10-2006, 03:39 AM

http://www.captcha.net/
download here:
http://www.puremango.co.uk/cm_php_ca...script_113.php

php implementations found here:
http://en.wikipedia.org/wiki/Captcha

Peter · 02-10-2006, 06:31 AM

Alternatively you could do a select query in the script to check if it already exists, if it does then it will not be added. This of course will also stop someone maliciously adding the same url constantly.

A possible other alternative is to make the field in the database that holds the URL inique.

Domains4u · 02-10-2006, 08:54 AM

Fixed now. Thanks to SecondVersion

02-10-2006, 03:36 AM	THREAD STARTER #1 (permalink)
Domains4u Account Suspended Join Date: Nov 2005 Location: www.TFFH.net Posts: 280	Need Urgent MySQL Help Hi all. Im in some real trouble here. LINK: http://www.ukgmc.com/radio/add.php Ive created a database that stores Radio URLs, and displays them in a .php file........all fine and good. I then placed a form at the top of the page for users to enter there own submissions........all fine a good. When a user submits a url its adds to the database and Displays 'ADDED TO DATABASE', but if the user then presses refresh it will add it again. I somehow need to stop duplicate entries into the database, becuase this could become a vunrability for hackers or annoying script kiddies who want to flood the databse. Whats the best way to stop this? ????: NamePros.com http://www.namepros.com/programming/166172-need-urgent-mysql-help.html Regards. Last edited by Domains4u; 02-10-2006 at 03:37 AM. Reason: added URL

02-10-2006, 03:39 AM	#2 (permalink)
weblord NamePros Legend Join Date: Dec 2005 Location: Philippines - www.Nabaza.com Posts: 19,785	http://www.captcha.net/ download here: http://www.puremango.co.uk/cm_php_ca...script_113.php php implementations found here: http://en.wikipedia.org/wiki/Captcha __________________ Nabaza.com - Amaia Last edited by weblord; 02-10-2006 at 03:43 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Great Scripts for Sale With Resale Rights!	Zeeble	Scripts For Sale	20	01-04-2006 02:39 AM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 10:46 PM
HOW TO: Use shell to control MySQL.	abdulmueid	Webmaster Tutorials	16	08-27-2005 09:17 AM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 02:17 PM

02-10-2006, 06:31 AM	#3 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,069	Alternatively you could do a select query in the script to check if it already exists, if it does then it will not be added. This of course will also stop someone maliciously adding the same url constantly. A possible other alternative is to make the field in the database that holds the URL inique.

02-10-2006, 08:54 AM	THREAD STARTER #4 (permalink)
Domains4u Account Suspended Join Date: Nov 2005 Location: www.TFFH.net Posts: 280	Fixed now. Thanks to SecondVersion

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)