Visman
70620c155f
Add more database information for MySQL
2023-09-10 22:52:26 +07:00
Visman
ebef5d5dad
Add some order
2023-07-14 20:45:32 +07:00
Visman
8b1f40e34c
Fix DB\AbstractStatement
2023-04-29 18:05:01 +07:00
Visman
e2cf3896b6
Up min PHP version from 7.3 to 8.0 - 4
2023-04-28 13:34:43 +07:00
Visman
7c7e1a097f
Up min PHP version from 7.3 to 8.0 - 3
2023-04-28 10:58:24 +07:00
Visman
5528d0480b
Up min PHP version from 7.3 to 8.0
2023-04-27 19:36:15 +07:00
Visman
c2b5758465
Fix truncateTable() method for SQLite
2023-03-31 09:43:16 +07:00
Visman
65941831e5
Update DB\Pgsql for COLLATE
2022-02-07 14:14:45 +07:00
Visman
cdea5ce590
Update DB drivers
2022-01-25 13:23:14 +07:00
Visman
c6253ef6fe
Update DB\Sqlite
2022-01-24 23:19:16 +07:00
Visman
efaf3112d8
Revert "Small changes that break everything"
...
This reverts commit e61bd6c3c0
.
2022-01-17 18:06:49 +07:00
Visman
e61bd6c3c0
Small changes that break everything
2022-01-17 18:06:33 +07:00
Visman
18710f1a2f
Update DB\Sqlite\alterField() method
2021-12-29 19:04:41 +07:00
Visman
8f838ce769
Update DB\Sqlite\dropIndex() method
...
Fix for PRIMARY KEY.
2021-12-29 18:03:01 +07:00
Visman
9902e302a5
Update DB\Mysql
2021-12-29 17:46:24 +07:00
Visman
bfecbd573c
Update DB\Sqlite
2021-12-29 17:14:32 +07:00
Visman
768074c78e
Update DB\Sqlite\addIndex() method
...
Fix for PRIMARY KEY.
2021-12-29 16:37:36 +07:00
Visman
777010f049
Update DB\Sqlite\indexExists() method
...
Fix for PRIMARY KEY.
2021-12-29 15:41:01 +07:00
Visman
acffa1cdfc
Update DB\Sqlite\dropField() method
2021-12-29 13:56:54 +07:00
Visman
66b0273725
Fix DB\Pgsql
2021-12-29 13:55:38 +07:00
Visman
91f192e52d
Fix DB\Sqlite
2021-12-28 21:25:16 +07:00
Visman
7e04d6acc2
Update DB drivers
2021-12-28 18:50:13 +07:00
Visman
2cb9f34dcd
Update DB drivers
...
Pass the prefix of the database tables by their name. Similar to sql queries.
2021-12-28 17:47:38 +07:00
Visman
2d71c280ca
Minor change
2021-12-23 13:22:23 +07:00
Visman
e893a5d4e5
Update DB\SqliteStatement
2021-12-23 13:21:59 +07:00
Visman
cb04b8657c
Update DB\AbstractStatement
2021-12-23 13:21:21 +07:00
Visman
99243e23e1
Update DBStatement
2021-12-22 23:28:11 +07:00
Visman
cd975a3855
Fix DB\Mysql
...
Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
2021-12-20 20:08:55 +07:00
Visman
5b5fedde23
Update DB drivers
...
Remove the checks that are not needed after the previous commit.
2021-12-20 19:44:57 +07:00
Visman
1d28b4f8c8
Update DB drivers
...
Add a separate method for creating a query string for a column.
2021-12-20 19:34:02 +07:00
Visman
27f624ee9d
Update DB\Pgsql #7
...
Fix addIndex() and dropIndex() for primary key.
2021-12-19 21:46:45 +07:00
Visman
e0d30948d0
Minor fixes
2021-12-19 17:19:49 +07:00
Visman
49c00d420b
Update DB\Sqlite #10
...
A crutch in the dropField() method for SQLite prior to version 3.36.0.
2021-12-18 19:02:02 +07:00
Visman
56c0b67525
Update DB\Sqlite
...
#10
2021-12-18 01:04:01 +07:00
Visman
f6dfd6fdcd
Update DB\Sqlite
...
More data for server statistics.
2021-12-17 14:29:50 +07:00
Visman
274ea421de
Update DB\SqliteStatement #9
...
Fix for PHP 8.0 - 8.0.6.
2021-12-16 23:13:24 +07:00
Visman
8c1f4a9503
Update DB\AbstractStatement #9
...
Add fetchAll() method.
2021-12-16 19:00:35 +07:00
Visman
9c813d46cb
Update DB\AbstractStatement
2021-12-16 16:51:23 +07:00
Visman
0b5e9b77f0
Add setFetchMode() to DB\AbstractStatement #9
2021-12-16 15:43:31 +07:00
Visman
2073aceed7
Update DB\AbstractStatement #9
...
In the case of -> fetch (PDO :: FETCH_COLUMN), the method should return the value from the first column of the row, not an array with the data of all columns of the row.
2021-12-16 13:09:23 +07:00
Visman
0d443ff683
Update DBStatement for SQLite #9
...
I had to split DBStatement for SQLite into two branches: for PHP 7 and for PHP 8, otherwise it does not allow inheriting the PDOStatement class.
2021-12-16 11:03:43 +07:00
Visman
481489f505
Remove debug output
2021-12-15 23:22:07 +07:00
Visman
3bd0a4aa3b
Fix DB\SqliteStatement for #9
...
For tables with no integer/boolean fields.
2021-12-15 19:31:11 +07:00
Visman
b12b96ccd5
Fix DB\AbstractStatement
...
#9
2021-12-15 18:05:53 +07:00
Visman
1077d2c6b6
Type conversion for #9
...
Added BOOLEAN to SQLite types.
Expanded DBStatement (started).
The fecth() method for INTEGER and BOOLEAN fields returns integer/float(?) and bool data.
2021-12-15 17:16:54 +07:00
Visman
1800381095
A little loop optimization
2021-12-15 09:48:01 +07:00
Visman
474dd4d439
Fix DB\Sqlite
2021-12-13 23:14:52 +07:00
Visman
04f5906281
Update DB\Mysql
2021-12-13 20:09:20 +07:00
Visman
2839c21416
Update DB\Pgsql
2021-12-13 20:09:02 +07:00
Visman
456751fa61
Add DB\Sqlite
2021-12-13 20:07:20 +07:00