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

report generation using php and mysql

Hi,

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.
0
whspider
Asked:
whspider
1 Solution
 
quincydudeCommented:
It would be a long story, including php scripting and formatting. May be you should learn something about php scripting with mysql first?

http://www.w3schools.com/php/php_mysql_intro.asp
0
 
Cornelia YoderArtistCommented:
0
 
UmeshCommented:
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() {
window.print();  
}
 
document.write("<form><input type=button "
+"value=\""+message+"\" onClick=\"printpage()\"></form>");
 
//-->
</script>

Open in new window

0
 
whspiderAuthor Commented:
Thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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