[SOLVED]Deleting Database Information

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

User avatar
iknownothing
Forum Contributor
Posts: 337
Joined: Sun Dec 17, 2006 11:53 pm
Location: Sunshine Coast, Australia

Post by iknownothing »

try making the delete button value small letters, and retry, just for good measure...
netpants
Forum Commoner
Posts: 39
Joined: Wed Nov 15, 2006 1:21 pm

Post by netpants »

Well I am getting the echo response of nothing was deleted , but its not deleting anything.
User avatar
iknownothing
Forum Contributor
Posts: 337
Joined: Sun Dec 17, 2006 11:53 pm
Location: Sunshine Coast, Australia

Post by iknownothing »

sorry mate, im an idiot, change this...

Code: Select all

<form type="POST" action="">
to this...

Code: Select all

<form method="POST" action="">
netpants
Forum Commoner
Posts: 39
Joined: Wed Nov 15, 2006 1:21 pm

Post by netpants »

MAN!!!!!!!

Warning: mysql_query(): Access denied for user 'apache'@'localhost' (using password: NO) in /home/freegames/domains/freegamespot.net/public_html/dancefactory/display.php on line 5

Warning: mysql_query(): A link to the server could not be established in /home/freegames/domains/freegamespot.net/public_html/dancefactory/display.php on line 5
User avatar
iknownothing
Forum Contributor
Posts: 337
Joined: Sun Dec 17, 2006 11:53 pm
Location: Sunshine Coast, Australia

Post by iknownothing »

in that case it sounds like something is wrong with the query. Is "Winners" the correct table name? and "id" is a correct field?

Code: Select all

$id = $_POST['id'];

