Lerma - Драйвера для работы с БД MySQL

Пусть вася пупкин потом не приходит на форум с раздолбанным хряком, о том что из бд выходят кракозябры и т.д. Да можно, но профит то 6лять где, ало?

Всегда поддерживал инициативу оптимизаций без лишних движений, наплевав на pr and others pr. Везде можно и возможно, а про максимальной эффективности не духа.

Спойлер: smitt

Диалог с некомпетентным чмoм прекращен и засунут в группу биомусоров(игнор лист)

Правильней пишется - параметр был опущен вместе с тобой, бомбежник. О_о

 

Обновляночка

Lerma ver 6.0
php ver 7.4

source code лишь.

Спойлер

fetch( Lerma :: FETCH_NUM )
Array
(
[0] => 138
[1] => Nouvu\Database\Lerma
[2] => 111
)

fetchall( Lerma :: FETCH_NUM )
Array
(
[0] => Array
(
[0] => 138
[1] => Nouvu\Database\Lerma
[2] => 111
)

[1] => Array
(
[0] => 139
[1] => Nouvu\Database\ComponentFetch
[2] => 111
)

[2] => Array
(
[0] => 140
[1] => php7.4
[2] => 111
)

[3] => Array
(
[0] => 141
[1] => Database
[2] => 111
)

[4] => Array
(
[0] => 142
[1] => Nouvu\Database\Core
[2] => 222
)

[5] => Array
(
[0] => 143
[1] => InterfaceDriver
[2] => 333
)

[6] => Array
(
[0] => 144
[1] => Nouvu\Database\LermaStatement
[2] => 333
)

)

fetch( Lerma :: FETCH_ASSOC )
Array
(
[id] => 138
[name] => Nouvu\Database\Lerma
[num] => 111
)

fetchall( Lerma :: FETCH_ASSOC )
Array
(
[0] => Array
(
[id] => 138
[name] => Nouvu\Database\Lerma
[num] => 111
)

[1] => Array
(
[id] => 139
[name] => Nouvu\Database\ComponentFetch
[num] => 111
)

[2] => Array
(
[id] => 140
[name] => php7.4
[num] => 111
)

[3] => Array
(
[id] => 141
[name] => Database
[num] => 111
)

[4] => Array
(
[id] => 142
[name] => Nouvu\Database\Core
[num] => 222
)

[5] => Array
(
[id] => 143
[name] => InterfaceDriver
[num] => 333
)

[6] => Array
(
[id] => 144
[name] => Nouvu\Database\LermaStatement
[num] => 333
)

)

fetch( Lerma :: FETCH_OBJ )
stdClass Object
(
[id] => 138
[name] => Nouvu\Database\Lerma
[num] => 111
)

fetchall( Lerma :: FETCH_OBJ )
Array
(
[0] => stdClass Object
(
[id] => 138
[name] => Nouvu\Database\Lerma
[num] => 111
)

[1] => stdClass Object
(
[id] => 139
[name] => Nouvu\Database\ComponentFetch
[num] => 111
)

[2] => stdClass Object
(
[id] => 140
[name] => php7.4
[num] => 111
)

[3] => stdClass Object
(
[id] => 141
[name] => Database
[num] => 111
)

[4] => stdClass Object
(
[id] => 142
[name] => Nouvu\Database\Core
[num] => 222
)

[5] => stdClass Object
(
[id] => 143
[name] => InterfaceDriver
[num] => 333
)

[6] => stdClass Object
(
[id] => 144
[name] => Nouvu\Database\LermaStatement
[num] => 333
)

)

fetch( Lerma :: MYSQL_FETCH_FIELD )
Array
(
[name] => id
[orgname] => id
[table] => lerma
[orgtable] => lerma
[def] =>
[db] => git
[catalog] => def
[max_length] => 3
[length] => 11
[charsetnr] => 63
[flags] => 49667
[type] => 3
[decimals] => 0
)

fetchall( Lerma :: MYSQL_FETCH_FIELD )
Array
(
[0] => Array
(
[name] => id
[orgname] => id
[table] => lerma
[orgtable] => lerma
[def] =>
[db] => git
[catalog] => def
[max_length] => 3
[length] => 11
[charsetnr] => 63
[flags] => 49667
[type] => 3
[decimals] => 0
)

[1] => Array
(
[name] => name
[orgname] => name
[table] => lerma
[orgtable] => lerma
[def] =>
[db] => git
[catalog] => def
[max_length] => 29
[length] => 196605
[charsetnr] => 33
[flags] => 4113
[type] => 252
[decimals] => 0
)

[2] => Array
(
[name] => num
[orgname] => num
[table] => lerma
[orgtable] => lerma
[def] =>
[db] => git
[catalog] => def
[max_length] => 3
[length] => 11
[charsetnr] => 63
[flags] => 36865
[type] => 3
[decimals] => 0
)

)

