PHP code example of ngekoding / sql-column-alias-extractor

1. Go to this page and download the library: Download ngekoding/sql-column-alias-extractor 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/ */

ngekoding / sql-column-alias-extractor example snippets


use Ngekoding\SqlColumnAliasExtractor\SqlColumnAliasExtractor;

$sql = "SELECT u.id, u.name AS username FROM users u";

$aliases = SqlColumnAliasExtractor::extract($sql);

print_r($aliases);
// [
//   'id' => 'u.id',
//   'username' => 'u.name'
// ]


use Ngekoding\SqlColumnAliasExtractor\SqlColumnAliasExtractor;

$wildcardResolver = function ($tableName) {
    // Example resolver for demo purposes.
    // In production, fetch column names dynamically from your database.
    if ($tableName === 'users') {
      return ['id', 'name', 'email'];
    }
    return [];
};

$sql = "SELECT u.*, c.name AS company_name FROM users u JOIN companies c ON c.user_id=u.id";

$aliases = SqlColumnAliasExtractor::extract($sql, $wildcardResolver);

print_r($aliases);
// [
//   'id' => 'u.id',
//   'name' => 'u.name',
//   'email' => 'u.email',
//   'company_name' => 'c.name'
// ]


use Ngekoding\SqlColumnAliasExtractor\Adapter\CodeIgniter3Adapter;
// use Ngekoding\SqlColumnAliasExtractor\Adapter\CodeIgniter4Adapter;

// IMPORTANT! We don't call the `get` function here.
$queryBuilder = $this->db
    ->select('u.id, u.name, u.email, c.name company_name')
    ->from('users u')
    ->join('companies c', 'c.user_id=u.id');

$aliases = CodeIgniter3Adapter::extract($queryBuilder);

print_r($aliases);
// [
//   'id' => 'u.id',
//   'name' => 'u.name',
//   'email' => 'u.email',
//   'company_name' => 'c.name'
// ]