Delete row in MySql

Harlugo

Anybody have any idea why i can't seems to be able to delete a row in my MySql table.

Here is the code submit by a single form with a submit button the field is call username:

<?php

include 'db.php';

$username = $_SESSION['username'];

$requete = "DELETE FROM lesgens WHERE username='$username'";
$verif = mysql_query ($requete,$id_connex);
if($verif){
echo "L'annonce est supprimée";
}
mysql_close($id_connex);

?>

Let me know i m a little puzzle by something that should be simple

examancer

two things... if the username was submitted via a form, then it wouldn't be in the $SESSIONS autoglobal array, it would be in either the $GET array or the $POST array depending on the form type, and will definately be in the $REQUEST array.

Also if the query fails you should output the MySQL error so that you can see exactly why its not working... so change this:

if($verif){
  echo "L'annonce est supprimée";
}

if (!$verif) {
  echo("Error deleting row: " . mysql_error());
} else {
  echo("Success!");
}

Harlugo

Hello,

I have apply the suggestion on my script and i have a SUCCESS message however the username row is still in my database: here is my script to see where i am:

<?php

include 'db.php';

$username2 = $_REQUEST['$username'];


$requete = "DELETE FROM lesgens WHERE username='$username2'";
$verif = mysql_query ($requete,$id_connex);
if($verif){
echo( "L'annonce est supprimée:".mysql_error());
}else{
echo("SUCCESS!");
}
mysql_close($id_connex);
?>

And my form

<html>
<body>
<h3 align="center"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Supprimer
une annonce</font></h3>
<form method="post" action="/script/delete.php3">
<table width="100%" border="0" cellspacing="0" cellpadding="0" style="BORDER-TOP: #DBE1C5 1px solid; BORDER-RIGHT: #DBE1C5 1px solid; BORDER-LEFT: #DBE1C5 1px solid; BORDER-BOTTOM: #DBE1C5 1px solid">
<tr>
<td bgcolor="#DBE1C5"><div align="right"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Tapez
le code de l'annonce: </font></div></td>
<td bgcolor="#DBE1C5"><font face="Verdana, Arial, Helvetica, sans-serif">
<input name="username" type="text" id="username">
<input type="submit" name="supprimer" value="Supprimer l'annonce">
</font></td>
</tr>
</table>
</form>
</body>
</html>

I am posting boot because i'm sure i missing something little let me know.

LordShryku

$username2 = $_REQUEST['$username']; 
// should actually be
$username2 = $_REQUEST['username'];

You should try echoing your request to the screen to make sure it's doing what you want

Harlugo

Thanks for this one: But my table is still not delete

here is my php so far:

<?php

include 'db.php';

$username2 = $_REQUEST['username'];


$requete = "DELETE FROM lesgens WHERE username=$username2";
$verif = mysql_query ($requete,$id_connex);
if($verif){
echo( "L'annonce est supprimée:".mysql_error());
}else{
echo("SUCCESS!");
}
mysql_close($id_connex);
?>

LordShryku

Need single quotes around your username in the SQL statement.

$requete = "DELETE FROM lesgens WHERE username='".$username2."'";

Harlugo

Still the same thing nice try for this one here is my code so far

<?php

include 'db.php';

$username2 = $_REQUEST['username'];


$requete = "DELETE FROM lesgens WHERE username='".$username2."'";
$verif = mysql_query ($requete,$id_connex);
if($verif){
echo( "L'annonce est supprimée:".mysql_error());
}else{
echo("SUCCESS!");
}
mysql_close($id_connex);
?>

Harlugo

Just change some of the code here is where i am now:

<?php

include 'db.php';

$username2 = $_REQUEST['username'];

$verif = mysql_query ("DELETE FROM lesgens WHERE username='".$username2."'");
if($verif){
echo( "L'annonce est supprimée:".mysql_error());
}else{
echo("SUCCESS!");
}
mysql_close($id_connex);
?>

LordShryku

Okay, it looks like you really need some debugging here. Echo your statement to the screen. Make sure you can perform the statement directly against the database. If so, make sure you're connected right. If so, make sure you have the right database selected. Going to have to go through the motions.....

Harlugo

When i do this with echo

<?php

include 'db.php';

$username2 = $_REQUEST['username'];


$requete = "DELETE FROM lesgens WHERE username='".$username2."'";
$verif = mysql_query ($requete,$id_connex);
echo $requete;

