sierratec1 Posted June 25, 2015 Share Posted June 25, 2015 Hi,For our web application using PHP & MySQL DB we need to generate reports using jasper reports.We are using XAMPPWe have installed Jaspersoft iReport 5.6.0Please suggest how can we connect to our MySQL DBPlease suggest whether we need to install anything aditionallyTo connect to DB - I tried the steps as in this ref link http://chathurangat.blogspot.in/2012/03/jasperreports-with-php.htmlI selected MySQL (com.mysql.jdbc.Driver) - JDBC Driver (as in step No. 6)Please suggest what I need to give JDBC url for this jdbc:mysql://localhost/DatabaseNameMy DB is availabe in MySQL - this can be accessed using phpmyadmin interface Thank you Link to comment Share on other sites More sharing options...
sierratec1 Posted June 29, 2015 Author Share Posted June 29, 2015 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' optionJDBC Driver: MySQL (org.gjt.mm.mysql.Driver) JDBC Url:jdbc:mysql://localhost/DatabaseNameKindly suggest how can we link to PHP web application. We need to open the report when clicking a link available in PHP web applicationThanks Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now