How to retrun from sql to php on successful statement

Question

I am inserting data into a table using PHP and want to find out if the SQL has worked properly so I can display a success message. Is there a way of returning success from SQL back to PHP after the statement is executed.

    function addPlayer($playerName, $dateOfBirth, $team) {
       $sql = "INSERT INTO players VALUES (DEFAULT, :name, :teamID, :dob)";
       $stmt = $this->connection->conn->prepare($sql);
       $stmt->bindParam(":name", $playerName);
       $stmt->bindParam(":dob", $dateOfBirth);
       $stmt->bindParam(":teamID", $team);
       $stmt->execute();
    }

I want to know if the execute statement has been successful and the data added to the table. Is there a way to have the SQL return a success or fail so I can display an error or success message on the page?

I haven't set it to anything myself so I assume it is the default value. However, I thought this was for PDO errors not returning the success of an SQL query, as a failed SQL query may not always throw a PDO error? — 6C69616D, Aug 27 '19 at 21:09
It depends on what you mean by "failed". It's not usually an error if a `SELECT` doesn't find any matching rows, or `UPDATE` doesn't find anything to update. — Barmar, Aug 27 '19 at 21:14
No, but sometimes Insert can fail due to a wrong data type being entered or the fact that the referential integrity of the table isn't being fulfilled. This doesn't throw an error for me. Would this be the case if I changed the error handling? — 6C69616D, Aug 27 '19 at 21:17
The default error mode is to just return `FALSE` rather than throw an error. I suggest you enable `PDO::ERRMODE_EXCEPTION` and use `try/catch` to report errors. — Barmar, Aug 27 '19 at 21:18
I'll try that and see if I can find the solution. If I am correct though this is for development only and not for the release of any software? — 6C69616D, Aug 27 '19 at 21:20
No, you definitely need it in production, so the script will stop if there's a problem. — Barmar, Aug 27 '19 at 21:21

dılo sürücü · Answer 1 · 2019-08-27T22:15:45.813

-1

   $sql = "INSERT INTO players VALUES (DEFAULT, :name, :teamID, :dob)";
       $connect= $this->connection->conn;
        $stmt= $connect->prepare($sql);
       $stmt->bindParam(":name", $playerName);
       $stmt->bindParam(":dob", $dateOfBirth);
       $stmt->bindParam(":teamID", $team);
       return   (   $stmt->execute()  && $connect->rowCount()>0);

Or shortly

     $stmt->execute();
    if ($stmt->rowCount() > 0)
    {
        return true;
    }

edited Aug 27 '19 at 22:15

answered Aug 27 '19 at 21:10

dılo sürücü

3,821
1
26
28

How does this work, surely I would need to know the row count before executing this? – 6C69616D Aug 27 '19 at 21:13
Is it really necessary to check `rowCount()`? The only reason why `INSERT` wouldn't insert any rows is if it gets an error. – Barmar Aug 27 '19 at 21:13
@6C69616D It's just testing whether the row count is non-zero. – Barmar Aug 27 '19 at 21:14
But if there is other data there already then that wont matter – 6C69616D Aug 27 '19 at 21:14
2

If you violate a unique constraint, it will get an error, so `execute()` will return `FALSE`. – Barmar Aug 27 '19 at 21:15
is this also the case if the referential integrity is not upheld by the new data – 6C69616D Aug 27 '19 at 21:18
2

@6C69616D Yes. Anything that prevents the query from completing will be treated as an error. – Barmar Aug 27 '19 at 21:19
In insert or update sometime execute method return true but SQL query not affectted none of column ...we check affected row if affected row the successful – dılo sürücü Aug 27 '19 at 21:19
I edited please try again ... – dılo sürücü Aug 27 '19 at 22:11

How to retrun from sql to php on successful statement

1 Answers1