Need Urgent MySQL Help

Domains4u · 02-10-2006, 02: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?

Regards.

weblord · 02-10-2006, 02: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, 05: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, 07:54 AM

Fixed now. Thanks to SecondVersion

02-10-2006, 02:36 AM	#1 (permalink)
Domains4u Account Suspended Join Date: Nov 2005 Location: www.TFFH.net Posts: 280 58.80 NP$ (Donate)	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? Regards. Last edited by Domains4u; 02-10-2006 at 02:37 AM. Reason: added URL

02-10-2006, 02:39 AM	#2 (permalink)
weblord NamePros Legend Join Date: Dec 2005 Location: Philippines - www.Nabaza.com Posts: 19,840 21,700.43 NP$ (Donate)	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 Last edited by weblord; 02-10-2006 at 02: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 01:39 AM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
HOW TO: Use shell to control MySQL.	abdulmueid	Webmaster Tutorials	16	08-27-2005 08:17 AM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM

02-10-2006, 05:31 AM	#3 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	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, 07:54 AM	#4 (permalink)
Domains4u Account Suspended Join Date: Nov 2005 Location: www.TFFH.net Posts: 280 58.80 NP$ (Donate)	Fixed now. Thanks to SecondVersion

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