Script problem

[mendoz]

Greetings,

I'm looking to create a page which shows up to 6 tables at a time.

My idea was to make a page called 'tables.php' with a table in it with two rows and three columns,
inside every cell I'll put an <? include ('table.php'); ?>.
'tables.php' will connect to a specific database via a var ('tables.php?cat=cat1').
Then I want it to check how many rows are in that database.

I want up to 6 <? include ('table.php'); ?>. in a page.
So, if for example I have 10 rows in database 'cat1',

First page will have:
6 <? include ('table.php'); ?>,

Second page will have:
4 <? include ('table.php'); ?>,
2 <? include ('table-no.php'); ?>,

example:

'tables.php?cat=cat1?id=0':
[table][tr]
[td]<? include ('table.php'); ?>,[/td]
[td]<? include ('table.php'); ?>,[/td]
[td]<? include ('table.php'); ?>,[/td]
[/tr]
[tr]
[td]<? include ('table.php'); ?>,[/td]
[td]<? include ('table.php'); ?>,[/td]
[td]<? include ('table.php'); ?>,[/td]
[/tr]
[/table]
next

'tables.php?cat=cat1?id=1':
[table]
[tr]
[td]<? include ('table.php'); ?>,[/td]
[td]<? include ('table.php'); ?>,[/td]
[td]<? include ('table.php'); ?>,[/td]
[/tr]
[tr]
[td]<? include ('table.php'); ?>,[/td]
[td]<? include ('table-no.php'); ?>,[/td]
[td]<? include ('table-no.php'); ?>,[/td]
[/tr]
[/table]
previous

This is a code I got from another forum, and it shows pictures..
How can I modify it to my needs?

<?php
mysql_connect( "localhost", "username", "password" ); // Use correct stuff there
mysql_select_db( "images" ); // Use Database Name
$max_images = 6;
if( !isset( $_GET[ 'page' ] ) ) {
$page = 1;
}
else {
$page = $_GET[ 'page' ];
}
$from = ($page * $max_images) - $max_images;

// select the image url's from the db, i_id = the id of the row in the mysql db
$sql = "SELECT * FROM images ORDER BY i_id LIMIT $from, $max_images";
$s = mysql_query( $sql );
while( $res = mysql_fetch_array( $s ) ) {
$i = 1;
//example variables, might be different for you

// assuming the row name is "src"
$src = $res[ 'src' ];

echo '<img src="'.$src.'"> ';
if( $i > 4 ) {
 echo '<br />';
}
$i++;
}
echo '<br />';
$total_images = mysql_result( mysql_query( "SELECT COUNT( i_id ) as Num FROM images" ), 0 );
$total_pages = ceil( $total_images / $max_images );
// previous page
if($page > 1){
 $prev = ( $page - 1 );
   echo '<a href="images.php?page='.$prev.'">Previous</a> ';
}

for( $i = 1; $i <= $total_pages; $i++ ) {
if( ( $page ) == $i ) {  

 echo "$i ";
}
else {
 echo '<a href="images.php?page='.$i.'">$i</a> ';
}
}
// next page
if( $page < $total_pages ) {
$next = ( $page + 1 );
echo '<a href="images.php?page='.$next.'">Next</a>';
}
?>

[void_function]

This multiple inclusion of same file and row selection from within a table cell sounds suspicious to me. Can you tell us the end result you want to achieve?

Because, the proper way to do it is to connect to db before you output anything, check for available rows that match "cat" variable and output table from within a loop where you fetch new database row per new tablerow presented on the page.

[mendoz]

I want the script to do the following:

1. <? $_get ?> the specific database
2. check how many rows are in it
3. for every row do <? include (table.php) ?>
4. if there are no rows left to complete the 6 rows limit do <? include (table-no.php) ?>
5. pagination

The output shold be something like this

table cat1 has 10 rows in it

tables.php?page=1?cat=cat1
<table>
<tr>
<td><? include ('table.php'); ?></td>
<td><? include ('table.php'); ?></td>
<td><? include ('table.php'); ?></td>
</tr>
<tr>
<td><? include ('table.php'); ?></td>
<td><? include ('table.php'); ?></td>
<td><? include ('table.php'); ?></td>
</tr>
</table>
next

