helpful script - horizontal looper, can be used for labels

[sfullman]

Hi All,

This script is about as basic as they come, for you newbies looking to print out labels or pictures or whatever in a "horizontal loop" where you control the # of columns.

this one is designed to print labels also by allowing an "offset" i.e. how many places we move forward. Appreciate your feedback on it - mods can this go in the resources section ? :-)

/***
this is the most basic script for printing labels - couldn't be much easier than this!
***/
//I must know the number of items.
$count=50;
$cols=10;
$offset=14; // must be > 1

if($count){ /*** <= use || here if desired to show a blank row ***/
	if(!$cols)$cols=3;
	if($offset<1)$offset=1;
	//how many rows the table will have - use this to start a new page if necessary
	$rows= ceil(($count+($offset-1))/$cols);

//total number of cells
$total=$rows*$cols;

//table here
?><table border="1"><?php
for($i=1;$i<=$total;$i++){
	//whether we're in an object cell or not
	$object=($i>($offset-1) && $i<=($count+($offset-1)) ? true : false);

	//what row we are on
	if(!fmod($i-1,$cols)){
		//declare table row
		?><tr><?php
		$row++;
		$posn='left';
	}
	//middle cell
	$posn=(!fmod($i-1,$cols) && !fmod($i,$cols) ? 'mid' : $posn);

	//now declare the actual table cell
	?><td><?php
	if($object==true){
		//here you'd pull from your result set for example $record=mysql_fetch_array($result,MYSQL_ASSOC);
		?>label here<?php
	}else{
		//do whatever needed for an empty cell or label
		?> ________ <?php
	}
	?></td><?php

	if(!fmod($i,$cols)){
		//close table row
		if($row<$rows){ ?></tr><?php }
		//open new table row
		?><tr><?php
		$posn='right';
	}
}
//close table
?></tr></table><?php
}

[halojoy]

Good script.

Comments to some of my changes in code below:
- removed some variables not needed for basic use, $row $posn
- <tr> only added in beginning, to avoid <tr><tr>
- added echo "\n" to prroduce nice HTML source code

<?php
error_reporting(E_ALL); //debug setting

 /*** basic script for printing labels in a table ***/

//number of items,columns and offset
$count=16;
$cols=5;
$offset=7; 

if($count){

if(!isset($cols))$cols=3; //default 3 columns
if(!isset($offset)||$offset<1)$offset=1; //must be >=1

//how many rows in table - can be used to start a new page
$rows= ceil(($count+($offset-1))/$cols);
//total number of cells
$total=$rows*$cols;

//table here
?><table border="1"><?php
echo "\n";

for($i=1;$i<=$total;$i++){

    //new table row
    if(!fmod($i-1,$cols)){
        ?><tr><?php
    echo "\n";
    }

    //whether we're in an object cell or not
    $object=($i>($offset-1) && $i<=($count+($offset-1)) ? true : false);

    //now declare the actual table cell
    ?><td><?php
    if($object==true){
        //here you'd pull from your result set for example $record=mysql_fetch_array($result,MYSQL_ASSOC);
        ?>label here<?php
    }else{
        //do whatever needed for an empty cell or label
        ?> ________ <?php
    }
    ?></td><?php
echo "\n";

    //close table row
    if(!fmod($i,$cols)){ 
        ?></tr><?php
    echo "\n";
    }

}

//close table
?></table><?php
}

?>

will produce this HTML code:

<table border="1">
<tr>
<td> ________ </td>
<td> ________ </td>
<td> ________ </td>
<td> ________ </td>
<td> ________ </td>
</tr>
<tr>
<td> ________ </td>
<td>label here</td>
<td>label here</td>
<td>label here</td>
<td>label here</td>
</tr>
<tr>
<td>label here</td>
<td>label here</td>
<td>label here</td>
<td>label here</td>
<td>label here</td>
</tr>
<tr>
<td>label here</td>
<td>label here</td>
<td>label here</td>
<td>label here</td>
<td>label here</td>
</tr>
<tr>
<td>label here</td>
<td>label here</td>
<td> ________ </td>
<td> ________ </td>
<td> ________ </td>
</tr>
</table>

