PHP code example of nouvu / lerma
1. Go to this page and download the library: Download nouvu/lerma library . Choose the download type require .
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
nouvu / lerma example snippets
Lerma :: create ( DriverEnum $driver ): ConnectDataInterface
new Lerma( string | array $dsn ): Lerma
use Nouvu\Database\{ Lerma, DriverEnum };
num :: MySQLi )
-> setData( host: '127.0.0.1', username: 'root', password: 'root' )
-> setDatabaseName( dbname: 'dbtest' )
-> setCharset( charset: 'utf8' )
-> setPort( port: 3306 )
-> getLerma();
use Nouvu\Database\Lerma;
erma = new Lerma( [ 'mysql:host=%s;username=%s;password=%s;dbname=%s;charset=%s;port=%d',
'127.0.0.1', 'root', 'root', 'dbtest', 'utf8', 3306
] );
use Nouvu\Database\{ Lerma, DriverEnum };
num :: SQLite3 )
-> setFile( __DIR__ . '/dbtest.db' )
-> getLerma();
use Nouvu\Database\Lerma;
erma = new Lerma( [ 'sqlite:db=%s', __DIR__ . '/dbtest.db' ] );
public static function create( DriverEnum $driver ): ConnectDataInterface
public function prepare( string | array $sql, array $data = null ): LermaStatement
public function query( string | array $sql ): LermaStatement
public function execute( array $data ): void
public function rollBack( mixed ...$rollback ): bool
public function beginTransaction( mixed ...$rollback ): bool
public function commit( mixed ...$commit ): bool
public function InsertID(): int
$values = [ 'group' => 6, 'Lerma' ];
$statement = $lerma -> prepare( [ 'SELECT * FROM `%s` WHERE `group` = :group AND `name` = ?', 'table' ], $values );
echo json_encode ( $statement -> fetch( Lerma :: FETCH_ASSOC ), 480 );
{
"id": 8,
"name": "Lerma",
"group": 6,
"text": "Инструмент",
"created_at": "2022-02-06 23:44:30"
}
$values = [
[ 'name1', 'group1', 'text1' ],
[ 'name2', 'group2', 'text2' ],
[ 'name3', 'group3', 'text3' ],
];
$lerma -> prepare( [ 'INSERT INTO `%s`( `name`, `group`, `text` ) VALUES ( ?,?,? )', 'table' ], $values );
echo $lerma -> InsertID(); // 3
$values = [
[ 'name1', 'group1', 'text1' ],
[ 'name2', 'group2', 'text2' ],
[ 'name3', 'group3', 'text3' ],
];
try
{
$lerma -> beginTransaction();
// uses rollBack if Exception
$lerma -> prepare( [ 'INSERT INTO `%s`( `name`, `group`, `text` ) VALUES ( ?,?,? )', 'table' ], $values );
$lerma -> commit();
}
catch ( \Nouvu\Database\Exception\LermaException )
{
}
// 2 ----------------
try
{
$lerma -> beginTransaction();
$lerma -> prepare( [ 'INSERT INTO `%s`( `name`, `group`, `text` ) VALUES ( ?,?,? )', 'table' ] );
foreach ( $values AS $row )
{
$lerma -> execute( $row );
}
$lerma -> commit();
echo $lerma -> InsertID(); // 3
}
catch ( \Nouvu\Database\Exception\LermaException )
{
$lerma -> rollBack();
}
public function fetch( int $mode = null, \Closure | string | null $argument = null ): mixed
public function fetchAll( int $mode = null, \Closure | string | null $argument = null ): iterable
public function rowCount(): int
public function columnCount(): int
public function getIterator(): \Traversable
$statement = $lerma -> query( 'SELECT * ...' );
foreach ( $statement AS $row )
{
// result $row
}
// OR
iterator_to_array ( $statement );
Array
(
[0] => Array
(
[0] => 1
[1] => Nouvu-Skeleton
[2] => 1
[3] => скелет
[4] => 2022-02-06 23:44:30
)
[1] => Array
(
[0] => 2
[1] => Nouvu-Framework
[2] => 1
[3] => ядро
[4] => 2022-02-06 23:44:30
)
[2] => Array
(
[0] => 3
[1] => Nouvu-Web
[2] => 1
[3] => веб
[4] => 2022-02-06 23:44:30
)
...
)
$statement = $lerma -> query( 'SELECT `name` ...' );
while ( $value = $statement -> fetch( Lerma :: FETCH_COLUMN ) )
{
// result #1
}
foreach ( $statement -> fetchAll( Lerma :: FETCH_COLUMN ) AS $value )
{
// result #2
}
$statement = $lerma -> query( 'SELECT `name` ...' );
$statement -> fetchAll( Lerma :: FETCH_FUNC, function ( object $std ) )
{
yield $std -> id => $std;
}
use function Nouvu\Database\Helpers\{ ... };
config( string $offset = null ): mixed
// Отключение именованных плейсхолдеров
config() -> set( 'namedPlaceholders', false );
// Установка режима вывода по умолчанию
config() -> set( 'mode', Lerma :: FETCH_OBJ );
// Вывод списка данных для подключения различных расширений
config( 'drivers' );
use Nouvu\Config\Config;
use Nouvu\Database\Lerma;
use Nouvu\Database\Modules;
return [
'dsn_default' => 'mysql',
'drivers' => [
'mysql' => [
'module' => Modules\MySQLi :: class,
'dbname' => 'dbtest',
'host' => '127.0.0.1',
'port' => 3306,
'charset' => 'utf8',
'username' => 'root',
'password' => 'root'
],
'sqlite' => [
'module' => Modules\SQLite3 :: class,
'db' => 'lerma.db'
],
],
'mode' => Lerma :: FETCH_NUM,
'namedPlaceholders' => true,
'ShemaExceptionConnect' => [
'mysql' => static function ( mysqli_sql_exception $mysqli_sql_exception )
{
throw $mysqli_sql_exception;
},
],
\Facade\Create :: class => [
'mysql' => \Nouvu\Database\Modules\Facade\Mysql\ConnectData :: class,
'sqlite' => \Nouvu\Database\Modules\Facade\Sqlite\ConnectData :: class,
],
]
debug( bool $reset = false ): Debug
echo json_encode ( debug(), 480 );
$connect = $lerma -> connect() -> get();
$stmt = $lerma -> query( [ 'SELECT * FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetch( Lerma :: FETCH_NUM ) );
Array
(
[0] => 1
[1] => Nouvu-Skeleton
[2] => 1
[3] => скелет
[4] => 2022-02-06 23:44:30
)
$stmt = $lerma -> query( [ 'SELECT * FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetchAll( Lerma :: FETCH_NUM ) );
Array
(
[0] => Array
(
[0] => 1
[1] => Nouvu-Skeleton
[2] => 1
[3] => скелет
[4] => 2022-02-06 23:44:30
)
[1] => Array
(
[0] => 2
[1] => Nouvu-Framework
[2] => 1
[3] => ядро
[4] => 2022-02-06 23:44:30
)
[2] => Array
(
[0] => 3
[1] => Nouvu-Web
[2] => 1
[3] => веб
[4] => 2022-02-06 23:44:30
)
[3] => Array
(
[0] => 4
[1] => ContainerPHP
[2] => 2
[3] => ленивая загрузка
[4] => 2022-02-06 23:44:30
)
[4] => Array
(
[0] => 5
[1] => Logger
[2] => 3
[3] => логирование
[4] => 2022-02-06 23:44:30
)
[5] => Array
(
[0] => 6
[1] => Query-Storage-Bank
[2] => 4
[3] => хранимые процедуры
[4] => 2022-02-06 23:44:30
)
[6] => Array
(
[0] => 7
[1] => Neuronet
[2] => 5
[3] => Нейросеть
[4] => 2022-02-06 23:44:30
)
[7] => Array
(
[0] => 8
[1] => Lerma
[2] => 6
[3] => Инструмент
[4] => 2022-02-06 23:44:30
)
[8] => Array
(
[0] => 9
[1] => McBanner
[2] => 7
[3] => Счетчик
[4] => 2022-02-06 23:44:30
)
[9] => Array
(
[0] => 10
[1] => Piramid
[2] => 7
[3] => Пирамида цветная
[4] => 2022-02-06 23:44:30
)
[10] => Array
(
[0] => 11
[1] => Aero
[2] => 8
[3] => старое ядро
[4] => 2022-02-06 23:44:30
)
[11] => Array
(
[0] => 12
[1] => Aero2
[2] => 8
[3] => старое ядро2
[4] => 2022-02-06 23:44:30
)
[12] => Array
(
[0] => 13
[1] => Aero-Authentication
[2] => 9
[3] => в мусор
[4] => 2022-02-06 23:44:30
)
)
$stmt = $lerma -> query( [ 'SELECT * FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetch( Lerma :: FETCH_ASSOC ) );
Array
(
[id] => 1
[name] => Nouvu-Skeleton
[group] => 1
[text] => скелет
[created_at] => 2022-02-06 23:44:30
)
$stmt = $lerma -> query( [ 'SELECT * FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetchAll( Lerma :: FETCH_ASSOC ) );
Array
(
[0] => Array
(
[id] => 1
[name] => Nouvu-Skeleton
[group] => 1
[text] => скелет
[created_at] => 2022-02-06 23:44:30
)
[1] => Array
(
[id] => 2
[name] => Nouvu-Framework
[group] => 1
[text] => ядро
[created_at] => 2022-02-06 23:44:30
)
[2] => Array
(
[id] => 3
[name] => Nouvu-Web
[group] => 1
[text] => веб
[created_at] => 2022-02-06 23:44:30
)
[3] => Array
(
[id] => 4
[name] => ContainerPHP
[group] => 2
[text] => ленивая загрузка
[created_at] => 2022-02-06 23:44:30
)
[4] => Array
(
[id] => 5
[name] => Logger
[group] => 3
[text] => логирование
[created_at] => 2022-02-06 23:44:30
)
[5] => Array
(
[id] => 6
[name] => Query-Storage-Bank
[group] => 4
[text] => хранимые процедуры
[created_at] => 2022-02-06 23:44:30
)
[6] => Array
(
[id] => 7
[name] => Neuronet
[group] => 5
[text] => Нейросеть
[created_at] => 2022-02-06 23:44:30
)
[7] => Array
(
[id] => 8
[name] => Lerma
[group] => 6
[text] => Инструмент
[created_at] => 2022-02-06 23:44:30
)
[8] => Array
(
[id] => 9
[name] => McBanner
[group] => 7
[text] => Счетчик
[created_at] => 2022-02-06 23:44:30
)
[9] => Array
(
[id] => 10
[name] => Piramid
[group] => 7
[text] => Пирамида цветная
[created_at] => 2022-02-06 23:44:30
)
[10] => Array
(
[id] => 11
[name] => Aero
[group] => 8
[text] => старое ядро
[created_at] => 2022-02-06 23:44:30
)
[11] => Array
(
[id] => 12
[name] => Aero2
[group] => 8
[text] => старое ядро2
[created_at] => 2022-02-06 23:44:30
)
[12] => Array
(
[id] => 13
[name] => Aero-Authentication
[group] => 9
[text] => в мусор
[created_at] => 2022-02-06 23:44:30
)
)
$stmt = $lerma -> query( [ 'SELECT * FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetch( Lerma :: FETCH_OBJ ) );
stdClass Object
(
[id] => 1
[name] => Nouvu-Skeleton
[group] => 1
[text] => скелет
[created_at] => 2022-02-06 23:44:30
)
$stmt = $lerma -> query( [ 'SELECT * FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetchAll( Lerma :: FETCH_OBJ ) );
Array
(
[0] => stdClass Object
(
[id] => 1
[name] => Nouvu-Skeleton
[group] => 1
[text] => скелет
[created_at] => 2022-02-06 23:44:30
)
[1] => stdClass Object
(
[id] => 2
[name] => Nouvu-Framework
[group] => 1
[text] => ядро
[created_at] => 2022-02-06 23:44:30
)
[2] => stdClass Object
(
[id] => 3
[name] => Nouvu-Web
[group] => 1
[text] => веб
[created_at] => 2022-02-06 23:44:30
)
[3] => stdClass Object
(
[id] => 4
[name] => ContainerPHP
[group] => 2
[text] => ленивая загрузка
[created_at] => 2022-02-06 23:44:30
)
[4] => stdClass Object
(
[id] => 5
[name] => Logger
[group] => 3
[text] => логирование
[created_at] => 2022-02-06 23:44:30
)
[5] => stdClass Object
(
[id] => 6
[name] => Query-Storage-Bank
[group] => 4
[text] => хранимые процедуры
[created_at] => 2022-02-06 23:44:30
)
[6] => stdClass Object
(
[id] => 7
[name] => Neuronet
[group] => 5
[text] => Нейросеть
[created_at] => 2022-02-06 23:44:30
)
[7] => stdClass Object
(
[id] => 8
[name] => Lerma
[group] => 6
[text] => Инструмент
[created_at] => 2022-02-06 23:44:30
)
[8] => stdClass Object
(
[id] => 9
[name] => McBanner
[group] => 7
[text] => Счетчик
[created_at] => 2022-02-06 23:44:30
)
[9] => stdClass Object
(
[id] => 10
[name] => Piramid
[group] => 7
[text] => Пирамида цветная
[created_at] => 2022-02-06 23:44:30
)
[10] => stdClass Object
(
[id] => 11
[name] => Aero
[group] => 8
[text] => старое ядро
[created_at] => 2022-02-06 23:44:30
)
[11] => stdClass Object
(
[id] => 12
[name] => Aero2
[group] => 8
[text] => старое ядро2
[created_at] => 2022-02-06 23:44:30
)
[12] => stdClass Object
(
[id] => 13
[name] => Aero-Authentication
[group] => 9
[text] => в мусор
[created_at] => 2022-02-06 23:44:30
)
)
$stmt = $lerma -> query( [ 'SELECT `name` FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetch( Lerma :: FETCH_COLUMN ) );
Nouvu-Skeleton
$stmt = $lerma -> query( [ 'SELECT `name` FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetchAll( Lerma :: FETCH_COLUMN ) );
Array
(
[0] => Nouvu-Skeleton
[1] => Nouvu-Framework
[2] => Nouvu-Web
[3] => ContainerPHP
[4] => Logger
[5] => Query-Storage-Bank
[6] => Neuronet
[7] => Lerma
[8] => McBanner
[9] => Piramid
[10] => Aero
[11] => Aero2
[12] => Aero-Authentication
)
$stmt = $lerma -> query( [ 'SELECT * FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetch( Lerma :: FETCH_FUNC, function ( object $data ): string
{
return implode ( ' - ', ( array ) $data );
} ) );
1 - Nouvu-Skeleton - 1 - скелет - 2022-02-06 23:44:30
$stmt = $lerma -> query( [ 'SELECT * FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetchAll( Lerma :: FETCH_FUNC, function ( object $data ): string
{
return implode ( ' - ', ( array ) $data );
} ) );
Array
(
[0] => 1 - Nouvu-Skeleton - 1 - скелет - 2022-02-06 23:44:30
[1] => 2 - Nouvu-Framework - 1 - ядро - 2022-02-06 23:44:30
[2] => 3 - Nouvu-Web - 1 - веб - 2022-02-06 23:44:30
[3] => 4 - ContainerPHP - 2 - ленивая загрузка - 2022-02-06 23:44:30
[4] => 5 - Logger - 3 - логирование - 2022-02-06 23:44:30
[5] => 6 - Query-Storage-Bank - 4 - хранимые процедуры - 2022-02-06 23:44:30
[6] => 7 - Neuronet - 5 - Нейросеть - 2022-02-06 23:44:30
[7] => 8 - Lerma - 6 - Инструмент - 2022-02-06 23:44:30
[8] => 9 - McBanner - 7 - Счетчик - 2022-02-06 23:44:30
[9] => 10 - Piramid - 7 - Пирамида цветная - 2022-02-06 23:44:30
[10] => 11 - Aero - 8 - старое ядро - 2022-02-06 23:44:30
[11] => 12 - Aero2 - 8 - старое ядро2 - 2022-02-06 23:44:30
[12] => 13 - Aero-Authentication - 9 - в мусор - 2022-02-06 23:44:30
)
$statement = $lerma -> query( 'SELECT `name` ...' );
$statement -> fetchAll( Lerma :: FETCH_FUNC, function ( object $data ) ): iterable
{
yield $data -> id => $data;
}
$stmt = $lerma -> query( [ 'SELECT `name`, `text` FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetch( Lerma :: FETCH_KEY_PAIR ) );
Array
(
[Nouvu-Skeleton] => скелет
)
$stmt = $lerma -> query( [ 'SELECT `name`, `text` FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetchAll( Lerma :: FETCH_KEY_PAIR ) );
Array
(
[Nouvu-Skeleton] => скелет
[Nouvu-Framework] => ядро
[Nouvu-Web] => веб
[ContainerPHP] => ленивая загрузка
[Logger] => логирование
[Query-Storage-Bank] => хранимые процедуры
[Neuronet] => Нейросеть
[Lerma] => Инструмент
[McBanner] => Счетчик
[Piramid] => Пирамида цветная
[Aero] => старое ядро
[Aero2] => старое ядро2
[Aero-Authentication] => в мусор
)
$stmt = $lerma -> query( [ 'SELECT `name`, `text` FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetchAll( Lerma :: FETCH_KEY_PAIR | Lerma :: FETCH_FUNC, function ( string $first, string $second ): string
{
return "--- {{$first} | {$second}} ---";
} ) );
Array
(
[Nouvu-Skeleton] => --- {Nouvu-Skeleton | скелет} ---
[Nouvu-Framework] => --- {Nouvu-Framework | ядро} ---
[Nouvu-Web] => --- {Nouvu-Web | веб} ---
[ContainerPHP] => --- {ContainerPHP | ленивая загрузка} ---
[Logger] => --- {Logger | логирование} ---
[Query-Storage-Bank] => --- {Query-Storage-Bank | хранимые процедуры} ---
[Neuronet] => --- {Neuronet | Нейросеть} ---
[Lerma] => --- {Lerma | Инструмент} ---
[McBanner] => --- {McBanner | Счетчик} ---
[Piramid] => --- {Piramid | Пирамида цветная} ---
[Aero] => --- {Aero | старое ядро} ---
[Aero2] => --- {Aero2 | старое ядро2} ---
[Aero-Authentication] => --- {Aero-Authentication | в мусор} ---
)
$stmt = $lerma -> query( [ 'SELECT * FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetchAll( Lerma :: FETCH_UNIQUE, 'group' ) );
Array
(
[1] => stdClass Object
(
[id] => 3
[name] => Nouvu-Web
[group] => 1
[text] => веб
[created_at] => 2022-02-06 23:44:30
)
[2] => stdClass Object
(
[id] => 4
[name] => ContainerPHP
[group] => 2
[text] => ленивая загрузка
[created_at] => 2022-02-06 23:44:30
)
[3] => stdClass Object
(
[id] => 5
[name] => Logger
[group] => 3
[text] => логирование
[created_at] => 2022-02-06 23:44:30
)
[4] => stdClass Object
(
[id] => 6
[name] => Query-Storage-Bank
[group] => 4
[text] => хранимые процедуры
[created_at] => 2022-02-06 23:44:30
)
[5] => stdClass Object
(
[id] => 7
[name] => Neuronet
[group] => 5
[text] => Нейросеть
[created_at] => 2022-02-06 23:44:30
)
[6] => stdClass Object
(
[id] => 8
[name] => Lerma
[group] => 6
[text] => Инструмент
[created_at] => 2022-02-06 23:44:30
)
[7] => stdClass Object
(
[id] => 10
[name] => Piramid
[group] => 7
[text] => Пирамида цветная
[created_at] => 2022-02-06 23:44:30
)
[8] => stdClass Object
(
[id] => 12
[name] => Aero2
[group] => 8
[text] => старое ядро2
[created_at] => 2022-02-06 23:44:30
)
[9] => stdClass Object
(
[id] => 13
[name] => Aero-Authentication
[group] => 9
[text] => в мусор
[created_at] => 2022-02-06 23:44:30
)
)
$stmt = $lerma -> query( [ 'SELECT * FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetchAll( Lerma :: FETCH_GROUP, 'group' ) );
Array
(
[1] => Array
(
[0] => stdClass Object
(
[id] => 1
[name] => Nouvu-Skeleton
[group] => 1
[text] => скелет
[created_at] => 2022-02-06 23:44:30
)
[1] => stdClass Object
(
[id] => 2
[name] => Nouvu-Framework
[group] => 1
[text] => ядро
[created_at] => 2022-02-06 23:44:30
)
[2] => stdClass Object
(
[id] => 3
[name] => Nouvu-Web
[group] => 1
[text] => веб
[created_at] => 2022-02-06 23:44:30
)
)
[2] => Array
(
[0] => stdClass Object
(
[id] => 4
[name] => ContainerPHP
[group] => 2
[text] => ленивая загрузка
[created_at] => 2022-02-06 23:44:30
)
)
[3] => Array
(
[0] => stdClass Object
(
[id] => 5
[name] => Logger
[group] => 3
[text] => логирование
[created_at] => 2022-02-06 23:44:30
)
)
[4] => Array
(
[0] => stdClass Object
(
[id] => 6
[name] => Query-Storage-Bank
[group] => 4
[text] => хранимые процедуры
[created_at] => 2022-02-06 23:44:30
)
)
[5] => Array
(
[0] => stdClass Object
(
[id] => 7
[name] => Neuronet
[group] => 5
[text] => Нейросеть
[created_at] => 2022-02-06 23:44:30
)
)
[6] => Array
(
[0] => stdClass Object
(
[id] => 8
[name] => Lerma
[group] => 6
[text] => Инструмент
[created_at] => 2022-02-06 23:44:30
)
)
[7] => Array
(
[0] => stdClass Object
(
[id] => 9
[name] => McBanner
[group] => 7
[text] => Счетчик
[created_at] => 2022-02-06 23:44:30
)
[1] => stdClass Object
(
[id] => 10
[name] => Piramid
[group] => 7
[text] => Пирамида цветная
[created_at] => 2022-02-06 23:44:30
)
)
[8] => Array
(
[0] => stdClass Object
(
[id] => 11
[name] => Aero
[group] => 8
[text] => старое ядро
[created_at] => 2022-02-06 23:44:30
)
[1] => stdClass Object
(
[id] => 12
[name] => Aero2
[group] => 8
[text] => старое ядро2
[created_at] => 2022-02-06 23:44:30
)
)
[9] => Array
(
[0] => stdClass Object
(
[id] => 13
[name] => Aero-Authentication
[group] => 9
[text] => в мусор
[created_at] => 2022-02-06 23:44:30
)
)
)
$stmt = $lerma -> query( [ 'SELECT `group`, `name` FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetchAll( Lerma :: FETCH_GROUP | Lerma :: FETCH_COLUMN ) );
Array
(
[1] => Array
(
[0] => Nouvu-Skeleton
[1] => Nouvu-Framework
[2] => Nouvu-Web
)
[2] => Array
(
[0] => ContainerPHP
)
[3] => Array
(
[0] => Logger
)
[4] => Array
(
[0] => Query-Storage-Bank
)
[5] => Array
(
[0] => Neuronet
)
[6] => Array
(
[0] => Lerma
)
[7] => Array
(
[0] => McBanner
[1] => Piramid
)
[8] => Array
(
[0] => Aero
[1] => Aero2
)
[9] => Array
(
[0] => Aero-Authentication
)
)
$stmt = $lerma -> query( [ 'SELECT * FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetch( Lerma :: MYSQL_FETCH_FIELD ) );
stdClass Object
(
[name] => id
[orgname] => id
[table] => github_test
[orgtable] => github_test
[def] =>
[db] => dbtest
[catalog] => def
[max_length] => 0
[length] => 11
[charsetnr] => 63
[flags] => 49667
[type] => 3
[decimals] => 0
)
$stmt = $lerma -> query( [ 'SELECT * FROM `%s`', $this -> table ] );
print_r ( $stmt -> fetchAll( Lerma :: MYSQL_FETCH_FIELD ) );
Array
(
[0] => stdClass Object
(
[name] => id
[orgname] => id
[table] => github_test
[orgtable] => github_test
[def] =>
[db] => dbtest
[catalog] => def
[max_length] => 0
[length] => 11
[charsetnr] => 63
[flags] => 49667
[type] => 3
[decimals] => 0
)
[1] => stdClass Object
(
[name] => name
[orgname] => name
[table] => github_test
[orgtable] => github_test
[def] =>
[db] => dbtest
[catalog] => def
[max_length] => 0
[length] => 196605
[charsetnr] => 33
[flags] => 4113
[type] => 252
[decimals] => 0
)
[2] => stdClass Object
(
[name] => group
[orgname] => group
[table] => github_test
[orgtable] => github_test
[def] =>
[db] => dbtest
[catalog] => def
[max_length] => 0
[length] => 11
[charsetnr] => 63
[flags] => 36865
[type] => 3
[decimals] => 0
)
[3] => stdClass Object
(
[name] => text
[orgname] => text
[table] => github_test
[orgtable] => github_test
[def] =>
[db] => dbtest
[catalog] => def
[max_length] => 0
[length] => 196605
[charsetnr] => 33
[flags] => 16
[type] => 252
[decimals] => 0
)
[4] => stdClass Object
(
[name] => created_at
[orgname] => created_at
[table] => github_test
[orgtable] => github_test
[def] =>
[db] => dbtest
[catalog] => def
[max_length] => 0
[length] => 19
[charsetnr] => 63
[flags] => 129
[type] => 12
[decimals] => 0
)
)
$stmt = $lerma -> prepare( [ 'SELECT * FROM `%s` WHERE ?', $this -> table ], [ 1 ] );
print_r ( $stmt -> fetch( Lerma :: MYSQL_FETCH_BIND ) );
Array
(
[0] => 1
[1] => Nouvu-Skeleton
[2] => 1
[3] => скелет
[4] => 2022-02-06 23:44:30
)
$stmt = $lerma -> prepare( [ 'SELECT `name` FROM `%s` WHERE ?', $this -> table ], [ 1 ] );
print_r ( $stmt -> fetch( Lerma :: MYSQL_FETCH_BIND | Lerma :: FETCH_COLUMN ) );
Nouvu-Skeleton