Added support for Mysql timezone on connection

ThingEngineer / PHP-MySQLi-Database-Class

Wrapper for a PHP MySQL class, which utilizes MySQLi and prepared statements.

Other

3.29k stars 1.35k forks source link

Added support for Mysql timezone on connection #973

Open sassoleo opened 2 years ago

sassoleo commented 2 years ago

Timezone can be specified in the constructor optionally, example: '-5:00' for EST The class will send the SQL query in the constructor: SET time_zone = '-5:00' Also fixed a problem with rawQuery on very long SQL queries, eliminating spaces from the query string

avbdr commented 1 year ago

sorry, this patch is breaking an existing constructor API.