Run a sql query with a timeout in PHP or How in PHP, to stop a sql query once already begun?

Question

I read the documentation for oci_cancel but it seems to me a bit fuzzy.

Does oci_cancel kill the sql process in the server?

If not, how can I make a script that executes a sql query, waits a moment and if the query exceeds 10 seconds (for example), cancel the query in the server?

Excuse me if this question is similar to one that has been asked time ago, but I didn't find any satisfactory answer.

Answer 1

PDO allows you to specify the query timeout with the "ATTR_TIMEOUT" attribute, although it's entirely dependent whether the driver supports it or not.