PHP code example of abilioj / tool-to-dev

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

abilioj / tool-to-dev example snippets


      use abilioj\ToolToDev\util\ToString;
    
    echo ToString::StringPraMaiusculas('hello world');


      use abilioj\ToolToDev\connection\ConnPDO;

    class connection extends ConnPDO
    {
    }


      use abilioj\ToolToDev\util\Sql

    // Exemplo de uso da classe Sql para gerar uma consulta SQL com JOIN
    $camposTabelas = array("u.nome_usuario", "s.tipo_status", "n.tipo_nivel", "u.data_cadastro_usuario", "u.id_usuario");
    $nomeTabelas = array("u" => "usuario");
    $condicoes = array("u.id_usuario=1");
    $conditionsLeftJoin = array("left join status_usuario s on s.id_status=u.id_status", "left join nivel_usuario n on n.id_nivel=u.id_nivel");

    $sql = new Sql('');
    $sql->arrayTable = $nomeTabelas;
    $sql->camposTabelas = $camposTabelas;
    $sql->ArryasTOMaiusculas = false;
    $sql->conditionsLeftJoin = $conditionsLeftJoin;
    $sql->condicoesTabela = $condicoes;
    $sql->colunaOrdenada = null;
    $sql->ordenacao = null;
    $sql->limit = null;
    $sql->TOP = null;

    echo $sql->sqlPesquisar();
    //resultado: SELECT u.nome_usuario, s.tipo_status, n.tipo_nivel, u.data_cadastro_usuario, u.id_usuario FROM usuario u left join status_usuario s on s.id_status=u.id_status left join nivel_usuario n on n.id_nivel=u.id_nivel WHERE u.id_usuario=1;