fetch( Lerma :: MYSQL_FETCH_BIND )
Array
(
[0] => 138
[1] => Nouvu\Database\Lerma
[2] => 111
)

fetch( Lerma :: MYSQL_FETCH_BIND | Lerma :: FETCH_COLUMN )
Nouvu\Database\Lerma
fetch( Lerma :: FETCH_COLUMN )
Nouvu\Database\Lerma
fetchall( Lerma :: FETCH_COLUMN )
Array
(
[0] => Nouvu\Database\Lerma
[1] => Nouvu\Database\ComponentFetch
[2] => php7.4
[3] => Database
[4] => Nouvu\Database\Core
[5] => InterfaceDriver
[6] => Nouvu\Database\LermaStatement
)

fetch( Lerma :: FETCH_KEY_PAIR )
Array
(
[138] => Nouvu\Database\Lerma
)

fetchall( Lerma :: FETCH_KEY_PAIR )
Array
(
[111] => Database
[222] => Nouvu\Database\Core
[333] => Nouvu\Database\LermaStatement
)

fetchall( Lerma :: FETCH_KEY_PAIR | Lerma :: FETCH_NAMED )
Array
(
[111] => Array
(
[0] => Nouvu\Database\Lerma
[1] => Nouvu\Database\ComponentFetch
[2] => php7.4
[3] => Database
)

[222] => Nouvu\Database\Core
[333] => Array
(
[0] => InterfaceDriver
[1] => Nouvu\Database\LermaStatement
)

)

fetchall( Lerma :: FETCH_KEY_PAIR | Lerma :: FETCH_FUNC )
Array
(
[111] => Array
(
[Database] => name
)

[222] => Array
(
[Nouvu\Database\Core] => name
)

[333] => Array
(
[Nouvu\Database\LermaStatement] => name
)

)

fetch( Lerma :: FETCH_FUNC )
138 - Nouvu\Database\Lerma - 111
fetchall( Lerma :: FETCH_FUNC )
Array
(
[0] => 138 - Nouvu\Database\Lerma - 111
[1] => 139 - Nouvu\Database\ComponentFetch - 111
[2] => 140 - php7.4 - 111
[3] => 141 - Database - 111
[4] => 142 - Nouvu\Database\Core - 222
[5] => 143 - InterfaceDriver - 333
[6] => 144 - Nouvu\Database\LermaStatement - 333
)

fetchall( Lerma :: FETCH_UNIQUE )
Array
(
[138] => Array
(
[name] => Nouvu\Database\Lerma
[num] => 111
)

[139] => Array
(
[name] => Nouvu\Database\ComponentFetch
[num] => 111
)

[140] => Array
(
[name] => php7.4
[num] => 111
)

[141] => Array
(
[name] => Database
[num] => 111
)

[142] => Array
(
[name] => Nouvu\Database\Core
[num] => 222
)

[143] => Array
(
[name] => InterfaceDriver
[num] => 333
)

[144] => Array
(
[name] => Nouvu\Database\LermaStatement
[num] => 333
)

)

fetchall( Lerma :: FETCH_GROUP )
Array
(
[111] => Array
(
[0] => Array
(
[id] => 138
[name] => Nouvu\Database\Lerma
)

[1] => Array
(
[id] => 139
[name] => Nouvu\Database\ComponentFetch
)

[2] => Array
(
[id] => 140
[name] => php7.4
)

[3] => Array
(
[id] => 141
[name] => Database
)

)

[222] => Array
(
[0] => Array
(
[id] => 142
[name] => Nouvu\Database\Core
)

)

[333] => Array
(
[0] => Array
(
[id] => 143
[name] => InterfaceDriver
)

[1] => Array
(
[id] => 144
[name] => Nouvu\Database\LermaStatement
)

)

)

fetchall( Lerma :: FETCH_GROUP | Lerma :: FETCH_COLUMN )
Array
(
[111] => Array
(
[0] => Nouvu\Database\Lerma
[1] => Nouvu\Database\ComponentFetch
[2] => php7.4
[3] => Database
)

[222] => Array
(
[0] => Nouvu\Database\Core
)

[333] => Array
(
[0] => InterfaceDriver
[1] => Nouvu\Database\LermaStatement
)

)

Lerma vs PDO= 6%

https://github.com/MouseZver/Lerma



Привет Помидоры..

 

Обновил readme