PHP code example of punk / query

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

punk / query example snippets




unk\Query\Sql;

// open the PDO connection and set it || Abrindo conexão com PDO
Sql::setConnection(['driver' => 'mysql',
    'database' => 'database',
    'port' => 'port',
    'username' => 'username',
    'password' => 'password']);

// Connect to an users table || Conectando a tabela de usuários
$users = Sql::from("users");

// listing the users || listando os usuários
foreach ($users->runSelect() as $user) {
    echo $user['full_name'];
}

// listing some users || listando alguns usuários
foreach ($users->where(['enable' , true])->runSelect() as $user) {
    echo $user['full_name'];
}

// listing some users || listando alguns usuários
foreach ($users->where(['enable' , true])->runSelect() as $user) {
    echo $user['full_name'];
}

// diplay Query constructor user join permissions
$users->leftJoin('permissions')->limit(12)->runSelect();

// Union Query
$users->where(['enable' , true])->union($users->where(['enable' , false]));

// Subselect activities to users
$activities = Sql::from("users_activities")->select('count(id)')->where(['user_id', 'id']);
$users->leftJoin('permissions')->select($activities);