Check if a record was deleted when running DELETE query

Question

Check if a record was deleted when running DELETE query

Asked 9 years, 1 month ago

Viewed 2,040 times

5

I’m making a simple PHP code to delete database email, only I need to use one if and else if a given action occurs.

If for example, deleting an email shows a particular message, or if you do not have that email requested in the database, a message appears that this data is no longer present in the table follows the code.

<?php 

$emailDel = $_POST['delemail'];

$dbc = mysqli_connect('localhost', 'xavier', 'xavier', 'store_database')or die('não foi possivel acessar Banco de Dados');

$query = "DELETE FROM clients WHERE email = '$emailDel'";
$result = mysqli_query($dbc, $query)or die('não foi possivel acessar Banco de Dados');



if($result = TRUE){
    echo $emailDel.' as deleting from database';
}else{
    echo $emailDel.' it is not present in database';
}

mysqli_close($dbc);


?>

Missed fetch_assoc, without it you do not take the result of the query

– rray

2015/10/19 at 01:20
This is wrong if($result = TRUE){ right is if($result == TRUE){ or if($result === TRUE){ or just if($result){.

– Guilherme Nascimento

2015/10/19 at 01:33
@rray I think this is not necessary because it is not a consultation but a DELETE from?

– Guilherme Nascimento

2015/10/19 at 01:34
What’s the matter?

– rray

2015/10/19 at 02:16
1

I found the problem quite clear.. I did not understand why they voted negative or to close.

– Daniel Omine

2015/10/19 at 02:22
@rray because the consultations of the type DELETE, UPDATE, INSERT return TRUE or FALSE only.

– Edilson

2015/10/19 at 02:52
@Edilson, there was no code before in the question, I figured I was doing a select before delete.

– rray

2015/10/19 at 03:03
@rray Yes, I just saw that the question was edited.

– Edilson

2015/10/19 at 03:06

Show 3 more comments

3 answers

Browser other questions tagged php mysql

You are not signed in. Login or sign up in order to post.

by Giancarlo Abel Giulian • **3,999** points · Answer 1 · 2015-10-19T00:37:06+00:00

3

An equal = assignment operator means that the variable will receive a certain value.

Two of a kind == condition operator.

So the right thing is:

if($result == True){
    echo $emailDel.' as deleting from database';
} else {
    echo $emailDel.' it is not present in database';
}

yeah, I’ve seen it here and how I’m new to php, now that I’ve seen the question of == for tbm condition extends to it, but that same tbm n worked, is that getting an answer to identify whether it has the value in the table for php to confirm would not be possible ?

– Marco Antonio Fernandes Xavier

2015/10/19 at 00:43
It must be an error before this condition, exprerimente put it at the beginning of your PHP file and edit your code with the error that returned: ini_set('display_errors', 'On'); and just below error_reporting(E_ALL);.

– Giancarlo Abel Giulian

2015/10/19 at 00:48
thanks, but I tried here, but nothing was identified.

– Marco Antonio Fernandes Xavier

2015/10/19 at 01:00
It has the code in the question, I edited it, I do not know if it was approved

– Giancarlo Abel Giulian

2015/10/19 at 01:10
I approved, the code is there yes.

– Marco Antonio Fernandes Xavier

2015/10/19 at 01:15
$result receives the return of mysqli_query(), which does not mean that any record has even been deleted because mysqli_query() returns true or false... if true, indicates that the query was executed without expected error, even if nothing was deleted.

– Daniel Omine

2015/10/19 at 05:57

Show 1 more comment

by Daniel Omine • **19,666** points · Answer 2 · 2015-10-19T02:33:46+00:00

Right after executing the query:

$result = mysqli_query($dbc, $query)or die('não foi possivel acessar Banco de Dados');

Check how many columns were affected with the function mysqli_affected_rows().

The function mysqli_query() returns boolean value.

1. true: when the execution was successful

2. false: when there was a mistake.

An important detail is that when you return true, does not mean that some record was deleted, but rather that the query was executed smoothly.

Therefore, just after checking the return of the query execution, check the return of mysqli_affected_rows().

if ($result == true){
    if ($total = mysqli_affected_rows($dbc))
        echo 'excluído: '.$total;
    else
        echo 'Nenhum registro excluído';
else
   echo 'Houve erro na execuão da query SQL: '.mysqli_error($dbc);

by Fabio Henrique • **2,156** points · Answer 3 · 2015-10-19T03:14:42+00:00

Try So
$Success = mysql_affected_rows();

if( isset($_POST['delemail']) ){   // Se existir o post prossiga... 
$emailDel = $_POST['delemail'];

$dbc = mysqli_connect('localhost', 'xavier', 'xavier', 'store_database')or    
die('não foi possivel acessar Banco de Dados');

$query = "DELETE FROM clients WHERE email = '$emailDel'";
$result = mysqli_query($dbc, $query)or die('não foi possivel acessar Banco   
de Dados');
$success = mysql_affected_rows();


if($success <> 0 ){ 
echo $emailDel.' as deleting from database';
}else{
echo $emailDel.' it is not present in database';
}

}else{    
echo"Erro";
}

mysqli_close($dbc);