Snippets Other
Other
Avery 5160 Print mod
by: Techmaster
|
March 5, 2004
Version: 1.2
Type: Full Script
Category: Other
License: GNU General Public License
Description: This script allows you to print to the avery 5160 standard PHPBuliders members helped me make and I think it's just right to share it with the rest of PHP Builder Thanks again for making my life that much easier
<?php
/**
* /----------------------------------------------------------------------\
* | Digital Express, Inc.
* | Copyright (c) 2002 Richard Clark All rights reserved.
* | http://www.dvexinc.com
* | <richievc@hotmail.com>
* |
* | AVERY 5160 Print Lables Moduel v 1.1.2 revised
* /----------------------------------------------------------------------\
*/
/**************************************************************** */
/**************************************************************** */
/**************************************************************** */
?>
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<title>Avery 6150</title>
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>Techmaster</o:Author>
<o:Template>Normal</o:Template>
<o:LastAuthor>Techmaster</o:LastAuthor>
<o:Revision>2</o:Revision>
<o:TotalTime>3</o:TotalTime>
<o:Created>2004-02-09T19:49:00Z</o:Created>
<o:LastSaved>2004-02-09T19:49:00Z</o:LastSaved>
<o:Pages>1</o:Pages>
<o:Words>36</o:Words>
<o:Characters>206</o:Characters>
<o:Company>Digital Express</o:Company>
<o:Lines>1</o:Lines>
<o:Paragraphs>1</o:Paragraphs>
<o:CharactersWithSpaces>241</o:CharactersWithSpaces>
<o:Version>10.3501</o:Version>
</o:DocumentProperties>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman"; margin-left:0in; margin-right:0in; margin-top:0in}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes}
@page Section1
{size:8.5in 11.0in;
margin:.5in 13.6pt 0in 13.6pt;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:4;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman"}
</style>
<![endif]-->
</head>
<body lang=EN-US style='tab-interval:.5in'>
<?
// CONN TO DB
$res = db_query("SELECT * FROM user
WHERE user_zip = '$user_zip'");
if (db_numrows($res) < 1){
echo "<CENTER><B>No Results</B></CENTER>";
} elseif (db_numrows($res) > 0) {
$cols = 0;
$rows = 0;
$max_cols=3;
$max_rows=10;
// Set the num of rows and cols
while ($data=db_fetch_array($res)){
# if ($rows == 0){ // echo out table info
#
# }
if ($cols < 1){ // output the tr
echo "<div class=Section1>
<table class=MsoNormalTable border=0 cellspacing=2 cellpadding=2
style='border-collapse:collapse;padding-top-alt:0in;padding-bottom-alt: 0in'>";
echo "<tr style='yfti-irow:0;page-break-inside:avoid;height:1.0in'>";
}
echo "<td width=189 style='width:189.0pt;padding:0in .75pt 0in .75pt;height:1.0in'>
<p class=MsoNormal align=center style='margin-top:0in; margin-right:5.3pt;
margin-bottom:0in; margin-left:5.3pt; margin-bottom:.0001pt;text-align:center'>
<span class=SpellE>";
echo "<FONT SIZE=1 FACE=\"Arial\">";
if ($data[user_co_name]) {
echo "$data[user_co_name]<BR>";
}
echo "$data[f_name] $data[l_name]<BR>
$data[user_address]<BR>
$data[user_city] $data[user_st]. $data[user_zip]</FONT>";
echo "</span></p></td>";
// before, you were outputting the end of the td before the beginning
$cols++;
if ($cols == $max_cols){ // reset cols, make new row, output trs
echo '</tr>';
$rows++;
$cols=0;
}
if ($rows == $max_rows){ // reset rows, end table,put in line break--I substituted <hr>
echo "</table></div><BR><BR>";
$rows=0;
}
}//end while loop
//now the tricky part, completing the last table
if ($cols == 0 && $rows == 0){ //done
} else { //end cols, then end table
while ($cols !=0 && $cols < $max_cols){//don't do if the cols have been reset
echo "<td width=252 style='width:189.0pt;padding:0in .75pt 0in .75pt;height:1.0in'>
<p class=Normal align=center style='margin-top:0in; margin-right:5.3pt;
margin-bottom:0in; margin-left:5.3pt; margin-bottom:.0001pt;text-align:center'>
<span class=SpellE> </td>";
$cols++;
}
if ($cols == $max_cols) echo '</tr>';//to end the row if needed
echo '</table></div>'; //to end the table
}//end else
}//end if there are more than 0 rows
?>
</body></html>
<?
/**************************************************************** */
/**************************************************************** */
/**************************************************************** */
?>
PHPBuilder
Policies
PHP Developer
Topics
PHP Developer
Resources
PHP Developer
References
