Skip to content

erro ao conectar com banco de dados MYSQL - Windows10 #126

@ivanfsilva

Description

@ivanfsilva

Olá,

Estou usando o PHP 7.2.9 e nenhum framework como Laravel.

Quando eu executo o script PHP sem a conexão ao BD, o relatório é executado normalmente. Quando eu coloco a conexão do BD, dá o seguinte erro:

Fatal error: Uncaught PHPJasper\Exception\ErrorCommandExecutable: Your report has an error and couldn 't be processed!\ Try to output the command using the function output(); and run it manually in the console. in C:\xampp\htdocs\PortPar\vendor\geekcom\phpjasper\src\PHPJasper.php:219 Stack trace: #0 C:\xampp\htdocs\PortPar\views\relContasBancariasPorEmpresa.php(48): PHPJasper\PHPJasper->execute() #1 C:\xampp\htdocs\PortPar\core\controller.php(13): require('C:\xampp\htdocs...') #2 C:\xampp\htdocs\PortPar\controllers\contasBancariasController.php(120): controller->loadView('relContasBancar...', Array) #3 C:\xampp\htdocs\PortPar\core\Core.php(43): contasBancariasController->relContasBancariasPorEmpresa() #4 C:\xampp\htdocs\PortPar\index.php(30): Core->run() #5 {main} thrown in C:\xampp\htdocs\PortPar\vendor\geekcom\phpjasper\src\PHPJasper.php on line 219

Uma pergunta: baixando o conector mysql, preciso copiá-lo para alguma pasta específica no XAMPP ?

SEGUE o SCRIPT PHP:

`<?php

use PHPJasper\PHPJasper;

$input = '\\xampp\htdocs\PortPar\rel\relContasBancarias.jasper';  
$output = '\\xampp\htdocs\PortPar\rel';    
$options = [
    'format' => ['pdf'],
    'locale' => 'pt_BR',
    'params' => [],
    'db_connection' => [
        'driver' => 'mysql',
        'username' => 'root',
        'password' => '',
        'host' => 'localhost',
        'database' => 'sdp',
        'port' => '3306'
    ]
];

$jasper = new PHPJasper;

$jasper->process(
    $input,
    $output,
    $options
)->execute();

// loading the file

$file = ('\\xampp\htdocs\PortPar\rel\relContasBancarias.pdf');
$filename = ('\\xampp\htdocs\PortPar\rel\relContasBancarias.pdf');
header('Content-type: application/pdf');
header('Content-Transfer-Encoding: binary');
header('Accept-Ranges: bytes');
@readfile($file);

?>`

Obrigado!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions