Reg using Jasper reports in PHP/MySQL web application installed using XAMPP

[sierratec1]

Hi,

1. For our web application using PHP  & MySQL DB we need to generate reports using jasper reports.
2. We are using XAMPP
3. We have installed Jaspersoft iReport 5.6.0
4. Please suggest how can we connect to our MySQL DB
5. Please suggest whether we need to install anything aditionally
6. To connect to DB - I tried the steps as in this ref link http://chathurangat.blogspot.in/2012/03/jasperreports-with-php.html
   1. I selected MySQL (com.mysql.jdbc.Driver) - JDBC Driver (as in step No. 6)
   2. Please suggest what I need to give JDBC url for this jdbc:mysql://localhost/DatabaseName
   3. My DB is availabe in MySQL - this can be accessed using phpmyadmin interface

 

Thank you

[sierratec1]

We did a fresh xampp installation. After starting Apache, MySQL and Tomcat using below setting. Now we could able to connect to MySQL tables and could able to view the report using 'Preview' option

JDBC Driver: MySQL (org.gjt.mm.mysql.Driver) JDBC Url:jdbc:mysql://localhost/DatabaseName

Kindly suggest how can we link to PHP web application. We need to open the report when clicking a link available in PHP web application

Thanks