Your browser does not seem to support CSS. If images appear below, please disregard them.
It appears that you're running an Ad-Blocker. This site is monetized by Advertising and by User Donations; we ask that if you find this site helpful that you whitelist us in your Ad-Blocker, or make a Donation to help aid in operating costs.
Previous Thread
Next Thread
Print Thread
Rate This Thread
#19317 - 07/06/03 08:00 PM help with a php/mysql news script  
Joined: Jun 2002
Posts: 62
UndeadBob Offline
Junior Member
UndeadBob  Offline
Junior Member

Joined: Jun 2002
Posts: 62
UK
i'm writing my own news script using php and mysql. but i have hit a problem. when i try to delete one entry they all get deleted. i know where the problem is but i don't know how to fix it. what happens is when you want to delete a entry you tick a checkbox next to the entry you want to get rid of and it should be deleted. but the php/mysql is setup so that the checkbox on the form are named after the mysql database id. that id number isn't sent to mysql when the delete request is made so all the entrys are deleted.
the relevant code is attached. any help is appreciated.

this is the delete form
Code:
 
<form action="delete_notice.php" method="post">
$query = "SELECT title, id FROM notices";
$result = mysql_query($query);
$numrows = mysql_num_rows($result);
while($row = mysql_fetch_array($result)){

?> <input name="<? echo "$row[id]"; ?>" type=checkbox>  <? echo "$row[title]";
print '
';
}
?>


<input type="submit" value="Delete selected">
</form>
 
and this is the query that deletes the entries
Code:
 
$id = $_POST['id'];

$link = mysql_connect("localhost", $dbuser, $dbpass) or die ("Database Error: Couldn't Connect!");

mysql_select_db($dbname, $link) or die ("Couldn't open $dbname!");

$query = "DELETE FROM notices WHERE 'id' = '$id' ";

mysql_query($query, $link) or die ("Couldn't delete data!");


mysql_close($link);

include "header.php";
print '<center>';
print '
';
print 'Notice(s) succesfully deleted';
print '
';
print '<a href="noticeadmin.php">Return to Notices Administration</a>';
print '<center>';
 
the table that is being accesed is notice and the fields are id (auto-incrementing id no.), title and notice.
i missed out the mysql connect stuff becuase that is ok.

many thanx


"Mrs. Jones, I'm sorry to inform you, but we've run the tests, and it appears that you have XP. Now don't cry - it's bad, but it's not a death sentence. Modern science has advanced in recent years, and it's now possible to live a reasonably happy life with XP. And there's a survivor's group that you'll want to meet as well."
Sponsored Links
#19318 - 07/06/03 08:36 PM Re: help with a php/mysql news script  
Joined: Mar 2002
Posts: 1,136
pergesu Offline
UGN Elite Poster
pergesu  Offline
UGN Elite Poster

Joined: Mar 2002
Posts: 1,136
Pimpin the Colorizzle
You also need a value in your checkbox tags, I think.

#19319 - 07/07/03 11:13 AM Re: help with a php/mysql news script  
Joined: Jun 2002
Posts: 62
UndeadBob Offline
Junior Member
UndeadBob  Offline
Junior Member

Joined: Jun 2002
Posts: 62
UK
i tried giving them a value but it made no difference. any more help will be greatly appreciated


"Mrs. Jones, I'm sorry to inform you, but we've run the tests, and it appears that you have XP. Now don't cry - it's bad, but it's not a death sentence. Modern science has advanced in recent years, and it's now possible to live a reasonably happy life with XP. And there's a survivor's group that you'll want to meet as well."
#19320 - 07/07/03 06:35 PM Re: help with a php/mysql news script  
Joined: Mar 2002
Posts: 197
Predator Offline
Member
Predator  Offline
Member

Joined: Mar 2002
Posts: 197
Belgium
You need to check if the selectboxes are checked or not. The name of the checkbox will be passed on as a post variable.


Never argue with fools... They will only drag you down to their level, and beat you with experience...
#19321 - 07/07/03 11:59 PM Re: help with a php/mysql news script  
Joined: Mar 2002
Posts: 256
ninjaneo Offline
UGN Security Staff
ninjaneo  Offline
UGN Security Staff

Joined: Mar 2002
Posts: 256
CA, USA
?> " type=checkbox>

$query = "DELETE FROM notices WHERE 'id' = '$id' ";


those are 2 lines w. errors as I scanned through...
Code:
?> <input name="<? echo $row["id"]; ?>" type=checkbox>  <? echo $row["title"];
and the more important one

Code:
$query = "DELETE FROM notices WHERE `id`=$id";

Sponsored Links
#19322 - 07/08/03 02:02 AM Re: help with a php/mysql news script  
Joined: Mar 2002
Posts: 1,136
pergesu Offline
UGN Elite Poster
pergesu  Offline
UGN Elite Poster

Joined: Mar 2002
Posts: 1,136
Pimpin the Colorizzle
actually, I think it's

Code:
$query = "DELETE FROM notices WHERE id='$id';
no quotes around id (the column)

#19323 - 07/10/03 06:08 AM Re: help with a php/mysql news script  
Joined: Mar 2002
Posts: 256
ninjaneo Offline
UGN Security Staff
ninjaneo  Offline
UGN Security Staff

