Help me with MySQL

Domains4u · 02-11-2006, 10:22 AM

Hi all

I own www.UKGMC.com which is a radio directory, but its also a working project, im going to be working with it for a good year or so until i develop a unique type of script that can be used like PHPBB (open source).

To jump to the point, ive write some working code in MySQL which is what you see when you click on the site above. With the help of a nampros member ive added a anti-duplication script to it, that stops users from refreshing the page and adding more submitions (basiclly flooding the page with crap), but that dosnt stop them adding junk manually.
????: NamePros.com http://www.namepros.com/programming/166555-help-me-with-mysql.html

So what i want to do now is add an admin page that will look EXACTLY the same except next to every entry there will be a Delete link, that deletes the entry, im maybe thinkking some check boxes to delete multiple entrys. But this will only be available in the admin/index.php part of the site, which ill have password protected.

Has anyone got any tutorials on the internet or any recourses that might help me to add a delete link to my code so that i can delete entrys without having to manually enter code?

Thanks for looking and i hope you can help.

D4U

Amnezia · 02-11-2006, 10:24 AM

mysql is not a programming language you need php to do something like that.

Eric · 02-11-2006, 10:35 AM

Well, on your admin index page just have a loop grab all the urls, like:

PHP Code:

   
$query = mysql_query("SELECT * FROM urls") or die("Error: ".mysql_error());

 
while($row = mysql_fetch_array($query))

{

  echo $row['url'].' <a href="?delete=yes&id='.$row['id'].'">Delete</a><br>';

????: NamePros.com http://www.namepros.com/showthread.php?t=166555
}

 
if($_GET['delete'] == "yes")

{

  $id = intval($_GET['id']);

  $query = mysql_query("DELETE FROM urls WHERE id = $id LIMIT 1") or die("Error, couldn't delete");

}

Err, something close to that

Domains4u · 02-11-2006, 10:38 AM

Originally Posted by Amnezia

mysql is not a programming language you need php to do something like that.

I am using PHP

Quote:

Well, on your admin index page just have a loop grab all the urls, like:

Thats sort of what i was looking for, ill look into it now ive got a base to work off. Couldnt find how to do it in my PHP books.
????: NamePros.com http://www.namepros.com/showthread.php?t=166555

Thanks SV.....saved the day........................again!

painperdu · 02-11-2006, 11:12 AM

Have you considered validating and checking for duplicates before they're entered into the db?

Domains4u · 02-11-2006, 02:07 PM

Pain yer, ive already got that sorted

Im just trying to create an admin page to delete unwanted posts.

02-11-2006, 10:22 AM	THREAD STARTER #1 (permalink)
Domains4u Account Suspended Join Date: Nov 2005 Location: www.TFFH.net Posts: 280	Help me with MySQL Hi all I own www.UKGMC.com which is a radio directory, but its also a working project, im going to be working with it for a good year or so until i develop a unique type of script that can be used like PHPBB (open source). To jump to the point, ive write some working code in MySQL which is what you see when you click on the site above. With the help of a nampros member ive added a anti-duplication script to it, that stops users from refreshing the page and adding more submitions (basiclly flooding the page with crap), but that dosnt stop them adding junk manually. ????: NamePros.com http://www.namepros.com/programming/166555-help-me-with-mysql.html So what i want to do now is add an admin page that will look EXACTLY the same except next to every entry there will be a Delete link, that deletes the entry, im maybe thinkking some check boxes to delete multiple entrys. But this will only be available in the admin/index.php part of the site, which ill have password protected. Has anyone got any tutorials on the internet or any recourses that might help me to add a delete link to my code so that i can delete entrys without having to manually enter code? Thanks for looking and i hope you can help. D4U

02-11-2006, 10:24 AM	#2 (permalink)
Amnezia Professional Monkey Join Date: Jul 2005 Location: Escaped from the zoo Posts: 907	mysql is not a programming language you need php to do something like that. __________________ Webmaster Words

02-11-2006, 10:35 AM	#3 (permalink)
Eric Senior Member Join Date: Mar 2005 Posts: 4,948	Well, on your admin index page just have a loop grab all the urls, like: PHP Code: `$query = mysql_query("SELECT * FROM urls") or die("Error: ".mysql_error()); while($row = mysql_fetch_array($query)) { echo $row['url'].' <a href="?delete=yes&id='.$row['id'].'">Delete</a><br>'; ????: NamePros.com http://www.namepros.com/showthread.php?t=166555 } if($_GET['delete'] == "yes") { $id = intval($_GET['id']); $query = mysql_query("DELETE FROM urls WHERE id = $id LIMIT 1") or die("Error, couldn't delete"); }` Err, something close to that

02-11-2006, 11:12 AM	#5 (permalink)
painperdu NamePros Regular Join Date: Jun 2003 Location: Louisiana, USA Posts: 658	Have you considered validating and checking for duplicates before they're entered into the db? __________________ dotbob.com -Cheap Domain Name Registrations/Unlimited Web Hosting Plan $5.98/month

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOWTO: Install the Apache Web Server, Perl, PHP, and MySQL on Windows	deadserious	Webmaster Tutorials	96	05-27-2007 02:24 PM
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
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 02:17 PM

02-11-2006, 02:07 PM	THREAD STARTER #6 (permalink)
Domains4u Account Suspended Join Date: Nov 2005 Location: www.TFFH.net Posts: 280	Pain yer, ive already got that sorted Im just trying to create an admin page to delete unwanted posts.

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