PHP code example of rebib / mysql-querybuilder

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

rebib / mysql-querybuilder example snippets


$selectBuilder = QueryBuilder::select();
$selectBuilder->setTable('TableA');
//AND QUERY
$andQuery      = QueryCreator::getAndQuery();
$andQuery->add(
    QueryCreator::getEqualQuery()->add(
        'status', 1));
//OR QUERY
$orQuery       = QueryCreator::getOrQuery();
$orQuery->add(
    QueryCreator::getEqualQuery()->add(
        'name', 'Sam')
);
$orQuery->add(
    QueryCreator::getEqualQuery()->add(
        'sex', 'm')
);
//ADD OrQuery to AndQuery   
$andQuery->add($orQuery);
$selectBuilder->getWhereQueryBuilder()->addQuery($andQuery);
//OUTPUT QUERY & PARAMS
$query         = $selectBuilder->buildQuery();
$parameters    = $selectBuilder->getQueryParameters();