When should I use closeCursor() for PDO statements?

php pdo

2022-08-30 13:12:01

The PHP documentation on closeCursor() says that it

frees up the connection to the server so that other SQL statements may be issued, but leaves the statement in a state that enables it to be executed again.

When I have used the command though it doesn't seem to matter if it is there or not in between my query statements, and I am beginning to wonder if I need it at all.

Is it different to use it for database calls that don't return data vs. those that do?

答案 1

This depends on the driver used. I think for mysql this will do nothing else than clear the result of the statement. After calling closeCursor() you cannot call fetch() anymore. However executing the statement again should not be a problem. Try to look at mysql_free_result(), it does a similar thing.

答案 2