tables.php?page=2cat=cat1
<table>
<tr>
<td><? include ('table.php'); ?></td>
<td><? include ('table.php'); ?></td>
<td><? include ('table.php'); ?></td>
</tr>
<tr>
<td><? include ('table.php'); ?></td>
<td><? include ('table-no.php'); ?></td>
<td><? include ('table-no.php'); ?></td>
</tr>
</table>
previous

[void_function]

mendoz wrote:

1. <? $_get ?> the specific database
2. check how many rows are in it

Ok, rows can only be in tables, so I'll assume you mean tables, not database.

3. for every row do <? include (table.php) ?>

If it is not a secret, what's in table.php?

4. if there are no rows left to complete the 6 rows limit do <? include (table-no.php) ?>

To give you a literal answer, you need fixed number of iterations and change inclusion file after you ouput the number of rows in the table that fit your category. For example:

// SELECT COUNT(*) FROM tablename WHERE cat='$category'
// get result into $numrows

define ('MAX_ROWS', 6);
define ('COLUMNS', 3);

$j=0;

echo "<table><tr>\n";

for ($i=0; $i<MAX_ROWS; $i++) {
  if ($i>($numrows-1)) {
    echo '<td>'; include 'table-no.php'; echo '</td>';
  } else {
    echo '<td>'; include 'table.php'; echo '</td>';
  }

  $j++;

  if (($j==COLUMNS) && ($i!=(MAX_ROWS-1))) {
    echo "</tr><tr>\n";
    $j=0;
  }
}

echo '</tr></table>'; 

[mendoz]

inside table.php there is a round border table with an image, whose src and link are $vars.

this is what I got from another forum.

<?php

// Connect to DB
include('connect.php');

// Select total results for pagination
$result = mysql_query('SELECT count(countryName) FROM tblCountry');
$num_records = mysql_result($result,0,0);

// Set maximum number of rows and columns
$max_num_rows = 2;
$max_num_columns = 2;
$per_page = $max_num_columns * $max_num_rows;

// Work out how many pages there are
$total_pages = ceil($num_records / $per_page);

// Get the current page number
if (isset($_GET['page'])) $page = $_GET['page']; else $page = 1;

// Work out the limit offset
$start = ($page - 1) * $per_page;

// Select the results we want including limit and offset
$result = mysql_query("SELECT countryName FROM tblCountry ORDER BY countryName LIMIT $start, $per_page");
$num_columns = ceil(mysql_num_rows($result)/$max_num_rows);
$num_rows = ceil(mysql_num_rows($result)/$num_columns);

// Echo the results
echo "<table border=\"2\">\n";
for ($r = 0; $r < $max_num_rows; $r++){
	echo "<tr>\n";
	for ($c = 0; $c < $max_num_columns; $c++){ // 1
		$x = $r * $max_num_columns + $c;
		if ($x < mysql_num_rows($result)){
//                   $y = mysql_result($result, $x, 0); // Commented out so I could show your example
                   $y = "include('table.php')";
                }
                else {
                   $y = "include('table-no.php')";
                }
		echo "<td>$y</td>";
	}
	echo "</tr>\n";
}

// Echo page numbers
echo "</table>\n";
for ($i=1;$i <= $total_pages;$i++) {
	if ($i == $page) echo " $i "; else echo " <a href=\"?page=$i\">$i</a> ";
}
?>

[void_function]

The code you have listed will not work because it echoes the include command into HTML where it has no meaning outside PHP. And by the way, do not include, but rather use different functions.

As for your desired implementation of the code itself, you want to present a table of images (or something), six per page in 3x2 layout, correct? Then you can use the code that I gave you above, except you have to construct proper SQL query which tracks which page it presents and how many rows are per page (6).

Tracking pages is simple, through &page=num (or whatever you want to call it) in the URL. You get the desired page number from $_GET['page'], don't forget to cast it into int, and construct the LIMIT clause:

//$num_rows contains the total number of rows in the table

$page= (isset($_GET['page'])) ? (int) $_GET['page'] : 1;
if ($page>floor($num_rows/6)) $page= floor($num_rows / 6);
if ($page<1) $page=1;

$start= ($page-1) * 6;

$query= "SELECT data FROM table WHERE cat='$cat' LIMIT $start, 6";

// perform query and display results

[mendoz]

Thanks void.

I'm a real newbie where it comes to php.

And by the way, do not include, but rather use different functions.

What do you mean by that?