jdorn / php-reports

A PHP framework for displaying reports from any data source, including SQL and MongoDB
http://jdorn.github.com/php-reports
GNU Lesser General Public License v3.0
478 stars 235 forks source link

Sample of usege PHP reports #104

Open danivu opened 11 years ago

danivu commented 11 years ago

Hi

Add sample reports to ZIp, from this i wasn't able to run, (they did not work). Please, add some reporth which will work ) to have test structure.

Thank you.

jdorn commented 11 years ago

The "Get Timezones Contained in a Region" report should work fine without any configuration. If it doesn't, make sure you follow the "Getting Started" section on http://jdorn.github.io/php-reports/

The MySQL and MongoDB sample reports depend on specific table and column names and are only meant as a starting point. If you put in your own SELECT query or MongoDB code that works with your database configuration, those reports should work as well.

leex279 commented 10 years ago

For me it doesn´t work, too. The link gives me: http://localhost/php-reports/report/html/?report=php/timezones.php

And its shown an error: 404 not found.

I followed exeactly the "Getting Startet" section.

mod_rewrite is on and htaccess, too.

Whats the problem?!

karol-wojcik commented 10 years ago

I finally got it working!

The problem is with dash "-" character in the url. Just remove it (rename directory and restart webserver) and that's all :)

Starfish777 commented 9 years ago

@karol-wojcik I uploaded the files directly out of the php-reports directory. So the dash in the php-reports part of the url is a non-issue for me. However, I still get the 404 Not Found Error (The requested URL /report/html/ was not found on this server.). The URL directs to --> http://localhost/report/html/?report=mysql/all-orders.sql But there is no /report/html directory in the cloned files. None of the reports are working when clicking on any of the "Report List" page links. They all direct to 404 Not Found error, citing the /report/html directory as not being found. I don't know if it was missing from the cloned git files or if it is auto-generated. Any insights would be helpful.

mvenkat777 commented 9 years ago

@jdorn

My rewrite module is on / htaccess downloaded I also had the same problem of 404 errors clicking on any of the reports like : http://localhost/phpreports/report/html/?report=mysql/drilldown/customer-orders.sql

Any help to fix this would be appreciated

mattrummler commented 8 years ago

I'm seeing the same problem with 404 errors when clicking on reports. I suppose it's an issue with the rewrite rules in .htaccess but I'm not going to dig into it as I have 3 other report platforms to evaluate.

Here is a definition of the problem & my configuration: Windows, Apache (2.2), MySQL 5.6 (very very likely not part of the issue),PHP 5.4.3. I followed the getting started guide. I see the main page but when I click on one of the default PHP reports (one of the timezone related reports) I receive a 404 error, (as far as I can tell @ a glance, because of a malformed URL).

Also, made sure there were no - in my path or URL.

If I don't like or experience a lot of difficulty with the other reporting solutions I will come back and work on this one (or just write something myself).

Thanks

rtmvnv commented 5 years ago

I had a similar problem and solved it by adding the following .htaccess file in the php-reports folder.

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php [QSA,L]

DirectoryIndex index.php