adodb/drivers/adodb-mysqli.inc.php, branch v5.22.8

mysqli: Improve setConnectionParameter

2025-01-25T01:03:00Z

- Simplify control statements with single if expressions. - Updated phpdoc with additional details on how to set connection property values. - Removed to-do that seemed wrong since the user should use setConnectionParameter for those or set the property directly. - Allow setting of ssl cert property values, clientFlags, port, and socket using the standard setConnectionParameter functionality. Feedback updates: - Return false for special cases with type checks on sslsert, socket, clientflags, or port fail - Added invalid connection param to output. - Simplified isset checks. - Changed sslcert to ssl and simplified subkeys to ('key', 'cert', 'ca', 'capath', 'cipher'). - Removed code duplication. - is_numeric should be checking value not parameter Fixes #1044

mysql: SSL not working due to wrong socket/flags

2025-01-25T00:50:42Z

- Remove inappropriate setting of socket. - Updated to use appropriate bitwise operations to check for set SSL client flags and update the default to not overwrite set user flags. - Add friendly error to let user know they need to add a SSL client flag when using certificates. Fixes #919, #1043 Signed-off-by: Damien Regad

Reset fetch mode before return from MetaColumns()

2024-05-26T14:14:17Z

Commit 249b7fb08569ce576cd1bf26098e00701145c6ec (PR #1017) introduced a regression caused by returning from the function without resetting $ADODB_FETCH_MODE to its original value. Fixes #1016

MySQL: allow forcing emulated prepared statements

2024-04-30T11:48:57Z

ADOdb 5.22.0 introduced use of bound variables and prepared statements, which broke compatibility with Manticore Search and ClickHouse. Adding $doNotUseBoundVariables property, allowing to revert to emulated prepared statements, used in ADODb until v5.21. Fixes #1028, PR #1029 Co-authored-by: Damien Regad Reworded and formatted PHPDoc block, fixed coding guidelines.

Catch getAssoc() execution error in metaColumns()

2024-01-10T18:44:31Z

When getAssoc() returns false, metaColumns() throws PHP Fatal error on array_change_key_case, bool given instead of array. We now check that getAssoc() completed successfully before continuing, and abort if not. Fixes #1016 Signed-off-by: Damien Regad

Fix mysqli bulkBind reset after one call

2023-11-01T13:54:02Z

Stored the current bulkBind value in a variable so $this->bulkBind can be reset after being set to false. Fixes #1000 (PR #1300)

Fail connection if mysqlnd is not available

2023-05-24T10:03:03Z

Since 5.22.0, the mysqli driver relies on the mysqli_stmt_get_result() function, which is only available in the MySQL Native Driver, to execute queries. An attempt to connect on a system using libmysqlclient should fail with an error message, to avoid problems down the line. Fixes #967

PHPDoc: ADODB_mysqli::setCharSet() is deprecated

2023-05-22T11:34:55Z

As mentioned in the documentation [1], function is deprecated for MySQL databases since version 5.21. [1]: https://adodb.org/dokuwiki/doku.php?id=v5:reference:connection:setcharset

Define ADOConnection::_query() method

2023-04-29T23:00:55Z

- Update child classes to be consistent with this declaration. - Remove unnecessary, non-PHPDoc comments - Consistent parameter names Fixes #966

PHPDoc: fix ADOConnection::execute() return type

2023-04-29T22:51:47Z

Remove redundant PHPDoc block in child classes ADODB_mysqli, ADODB_oci8. Fixes #964