Wrap Columns Down

[stratguitar]

Hello!

I found this piece of code for wrapping multiple rows from a db query that displays items down then across: here in one of the forums at:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10226667

DISPLAYING RESULTS IN COLUMNS

i.e.

a d g
b e h
c f i

Which is something I'd like to use.

This code works fine if the rows returned are divisible equally by 6 (or 3).

HOWEVER, if the number of columns is changed to 4, the code blows up. (example: 78 rows works fine with this code as is, or with num_cols=3, but with num_cols=4, there is a remainder of 2, and the code reports undefined offset 78 and 79)

How to rewrite this or append it so that one can change the columns to another number easily, i.e. 4 or 5?

$sql = "SELECT * FROM Items WHERE Category='$CA' ORDER BY ItemName";
$result = mysql_query($sql, $db) or die('MySQL error: ' . mysql_error() . '<br>Query: ' . $sql);

echo "<table>\n";

$num_rows = mysql_num_rows($result);
$num_cols = 6; //number of columns to display
$disp_rows = ceil($num_rows/$num_cols);
while ($row = mysql_fetch_array($result)) {
$data_array[] = $row;
}
for ($i=0; $i<$disp_rows; $i++) {
echo '<tr>';
for ($j=0; $j<$num_cols; $j++) {
echo '<td>'. $data_array[(($disp_rows*$j)+$i)][0] .'</td>';
}
echo "</tr>\n";
}
echo "</table>\n";

Thanks!
Strat

[spighita]

I use something like this,

$i=1;

while($row=mysql_fetch_array($rs)){
if ($i==1) { 
			echo "<TABLE width='400'cellspacing='0' cellpadding='0' border='0'>";
			} //end if ($i==1)
		if ($i%3==0){ 
			echo "<TR>";
			} //end if ($i%3==1)
		echo "<TD>", $row['name']." ". $row['lastname']." </TD>";
		if(($i%3)==2){ echo "</TR>";}
		$i++;
}
}
echo "</TABLE>";

Anyway this will also get what you are looking for.

I close the table outside the if

[stratguitar]

Thanks!

With the addition of a missing forward bracket or removal of one too many end brackets, this works just perfectly (either way.... )! (I expect that's what you intended as I got an error without it, but want to make sure I'm doing this correctly.)

AS WRITTEN ABOVE - ERROR MESSAGE
Parse error: parse error, unexpected '}' in D:\test\wrapdown_new.php on line 38

Line 38 represents the final bracket of your code prior to
echo "</TABLE>";

I would like to ensure that I'm putting the missing forward bracket in the correct place; or may I assume the last } bracket is one too many?:

Just learning to interpret the code; I appreciate the notations you included with yours. Very, very helpful, indeed!

Strat

[stratguitar]

Er, actually -- I just reviewed this...

It wraps across, not down. That's why I posted the original code, in my first note -- because I already have an 'across' wrapper. My client insists it wrap down.

I actually found the original code in another forum just now; there was a missing definition that, once implemented, allows this code to work. I don't know if I'm permitted to post this, but am doing it anyway, because it's very helpful (column by Matt Wade), and took me 3 days to find; I'd like it here for others to share since my subject title should make searching much easier. 😃

<?PHP
$columns = 4;

mysql_connect('localhost','','');
mysql_select_db('test');
$query = "SELECT stuff FROM mystuff ORDER BY stuff";
$result = mysql_query($query);

$num_rows = mysql_num_rows($result);

//we are going to set a new variables called $rows
$rows = ceil($num_rows / $columns);

//to do this display, we will need to run another loop
//this loop will populate an array with all our values
while($row = mysql_fetch_array($result)) {
$data[] = $row['stuff'];
}

echo "<TABLE BORDER=\"0\">\n";

//here we changed the condition to $i < $rows
for($i = 0; $i < $rows; $i++) {

echo "<TR>\n";

//here will run another loop for the amount of columns
for($j = 0; $j < $columns; $j++) {
    if(isset($data[$i + ($j * $rows)])) {
        echo "<TD>" . $data[$i + ($j * $rows)] . "</TD>\n";
    }
}
echo "</TR>\n";

}
echo "</TABLE>\n";
?>

also included was one for multiple column display:

