emagoediv/queryxel

Gerador de arquivo exel com consultas sql - Exel file generator with sql queries

dev-master 2022-04-15 00:12 UTC

MIT

• Matheus Amorim

README

Generate exel files with the query result in the database quickly

Utilização:

To use:

Para utilizar essa dependência, siga o exemplo abaixo:

<?php

    require_once './vendor/autoload.php';

    use exelrel\method\Generate;

    $conn = new PDO('mysql:host=yourhost;dbname=yourdatabase', 'youruser', 'yourpass');
    $query = "SELECT nameUser, userId FROM users";
    $test = new Generate($conn, $query, '/.arquivosExel/', ['name of user', 'id of user']);
    $test->generateExel();  

Image of result:

Params:

• PDO $ObjPDOConection (Your object PDO),

• string $sqlQuery (Your querie),

• string $dir (Your diretory of save files),

• array $header (First row of your queries)