[Resolved] divide results and display in rows

[rayzun]

Ive read somewhere about this result, but I cannot find it again.

My script queries a data file, and displays one after the other until all results are shown. The results can be veried up to many hundreds showing.

How to divide the results into seperate <td> 4 rows evenly as possible?

<td> <td> <td> <td>
result result result result
results results results result
</td> results results results
</td> </td> </td>

</tr></table>

My script so far:

<?php
list($first) = explode('/', substr($PATH_INFO,1));
$num_results=1000;

$lines = file('/AAACars.data');

$num=count($lines);

$count=0;

foreach ($lines as $line) {

$parts = explode('|', $line);
if ($parts[2] == $first) {

$count++;

if($count<=$num_results)

echo "<a href=\"/rars.$parts[0].html/$parts[0]/$parts[2]\">$parts[1]</a>";

}}
?>

[paulnaj]

Hi rayzun,

Suppose you want to display your results over $num_rows and you have $num results to consider. The number of columns is then $num/$num_rows, but rounded up. Then just cycle through the rows and cols. Only thing to worry about is what we put in a td if we've run out of results on the last row.

$NUMBER_OF_ROWS = 4; // You set this number
$lines = file('/AAACars.data');
$num = count($lines);
$num_cols = ceil($num/$NUMBER_OF_ROWS);
echo '<table border="1">';
for($row = 0; $row < $NUMBER_OF_ROWS; $row++){
	echo '<tr>';
	for($col = 0; $col < $num_cols; $col++){
		$n = $num_cols*$row + $col;
		if($num <= $n){
			$result = '&nbsp;';
		} else {
			$parts = explode('|', $lines[$n]);
			$result = '<a href="/rars.'.$parts[0].'.html/'.$parts[0].'/'.$parts[2].'">'.$parts[1].'</a>';
		}
		echo '<td>'.$result.'</td>';
	}
	echo '</tr>';
}
echo '</table>';

BTW, your attempt at a table ...

<td> <td> <td> <td>
result result result result
results results results result
</td> results results results
</td> </td> </td>

</tr></table>

... is a bit all over the place :queasy: This is really basic HTML, which you're going to have to learn to get anywhere, I'm afraid. There are tons of places to get going. Here's one: http://www.w3schools.com/html/default.asp ... it's got a chapter on tables listed.

Paul 🙂

EDIT: a typo or two!

[rayzun]

ok thanx Paul !

I think I can work with this code snippet.

Although, a part is missing that is needed in the script which was shown previously.

list($first) = explode('/', substr($PATH_INFO,1));

$parts = explode('|', $line);

if ($parts[2] == $first) {

Well, Im not sure if you left this out for good reason, but without this code snippet, I get a return of the entire database. This is way to much information to be listed on one page.

for example....

http://url.com/orders.php/Paid

list($first) = explode('/', substr($PATH_INFO,1));
if ($parts[2] == $first) {

from this code snippet, I will select the first front slash info after the named PHP page. Now the script goes through the data searching for all lines with "Paid" in parts[2]

datafile:
1|online|Paid
2|call|Paid ...

More... Is it possible to show the results as 4 Columns instead of 4 rows.

I wouldn't ask if this was something I could stumble upon the answers myself, but after different coding attempts Im left in the dark.

[paulnaj]

Ok rayzun,

I did leave out the 'filter' ... was just trying to show you how you might calculate the table size. For fixed rows, you need to know how the total number of entries to be displayed before you start building the table.

For fixed columns, it's actually not necessary, but I've done it anyway.

<?php
// Assuming $PATH_INFO has been defined above
list($first) = explode('/', substr($PATH_INFO, 1)); 

$MAX_RESULTS = 1000; 	// Constant ... use uppercase to help read
$results = array();		// Store the items to be displayed here	

$lines = file('/AAACars.data'); 
$count = 0; 
for($i = 0; $i < count($lines); $i++){
	$parts = explode('|', $lines[$i]); 
	if($parts[2] == $first){ 
		$results[] = '<a href="/rars.'.$parts[0].'.html/'.$parts[0].'/'.$parts[2].'">'.$parts[1].'</a>';
		if(++$count == $MAX_RESULTS) break; // ... out of the loop altogether.
	}
} 


$NUMBER_OF_COLS = 4; // You set this number 
$num_results = count($results); 
$num_rows = ceil($num_results/$NUMBER_OF_COLS); 
echo '<table border="1">'; 
for($row = 0; $row < $num_rows; $row++){ 
    echo '<tr>'; 
    for($col = 0; $col < $NUMBER_OF_COLS; $col++){ 
        $n = $NUMBER_OF_COLS*$row + $col; 
        if($num_results <= $n){ 
            $result = '&nbsp;'; 
        } else { 
            $result = $results[$n]; 
        } 
        echo '<td>'.$result.'</td>'; 
    } 
    echo '</tr>'; 
} 
echo '</table>';
?>

(Just curious ... why not use mysql to store the info? It's a whole lot more stable, fast, easy (blah, blah) than files.)

Paul.

[rayzun]

ok thanx Paul !

thanks for the instructions...

I have had no choice, but to migrate my template using txt data files to the MySQL method. Your right alot faster! page load time cut by nearly 20 seconds.