Php Programming Code Examples
Php > Arrays Code Examples
Dynamic table columns
Dynamic table columns
THIS IS NOT WORKING OUT OF THE BOX
this is a small bit of code i did the other day that i found very usefull and maybe you will too ;) $catsCnt is the result from count() ing a result from mysql_fetch_array. The first line of this file is where you define how many columns you want in your table.
you need to edit this code to fit your site and maybe even just remove the part marked important
<?php
define('NUM_COLS', 2);
require_once ('../includes/config.inc');
if (!isset($_SESSION['user']['auth'])) {
header ("Location: http://example");
ob_end_clean();
exit();
} else {
// set the page title
$page_title = 'NYASPDP Browse Subjects';
include ('../includes/reg_header.htm');
// connect to the database
require_once ('../includes/dbconnect.php');
// START THE IMPORTANT STUFF
$query = "SELECT cat_id, cat_name FROM catg WHERE cat_name !='!INSTRUCTOR SELECT ONE'";
$result = @mysql_query($query) or die(mysql_error());
$cats = array();
while($cat=mysql_fetch_array($result)) {
array_push($cats, $cat);
}
$catsCnt = count($cats);
echo "\n<h1>Select A Subject</h1>";
echo "\n<table border='0' cellpadding='2' cellspacing='2' width='90%' align='center'>";
echo "\n<tr>";
for($x=0; $x < $catsCnt; $x++) {
if(($x+1) % NUM_COLS == 0) {
echo "<td class='tblData' width='".(100/NUM_COLS)."%' NOWRAP><a href='courses.php?sid=".$cats[$x]['cat_id']."' class='normal'>".$cats[$x]['cat_name']."</a></td></tr>";
if ($x!=($catsCnt-1)) echo "\n<tr>";
} else {
echo "<td class='tblData' width='".(100/NUM_COLS)."%' NOWRAP><a href='courses.php?sid=".$cats[$x]['cat_id']."' class='normal'>".$cats[$x]['cat_name']."</a></td>";
}
}
$numSpaces=$catsCnt%NUM_COLS;
if ($numSpaces!=0) {
for ($i=0;$i<=$numSpaces;$i++) {
echo "<td width='".(100/NUM_COLS)."%' NOWRAP> </td>";
}
echo "</tr>\n";
}
echo "\n</table>";
// END THE IMPORTANT STUFF
// Include the HTML footer.
include ('../includes/reg_footer.htm');
}
?>
