PHP code example of daycry / doctrine

1. Go to this page and download the library: Download daycry/doctrine 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/ */

daycry / doctrine example snippets




use Daycry\Doctrine\Configuration;
use Daycry\Doctrine\Doctrine;

$config = new Configuration();
$config->connection = ['driver' => 'pdo_sqlite', 'memory' => true];
$doctrine = new Doctrine($config);

echo $doctrine->getEm()->getConnection()->fetchOne('SELECT 1');


$doctrine = service('doctrine');
$em = $doctrine->getEm();

// An explicitly named database group:
$reporting = \Daycry\Doctrine\CodeIgniter4\Config\Services::doctrine(true, 'reporting');


use Daycry\Doctrine\DataTables\Builder;

$response = Builder::create()
    ->withQueryBuilder($queryBuilder)
    ->withColumnAliases(['id' => 'p.id', 'name' => 'p.name'])
    ->withSearchableColumns(['p.name'])
    ->withRequestParams($requestParams)
    ->getResponse();

bash
php spark doctrine:publish

bash
php vendor/bin/daycry-doctrine doctrine-bootstrap.php orm:info
php vendor/bin/daycry-doctrine doctrine-bootstrap.php doctrine:doctor --json
php vendor/bin/daycry-doctrine doctrine-bootstrap.php doctrine:cache:warmup

php spark doctrine:doctor --group reporting --json
php spark doctrine:cache:warmup --group reporting