• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 844
  • Last Modified:

report generation using php and mysql


I have created a table empl for employes.now i need to know how to make a report format of the details of the employes and enable a print of the same.
1 Solution
It would be a long story, including php scripting and formatting. May be you should learn something about php scripting with mysql first?

Cornelia YoderArtistCommented:
UmeshMySQL Principle Technical Support EngineerCommented:
If its a one time requirement and then its very simple..  But if you want a tool which generates report then Pls go for any reporting tools suggested in prev comments.... also search for Open Source free reporting tools if you wnat to go for Free reporting tools

I assume that you have a web server running and it supports php.

1. Create a php page which connects MySQL server and pulls the data from the table emp
2. Make use of below java script snippet to print the current page(should be in <head> of the current page)

<script language="Javascript1.2">
var message = "Print this Page";
function printpage() {
document.write("<form><input type=button "
+"value=\""+message+"\" onClick=\"printpage()\"></form>");

Open in new window

whspiderAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now