|
|
|
|
Like this code?
Show the author your appreciation.
|
|
| |
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://www.nyaspdp.org/nyaspdp.php");
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');
}
?> | |
|
|
| Database resultset navigation
Categories : PHP, HTML and PHP, Databases, MySQL, Navigation | | | This program will take data from a user via a web based form, validate it, show it
to the user for re-validation, and finally insert it into the database. Plenty of
sanity checking on the fields in the form.
Categories : MySQL, HTML and PHP, PHP, Complete Programs, Databases | | | A very simple way to build and do a hierarchical html categories browser without javascript , just using html php and mySql
Categories : HTML and PHP, Databases, Algorithms, PHP, MySQL | | | Sort the results from a SELECT query (any number of columns) into an array automatically.
Categories : PHP, PHP Classes, Arrays, Databases, MySQL | | | Automatically printing the contents of an sql table in MySQL.
Categories : MySQL, PHP, HTML and PHP, Databases | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | How can i Preload a 'SELECT MULTIPLE'?
Categories : HTML and PHP, PHP, MySQL, Databases | | | Paginating the mySQL data
Categories : PHP, Algorithms, Databases, MySQL, HTML and PHP | | | This functions makes it easy to use session-variables known from ASP. With one Cookie the array "session" will save and restore from a db-record. In this version MySQL is used but it's should very easy to change
Categories : PHP, Arrays, Cookies, MySQL, Databases | | | DDN FFA Network Script
Categories : PHP, MySQL, Complete Programs, HTML and PHP, Databases | | | A script to generate a report from a valid mysql connection. The user has to supply which fields he wants to display in table. All properties are changable.
Categories : PHP, PHP Classes, Databases, MySQL, HTML and PHP | | | This simple function will take a few arguments and easily set a associative array for each column in a result from a MySQL query
Categories : Databases, PHP, MySQL, Arrays | | | This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server.
Categories : Databases, MySQL, Complete Programs, PHP, Databases | | | PHP and MySQL scripting for Muyltiple CheckBoxes
Categories : HTML and PHP, MySQL, Databases, PHP | | | Function for retrieving MySQL enum values into a PHP array.
Categories : PHP, Databases, MySQL, Arrays | |
|
|