if($verif){
echo( "probleme:".mysql_error());
}else{
echo("SUCCESS!");
}
mysql_close($id_connex);
?>

i have this:

DELETE FROM lesgens WHERE username=''SUCCESS!

i have many field but what i need to do and i think this should work i wish when is doing a query to delete the row of the unique username it remove the row completly.

the database is working well connected

i have allready a script that is registering new data in it and it s working

strange

LordShryku

That means it isn't getting the username right. Since you're using post, try this

<?
include 'db.php'; 

$username2 = $_POST['username']; 

$requete = "DELETE FROM lesgens WHERE username='".$username2."'"; 
$verif = mysql_query ($requete,$id_connex); 
echo $requete; 

if($verif){ 
echo( "probleme:".mysql_error()); 
}else{ 
echo("SUCCESS!"); 
} 
mysql_close($id_connex); 
?>

examancer

the problem is that your script prints "Success" when it FAILS, not when its successfull.

in my example the if statement is different:

if(!$verif){ // notice the ! which means that if the query FAILS (not succeeds) then the following will be output:
echo( "probleme:".mysql_error()); 
}else{ // then, if the query doesn't fail we do this stuff:
echo("SUCCESS!"); 
}

and so you can see exactly what all the values are, change your code to this:

include 'db.php';  

$username2 = $_POST['username'];

echo("Deleting username:" . $username2);

$requete = "DELETE FROM lesgens WHERE username='".$username2."'";
$verif = mysql_query ($requete,$id_connex);  

echo $requete;  

if(!$verif){  

echo( "probleme:".mysql_error());  

}else{  

echo("SUCCESS!");  

}
mysql_close($id_connex);

edit: spelling errors, and incorporated my suggestion into his code.

Harlugo

Look good but not yet , but i feel i m so close to it here is the code:

<? 
include 'db.php';  

$username2 = $_POST['username'];  

$requete = "DELETE FROM lesgens WHERE username='".$username2."'";  

$verif = mysql_query ($requete,$id_connex);  

echo $requete;  

if($verif){  

echo( "probleme:".mysql_error());  

}else{  

echo("SUCCESS!");  

}  

mysql_close($id_connex);  

?>

the echo message is:

DELETE FROM lesgens WHERE username='mama'SUCCESS!

Normally it will the delete the entiry row of the data right?

Seems strange that it is not doing it.

Harlugo

Originally posted by LordShryku
That means it isn't getting the username right. Since you're using post, try this

<?
include 'db.php'; 

$username2 = $_POST['username']; 

$requete = "DELETE FROM lesgens WHERE username='".$username2."'"; 
$verif = mysql_query ($requete,$id_connex); 
echo $requete; 

if($verif){ 
echo( "probleme:".mysql_error()); 
}else{ 
echo("SUCCESS!"); 
} 
mysql_close($id_connex); 
?>

[/B]

seems right for that but the bug is still there here is my modification with your help:

<? 
include 'db.php';  

$username2 = $_POST['username'];  

$requete = "DELETE FROM lesgens WHERE username='".$username2."'";  

$verif = mysql_query ($requete,$id_connex);  

echo $requete;  

if(!$verif){ // notice the ! which means that if the query FAILS (not succeeds) then the following will be output: 
echo( "probleme:".mysql_error());  

}else{ // then, if the query doesn't fail we do this stuff: 
echo("SUCCESS!");  

}

mysql_close($id_connex);  

?>

and the echo message now is

DELETE FROM lesgens WHERE username='mama'probleme:

LordShryku

Yep, the SQL is right now...still not deleting?

examancer

well... that means the query definately isn't going through, so you may want to make sure you are connected to MySQL properly and have the right DB selected.

Harlugo

Nop still the same look strange for me!

Harlugo

maybe its a simple comprehension problem or i just dont understand why it s not deleting a row of data.

i have a database with many username and all of them have feature like height size etc this should work right?

i double triple check my database is well connected

maybe its the $id_connex

you are working real hard thank you. feel less alone

LordShryku

Yeah, couldn;t hurt to remove the connection from mysql_query(). It should just pick up the connection if it is connected...

Harlugo

MIRACLE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

by remove the id_connex it worked!!!!!

Thanks you. You've beeen a real Help a success for tonight but (not a success every night !😉

I will have past 2 days on it without you, have a good night

going to sleep 2h48 am