if (isset($_POST['delete'])){
mysql_query("DELETE FROM Winners WHERE id = '$id'");
else {
echo "Nothin was deleted";
}
and also, move all your database login details above the code...
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

netpants wrote:MAN!!!!!!!

Warning: mysql_query(): Access denied for user 'apache'@'localhost' (using password: NO) in /home/freegames/domains/freegamespot.net/public_html/dancefactory/display.php on line 5

Warning: mysql_query(): A link to the server could not be established in /home/freegames/domains/freegamespot.net/public_html/dancefactory/display.php on line 5
This means you did not authenticate, meaning your username and/or password is incorrect.
netpants
Forum Commoner
Posts: 39
Joined: Wed Nov 15, 2006 1:21 pm

Post by netpants »

This is not true, I am using the same username and password the whole time. That has never changed. I use the same info to insert stuff into the database. I just checked the permissions for that user and they do have delete permission.
netpants
Forum Commoner
Posts: 39
Joined: Wed Nov 15, 2006 1:21 pm

Post by netpants »

Moved the

Code: Select all

<font color="#FFFFFF"><? 
$id = $_POST['id']; 

if (isset($_POST['delete'])){ 
mysql_query("DELETE FROM Winners WHERE id = '$id'"); 
}else { 
echo "Nothin was deleted"; 
} 
?> </font>
To after the login details, and the error is gone , but still not able to delete.
User avatar
iknownothing
Forum Contributor
Posts: 337
Joined: Sun Dec 17, 2006 11:53 pm
Location: Sunshine Coast, Australia

Post by iknownothing »

can u please post the entire file again
netpants
Forum Commoner
Posts: 39
Joined: Wed Nov 15, 2006 1:21 pm

Post by netpants »

Code: Select all

<? 
$username=""; 
$password=""; 
$database=""; 

mysql_connect(localhost,$username,$password); 
@mysql_select_db($database) or die( "Unable to select database"); 
$query="SELECT * FROM Winners"; 
$result=mysql_query($query); 
$num=mysql_numrows($result); 
?>

<font color="#FFFFFF"><? 
$id = $_POST['id']; 

if (isset($_POST['delete'])){ 
mysql_query("DELETE FROM Winners WHERE id = '$id'"); 
}else { 
echo "Nothin was deleted"; 
} 
?> </font>

<html> 

<head> 
<meta http-equiv="Content-Language" content="en-us"> 
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> 
<title>Add Winner</title> 
</head> 

<body bgcolor="#000000"> 

<p align="left"> 
<img border="0" src="1392094530_m.jpg" width="170" height="119"> 

<font color="#FFFFFF"> 
<form action="insert.php" method="post"> 
Date: <input type="text" name="loggedDate">  <br> 
First Name: <input type="text" name="firstName">  <br> 
Last Name: <input type="text" name="lastName"><br> 
Birthdate: <input type="text" name="birth"><br> 
Phone Number: <input type="text" name="phone"><br> 
Street Number: <input type="text" name="streetNumber"> 
Street Name: <input type="text" name="streetName"> 
City: <input type="text" name="city"><br> 
State: <input type="text" name="state" size="2"> 
Zip Code: <input type="text" name="zip"> 
Prize: <input type="text" name="prize"><br> 
E-Mail: <input type="text" name="email"><br> 
<input type="Submit" value="Add Winner"> 
</form></font> 

</p> 
<table border="0" width="986"> 
        <tr> 
                <td width="200"><font color="#FFFFFF">Add Winner<p> 
                <font color="#FFFFFF"><a href="display.php">Display Winner</a></font></td> 
                <td width="863" rowspan="3" valign="top"> 
                <table border="0" width="100%"> 
                        <tr> 

                                <td>&nbsp; 


<table border="0" cellspacing="2" cellpadding="2"> 
<tr> 
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><a href="<? $orderby = 'id' ?>">ID</a></font></th> 
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Date</font></th> 
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><a href="<? $orderby = 'name' ?>">Name</a></font></th> 
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Birthday</font></th> 
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Phone</font></th> 
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Street Number</font></th> 
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Street Name</font></th> 
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">City</font></th> 
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">State</font></th> 
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Zip</font></th> 
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Prize</font></th> 
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">E-Mail</font></th> 
<th><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2">Edit</font></th> 
</tr> 

<? 
$i=0; 
while ($i < $num) { 
$id=mysql_result($result,$i,"id"); 
$date=mysql_result($result,$i,"loggedDate"); 
$first=mysql_result($result,$i,"firstName"); 
$last=mysql_result($result,$i,"lastName"); 
$birth=mysql_result($result,$i,"birth"); 
$phone=mysql_result($result,$i,"phone"); 
$streetnumber=mysql_result($result,$i,"streetNumber"); 
$streetname=mysql_result($result,$i,"streetName"); 
$city=mysql_result($result,$i,"city"); 
$state=mysql_result($result,$i,"state"); 
$zip=mysql_result($result,$i,"zip"); 
$prize=mysql_result($result,$i,"prize"); 
$email=mysql_result($result,$i,"email");  

?> 

<form method="POST" action=""> 
<tr> 
<td bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$id"; ?></font></td> 
<td bgcolor="#202020"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$date"; ?></font></td> 
<td bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$first $last"; ?></font></td> 
<td bgcolor="#202020"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$birth"; ?></font></td> 
<td bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$phone";  ?></font></td> 
<td bgcolor="#202020"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$streetnumber"; ?></font></td> 
<td bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$streetname";  ?></font></td> 
<td bgcolor="#202020"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$city";  ?></font></td> 
<td bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$state";  ?></font></td> 
<td bgcolor="#202020"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$zip";  ?></font></td> 
<td bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$prize";  ?></font></td> 
<td bgcolor="#202020"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><? echo "$email";  ?></font></td> 
<td bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" color="#FFFFFF" size="2"><input type="submit" value="delete" name="delete"></font></td></tr> </form> 
<? 
++$i; 
} 
?> 
</table> 
</td> 
</tr> 
</table> 
                <p> 

</body> 
<?
mysql_close(); 
?>
</html>
netpants
Forum Commoner
Posts: 39
Joined: Wed Nov 15, 2006 1:21 pm

Post by netpants »

not getting the nothing was deleted echo anymore though.
User avatar
iknownothing
Forum Contributor
Posts: 337
Joined: Sun Dec 17, 2006 11:53 pm
Location: Sunshine Coast, Australia

Post by iknownothing »

change...

Code: Select all

<?
$id = $_POST['id'];

if (isset($_POST['delete'])){
mysql_query("DELETE FROM Winners WHERE id = '$id'");
}else {
echo "Nothin was deleted";
}
?>
to this...

Code: Select all

<?
$id = $_POST['id'];

if (isset($_POST['id'])){
mysql_query("DELETE FROM Winners WHERE id = '$id'");
}else {
echo "Nothin was deleted";
}
?>
and see how it goes...
netpants
Forum Commoner
Posts: 39
Joined: Wed Nov 15, 2006 1:21 pm

Post by netpants »

Nothing, still clicks like iot want sto do something but nothing happens.
User avatar
iknownothing
Forum Contributor
Posts: 337
Joined: Sun Dec 17, 2006 11:53 pm
Location: Sunshine Coast, Australia

Post by iknownothing »

edit it again to this...

Code: Select all

<?
$id = $_POST['id'];

if (isset($_POST['id'])){
mysql_query("DELETE FROM Winners WHERE id = '$id'", $con);
}else {
echo "Nothin was deleted";
}
?>
netpants
Forum Commoner
Posts: 39
Joined: Wed Nov 15, 2006 1:21 pm

Post by netpants »

Post Reply