MySQLi is gettng a feature to bind arrays to execute($array) method in single call. This would apply to standard int index based arrays and associative arrays.
PHP 8.1 – MySQLi: binding multiple values
database
PHP 8.1 – MySQLi: fetch_column()
New function was added to retrieve first or any other column from the result set to MySQLi object. This follows the fetchColumn() method from PDO and behaves in the same manner.
PHP 8.1 – Default MySQLi Error Mode
The default error mode for mysqli calls is now changed from silent mode to Exception mode. This doesn’t affect PDO object since PHP Data Object is already throwing Exception by default.
SQL Queries for mere mortals – Review
So you want to learn a SQL language and you are indeed a human? Don’t look further, this read will provide you some decent amount of the basic and those more advanced knowledge of SQL programming in no time. However be prepare for some long ass reading with this 4th edition of over nearly one thousand pages IT book.