Get PDO connection ID

Question

Is there a way to get a unique connection id of a PDO connection to mysql?

Answer 1

Try sth like this.

print_r($dbh->query('SELECT CONNECTION_ID()')->fetch(PDO::FETCH_ASSOC));

you can use a regular query to execute the CONNECTION_ID() mysql command to get the connection ID.

See the mySQL manual for more