Add mysqli exception mode - #349

thanks, maybe we can remove the warning suppression (@) now too? other question is can we get the state before we set it and set it back after connecting?

It also seems that MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT is the default since php 8.1, that would mean we already get exceptions in this driver but doesn't catch them?

thanks, maybe we can remove the warning suppression (@) now too? other question is can we get the state before we set it and set it back after connecting?

Thanks for pointing this out. I removed the error suppression.
We can get the state from mysqli_driver->report_mode but I don't see why we would need to do that.

It also seems that MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT is the default since php 8.1, that would mean we already get exceptions in this driver but doesn't catch them?

Yes, that would be true. Hence, why the current code needs to be changed because it doesn't work as intended. I still like to set the error mode explicitly though.

Thanks @kamil-tekiela for this fix, and @HLeithner and @rdeutz for reviews.