I am able to retrieve the results from the SELECT commands using $stmt->nextRowset() however, I cannot retrieve the total number of records that have been updated, deleted, or inserted. Using PHP and PDO, for each query, I want to see either the results or the affected rows however, this doesn't work for UPDATE, INSERT, or DELETE queries (unless they are the only query in the procedure). I have a procedure with a mix of SELECT commands and UPDATE commands.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |