PHP code example of denniscarrazeiro / php-sql-builder-module

1. Go to this page and download the library: Download denniscarrazeiro/php-sql-builder-module 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/ */

denniscarrazeiro / php-sql-builder-module example snippets


	
use \DennisCarrazeiro\Php\Sql\Builder\Module\Select;

$table = "test";
$column = "id";
$primaryKey = 1;

$select = new Select();
$select->table($table)->where(new Equal(new Column($column), new Value($primaryKey)));





use \DennisCarrazeiro\Php\Sql\Builder\Module\Joins\LeftJoin\LeftJoin;
use \DennisCarrazeiro\Php\Sql\Builder\Module\Select\Select;
use \DennisCarrazeiro\Php\Sql\Builder\Module\Condition\Equal;
use \DennisCarrazeiro\Php\Sql\Builder\Module\Columns\Column;
use \DennisCarrazeiro\Php\Sql\Builder\Module\Values\Value;

$table = 'user as u';
$leftJoinAddress = new LeftJoin('address e',new Equal(new Column('e.id_user'),new Column('u.id')));
$leftJoinCreditCard = new LeftJoin('credit_card c',new Equal(new Column('c.id_user'),new Column('u.id')));

$select = new Select();
$select->table('user as u')
	   ->joins($leftJoinEndereco,$leftJoinCreditCard)
	   ->groupBy(new Column('u.id'))
	   ->where(new Equal(new Column('u.id'),new Value(78)));


bash
curl -sS https://getcomposer.org/installer | php && php composer.phar install