<?PHP
$columns = 4;

mysql_connect('localhost','root','LRMSys2k');
mysql_select_db('test');

//change the query to get another field from the database
$query = "SELECT stuff, morestuff FROM mystuff ORDER BY stuff";
$result = mysql_query($query);

$num_rows = mysql_num_rows($result);

$rows = ceil($num_rows / $columns);

while($row = mysql_fetch_array($result)) {
$data[] = $row['stuff'];

//store the other field into an array
$data2[] = $row['morestuff'];

}

echo "<TABLE BORDER=\"0\">\n";

for($i = 0; $i < $rows; $i++) {

echo "<TR>\n";

for($j = 0; $j < $columns; $j++) {
    if(isset($data[$i + ($j * $rows)])) {
        echo "<TD>" . $data[$i + ($j * $rows)] . "</TD>\n";

        //echo out the field
        echo "<TD>" . $data2[$i + ($j * $rows)] . "</TD>\n";
    }
}
echo "</TR>\n";

}
echo "</TABLE>\n";
?>

I would have posted the URL in the other forum, but am not sure of the rules here. (which I should have read, but now I'm here in edit mode....)

Strat

[coreyp_1]

My solution:

You can change number of columns by changing one variable ($num_cols), and no floating point math!

The difference is in approach. The other solutions populate an array sequentially, then access the elements based upon complicated floating point arithmatic. I populate the array based upon the number of columns, so that, when accessed sequentially, will populate the cells of a table in the desired order)

It should be faster with integer based math, but I'm not sure.

Haven't tested it, though...

$sql = "SELECT * FROM Items WHERE Category='$CA' ORDER BY ItemName"; 
$result = mysql_query($sql, $db) or die('MySQL error: ' . mysql_error() . '<br>Query: ' . $sql); 
$num_rows = mysql_num_rows($result); 
$num_cols = 6; //number of columns to display 

// generic counters
$i = 0;
$offset = 1;

// $data_array, populated according to the number of colums desired
while ($row = mysql_fetch_array($result)) { 
    $data_array[$i] = $row;
    $i += $num_cols;
    if ($i >= $num_rows)
        $i = $offset++;
    } 

// another generic counter
$col = 1;

echo '<table>\n<tr>'; 
for ($i=0; $i<$num_rows; $i++) { 
    if ($col > $num_cols) {
        echo "</tr>\n<tr>";
        $col = 1;
        }
    echo '<td>'. $data_array[$i][0] .'</td>'; 
    $col++;
    }
echo "</tr>\n</table>\n"; 

[tekky]

my solution:

<?
//to use this... just call down() with an array as the parameter and have $rows/$cols set already
function down($a)
{
	global $rows, $cols, $b; //pulling in global vars for function, note $b can be delete if dont want to export to array
	$i=0; //var for exporting to array, delete if dont want to use it
	$rowend = sizeof($a)-(sizeof($a)-$rows*intval($cols-1)); //var to  mark end of rowcount in for loop
	echo "<table border=1 cellspacing=1 cellpadding=2>\n";
	for($y=0;$y<$rows;$y++)
	{
		echo '<tr>'; //start table row
		for($x=0;$x<=$rowend;$x=$x+$rows)
		{
			if (isset($a[$x+$y])) //if nothing, dont print this column
			{
				echo '<td>' .$a[$x+$y]. '</td>'; //outputting the table columns
				$b[$i] = $a[$x+$y]; //exporting into a serialized array if you want to use it later that way...
				$i++; //counter of exporting in array format delete if you dont care about this
			}

	}
	echo "</tr>\n"; //end table row
}
echo "</table>\n"; //end table
return;
}

$array = range('A', 'Z'); //test array
$b = array(); //export array for serialized version of ouput from down()
$rows = $_GET['rows']; //change this to whatever, I used $_GETS to test w/o uploading to change the row count each time
$cols = intval(sizeof($array)/$rows)+1; //initializing columns count
down($array); //calling my function to export the array to a table and currently a serialized array also
echo "<br>\n<pre>"; //debug output to test the serialized array output
print_r($b);
echo "</pre>\n";
?>

note: this has been tested with all kinds of numbers below and equal to 26, note, there is no if checks for if the value is LARGER than the array.... may or may not work then...