Help me with MySQL

Domains4u · 02-11-2006, 09: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.

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, 09:24 AM

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

**Eric** · 02-11-2006, 09: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>';

}

 
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, 09:38 AM

Quote:

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.

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

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

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

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

Pain yer, ive already got that sorted

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

02-11-2006, 09:22 AM	#1 (permalink)
Domains4u Account Suspended Join Date: Nov 2005 Location: www.TFFH.net Posts: 280 58.80 NP$ (Donate)	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. 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, 09:24 AM	#2 (permalink)
Amnezia Professional Monkey Join Date: Jul 2005 Location: Escaped from the zoo Posts: 908 13.25 NP$ (Donate)	mysql is not a programming language you need php to do something like that. __________________ [http://www.webmasterwords.com/python-split-and-join-examples]Python Tutorials[/url]

02-11-2006, 09:35 AM	#3 (permalink)
Eric NPQ's PA, Slave, and On Call Coder Technical Services Join Date: Mar 2005 Posts: 4,545 0.71 NP$ (Donate)	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>'; } 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, 10:12 AM	#5 (permalink)
painperdu NamePros Regular Join Date: Jun 2003 Location: Louisiana, USA Posts: 665 33.75 NP$ (Donate)	Have you considered validating and checking for duplicates before they're entered into the db? __________________ ****dotbob.com** Cheap Domain Name Registrations** -Dotbob.com

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 01:24 PM
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
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM

02-11-2006, 01:07 PM	#6 (permalink)
Domains4u Account Suspended Join Date: Nov 2005 Location: www.TFFH.net Posts: 280 58.80 NP$ (Donate)	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)

Technical Services