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

 


PHPMagic   My Contact Table   Database Tools   Specials   Reports   Order
MySQL Database Report Generator
Home » PHP Reports Generator
 
Database Reports - PHP Reports 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

 

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-2008 Website Databases All rights reserved
Home  |  PHPMagic  | Database Tools  |  Download  |   Forums  |  Contact
 
Order Now