[Weedpacket]

Consider using the modulus operator % rather than the floating-point fmod() function. I.e.,

($i%$cols == 1)

instead ofcode=php[/code]

[hermes369]

I've been investigating your technique as a solution to a problem I have. Since I'm a big noob, I'm not convinced I'm conceptualizing the problem correctly. I've been able to get a result close to what I want, but the resulting html is hideous:

<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body>
<?php

$link = mysql_connect('localhost', 'xxx', 'xxxx');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo "Connected successfully"."<br />" . "\n";
mysql_select_db("usaDlrData", $link)
  or die("Couldn't select database.");
$sql = 'SELECT usaDlrStates.usState, usaDlr.*'
        . ' FROM usaDlr'
        . ' LEFT JOIN usaDlrStates ON usaDlr.usStateAbbr = usaDlrStates.usStateAbbr '
        . ' ORDER BY usaDlrStates.usState ASC';
$result = mysql_query($sql, $link);
if (!$result) {
        die('Invalid query: ' . mysql_error());
}
function nullCheck($varName) {
        $showVar = "";
        if (strlen($varName)  > 1) {
                 $showVar = $varName . "<br />\n";
        }
        return $showVar;
}
echo "<table border='2'>";
$cellCount = 1;
$recordCount = 0;
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
        $usState = $row{'usState'};
        $usaDlrName = $row{'usaDlrName'};
        $usaDlrAddr = $row{'usaDlrAddr'};
        $usaDlrAddr1 = $row{'usaDlrAddr1'};
        $usaDlrCity = $row{'usaDlrCity'};
        $usStateAbbr = $row{'usStateAbbr'};
        $usaDlrZip = $row{'usaDlrZip'};
        $usaDlrPhone = $row{'usaDlrPhone'};
        $usaDlrPhone2 = $row{'usaDlrPhone2'};
        $usaDlrZip = $row{'usaDlrZip'};
        $usaDlrFax = $row{'usaDlrFax'};
        $usaDlrEmail = $row{'usaDlrEmail'};
        $usaDlrWebSite = $row{'usaDlrWebSite'};
        $usaDlrLogo = "<img src='http://www.scubadorag.com/coco/adsLogos/".$row{'usaDlrLogo'}."' alt='Visit ".$usaDlrName.".' />";
        $usaDlrID = $row{'usaDlrID'};
        $record = "\t\t".$usaDlrName."<br />\n"
                ."\t\t".$usaDlrAddr."<br />\n"
                ."\t\t".nullCheck($usaDlrAddr1)
                .$usaDlrCity.", ".$row{'usStateAbbr'}."<br />". "\n"
                ."\t\t".$usaDlrZip."<br />". "\n"
                ."\t\t".nullCheck($usaDlrPhone)
                ."\t\t".nullCheck($usaDlrPhone2)
                ."\t\t".nullCheck($usaDlrFax)
                ."\t\t<a href='mailto:".$usaDlrEmail."'>".$usaDlrEmail."</a>". "<br />\n"
                ."\t\t<a href='http://".$usaDlrWebSite."'>".$usaDlrWebSite."</a><br />\n"
                ."\t\t".$usaDlrLogo."<br />\n";
        while ($usState != $usaStateHeader) {
                echo "<tr>\n\t<th colspan='3'>\n\t\t<h1>".$usState."</h1>\n\t</th>\n</tr>\n";
                $usaStateHeader = $usState;
                print "<tr>\r";
                $cellCount = 1;
        }
        if ($cellCount == 3) {
                print "\t<td align='left' valign='top'>\r".$record."\n\t</td>\n</tr>\r";
                $cellCount = 1;
        } else {
                print "\t<td align='left' valign='top'>".$record."</td>\r";
                $cellCount++;
        }
}
echo "</table>";
mysql_free_result($result);
mysql_close($link);
?>
</body>
</html>

I've been working with your example as it's more flexible, it doesn't get me the

<th>*</th>

row, but the results are much more attractive, and ah, valid.

Please be gentle!
Thanks again,
B.