KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.

CodeIgniter Integration #1201

Open Ed Martin opened this topic on on Dec 3 - 8 comments

Ed Martin commented on Dec 3

I am getting very confused by the various options to integrate KoolReport Pro with CodeIgniter. I have not been able to get the sample reports to display as I am having trouble finding the autoload.php which is being required in the MyReport.php controller file. My error indicates the file cannot be found, but there is an error in the path, application is appearing in the path, but I am not sure as to why. My base url is "http://localhost/123/".

I have used composer to install KoolReport Pro, so the files are under the vendor folder.

A PHP Error was encountered Severity: Warning Message: require(C:\xampp\htdocs\123\application\vendor/autoload.php): failed to open stream: No such file or directory Filename: reports/MyReport.php Line Number: 3

KoolReport commented on Dec 4

Could you please check if the path "C:\xampp\htdocs\123\application\vendor/autoload.php" is correct? Can you find that autoload.php file.

Ed Martin commented on Dec 4

The actual path is "C:\xampp\htdocs\123\vendor/autoload.php" The system is adding in the reference to the application directory. I used Composer to install Koolreport Pro. The vendor folder is the same level as application.

I have the base url set as http://localhost/123

KoolReport commented on Dec 4

What is the your require command for the vendor/autoload.php? Can you paste it here.

Ed Martin commented on Dec 4

<?php //MyReport.php require APPPATH."vendor/autoload.php";

KoolReport commented on Dec 4

So you change to:

require_once APPPATH."../vendor/autoload.php";
Ed Martin commented on Dec 4

Thanks, that corrected the issue. I appreciate the fast response!

KoolReport commented on Dec 4

You are welcome :)

Ed Martin commented 7 days ago

I have been working through the examples to learn more about how to integrate Koolreport into my projects. I was working on the Amazing themes example and ran into a similar issue with the path.

A PHP Error was encountered Severity: Warning Message: fopen(../../../databases/customer_product_dollarsales2.csv): failed to open stream: No such file or directory Filename: datasources/CSVDataSource.php Line Number: 131

I configured the MyReport.php file like so:

<?php require_once APPPATH."../vendor/autoload.php";

class MyReport extends \koolreport\KoolReport {

use \koolreport\amazing\Theme;
public function settings()
{
    return array(

  "dataSources"=>array(
    "sales"=>array(
        "class"=>'\koolreport\datasources\CSVDataSource',
        "filePath"=>"../../../databases/customer_product_dollarsales2.csv",
        "fieldSeparator"=>";"
            ),
        ),
    );
}

}

I tried several changes to the class statement and filepath, but have not made progress. I was hpopign to a bit of assitance with this, thanks.

KoolReport Is Free and Open-Source!

KoolReport is a professional php reporting framework which saves you tons of time to construct dynamic data report & dashboard.

  • Connect to various datasources such as MySQL, SQL Server, MongoDB or even from CSV or Excel file.
  • Contain series of powerful built-in data processes for your data manipulation.
  • Generate stunning charts and graphs to help you communicate data insights to your audiences effectively.
  • Integrate seamlessly with any php frameworks such as Laravel, CodeIgniter, Symfony.
Download Now and register our tutorials to get started!

Download KoolReport
help needed
solved

None