Joined: Mar 2002
Posts: 256
CA, USA
no bish, there feet! not single quotes! thats uber important! heh

#19324 - 07/12/03 02:10 PM Re: help with a php/mysql news script  
Joined: Dec 2002
Posts: 3,255
§intå× Offline
§intå×  Offline



Joined: Dec 2002
Posts: 3,255
Likes: 1
Maryland
This should put you closer.

Code:
<form action="delete_notice.php" method="post">
	<?
	$query = mysql_query("SELECT title, id FROM notices");
	$numrows = mysql_num_rows($query);
	while($query2 = mysql_fetch_array($query))
	{
		?> 
		<input name="data" id="data" value="<? echo ".$query2[id]."; ?>" type=checkbox>  
		<? 
		echo ".$query2[title].";
		print '
';
	}
?>


<input type="submit" value="Delete selected">
</form> 
Code:
<?
$id = $_POST['id'];
$link = mysql_connect("localhost", $dbuser, $dbpass) or die ("Database Error: Couldn't Connect!");
mysql_select_db($dbname, $link) or die ("Couldn't open $dbname!");
$query = "DELETE FROM notices WHERE 'id' = '$data'";
mysql_query($query, $link) or die ("Couldn't delete data!");
mysql_close($link);include "header.php";print '<center>';
print '
';
print 'Notice(s) succesfully deleted';
print '
';
print '<a href="noticeadmin.php">Return to Notices Administration</a>';
print '<center>';
?>
Code:
$query = "DELETE FROM notices WHERE 'id' = '$data'";
This is the only line I changed. You need to put that in a while loop and process the array that will now be created.

data[0]
data[1]
data[2]
etc etc etc...

might even want to try this
Code:
$dbuser = "username";
$dbpass = "password";
$link = mysql_connect("localhost", $dbuser, $dbpass) or die ("Database Error: Couldn't Connect!");
mysql_select_db($dbname, $link) or die ("Couldn't open $dbname!");



$query = mysql_query("DELETE FROM notices WHERE 'id' = '$data' LIMIT 1");
It can work. I did it for my messenger. If you realy want me to show you let me know. Check my forms. Get an account at http://www.tradebikes.com and message me. View the source and look at my checkbox HTML and compare to yours. I think I needed a for loop.


My New site OpenEyes
#19325 - 07/14/03 05:01 PM Re: help with a php/mysql news script  
Joined: Jun 2002
Posts: 62
UndeadBob Offline
Junior Member
UndeadBob  Offline
Junior Member

Joined: Jun 2002
Posts: 62
UK
i am still having problems, the above suggestions didn't really help. more help will be greatly accepted.


"Mrs. Jones, I'm sorry to inform you, but we've run the tests, and it appears that you have XP. Now don't cry - it's bad, but it's not a death sentence. Modern science has advanced in recent years, and it's now possible to live a reasonably happy life with XP. And there's a survivor's group that you'll want to meet as well."
#19326 - 07/17/03 09:27 PM Re: help with a php/mysql news script  
Joined: Mar 2002
Posts: 256
ninjaneo Offline
UGN Security Staff
ninjaneo  Offline
UGN Security Staff

Joined: Mar 2002
Posts: 256
CA, USA
erm this might work Its actually supposed to be a combonation.
Code:
$query = "DELETE FROM notices WHERE `id`='$id'";
hey, do this also.
Code:
mysql_query($query) or die(mysql_error());
just to give us an Idea...

Sponsored Links
#19327 - 10/17/03 02:21 AM Re: help with a php/mysql news script  
Joined: Oct 2003
Posts: 1
Paulo Breda Offline
Junior Member
Paulo Breda  Offline
Junior Member

Joined: Oct 2003
Posts: 1
Please help me to do a chat or post in javascript

#19328 - 10/24/03 12:20 PM Re: help with a php/mysql news script  
Joined: Dec 2002
Posts: 3,255
§intå× Offline
§intå×  Offline



Joined: Dec 2002
Posts: 3,255
Likes: 1
Maryland
Paulo Breda

A chat would probably be best writen in Java. You can learn how to make an applet. look for pergesu on here he knows Java.

http://java.sun.com

For a post... I assume you mean a bulleting board. You might want to try

Perl
PHP/MySQL
Python
Delphi
JSP
ASP

any of those will allow you to code a web board.

If you start today you might know enough in about 1 year to code a full bulletin board like this one.


My New site OpenEyes

Member Spotlight
Gremelin
Gremelin
Portland, OR; USA
Posts: 7,195
Joined: February 2002
Show All Member Profiles 
Forum Statistics
Forums45
Topics46,786
Posts81,956
Average Daily Posts11
Members2,159
Most Online1,567
Apr 25th, 2010
Latest Postings
Top Posters(All Time)
UGN Security 39,950
Gremelin 7,195
§intå× 3,255
SilentRage 1,273
Ice 1,146
pergesu 1,136
Infinite 1,041
jonconley 955
Girlie 908
unreal 860
Top Liked Users (All Time)
§intå× Likes: 1
Cold Sunn Likes: 1
Crime Likes: 1
Cyrez Likes: 1
Ghost Likes: 1
Gremelin Likes: 4
Ice Likes: 1
unreal Likes: 1
Top Liked Users (30 Days)
Powered by UBB.threads™ PHP Forum Software 7.6.0
(Snapshot build 20160902)