Organizational Research By

Surprising Reserch Topic

what does a successful mysql delete return how to check if delete was successfu


what does a successful mysql delete return how to check if delete was successfu  using -'php,mysql'

Using PHP, I am trying to delete a record, but I want to check if it was successful or not. Is anything returned from a successful DELETE FROM foo where bar = 'stuff'?

Alternatively, do you know any other ways to check if a DELETE was successful? Or am I better off just making sure the row exists before I delete it? I am trying to avoid another query if possible.
    

asked Sep 14, 2015 by ZUKChandaom
0 votes
6 views



Related Hot Questions

3 Answers

0 votes

Assuming you are using mysql_query:

For other type of SQL statements, INSERT, UPDATE, DELETE, DROP, etc, mysql_query() returns TRUE on success or FALSE on error.

If you are using PDO::exec, then the manual says this:

PDO::exec() returns the number of rows that were modified or deleted by the SQL statement you issued. If no rows were affected, PDO::exec() returns 0.

Don't want to answer snipe, but since this was selected as the answer, I should note that mysql_query will return TRUE even if the query did not actually remove anything. You should use mysql_affected_rows to check for that.

answered Sep 14, 2015 by GeraldoRestr
0 votes

you could try this for your php code, placed after your query runs:

if (mysql_affected_rows() > 0) {
    echo "You have successfully updated your data.

"; } else { echo "The data you submitted matched the current data so nothing was changed.

"; }
answered Sep 14, 2015 by sammy
0 votes

Additionally, if you care about the number of rows that were affected:

[Use] mysql_affected_rows() to find out how many rows were affected by a DELETE, INSERT, REPLACE, or UPDATE statement.

answered Sep 14, 2015 by LayJxj

...