Database Reports and Database Queries
Home  |   Forums  |  Contact Us
PHP Magic
Overview
PHP Magic Demo
Download Free Trial
Download Free Samples
F.A.Q.
Order Now
Database Software
PHP Form Processor
Database Reports
Scripts & Software
Access to MySQL *
Excel to MySQL *
Members Login Script *
Web Form Security *
Website Databases
About Us
Contact Us
Forums
Order Now

 

 

Discounted Products
Access to MySQL*
Excel to MySQL*
Members Login Script*
Web Form Security*
Get all 4 for only $19.95

 


PHPMagic   PHPMagic Plus   Database Reports   PHP Forms   Order
MySQL Database Report Generator
Home » PHP Database Report Generator
 
Database Reports - PHP Report Generator

Generate your database reports with this wizard in only a few minutes on any of your existing MySQL databases. Since this is a php driven application you simply upload the application files to a folder within your web site and you are ready to generate reports. Execute statistical queries such as sum a column.

This MySQL database report tool is simple to use even for the novice. No coding experience required. Try it here and see for yourself.

Screenshots - > Here

   Database Reports in Only 10 simple steps ~

 

Step 1: Begin
Upload the files and point your browser to the folder you uploaded the files:
www.yoursite.com/some_folder/index.php

 

Step 2: Connect to your database
Enter MySQL database parameters and select connect.

 

Step 3: Select Database Reports or Execute SQL queries
Once connected your database(s) available will be displayed. Select to run a report or execute an SQL query. (If you slect SQL Query you will be taken to an SQL query textbox.) Select -> continue.

 

Step 4: Select Table
Select the table -> continue
(If you select SQL Query you will be taken to an SQL query textbox.)

 

Step 5: Select Fields
Select the fields for this report -> continue. *Perform statistical operation on a field.

 

Step 6: Select Grouping Order
Select the fields to group by for this report -> continue.

 

Step 7: Select Sorting Order
Select the order to display the fields and the ascending or decending order -> continue.

 

Step 8: Select Report Layout
Select the type of layout you wish to view your report. Most similar to ms access reports. Block, Outline1, Outline2, Align Left 1, Align Left 2-> continue.

 

Step 9: Select Report Style
Select the css to display your data or create your own -> continue.

 

Step 10: Select Report Settings
Enter Report Title, header text, footer text, Report name and the number of records to display per page -> Generate - Print or export reports to csv or pdf file.

 

Generated reports will be displayed to browser and the report file generated is stored in a folder named reports for future reference. This allows you to create links or add a bookmark to the reports for future use without recreating the same report over and over. Note on using Multiple Tables

Target system requirements: The system where you will install the PHP application must support PHP scripting; PHP 4 or higher; MySQL 3.x or higher.

Back to top

© 2003-2012 Website Databases All rights reserved
Home  |  PHPMagic  | PHP Forms  |  Forums  |  Contact
 
Order Now