Jump to content

Archived

This topic is now archived and is closed to further replies.

nixalot

Printing ALL Records

Recommended Posts

Hey guys/gals,
I'm a systems administrator for the State of Mississippi, and I've been put in charge of developing an online database system for use by the supervisors of 5 service center locations. The system I'm putting together is populated via data from another database that is entered directly from call center employees we have here in downtown Jackson. The reason we have two databases is because we don't want to give the service center supervisors/employees direct access to the call center data. I have successfully set up Apache, PHP5, and MySQL on a spare computer we have here at the office and using Dreamweaver 8 I have set up a site and numerous PHP pages to display rosters of all the appointments made by date.

First, let me just say that I have come a LONG way from not knowing ANYTHING whatsoever about PHP to where I am now, however, the pages I have set up display 75 records at a time, and I need to add a "Print Roster" button to the pages so that no matter how many records there are, the supervisors don't have to manually skip to each page and print with their browser print button.

What I would theoretically like to do is to have the "Print Roster" button automatically send the print to the printer in landscape format, fit all fields to the page, and print ALL records from the particular recordset that populates each given page.

I know this is doable... I just don't know how. I have a script for retrieving data and displaying the results... is it as simple as using a print() statement?

This is a huge challenge for me to say the least, however, I have begun to catch somewhat of a fever for PHP since I started working with it... I have been amazed at the things you can do with it even thus far...

Thanks!
nixalot [img src=\"style_emoticons/[#EMO_DIR#]/unsure.gif\" style=\"vertical-align:middle\" emoid=\":unsure:\" border=\"0\" alt=\"unsure.gif\" /]

Share this post


Link to post
Share on other sites
[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]
What I would theoretically like to do is to have the "Print Roster" button automatically send the print to the printer in landscape format, fit all fields to the page, and print ALL records from the particular recordset that populates each given page.
[/quote]

well your question is more of a css question, seeing as how the php part is just a standard select everything query and dump it all on the screen, no pagination, etc......

printstuff.php
[code]
<html>
<head>
   <style type="text/css" media="print">
         div.page { height: 750px;
                         width: 800px;
                         filter: progid:D/XImageTransform.Microsoft.BasicImage(Rotation=1); }
   </style>
</head>
<body>
<div class="page">

<?php
   //need to establish connection to database before the following code...
   $sql = "select * from table";
   $result = mysql_query($sql) or die(mysql_error();
   while ($info = mysql_fetch_array($result)) {
       //dunno what columns you have or types or anything. echo your info here...
       echo $info['blah'] . "<br>";
   }
?>

</div>
</html>
</body>
[/code]

i can't really help you on fitting all the fields to the page, as i have no idea what kind of fields or how many there are... but, notice how there is no pagination scripting in there, so it will just dump everything onto the screen.

p.s. - this only works with IE

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.