PHP code example of smeservicesvn / dbal-query-builder-wrapper

1. Go to this page and download the library: Download smeservicesvn/dbal-query-builder-wrapper 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/ */

smeservicesvn / dbal-query-builder-wrapper example snippets


use QueryBuilderBundle\QueryBuilderTool;
use QueryBuilderBundle\Condition;

$queryBuilder = new QueryBuilderTool();
$queryBuilder->addToSelect('u.username, u.id');
$queryBuilder->setFrom('users', 'u');
$queryBuilder->addJoins(QueryBuilderTool::LEFT_JOIN, 'groups', 'gr', 'u.group_id = gr.id');
$queryBuilder->addGroupBy('id', 'gr');
$queryBuilder->addIntCondition('recycled', 'u', 0, Condition::EQUAL);
$queryBuilder->addCondition(new Condition(Condition::IS_NOT_NULL, 'id', 'gr'));

$sql = $queryBuilder->getSqlQueryWithParams();
echo $sql;
// Output: SELECT u.username, u.id  FROM users u  LEFT JOIN groups gr ON u.group_id = gr.id  WHERE  u.recycled = 0  AND  gr.id IS NOT NULL  GROUP BY gr.id