php.ComLanka.com PHP Tutorial ,PHP source code, PHP online example

Algorithms Arrays Passwords Uncategorized
Commerce Uncategorized
Databases Abstraction Layers Informix LDAP MS SQL MySQL ODBC PostgreSQL Uncategorized
Date & Time Calculators Conversion Translation Uncategorized
Discussion Chat Forums Guestbooks Polls Uncategorized
Email Validation Uncategorized
External Uncategorized
Files and Directories Uncategorized
Games Uncategorized
Graphics 3-D Graphs Resizing Thumbnails Uncategorized
HTML Forms Menus & Navigation Source Viewers Tables Templates Uncategorized
HTTP Authentication Cookies File Uploading Uncategorized
I18N Uncategorized
Math Uncategorized
Miscellaneous Uncategorized
Searching and Trees Uncategorized
Security Uncategorized
Text Uncategorized
Utilities Calendars Counters Link Checkers Weather Uncategorized
XML Uncategorized

php sample source codes
KISS = "keep it simple stupid" This is a pretty simple if statement that I did for a cobol program works like a champ //the swicth is set to odd and the if statement alternates it and the color $switch = "odd"; while($row = mysql_fetch_object($result)) { echo $switch; ///////////////////////////////////////////// // if switch odd to even // Var $switch even : odd // Var $color that is swithced ///////////////////////////////////////////// if ($switch == "odd") { $color ="#000033"; $switch = "even"; } else { $color = "#CCCCC"; $switch = "odd"; } // Var $color that is alternated echo "<tr bgcolor='$color'>"; echo "<td>".$row->ex_Name."</td>"; echo "<td>".$row->ex_Des."</td>"; echo "</tr>"; } echo "</table>";
This code puts results from a mysql_query into rows and the colors of the rows alternate. Useful for displaying information such as schedules or lists. <? $connection = mysql_connect("hostname","username","password"); $db = mysql_select_db("db_name", $connection); $sql = mysql_query("SELECT * FROM table_name ORDER BY field1 ASC"); echo "<table cellpadding=0 cellspacing=0 border=0><tr><td><b>Field1</b></td><td><b>Field2</b></td><td><b>Field3</b></td></tr>"; $alternate = "2"; while ($row = mysql_fetch_array($sql)) { $field1 = $row["field1"]; $field2 = $row["field2"]; $field3 = $row["field3"]; if ($alternate == "1") { $color = "#ffffff"; $alternate = "2"; } else { $color = "#c0c0c0"; $alternate = "1"; } echo "<tr bgcolor=$color><td>$field1</td><td>$field2</td><td>$field3</td></tr>"; } echo "</table>"; ?>
This is a simple way to alternate row colors in php function row_color($i) { $bgcolor1 = "#222222"; $bgcolor2 = "#444444"; if ( ($i % 2) == 0 ) { return $bgcolor1; } else { return $bgcolor2; } }
if u need to put some colors in your tables or any where else this code can help you, Any comment or opinion email me // NOTES: // for color reference check this this URL: http://home.i1.net/~dwolfe/hexmixer/000000.shtml; // // // ------------------------------------------------------------------------ // alternate_2colors // ------------------------------------------------------------------------ // Alternating colours with two colours // * example 1 // <table cellpadding=0 cellspacing=0 border=0 width=100%> /* <?php // include('html.php'); html.php contains our function // $t = 0; // while($t < 10) // { // echo '<TR BGCOLOR="' . $cl = alternate_2colors('#EEEEEE', '#FFFFFF', $t++). '"><td>'. $t . "</td></tr>\n"; // } // ?> // <table> */ // * example 2 // $nb += 1; // $couleur = alternate_2colors('#EEEEEE', '#FFFFFF', $nb); // echo'<TD BGCOLOR="'.$couleur.'"align=middle vAlign=center width=30%><SPAN class=small>'. $Ttl . '</SPAN></TD>'; // echo'<TD BGCOLOR="'.$couleur.'"align=middle vAlign=center width=30%><SPAN class=small>'. $Alb . '</SPAN></TD>'; // echo'<TD BGCOLOR="'.$couleur.'"align=middle vAlign=center width=30%><SPAN class=small>'. $Art . '</SPAN></TD>'; // echo'<TD BGCOLOR="'.$couleur.'"align=middle vAlign=center width=9%><SPAN class=small>'. $Time . '</SPAN></TD>'; // function alternate_2colors($color_1, $color_2, $cpt) { $couleur = ($cpt % 2) ? $color_1 : $color_2; return $couleur; } // ------------------------------------------------------------------------ // alternate_xcolors // ------------------------------------------------------------------------ // Alternating colors with unlimited colors // * $colors Has to be an array // * $t is an incremented interger // * $z iz the maximum value that $t can take // // * example // <table cellpadding=0 cellspacing=0 border=0 width=100%> /* <? php // include('html.php'); html.php contains our function // $colors = array(); // $colors[] = "#EDEDED"; // $colors[] = "#CCCCCC"; // $colors[] = "#FFFFFF"; // $colors[] = "#FFFFDF"; // // $t = 0; // while($t < 10) // { // echo '<TR BGCOLOR="' . $cl = alternate_Xcolors($colors,$t++,$t). '"><td>'. $t . "</td></tr>\n"; // } // ?> // <table> */ function alternate_Xcolors($colors, $t, $z) { $zb = floor($z/sizeof($colors)); $y = $z -($zb * sizeof($colors)); while ( $x < $zb ) { foreach($colors as $col) { $colr[] = $col; } $x++; } for ($i = 0; $i <= $y-1; $i++) { $colr[] = $colors[$i]; } return $colr[$t]; } // ------------------------------------------------------------------------ // Gradient // ------------------------------------------------------------------------ // create a gradient of colors from two colors // * $coldeb is the first color of the gradient in hex. // * $colfin is the last color of the gradient in hex, // this color will be ajasted for mathmatical reasons. // * $n is the size of the array returned by our function, // for example number of rows in a table. // // * example /* <? php // include('html.php'); html.php contains our function // $coldeb = '99FF99'; // $colfin = 'CCFFFF'; // $n = 79; // echo '<table cellpadding=0 cellspacing=0 border=0 width=100%>'; // foreach (Gradient($coldeb, $colfin, $n) as $gr) // { // echo '<tr bgcolor="#' . $gr . '"><td>col</td><td>col2</td></tr>'; // } // echo '</table>'; // ?> */ // calculate the RBG in decimal for an hex color function SeparateRBG($col) { $Color[R]= hexdec(substr($col, 0, 2 )); $Color[B] = hexdec(substr($col, 2, 2)); $Color[G] = hexdec(substr($col, -2)); return $Color ; } // return $GradientColor an array that contien the final gradient function Gradient($coldeb, $colfin, $n) { $Color[deb] = SeparateRBG($coldeb); $Color[fin] = SeparateRBG($colfin); $rbg = array('R', 'B', 'G'); // calculate the red, the bleu, and the green gradient foreach ($rbg as $RBG) { $Color[enc][$RBG] = floor( (($Color[fin][$RBG]) - ($Color[deb][$RBG])) / $n ); for ($x = 0 ; $x < $n ; $x++) { $Color[gradient][$RBG][$x] = dechex($Color[deb][$RBG] + ($Color[enc][$RBG] * $x)); if (strlen(strval($Color[gradient][$RBG][$x])) < 2) { $Color[gradient][$RBG][$x] = '0' . $Color[gradient][$RBG][$x]; } } } // build the final gradient array for ($i = 0 ; $i < $n ; $i++) { $GradientColor[] = $Color[gradient][R][$i] . $Color[gradient][B][$i] . $Color[gradient][G][$i]; } return $GradientColor; } // ------------------------------------------------------------------------ // Shade // ------------------------------------------------------------------------ // create a shade of colors from two colors // * $coldeb is the first color of the gradient in hex. // * $colfin is the last color of the gradient in hex, // this color will be ajasted for mathmatical reasons. // * $N is the size of the array returned by our function, // for example number of rows in a table. // // * example /* <? php // include('html.php'); html.php contains our function, it has to contien SeparateRBG($col) also // $coldeb = '99FF99'; // $colfin = 'CCFFFF'; // $n = 79; // echo '<table cellpadding=0 cellspacing=0 border=0 width=100%>'; // foreach (Shade($coldeb, $colfin, $n) as $gr) // { // echo '<tr bgcolor="#' . $gr . '"><td>col</td><td>col2</td></tr>'; // } // echo '</table>'; // ?> */ function Shade($coldeb, $colfin, $N) { $n = floor($N/2); $Color[deb] = SeparateRBG($coldeb); $Color[fin] = SeparateRBG($colfin); $rbg = array('R', 'B', 'G'); // calculate the red, the bleu, and the green gradient foreach ($rbg as $RBG) { $Color[enc][$RBG] = floor( (($Color[fin][$RBG]) - ($Color[deb][$RBG])) / $n ); for ($x = 0 ; $x <= $n ; $x++) { $Shade[$RBG][$x] = dechex($Color[deb][$RBG] + ($Color[enc][$RBG] * $x)); if (strlen(strval($Shade[$RBG][$x])) < 2) { $Shade[$RBG][$x] = '0' . $Shade[$RBG][$x]; } } } // build the final gradient array for ($i = 0 ; $i <= $n ; $i++) { // $ShadeColor is the array that contien the final garadient $ShadeColor[] = $Shade[R][$i] . $Shade[B][$i] . $Shade[G][$i]; } $ShadeColorRev = Array_reverse($ShadeColor); array_pop ($ShadeColor); $shade = Array_merge($ShadeColor ,$ShadeColorRev ); unset($ShadeColorRev); unset($ShadeColor); return $shade; } ?>
<p>This nifty little pice of code is probably the best method, because it means you can have unlimted colours, 4, 4, or 5 colours... <p>There's nothing complicated about it either... it's but 2 lines of code at the end of a loop... <table cellpadding=0 cellspacing=0 border=0 width=100%> <? // Define the colours... $colours = array(); $colours[] = "#EDEDED"; $colours[] = "#CCCCCC"; $colours[] = "#FFFFFF"; // Loop through from 10 -> 15 for ($i = 1; $i <= 15; $i++){ // Print the row with the colour value... printf("<tr bgcolor=\"%s\"><td>$i</td></tr>\n", $colours[0]); // Now for the magic... First we take the last value off the end of the array // and pop it onto the beginning... array_unshift($colours, $colours[count($colours)-1]); // array_unshift does this nicley, and I've added the "count($colours)-1" // bit so you can have as many colours as you need... // Then we remove the last element of the array... array_pop($colours); } ?> </table>
This small bit of code is an effecient way of alternating colors in an HTML table when printing the results of a database query. <html> <head> <style> .td1 { font: bold 10pt Tahoma; background: #AAAAAA; } .td2 { font: bold 10pt Tahoma; background: #BBBBBB; } .trhead { font: bold 11pt Tahoma; background: #00689e; color: #FFFFFF; } </style> </head> <body> <? mysql_pconnect("localhost", "*****", "*****") or die("error connecting to database"); mysql_select_db("events") or die("error selecting database"); $rs = mysql_query("SELECT ID, Name, City, County, Date FROM events order by $listEvents ASC"); // create an array holding the classes you want to switch between $classes=array("td1","td2"); // a counter to keep track of which class is currently being used $classifier=0; $num = mysql_num_rows($rs); $i = 0; echo "<TABLE style=\"border: double\" width=650 align=center cellpadding=4 cellspacing=0>"; echo "<tr class=trhead>"; echo "<td width=35%>Event Name</td>"; echo "<td width=20%>City</td>"; echo "<td width=20%>County</td>"; echo "<td width=20%>Date</td>"; echo "<td width=5%>&nbsp;</td>"; echo "</tr>"; while ($i < $num): $id = mysql_result($rs,$i,"ID"); $name = mysql_result($rs,$i,"Name"); $city = mysql_result($rs,$i,"City"); $county = mysql_result($rs,$i,"County"); $date = mysql_result($rs,$i,"Date"); $name = "<a href=details.php3?id=$id&mode=1>" . $name . "</a>"; // access the value in the array associated with the key equal to the counter and print it in the <tr> bg echo "<tr class=" . $classes[$classifier] .">"; echo "<td>" . $name . "</td>"; echo "<td>" . $city . "</td>"; echo "<td>" . $county . "</td>"; echo "<td>" . date("M j, Y", $date) . "</td>"; echo "<td><a href=Action.php3?id=$id&mode=2 title=\"Edit\"><img src=\"edit.gif\" border=0></a></td>"; echo "</tr>"; $i++; // increment the counter and mod it by 2 to effectively alternate between two numbers $classifier=($classifier+1)%2; endwhile; break; ?> </body> </html>
An simple function designed to alternate row colors in a table. <?php function row_color($cnt,$even,$odd) { print ($cnt%2) ? "<tr bgcolor=\"$odd\"> : "<tr bgcolor=\"$even\">"; }
This code will show you how easily to handle an alternative colored rows using defined function I called it as foxcol($x) where $x is int <? $y = 0;//will be needed later to make counter inside the loop function foxcol($x)// The function which will print the color name { $x++; if ($x%2 > 0.5) { print("red"); } else { print("yellow"); } } ?> <table width="100%" border=1> <? for ($i = 0; $i < 14; ++$i)://The loop inwhich rows will be repeated ++$y;// The counter which will passed throgh the function to produce the color ?> <tr bgcolor="<?foxcol($y)?>"> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <? endfor; ?> </table>
<p>This nifty technique can be used for generating alternating colours using 2 colours... <p>It's small. It's quick and it's faster than most methods i've seen. <p>Pretty simple really, use the % (mod) operator in conjunction with the ? : triniary operator and bingo! Alternating row colours...! <table cellpadding=0 cellspacing=0 border=0 width=100%> <? // Define the colours... $colour1 = "#EDEDED"; $colour2 = "#FFFFFF"; // Loop through from 10 -> 10 for ($i = 1; $i <= 10; $i++){ // print the row! // This is simple! printf("<tr bgcolor=\"%s\"><td>$i</td></tr>\n", $i%2 ? $colour1 : $colour2); } // this can be modified, to do the same while printing database entries... // all you need to do in make sure there's a $i variable for comparing. // The syntax for the "? : " operator are pretty easy to understand // example: <expr1> ? <expr2> : <expr3> // if <expr1> evaluates to true, then <expr2> comes into play // Otherwise, <expr3> get's evaluated. ?> </table>
complex Table class for gegeration of HTML Tables with most of Tag-features. Table can flexible resized ( add rows or columns ) during script, so that it is not possible to know how many lines you need in the Table ( e.g. select statement from database ). Values of the TD's can be assigned in every order you want. also overwriting of values is possible, because the HTML code is sent at the end of code and not everytime you change the table definitions. All tags are used ( e.g. rowspan, colspan, backgroundcolor .... ) at least for ns 4.78. Everything can be viewed in most Browsers ( tested i.e 4.0 and upper, NS 4.78 and upper, Opera ) Every row may be a header. maybe some small bugs, but is working in productive system. <?php /** * @package Table **/ /** Module Name : class.CC_Table.php -- Classname : Table * * HTML Table generation class * creates a table in html, with indents in source code * and makes all columns, even if not filled , valid * * * @description <Description of the module/ server> * */ class Table { /** * array[$row][$col]: <br> value of columns in table * @see AddColumn() * @see Table() * @access private */ var $cols = array(); /** * array[$rows] : amount of columns in a row * @see AddColumn() * @access private **/ var $col_amount = array(); /** * boolean: if set to true, first row is an html Table header * @see TableHeader(), with argument true if header, false if not * @access private **/ var $is_header_active = false; /** * array: all rows have now a flag for heading column * * when row should be a heading row set row to 1 * **/ var $row_headings = array(); /** * number: amount of rows; * @access private */ var $max_row; /** * the maximum amount of columns in the table ( e.g. row1 = 5 cols, row2 = 8 cols --> max_cols = 8 ) * @access private **/ var $max_col; /** in case of table was called without initial load of columns, the actual column writing into is set here * @see Table() * @access private **/ var $act_col; /** * array[$col]: size of column $col * @see ChangeColSize() * @access private **/ var $col_size = array(); /** * size of table in percent * @see SetTableWidth() * @access private **/ var $t_size = "95%"; /** * tabulator index for source code indention, raised on new table element, smallered on end table element * @access private **/ var $open_tab=0; /** * tabulator index for source code indention, raised on new row element, smallered on end row element * @see AddRow() * @access private **/ var $open_Row=0; /** * tabulator index for source code indention, raised on new column element, smallered on end column element * @see AddColumn() * @access private **/ var $open_Col=0; /** * number if set to 0, no borders are shown, if set to >0 a border with width $t_border is shown * @see SetTableBorder() * @access private **/ var $t_border=0; /** * number the empty space between value and border of column in pixels * @see SetTableCellSpacing() * @access private **/ var $t_cellspacing=2; /** * number the distance between to columns in pixels * @see SetTableCellPadding() * @access private **/ var $t_cellpadding=2; /** * Backgroundcolor of the table element * @see SetTableBackgroundColor() * @access private **/ var $t_bgcolor=DefTableBackgroundcolour; /** * the vertical alignment of the table in html display * @see SetTableAlign() * @access private **/ var $t_align="CENTER"; /** * array[$col]: the prefix of the value in column $col ( e.g put a html tag like \< b> ) * @see SetColumnPrefix() * @access private **/ var $c_prefix = array(); /** * array[$col]: the postfix of the value in column $col ( e.g put a end html tag like \</B> ) * @see SetColumnPostfix() * @access private **/ var $c_postfix = array(); /** * array[$row][$col]: Backgroundcolor of the column $col in row $row * @see {@link ChangeColumnColor} {@link ChangeRowColor} {@link SetColumnBackgroundColor} * @access private **/ var $c_bgcolor = array(); /** * string: the default alignmend of the columns in table, if NO ALIGNMENT IS SET IN c_align for a column * @access private **/ var $c_align_default = "CENTER"; /** * string: the default vertical alignment of the columns in table, if NO ALIGNMENT IS SET IN c_valign for a column * @access private **/ var $c_valign_default = "MIDDLE"; /** * array[$row][$col]: the alignment of the value in column $col in row $row * @see SetColumnAlign() * @access private **/ var $c_align = array(); /** * array[$row][$col]: the columnspan of the column $col in row $row * @see ChangeColSpan() * @access private **/ var $c_colspan = array(); /** * $array[$row][$col]: vertical alignment in column $col in row $row * @see SetColumnVertikalAlign() * @access private **/ var $c_valign = array(); /** ** ??????? * @access private **/ var $c_vspace = array(); /** * array[$row][$col]: heigth of column $col in row $row ( not properly working, always heighest column is standard ) * @access private **/ var $c_height = array(); /** * array[$col]: width of column $col in row $row ( not properly working, always biggest column is standard ) * @access private **/ var $c_width = array(); /** * array[$row][$col]: wrap mode in column $column row $row * @access private **/ var $c_nowrap = array(); /** * array[$row][$col]: rowspan of the column $column in row $row (default is 1 ) * @access private **/ var $c_rowspan = array(); /** * array[$row][$col]: column $column in row $row is an header * @access private **/ var $c_head = array(); /** * boolean: internal use only, flag if table was already checked for validation * @access private **/ var $table_finished = false; /** Kontruktor of Class Table * A HTML TABLE Template is prepared, if called with arguments, then columns and rows are initialized * if not, each new column(row) must be added manually using {@link AddColumn}({@link AddRow}) * * @desc Konstruktor of TableClass, with parameter called create a table with row and cols, if not, empty table * @param boolean if true, all arguments must be given, * @param number amount of rows * @param number amount of columns in one row **/ function Table($create=false,$row_amount=1,$col_amount=1) // _contructor { $this->max_row = 0; $this->max_col = 0; $this->act_col = 0; if ( $create ) { $this->Table2($row_amount,$col_amount); $this->SaneTable(); } } /** Konstruktor extension, if Table has already definition * * @desc no direct call please, will be called by Konstruktor * * @param number amount of rows in the table * @param number amount of column in one row * @return void * @access private **/ function Table2($row_amount,$col_amount) { for ( $the_row = 1; $the_row <= $row_amount; $the_row++ ) { $this->AddRow(); for ( $the_col = 1; $the_col <= $col_amount; $the_col++ ) { $this->AddColumn(); } } if ( $col_amount == 1 ) { $this->c_size[1][1] = "100%"; } else { $this->ChangeColSize(1,ceil(100/$col_amount)); } } /** Activates or deactivates Borders in table * * @desc Activates or deactivates Borders in table * @param number 0 for no border, >0 for size of border in pixels * @return void **/ function SetTableBorder($bordersize=0) { $this->t_border = $bordersize; } /** Activates or deactivates Header row in table * * Header row is ALWAYS ONLY the FIRST ROW * * @desc Activates or deactivates Header row in table * @param boolean true if header is active * @return void **/ function SetTableHeader($setting=true) { //$this->is_header_active = $setting; $this->SetRowToHeader(1); } function SetRowToHeader($row) { $this->row_headings[$row] = 1; } /** Width of table in percent in Browser * * width of table in percent in the browser * if table is in an other table, the width in percent * is depending of the with of the column * * @desc Width of table in percent in Browser * @param number width in percent * @return void **/ function SetTableWidth($width="80") { $this->t_size = $width."%"; } /** distance between value end borders of a column * * @desc distance between value end borders of a column * @param number distance in pixels * @return void **/ function SetTableCellSpacing($space=2) { $this->t_cellspacing = $space; } /** distance between two column or rows * * @desc distance between two column or rows * @param number distance between two column or rows in pixels * @return void **/ function SetTableCellPadding($padding=2) { $this->t_cellpadding = $padding; } /** Alignment of Table in Browser * * @desc Alignment of Table in Browser ( CENTER,LEFT,RIGTH ) * @param string HTML TAG for alignment ( CENTER,LEFT,RIGTH ) */ function SetTableAlign($align=CENTER) { $this->t_align = $align; } /** Prefix of value of one complete column * the prefix of the value in column $col ( e.g put a html tag like \< b>) * * @desc Prefix of value of one complete column * @param number columnnumber ( complete column will be set with the prefix) * @param string prefix of value * @return void **/ function SetColumnPrefix($col,$prefix="") { $this->c_prefix[$col] = $prefix; } /** Postfix of a column for one complete column * the prefix of the value in column $col ( e.g put a html tag like \< /b>) * * @desc Postfix of value of one complete column * @param number columnnumber ( complete column will be set with the prefix) * @param string postfix of value * @return void **/ function SetColumnPostfix($col,$postfix="") { $this->c_postfix[$col] = $postfix; } /** Changes the Width of a column in row $row, does not change any other column * @desc Changes the Width of a column in row $row * @param number number of column to change in row $row * @param string the width of the column in percent ( without percent sign * @return void **/ function SetColumnWidth($row,$col,$width) { //$this->c_width[$row][$col] = $width."%"; $this->c_width[$col] = $width."%"; } /** Setting the backgroundcolor of one column * * @desc Setting the backgroundcolor of one column * @param number row in table * @param number column in table * @param html color synthax * @return void **/ function SetColumnBackgroundColor($row,$col,$color) { $this->c_bgcolor[$row][$col] = $color; } /** Alignment for one column in one row * * @desc Alignment for one column in one row * @param number number of row * @param number number of column * @param string alignment in html synthax * @return void **/ function SetColumnAlign($row,$col,$align) { $this->c_align[$row][$col] = $align; } /** Change Default Value for column alignment in a complete table * * Change Default Value for column alignment in a complete table * is used for every column, where no c_align is defined explicit * * @param string the alignment of all columns( RIGHT CENTER LEFT ) **/ function SetColumnAlignDefault($align) { $this->c_align_default = $align; } /** Change Default Value for vertical column alignment in a complete table * * Change Default Value for vertical column alignment in a complete table * is used for every column, where no c_valign is defined explicit * * @param string the vertical alignment of all columns( MIDDLE TOP BOTTOM ) **/ function SetColumnVerticalAlignDefault($align) { $this->c_valign_default = $align; } /** set the backgroundcolor of an html table * * @desc set the backgroundcolor of an html table * @param string color in html synthax * @return void **/ function SetTableBackgroundColor($color=DefTableBackgroundcolour) { $this->t_bgcolor = $color; } /** set the vertical alignment in a column * * @desc set the vertical alignment in a column * @param number number of row * @param number number of column * @param string alignment in html synthax * @return void **/ function SetColumnVerticalAlign($row,$col,$align=MIDDLE) { $this->c_valign[$row][$col] = $align; } /** Changes the size of one Column to col_size. * All rest of the table size is evenly distributed to the remaining cols * @desc Changes the size of one Column to col_size. * @param column to change * @param Size in Percent ( without the % sign ) * @return void */ function ChangeColSize($column,$col_size) { $rest = 100 - $col_size; $per_col = ceil($rest/($this->max_col-1)); for ( $cols = 1; $cols <= $this->max_col; $cols++ ) { $this->c_width[$cols] = $per_col."%"; } $this->c_width[$column] = $col_size."%"; } /** Changes the Width of a column, does not change any other column * @desc Changes the Width of a column, does not change any other column * @param number number of column to change * @param string the width of the column in percent ( without percent sign * @return void **/ function ChangeCompleteColumnWidth($col,$width) { for ( $row = 1; $row <= $this->max_row; $row++) { $this->SetColumnWidth($row,$col,$width); } } /** the columnspan of the column $col in row $row * * @desc the columnspan of the column $col in row $row * @param number number of row * @param number number of column * @param number amount of columns used by column * @return void **/ function ChangeColSpan($row,$column,$colspan) { if ( is_array($this->c_colspan[$row]) ) { $amount = array_sum($this->c_colspan[$row]); if ( $amount >= $this->max_col && $colspan > 1 ) { $anzahl = sizeof($this->cols[$row]); unset($this->cols[$row][$anzahl]); unset($this->c_colspan[$row][$anzahl]); $this->ChangeColSpan($row,$column,$colspan); } else if ( $colspan > 1 ) { $this->c_colspan[$row][$column] = $colspan; } else { echo "Fehler beim erstellen der Tabelle beim ndern des ColSpan"; echo "Fehler beim erstellen der Tabelle beim ndern des ColSpan"; } } else { for ( $i = 1; $i <= $this->max_col ; $i++) { $this->c_colspan[$row][$i] = 0; } $amount = array_sum($this->c_colspan[$row]); if ( $amount >= $this->max_col && $colspan > 1 ) { $anzahl = sizeof($this->cols[$row]); unset($this->cols[$row][$anzahl]); unset($this->c_colspan[$row][$anzahl]); $this->ChangeColSpan($row,$column,$colspan); } else if ( $colspan > 1 ) { $this->c_colspan[$row][$column] = $colspan; } else { echo "Fehler beim erstellen der Tabelle beim ndern des ColSpan"; } } } /** Puts a value into an html table column * * @desc Puts a value into an html table column * @param string the value that should be shown in the row $row and column $column * @param number the row number, if not given, the actual row is used ( the last row created ) * @param number the column number, if not given the actual is used ( the last created ) * @return void **/ function PutIntoColumn( $_theLine, $row= "", $column= "" ) { //global $ht; if ( empty($column) ) { $column= $this->act_col; } if ( empty($row) ) { $row= $this->max_row; } $this->cols[$row][$column] = $_theLine; } /** Changes the Vertical Alignment of an complete column * @return void * @param column_to_change column_number ( starting from 1 ) * @param ALIGN CENTER or LEFT or RIGHT * @desc Changes the alignment of all fields in the column column_to_change */ function ChangeColumnVerticalAlignment($column_to_change,$ALIGN) { for ( $i = 1; $i <= $this->max_row; $i++) { $this->c_valign[$i][$column_to_change] = $ALIGN; } } /** Changes the Alignment of an complete column * @return void * @param column_to_change column_number ( starting from 1 ) * @param ALIGN CENTER or LEFT or RIGHT * @desc Changes the alignment of all fields in the column column_to_change */ function ChangeColumnAlignment($column_to_change,$ALIGN) { for ( $i = 1; $i <= $this->max_row; $i++) { $this->c_align[$i][$column_to_change] = $ALIGN; } } /** Changes the Alignment of an complete row * @return void * @param row_to_change Number Of Row ( starting from 1 ) * @param ALIGN CENTER or RIGHT or LEFT * @desc Changes the Alignment of all fields in the Row (row_to_change ) */ function ChangeRowAlignment($row_to_change,$ALIGN) { for ( $i = 1; $i <= $this->max_col; $i++ ) { $this->c_align[$row_to_change][$i] = $ALIGN; } } /** Changes the color of a complete row * or on all rows from the named one, if arg #3 is true * * @return void * @param row_to_change Number Of Row ( starting from 1 ) * @param color e.g. "#000000" or "black" * @param all = false true or false * @desc Changes the color of all fields in the Row (row_to_change) or all fields in table ( if all = true ) */ function ChangeRowColor($row_to_change,$color,$all=false) { if ( $all ) { for ( $The_rows_to_change = $row_to_change ; $The_rows_to_change <= $this->max_row; $The_rows_to_change++ ) { for ( $i = 1; $i <= $this->max_col; $i++ ) { $this->c_bgcolor[$The_rows_to_change][$i] = $color; } } } else { for ( $i = 1; $i <= $this->max_col; $i++ ) { $this->c_bgcolor[$row_to_change][$i] = $color; } } } /** Changes the color of a complete color * or on all column from the named one, if arg #3 is true * * @return void * @param column_to_change Number of Column( starting from 1 ) * @param color e.g. #000000 or "black" * @desc Change all fields in one Column(column_to_change) to color ( color ) */ function ChangeColumnColor($column_to_change,$color) { for ( $i = 1; $i <= $this->max_row; $i++) { //$this->c_bgcolor[$i][$column_to_change] = $color; //$this->ColumnBackgroundColor($i,$column_to_change,$color); $this->SetColumnBackgroundColor($i,$column_to_change,$color); } } /** Adds a column after the actual row ( the last one created ) * @return void * @desc Adds a column to the Actual Row. If the Actual row has the most columns, all other rows are updated to the same amount of cols */ function AddColumn() { $this->act_col++; if ( $this->act_col > $this->max_col ) $this->max_col = $this->act_col; //$this->cols[$this->max_row][$this->act_col] = $_theLine; } /** Adds a column after the actual column ( the last one created ) * @return void * @desc Adds a new row to the table construct */ function AddRow() { $this->max_row++; $this->act_col = 0; } function GetRowAmount() { return $this->max_row; } /** Inserts a new Column in all rows between col-1 and col * before the column with the number $col * @return void * @param col Column number ( starts from 1) * @desc Inserts a new Column in all rows between col-1 and col */ function InsertColumn($col) { for ( $_row = 1; $_row <= $this->max_row; $_row++ ) { for ( $_col = $this->max_col; $_col >= $col; $_col-- ) { $this->cols[$_row][$_col+1] = $this->cols[$_row][$_col]; $this->cols[$_row-2][$col] = ""; } } //global $ht; $this->cols[$_row-2][$col] = ""; $this->max_col++; } /** Inserts a new Row between $row-1 and $row * * @desc Inserts a new Row between $row-1 and $row * * @param number the row number, which will be after the new row * @return void **/ function InsertRow($row) { for ( $_row = $this->max_row ; $_row >= $row ; $_row-- ) { for ( $_col = 1; $_col <= $this->max_col; $_col++) { $this->cols[$_row+1][$_col] = $this->cols[$_row][$_col]; $this->c_colspan[$_row+1][$_col] = $this->c_colspan[$_row][$_col]; } } for ( $_col = 1; $_col <= $this->max_col; $_col++) { $this->cols[$row][$_col] = ""; $this->c_colspan[$row][$_col] = 1; } $this->max_row++; } /** Finalizes a table construct, * adds all tags, wich are not specially defined * @desc Finalizes a table construct * @return void * @access private **/ function SaneTable() { for ( $_row = 1; $_row <= $this->max_row; $_row++ ) { for ( $_col = 1; $_col <= $this->max_col; $_col++ ) { $tmp = trim($this->cols[$_row][$_col]); $x = isset($this->cols[$_row][$_col]); if ( ! isset($this->cols[$_row][$_col]) ) { $this->cols[$_row][$_col] = "&nbsp;"; } else if ( empty($tmp) ) { $this->cols[$_row][$_col] = $this->cols[$_row][$_col]."&nbsp;"; } if ( empty( $this->c_colspan[$_row][$_col]) ) { $this->c_colspan[$_row][$_col] = 1; } if ( $this->table_finished ) { if ( empty($this->c_bgcolor[$_row][$_col]) ) { $this->c_bgcolor[$_row][$_col] = $this->t_bgcolor; } if ( empty( $this->c_align[$_row][$_col]) ) { $this->c_align[$_row][$_col] = $this->c_align_default; } if ( empty( $this->c_valign[$_row][$_col]) ) { $this->c_valign[$_row][$_col] = $this->c_valign_default; } if ( empty( $this->c_vspace[$_row][$_col]) ) { $this->c_vspace[$_row][$_col] = ""; } if ( empty( $this->c_height[$_row][$_col]) ) { $this->c_height[$_row][$_col] = ""; } if ( empty( $this->c_width[$_col]) ) { $this->c_width[$_col] = ceil(100/$this->max_col); } if ( empty( $this->c_head[$_col]) ) { $this->c_head[$_row][$_col] = false; } } //$this->cols[$_row][$_col] .= " $_row --> $_col "; } // $col_span = array_sum($this->c_colspan[$_row]); //echo $col_span; } } /** Checks if the table definition is complete * @return void * @desc The current table construct is beeing parsed, and searched for missing or invalid columns */ function TestTable() { //global $ht; //$ht->Write_R($this->cols); for ( $i = 0; $i < $this->rows; $i++ ) { if ( sizeof($this->cols[$i]) != $sizeof($this->cols[0]) ) { print "Fehler in zeile $i"; } } } /** * Writes the $_theLine with an Linebreak in HTML AND in source code * @desc Schreibe nach HTML mit HTML Newline und mit Sourcecode Newline */ function W_WriteLn($_theLine="") { return $_theLine . "\n<br>\n"; } /** generates the table and returns the html code for it * returnes a complete ( and sane ) HTML Table construct * @return string * @desc returns the HTML Table constructm after validating and filling the missing columns */ function GenTable() { //global $ht; //$ht = new W_HTMLGeneration(); $this->table_finished = true; $this->TestTable(); $this->SaneTable(); $c_size = 100 / $this->max_col; $the_table = $this->OpenTableX(); for ( $_row = 1; $_row <= $this->max_row; $_row++ ) { $the_table .= $this->Row(true); for ( $_col = 1; $_col <= $this->max_col; $_col++ ) { if ( $this->row_headings[$_row] == 1 ) { $this->c_head[$_row][$_col] = true; $the_table .= $this->Column(true,$_row,$_col); if ( !empty($this->c_prefix[$_col])) { $the_table .= $this->c_prefix[$_col]; } $the_table .= $this->cols[$_row][$_col]; if ( !empty($this->c_postfix[$_col])) { $the_table .= $this->c_postfix[$_col]; } $the_table .= $this->Column(false,$_row,$_col); if ( $this->c_colspan[$_row][$_col] > 1 ) { $_col += $this->c_colspan[$_row][$_col] -1; } } else { $the_table .= $this->Column(true,$_row,$_col); if ( !empty($this->c_prefix[$_col])) { $the_table .= $this->c_prefix[$_col]; } $the_table .= $this->cols[$_row][$_col]; if ( !empty($this->c_postfix[$_col])) { $the_table .= $this->c_postfix[$_col]; } $the_table .= $this->Column(false); if ( $this->c_colspan[$_row][$_col] > 1 ) { $_col += $this->c_colspan[$_row][$_col] -1; } } } $the_table .= $this->Row(false); } $the_table .= $this->CloseTableX(); return $the_table; } /** DO NOT USE * @desc DO NOT USE * @access private **/ function OpenTableX() { $this->open_tab++; $result = "\n"; for ( $i=0;$i<=$this->open_tab;$i++) { $result .= " "; } $result .= '<table summary="_" '; if ( !empty($this->t_size) ) { $result .= ' width="'.$this->t_size.'"'; } $result .= ' border="'.$this->t_border.'"'; $result .= ' cellspacing="'.$this->t_cellspacing.'"'; $result .= ' cellpadding="'.$this->t_cellpadding.'"'; if ( !empty($this->t_bgcolor) ) { $result .= ' bgcolor="'.$this->t_bgcolor.'"'; } if ( !empty($bordercolor) ) { $result .= ' BORDERCOLOR="'.$bordercolor.'" '; } if ( $this->t_align != "" ) { $result .= ' align="'. $this->t_align .'" '; } $result .= ">"; return $result; } /** * @return unknown * @desc DO NOT CALL THIS FUNCTION DIRECTLY. Ends the HTML Table Construct. DO NOT CALL THIS FUNCTION DIRECTLY */ function CloseTableX() { $result = "\n"; for ( $i=0;$i<=$this->open_tab;$i++) { $result .= ""; } $this->open_tab--; $result .= '</TABLE>'; return $result; } /** * @return unknown * @param start true ( td open ) or false (td close ) * @param _row = null Rownumber ( starts from 1 ) * @param _col = null Columnnumber ( starts from 1 ) * @desc Creates the HTML Code for an tabledatafield. uses Classvariablesarray for instructions */ function Column($start,$_row=0,$_col=0) { if ( $start ) { $this->open_Col++; } $result = "\n"; for ( $i=0;$i<=$this->open_tab + $this->open_Row + $this->open_Col ;$i++) { $result .= " "; } if ( !$start) { $this->open_Col--; } if ( $start ) { $result .= '<T'; } else { $result .= '</T'; } if ( $this->c_head[$_row][$_col] == true ) { $result .= 'H '; } else { $result .= 'D '; } if ( $start ) { if ( !empty($this->c_bgcolor[$_row][$_col]) ) $result .= 'BGCOLOR="'.$this->c_bgcolor[$_row][$_col] .'" '; if ( !empty($this->c_align[$_row][$_col]) ) $result .= ' ALIGN="'.$this->c_align[$_row][$_col].'" '; if ( !empty($this->c_colspan[$_row][$_col]) ) $result .= ' COLSPAN="'.$this->c_colspan[$_row][$_col].'" '; if ( !empty($this->c_rowspan[$_row][$_col]) ) $result .= ' ROWSPAN="'.$this->c_rowspan[$_row][$_col].'" '; if ( !empty($this->c_valign[$_row][$_col]) ) $result .= ' VALIGN="'.$this->c_valign[$_row][$_col].'" '; if ( !empty($this->c_vspace[$_row][$_col]) ) $result .= ' VSPACE="'.$this->c_vspace[$_row][$_col].'" '; if ( !empty($this->c_height[$_row][$_col]) ) $result .= ' HEIGHT="'.$this->c_height[$_row][$_col].'" '; if ( !empty($this->c_width[$_row][$_col]) ) $result .= ' WIDTH="'.$this->c_width[$_col].'" '; /*if ( $this->c_bgcolor != "") { $result .= 'BGCOLOR="'.$this->c_bgcolor .'" '; } if ( $this->c_align != "" ) { $result .= ' ALIGN="'.$this->c_align.'" '; } if ( $this->c_colspan != "") { $result .= ' COLSPAN="'.$this->c_colspan.'" '; } if ( $this->c_rowspan != "") { $result .= ' ROWSPAN="'.$this->c_rowspan.'" '; } if ( $this->c_valign != "" ) { $result .= ' VALIGN="'.$this->c_valign.'" '; } if ( $this->c_vspace != "" ) { $result .= ' VSPACE="'.$this->c_vspace.'" '; } if ( $this->c_height != "" ) { $result .= ' HEIGHT="'.$this->c_height.'" '; } if ( $this->c_width != "" ) { $result .= ' WIDTH="'.$this->c_width.'" '; }*/ //if ( $this->c_nowrap != "" ) { $result .= ' nowrap';} } $result .= ">\n"; return $result; } /** DO NOT USE * @desc DO NOT USE * @access private **/ function Row($start,$valign="") { if ( $start ) { $this->open_Row++; } $result = "\n"; for ( $i=0;$i<=$this->open_tab + $this->open_Row ;$i++) { $result .= " "; } if ( !$start ) { $this->open_Row--; } if ( $start ) { $result .= "<TR"; if ( $valign != "" ) { $result .= ' VALIGN="'.$valign.'" '; } } else { $result .= "</TR"; } $result .= ">\n"; return $result; } /** DO NOT USE * @desc DO NOT USE * @access private **/ function WriteTableHead($heading) { global $w_ht; $result = $this->Row(true); for ( $i = 0; $i < sizeof($heading); $i++) { $result .= $this->Column(true,"",CENTER,"","","","","","","",true); $result .= $this->PutIntoColumn($w_ht->W_WriteLn($heading[$i]),1,$i+1); //$result .= $this->PutIntoColumn(($heading[$i]),1,$i+1); $result .= $this->Column(false,"","","","","","","","","",true); } $result .= $this->Row(false); return $result; } /** * generates a empty HTML Table column * * for $colsize look at StartColumn ($width) */ function NullColumn($colsize="",$head=false,$bgcol="",$colspan=1,$rowspan=1) { if (!empty($colsize)) { $result = $this->Column(true,$bgcol,CENTER,$colspan,0,0,"",$colsize,"",$rowspan,$head); } else { $result = $this->Column(true,$bgcol,CENTER,$colspan,0,0,"","50%","",$rowspan,$head); } $result .= $this->WriteLine("&nbsp;"); $result .= $this->Column(false); return $result; } function ReadCommentsForColumns($column_name,$table_name,$which=0) { global $db,$CONNECTION; $sql = "select comments from all_col_comments where table_name = '"; $sql .= $table_name ; $sql .= "'"; $sql .= " AND COLUMN_NAME = '"; $sql .= $column_name; $sql .= "'"; $Column_info = $db->loadATable($sql, $CONNECTION, "DBA_COL_COMMENTS"); array_shift($Column_info); $commentar = explode(":",$Column_info[0][0]); if ( !empty($commentar[$which] )) { return $commentar[$which]; } elseif ( !empty($commentar[0]) ) { return $commentar[0]; } else { return "Keine Kommentar f r Feld ". $column_name; } } } ?>
This PHP script will take the contents of a character delimited text file and create a nice looking table for it. file2table.php <?php // // This PHP script will take the contents of a character delimited text file // and create a nice looking table for it. // // Rules of the text file: // 1. First line of text file should the the table headings // 2. Each column should be separated by the delimiter // 3. Default colors will be blue and white // 4. Default tablename ( id ) will be "table_x" where x will be incremented // if there are multiple function calls. // // SYNTAX: // // echo file2table( $filename, $tablename, $delimeter, $r_color1, $r_color2 ); // // $x=0; function file2table( $filename, $tablename, $delimeter, $r_color1, $r_color2 ) { $x++; $border=0; $cellspacing=4; $thColor="aqua"; $align="center"; $rowctr=0; // change to 1 if you do not want table headers $result = "<div id=\"table_$x\">\n\t"; $result .= "<table border=\"$border\" cellspacing=\"$cellspacing\" align=\"$align\">\n\t\t"; //$file = "info/contracts_warranties.txt"; $file = "$filename"; $fd = @fopen( $file, "r" ); while( !feof( $fd ) ) { $rowctr++; $buffer = fgets( $fd, filesize( $file ) ); $line = explode( $delimeter, rtrim( $buffer ) ); //$arrylgth = count( $line ); if( $rowctr == 1 ) { $result .= "<tr>\n\t\t\t"; $arrylgth = count( $line ); for( $colctr = 0; $colctr < $arrylgth; $colctr++ ) { $result .= "<th bgColor=\"$thColor\" nowrap><font size=\"+1\">$line[$colctr]</font></th>\n\t\t\t"; } $result .= "\n\t\t</tr>"; $columns = $arrylgth; } else { $result .= "<tr>\n\t\t\t"; $altcolor++; for( $colctr = 0; $colctr < $columns; $colctr++ ) { if( $line[$colctr] == "" ) { $line[$colctr] = "&nbsp;"; } if( $altcolor%2 == 0 ) { $result .= "<td bgColor=\"$r_color1\">$line[$colctr]</td>\n\t\t\t"; } else { $result .= "<td bgColor=\"$r_color2\">$line[$colctr]</td>\n\t\t\t"; } } $result .= "\n\t\t</tr>"; } } $result .= "\n\t</table>\n\t</div>\n"; fclose( $fd ); return $result; } ?> filename.php - This is the file that calls the above function. <html> <head> <title>AutoTAP results from car</title> <!-- Include the "file2table.php" function for use --> <?php require( "file2table.php" ); ?> </head> <body bgColor="white"> <? echo file2table "../aug21b.csv", "geotable", ",", "lightyellow", "lightgreen" ); ?> </body> </html>
This class create a ajax-driven dynamic table. Data are retrieved fron an SQLite database and updated on-the-fly as the user changes them. Full package downloadable here http://www.evolvetechnologies.it/duepuntozero/esempi/dyntable_sqlite.zip class dyntable { var $fixed_width; //Variabile booleana che indica se la larghezza della tabella fissa var $table_code; //Il codice html della tabella generato var $headers = array(); //Array contenente le testate delle colonne var $rows = array(); //Array contenente le righe della tabella var $actions = array(); //Array contenente le azioni delle celle var $col_align = array(); //Array contenente gli allineamenti delle celle var $num_cols; //Numero delle colonne della tabella var $col_width = array(); //Array contenente la larghezza per ciascuna colonna var $default_width = 30; //Larghezza di default delle colonne var $editable; //Variabile booleana che indica se le celle dalla tabella sono modificabili var $print_row_number; //Variabile booleana che indica se stampare i numeri di riga var $row_height = 17; //Altezza delle righe var $row_wrap = true; //Variabile booleana che indica se il testo puo andare a capo var $number_column_width = 14; //Larghezza della colonna dei numeri di riga function dyntable($num_cols,$col_width=array(),$print_row_number=false,$fixed_width=true,$editable=false) { //scrivo il numero di colonne della tabella $this->num_cols = $num_cols; //se ricevo la larghezza di ciascuna colonna la scrivo if($col_width) $this->col_width = $col_width; //altrimenti setto tutte le colonne alla larghezza di default else { for($i = 0; $i < $this->num_cols; $i++) array_push($this->col_width,$this->default_width); } //Scrivo se la tabella deve avere lunghezza fissa o no $this->fixed_width = $fixed_width; //Scrivo se le celle della tabella sono modificabili $this->editable = $editable; //Scrivo se stampare i numeri di riga $this->print_row_number = $print_row_number; } function add_headers($headers_array = array()) { //Se ricevo i valori da inserire nella testata li scrivo if($headers_array) $this->headers = $headers_array; //altrimenti inserisco una testata vuota else { for($i = 0; $i < $this->num_cols; $i++) array_push($this->headers,""); } } function add_row($values_array = array(),$action_array = array()) { //Se ricevo i valori da inserire nella riga li scrivo if($values_array) array_push($this->rows,$values_array); //altrimenti inserisco una riga vuota else { for($i = 0; $i < $this->num_cols; $i++) array_push($this->rows,""); } if($action_array) array_push($this->actions,$action_array); } function create() { /************************************************ TESTATA DELLA TABELLA ************************************************/ echo "<div class=\"row\">\n"; //se devo stampare i numeri di riga aggiungo una colonna if($this->print_row_number) { echo "<div nowrap=\"nowrap\" class=\"head\" id=\"head_0\" style=\"width:".$this->number_column_width."px;\"></div>\n"; echo "<div nowrap=\"nowrap\" class=\"drag\" id=\"drag_0\" onMouseDown=\"start_resize(this)\"></div>\n"; } //stampo tutte le testate tranne l'ultima ed inserisco il separatore per ridimensionare for($i = 1; $i < $this->num_cols; $i++) { $width = $this->col_width[$i-1]; $testo = $this->headers[$i-1]; echo "<div nowrap=\"nowrap\" class=\"head\" id=\"head_$i\" style=\"width:".$width."px;\">$testo</div>\n"; echo "<div nowrap=\"nowrap\" class=\"drag\" id=\"drag_$i\" onMouseDown=\"start_resize(this)\"></div>\n"; } $testo = $this->headers[$i-1]; $width = $this->col_width[$i-1]; //stampo l'ultima colonna senza sepatatore in fondo echo "<div nowrap=\"nowrap\" class=\"head\" id=\"head_$i\" style=\"width:".$width."px;\">$testo</div>\n"; echo "</div>\n"; /************************************************ CORPO DELLA TABELLA ************************************************/ $num = 1; foreach ($this->rows as $row) { echo "<div class=\"row\">\n"; //se devo stampare i numeri di riga aggiungo una colonna if($this->print_row_number) { echo "<div nowrap=\"nowrap\" class=\"col0\"style=\"text-align:right;width:".$this->number_column_width."px;\">$num</div>\n"; echo "<div nowrap=\"nowrap\" class=\"sep\"></div>\n"; } $array_azioni = $this->actions[$num-1]; //stampo tutte le colonne tranne l'ultima ed inserisco il separatore for($i = 1; $i < $this->num_cols; $i++) { $testo = $row[$i-1]; $width = $this->col_width[$i-1]; $azione = $array_azioni[$i-1]; if($this->editable) $edit = " ondblclick=\"edit(this,'$azione')\""; echo "<div class=\"col$i\" style=\"width:".$width."px;\"$edit>$testo</div>\n"; echo "<div nowrap=\"nowrap\" class=\"sep\"></div>\n"; } $testo = $row[$i-1]; $width = $this->col_width[$i-1]; $azione = $array_azioni[$i-1]; if($this->editable) $edit = " ondblclick=\"edit(this,'$azione')\""; //stampo l'ultima colonna senza sepatatore in fondo echo "<div class=\"col$i\" style=\"width:".$width."px;\"$edit>$testo</div>\n"; echo "</div>\n"; $num++; } } function set_rows($row_height,$row_wrap=true) { $this->row_height = $row_height; $this->row_wrap = $row_wrap; } function print_scripts() { echo "<script language=\"JavaScript\" type=\"text/javascript\" src=\"js/dyntable.js\"></script>"; if($this->fixed_width) echo "<script>\nvar fixed_width = true;</script>\n"; else echo "<script>\nvar fixed_width = false;\n</script>\n"; } function set_align($array_align) { $this->col_align = $array_align; } function print_styles() { echo "<link href=\"css/dyntable.css\" rel=\"stylesheet\" type=\"text/css\" />"; echo "<style>\n"; if($this->print_row_number) { echo ".col0 {\n"; echo "padding-top:3px;\n"; echo "margin-top:-1px;\n"; echo "float:left;\n"; echo "border: 1px solid #E2E2E2;\n"; echo "overflow:hidden;\n"; echo "height:".$this->row_height."px;\n"; echo "padding-left:5px;\n"; echo "border-left: 0px solid #E2E2E2;\n"; echo "border-right: 0px solid #E2E2E2;\n"; echo "white-space: nowrap"; echo "}\n"; } for($i = 1; $i < $this->num_cols+1; $i++) { echo ".col$i {\n"; echo "padding-top:3px;\n"; echo "margin-top:-1px;\n"; echo "float:left;\n"; echo "border: 1px solid #E2E2E2;\n"; echo "overflow:hidden;\n"; echo "height:".$this->row_height."px;\n"; echo "padding-left:5px;\n"; echo "border-left: 0px solid #E2E2E2;\n"; echo "border-right: 0px solid #E2E2E2;\n"; if(!$this->row_wrap) echo "white-space: nowrap\n"; if($this->col_align) { $align = $this->col_align[$i-1]; echo "text-align:$align\n"; } echo "}\n"; } echo ".sep {\n"; echo "float:left;\n"; echo "border: 0px solid #E2E2E2;\n"; echo "height:".$this->row_height."px;\n"; echo "width:3px;\n"; echo "border-left:none;\n"; echo "border-right:none;\n"; echo "background-image:url(images/sep.gif);\n"; echo "}\n"; echo "</style>\n"; } }
A simple code to present data from the database with altering background color function everyother($bgcolor) { static $counter=0; if ($counter % 2 == 0) { echo "$ind<tr style=\"background-color:$bgcolor\">\n"; } else { echo "$ind<tr style=\"background-color:#ffffff\">\n"; } $counter++; }
PHP 5 Class to generate HTML tables. Fixes most of the common problems with tables (empty cells, different number of columns per row, etc). Supports all w3 standard tags and attributes. Allows for alternating row colors (any number of colors may be used). <?php /* * table.class.php - quick and dirty table classes * * @author Aaron D. Campbell <acampbell@autotransteam.com> * * TODO: make rowspan work with 0 as parameter (0 is to span ALL rows) */ /* * Cell - basic cell creation */ class Cell{ //$settings - array - containing all possible settings as keys public $settings = array('data'=>NULL, 'abbr'=>NULL, 'rowspan'=>NULL, 'colspan'=>NULL, 'id'=>NULL, 'style'=>NULL, 'class'=>NULL, 'lang'=>NULL, 'dir'=>NULL, 'title'=>NULL, 'onclick'=>NULL, 'ondblclick'=>NULL, 'onmousedown'=>NULL, 'onmouseup'=>NULL, 'onmouseover'=>NULL, 'onmousemove'=>NULL, 'onmouseout'=>NULL, 'onkeypress'=>NULL, 'onkeydown'=>NULL, 'onkeyup'=>NULL, 'align'=>NULL, 'char'=>NULL, 'charoff'=>NULL, 'valign'=>NULL); //$data is this cell's data, and $th is a bool telling if the cell is a header cell public $data, $th; /* * public function __construct * * @param string $data The data for the cell * @param array $settings an associative array containing any of the following keys: * 'abbr' - string - abbreviation for header cell * 'rowspan' - int - number of rows spanned by cell * 'colspan' - int - number of columns spanned by cell * 'id' - string - document-wide unique id for cell * 'style' - string - style info for cell * 'class' - string - space-separated list of classes for cell * 'lang' - string - language code for contents of cell * 'dir' - string - direction for weak/neutral text in cell (LTR | RTL) * 'title' - string - advisory title * 'align' - string - align, text alignment (left | center | right | justify | char) * 'char' - string - alignment char, e.g. char=':' * 'charoff' - string - offset for alignment char * 'valign' - string - vertical alignment in cell (top | middle | bottom | baseline) * The following Intrinsic events all correspond to their names, and are strings: * 'onclick', 'ondblclick', 'onmousedown', 'onmouseup', 'onmouseover', * 'onmousemove', 'onmouseout', 'onkeypress', 'onkeydown', 'onkeyup' * * @param bool $th tells whether the cell is a header cell (<th>). * Defaults to FALSE * * Please note thataccording to w3 standards * (http://www.w3.org/TR/html4/index/attributes.html), align and valign are NOT * depreciated as of 04/04/2005 for the following: COL, COLGROUP, TBODY, TD, TFOOT, * TH, THEAD, or TR * * @return void */ public function __construct($data=NULL, $settings=array(), $th=false){ //remove all empty settings. They are useless. $settings = array_diff($settings,array('')); //Check that dir, align, and valign are set to acceptable values per w3 standards if(isset($settings['dir'])){ $options = array('rtl', 'ltr'); $settings['dir'] = strtolower($settings['dir']); if(!in_array($settings['dir'],$options)){unset($settings['dir']);} } if(isset($settings['align'])){ $options = array('left', 'center', 'right', 'justify', 'char'); $settings['align'] = strtolower($settings['align']); if(!in_array($settings['align'],$options)){unset($settings['align']);} } if(isset($settings['valign'])){ $options = array('top', 'middle', 'bottom', 'baseline'); $settings['valign'] = strtolower($settings['valign']); if(!in_array($settings['valign'],$options)){unset($settings['valign']);} } /* * go through each setting. If the setting is valid (a key exists in * $this->settings for it) set the value accordingly */ foreach($this->settings as $setting => $value){ if(array_key_exists(strtolower($setting),$settings)){ $this->settings[$setting] = $settings[$setting]; } } $this->data = $data; $this->th = $th; } /* * public function get_cell * * Assembles the cell, including all it's settings, and returns the proper HTML as * a string * * @return string */ public function get_cell(){ //set the cell type to 'th' or 'td' depending on $this->th $cell_type = ($this->th) ? 'th' : 'td'; //$c is the html for the cell $c = " <{$cell_type}"; //step through the settings for the cell, and add any that are set foreach($this->settings as $setting => $value){ if(isset($value)){$c .= " {$setting}=\"{$value}\"";} } if ($this->data == '') {$this->data = '&nbsp;';} $c .= ">{$this->data}</{$cell_type}>\r\n"; return $c; } } /* * Row - basic row creation */ class Row{ //$cells is an array containing references to each instance of a Cell in this Row public $cells = array(); //$settings - array - containing all possible settings as keys public $settings = array('id'=>NULL, 'style'=>NULL, 'class'=>NULL, 'lang'=>NULL, 'dir'=>NULL, 'title'=>NULL, 'onclick'=>NULL, 'ondblclick'=>NULL, 'onmousedown'=>NULL, 'onmouseup'=>NULL, 'onmouseover'=>NULL, 'onmousemove'=>NULL, 'onmouseout'=>NULL, 'onkeypress'=>NULL, 'onkeydown'=>NULL, 'onkeyup'=>NULL, 'align'=>NULL, 'char'=>NULL, 'charoff'=>NULL, 'valign'=>NULL); //$cur_cell = reference pointing to the last added instance of Cell public $cur_cell; public $restart_colors; /* * public function __construct * * @param array $settings an associative array containing any of the following keys: * 'id' - string - document-wide unique id for row * 'style' - string - style info for row * 'class' - string - space-separated list of classes for row * 'lang' - string - language code for contents of row * 'dir' - string - direction for weak/neutral text in row (LTR | RTL) * 'title' - string - advisory title * 'align' - string - align, text alignment (left | center | right | justify | char) * 'char' - string - alignment char, e.g. char=':' * 'charoff' - string - offset for alignment char * 'valign' - string - vertical alignment in row (top | middle | bottom | baseline) * The following Intrinsic events all correspond to their names, and are strings: * 'onclick', 'ondblclick', 'onmousedown', 'onmouseup', 'onmouseover', * 'onmousemove', 'onmouseout', 'onkeypress', 'onkeydown', 'onkeyup' * * Please note thataccording to w3 standards * (http://www.w3.org/TR/html4/index/attributes.html), align and valign are NOT * depreciated as of 04/04/2005 for the following: COL, COLGROUP, TBODY, TD, TFOOT, * TH, THEAD, or TR * * @return void */ public function __construct($settings=array(),$restart_colors=false){ //remove all empty settings. They are useless. $settings = array_diff($settings,array('')); //Check that dir, align, and valign are set to acceptable values per w3 standards if(isset($settings['dir'])){ $options = array('rtl', 'ltr'); $settings['dir'] = strtolower($settings['dir']); if(!in_array($settings['dir'],$options)){unset($settings['dir']);} } if(isset($settings['align'])){ $options = array('left', 'center', 'right', 'justify', 'char'); $settings['align'] = strtolower($settings['align']); if(!in_array($settings['align'],$options)){unset($settings['align']);} } if(isset($settings['valign'])){ $options = array('top', 'middle', 'bottom', 'baseline'); $settings['valign'] = strtolower($settings['valign']); if(!in_array($settings['valign'],$options)){unset($settings['valign']);} } /* * go through each setting. If the setting is valid (a key exists in * $this->settings for it) set the value accordingly */ foreach($this->settings as $setting => $value){ if(array_key_exists(strtolower($setting),$settings)){ $this->settings[$setting] = $settings[$setting]; } } $this->restart_colors = $restart_colors; } /* * public function add_cell * * @param string $data * @param array $settings * @param bool $th * * All params get passed directly to Cell::__construct. Please see the * Cell::__construct notes for more information * * Creates a new instance of the Cell class, and adds it to the end of the cells * array * * updates $this->cur_cell to point to the new cell * * @return void */ public function add_cell($data=NULL,$settings=array(),$th=false){ $this->cells[] = new Cell($data,$settings,$th); $this->cur_cell =& $this->cells[sizeof($this->cells)-1]; } /* * public function get_row * * Assembles the row, including all it's settings and cells, and returns the proper * HTML as a string * * @return string */ public function get_row(){ //$r is the html for the row $r = ' <tr'; //step through the settings for the Row, and add any that are set foreach($this->settings as $setting => $value){ if(isset($value)){$r .= " {$setting}=\"{$value}\"";} } $r .= ">\r\n"; //step through all the cells, and add them to the row foreach($this->cells as $cell){$r .= $cell->get_cell();} $r .= " </tr>\r\n"; return $r; } } /* * Table - basic table creation */ class Table{ /* * $head_rows is an array containing references to each instance of a Row that * are part of the head (thead) of the table */ public $head_rows = array(); /* * $body_rows is an array containing references to each instance of a Row that * are part of the body (tbody) of the table */ public $body_rows = array(); /* * $foot_rows is an array containing references to each instance of a Row that * are part of the head (tfoot) of the table */ public $foot_rows = array(); //$settings - array - containing all possible settings as keys public $settings = array('id'=>NULL, 'style'=>NULL, 'class'=>NULL, 'lang'=>NULL, 'dir'=>NULL, 'title'=>NULL, 'onclick'=>NULL, 'ondblclick'=>NULL, 'onmousedown'=>NULL, 'onmouseup'=>NULL, 'onmouseover'=>NULL, 'onmousemove'=>NULL, 'onmouseout'=>NULL, 'onkeypress'=>NULL, 'onkeydown'=>NULL, 'onkeyup'=>NULL, 'frame'=>NULL, 'rules'=>NULL, 'summary'=>NULL, 'width'=>NULL, 'border'=>0, 'cellspacing'=>0, 'cellpadding'=>0); public $row_colors = NULL; //$cur_row = reference pointing to the last added instance of Row public $cur_row; /* * Number of rows and columns in the table. * $num_rows in incremented * $num_cols is set inside prep_table() */ public $num_cols = 0; public $num_rows = 0; /* * public function __construct * * @param array $settings an associative array containing any of the following keys: * 'id' - string - document-wide unique id for row * 'style' - string - style info for row * 'class' - string - space-separated list of classes for row * 'lang' - string - language code for contents of row * 'dir' - string - direction for weak/neutral text in row (LTR | RTL) * 'title' - string - advisory title * 'frame' - string - which parts of table frame to render * (void|above|below|hsides|lhs|rhs|vsides|box|border) * 'rules' - string - rulings between rows and cols (none|groups|rows|cols|all) * 'summary' - string - purpose/structure for speech output * 'width' - string - table width * 'border' - int - controls frame width around table * 'cellspacing' - int - spacing between cells * 'cellpadding' - int - spacing within cells * 'row_colors' - array | string - array OR comma-seperated values, these are * background colors, given in hex, that alternate for each row. * They will NOT override a color set for a specific row. * They default to: #FFFFFF & #EFEFEF * The following Intrinsic events all correspond to their names, and are strings: * 'onclick', 'ondblclick', 'onmousedown', 'onmouseup', 'onmouseover', * 'onmousemove', 'onmouseout', 'onkeypress', 'onkeydown', 'onkeyup' * * @return void */ public function __construct($settings = array()){ //remove all empty settings. They are useless. $settings = array_diff($settings,array('')); //Check that dir, frame, and rules are set to acceptable values per w3 standards if(isset($settings['dir'])){ $options = array('rtl', 'ltr'); $settings['dir'] = strtolower($settings['dir']); if(!in_array($settings['dir'],$options)){unset($settings['dir']);} } if(isset($settings['frame'])){ $options = array('void', 'above', 'below', 'hsides', 'lhs', 'rhs', 'vsides', 'box', 'border'); $settings['frame'] = strtolower($settings['frame']); if(!in_array($settings['frame'],$options)){unset($settings['frame']);} } if(isset($settings['rules'])){ $options = array('none', 'groups', 'rows', 'cols', 'all'); $settings['rules'] = strtolower($settings['rules']); if(!in_array($settings['rules'],$options)){unset($settings['rules']);} } //get the row_colors to alternate if(isset($settings['row_colors'])){ if(!is_array($settings['row_colors'])){ $this->row_colors = explode(',',$settings['row_colors']); }else{$this->row_colors = $settings['row_colors'];} foreach($this->row_colors as $key => $value){ if(!preg_match('/^#/',$value)){$this->row_colors[$key] = '#'.$this->row_colors[$key];} } unset($settings['row_colors']); }else{$this->row_colors = array('#FFFFFF','#EFEFEF');} /* * go through each setting. If the setting is valid (a key exists in * $this->settings for it) set the value accordingly */ foreach($this->settings as $setting => $value){ if(array_key_exists(strtolower($setting),$settings)){ $this->settings[$setting] = $settings[$setting]; } } } /* * public function add_row * * @param array $settings * * All params get passed directly to Row::__construct. Please see the * Row::__construct notes for more information * * Creates a new instance of the Row class, and adds it to the end of the body_rows * array (rows that will go into tbody) * * updates $this->cur_row to point to the new Row * * @return Row */ public function &add_row($settings=array(),$restart_colors=false){ $this->body_rows[] = new Row($settings,$restart_colors); $this->cur_row = $this->body_rows[sizeof($this->body_rows)-1]; $this->num_rows++; return $this->body_rows[sizeof($this->body_rows)-1]; } /* * public function add_body_row * * @param array $settings * * All params get passed directly to Row::__construct. Please see the * Row::__construct notes for more information * * Creates a new instance of the Row class, and adds it to the end of the body_rows * array (rows that will go into tbody) * * updates $this->cur_row to point to the new Row * * @return Row */ public function &add_body_row($settings=array(),$restart_colors=false){ $this->body_rows[] = new Row($settings,$restart_colors); $this->cur_row = $this->body_rows[sizeof($this->body_rows)-1]; $this->num_rows++; return $this->body_rows[sizeof($this->body_rows)-1]; } /* * public function add_head_row * * @param array $settings * * All params get passed directly to Row::__construct. Please see the * Row::__construct notes for more information * * Creates a new instance of the Row class, and adds it to the end of the head_rows * array (rows that will go into thead) * * updates $this->cur_row to point to the new Row * * @return Row */ public function &add_head_row($settings=array(),$restart_colors=false){ $this->head_rows[] = new Row($settings,$restart_colors); $this->cur_row = $this->head_rows[sizeof($this->head_rows)-1]; $this->num_rows++; return $this->head_rows[sizeof($this->head_rows)-1]; } /* * public function add_foot_row * * @param array $settings * * All params get passed directly to Row::__construct. Please see the * Row::__construct notes for more information * * Creates a new instance of the Row class, and adds it to the end of the foot_rows * array (rows that will go into tfoot) * * updates $this->cur_row to point to the new Row * * @return Row */ public function &add_foot_row($settings=array(),$restart_colors=false){ $this->foot_rows[] = new Row($settings,$restart_colors); $this->cur_row = $this->foot_rows[sizeof($this->foot_rows)-1]; $this->num_rows++; return $this->foot_rows[sizeof($this->foot_rows)-1]; } /* * public function get_table * * Assembles the table, including all it's settings and rows, and returns the proper * HTML as a string * * @return string */ public function get_table(){ //run prep_table to fix minor errors, etc. $this->prep_table(); //run change_colspan0 to fix colspan=0 problem with IE (IE does not support it) $this->change_colspan0(); //$t is the html for the row $t = '<table'; //step through the settings for the table, and add any that are set foreach($this->settings as $setting => $value){ if(isset($value)){$t .= " {$setting}=\"{$value}\"";} } $t .= ">\r\n"; //Add all the rows, in the correct order (head, foot, body) //step through all the head_rows, and add them to the table in thead tags if(sizeof($this->head_rows) > 0){ $t .= " <thead>\r\n"; foreach($this->head_rows as $row){$t .= $row->get_row();} $t .= " </thead>\r\n"; } //step through all the foot_rows, and add them to the table in tfoot tags if(sizeof($this->foot_rows) > 0){ $t .= " <tfoot>\r\n"; foreach($this->foot_rows as $row){$t .= $row->get_row();} $t .= " </tfoot>\r\n"; } //step through all the body_rows, and add them to the table in tbody tags if(sizeof($this->body_rows) > 0){ $t .= " <tbody>\r\n"; foreach($this->body_rows as $row){$t .= $row->get_row();} $t .= " </tbody>\r\n"; } $t .= "</table>\r\n"; return $t; } /* * private function change_colspan0 * * Checks all cells, and if colspan is set to '0' it changes it to the total * columns in the table. This is because IE does not support the w3 standard where * colspan="0" means "span the whole table" * * @return void */ private function change_colspan0(){ $row_groups = array('head_rows'=>&$this->head_rows,'body_rows'=>&$this->body_rows,'foot_rows'=>&$this->foot_rows); foreach($row_groups as &$rows){ foreach($rows as &$row){ foreach($row->cells as &$cell){ if((isset($cell->settings['colspan'])) && ($cell->settings['colspan'] == '0')){ $cell->settings['colspan'] = $this->num_cols; } } } } } /* * private function find_diff * * @param array $c an array of cells per row in a table * * Modifies an array to how many cells need to be added to each row, in order for * the table to be right * * @return void */ private function find_diff(&$c){ if($c != NULL){$c = $this->num_cols - $c;}else{$c = 0;} } /* * private function prep_table * * Fixes common errors with HTML tables: * All empty cells are filled with '&nbsp;' * All rows are adjusted to be the same length * * Also adds alternating row colors * * @return void */ private function prep_table(){ $color = 0; $cols_from_rowspan = array(); $col_count = array(); //put all row arrays into an array, so we can loop through them in order that //they appear. This helps with rowspans $row_groups = array('head_rows'=>&$this->head_rows,'body_rows'=>&$this->body_rows,'foot_rows'=>&$this->foot_rows); //step through row groups (head, body, foot) foreach($row_groups as $key=>&$rows){ //add element to the $col_count array, correspoding to the current group $col_count[$key] = array(); //step through the rows in the current row_group foreach($rows as &$row){ //$cells is used to calculate the number of cells in each row $cells = 0; //add in cells from previous row spans if(isset($cols_from_rowspan[0])){$cells += array_shift($cols_from_rowspan);} //step through each cell in the current row foreach($row->cells as &$cell){ //if there IS a colspan set, compensate if(isset($cell->settings['colspan'])){ //if colspan is NOT set to 0, increment cell count by colspan if($cell->settings['colspan'] != '0'){ $cells += $cell->settings['colspan']; } //if colspan IS set to 0, and There are more cells in this row...unset //colspan...you can't have colspan=0 & have more cells elseif(count($row->cells) != 1){ unset($cell->settings['colspan']); $cells++; } //if colspan IS set to 0, and it's the only cell in the row, set cell count //to NULL (later used by $this->find_diff to let it know NOT to adjust //the number of cells in this row) else{$cells = NULL;} } //If there is no colspan set, increment the cell count ($cells) else{$cells++;} //If there is a rowspan set, compensate if(isset($cell->settings['rowspan'])){ //for each row that is spaned, add 1 or the colspan to an array...later //used to adjust the next rows. for($i=0;$i<$cell->settings['rowspan']-1;$i++){ if(isset($cols_from_rowspan[$i])){ if(isset($cell->settings['colspan'])){$cols_from_rowspan[$i] += $cell->settings['colspan'];} else{$cols_from_rowspan[$i]++;} } else{ if(isset($cell->settings['colspan'])){$cols_from_rowspan[$i] = $cell->settings['colspan'];} else{$cols_from_rowspan[$i] = 1;} } } } } //Set the col_count for the current group, for the current row to the number //of cells in this row $col_count[$key][] = $cells; //if the number of cells in this row is more than previous rows, adjust the //table's number of columns if($cells > $this->num_cols){$this->num_cols = $cells;} if($row->restart_colors){$color = 0;} //if there is no background color for the row, use the next row color in sequence if(!preg_match('/background-color:#[0-9A-F]{6}/',$row->settings['style'])){ if(!isset($row->settings['style'])){$row->settings['style'] = '';} $row->settings['style'] .= "background-color:{$this->row_colors[$color%sizeof($this->row_colors)]};"; } //increment to next color $color++; } } //step through the column counts from each row group foreach($col_count as $array => &$cur_col_count){ //change the array of cells per row into an array of numbers of cells to be //added to each row to fix the table. array_walk($cur_col_count,array(&$this,'find_diff')); //remove any rows that do NOT need any adjustment $cur_col_count = array_diff($cur_col_count,array(0)); //adjust rows, by adding cells foreach($cur_col_count as $key => $diff){ for($i=0;$i<$diff;$i++){ $this->{$array}[$key]->add_cell('&nbsp;'); } } } } } ?>
Why yet another table formatter? Because this allows to put more than one db field in the same table cell, or to use the same field in more than one cell. The example should explain better than my English. <?php class Table { var $tags = array( "table" => '<table cellpadding="2" cellspacing="0">', "tr.odd" => '<tr class="odd">', "tr.even" => '<tr class="even">', "th" => '<th>', "td" => '<td>' ); function setColumns($columns) { $this->columns = $columns; $this->rowCount = 0; print($this->tags["table"] . "\n"); print(" <tr>\n"); reset($columns); while (list($col,) = each($columns)) { print(" " . $this->tags["th"] . "$col</th>\n"); } print(" </tr>\n"); } function appendRow($values) { extract($values); $tr = ++$this->rowCount % 2 ? "tr.odd" : "tr.even"; print(" " . $this->tags[$tr] . "\n"); reset($this->columns); while (list(,$fmt) = each($this->columns)) { eval('$str = "'. addslashes($fmt) . '";'); print(" " . $this->tags["td"] ."$str</td>\n"); } print(" </tr>\n"); } function show() { print("</table>\n"); } } ?>
This example shows a table with 15 rows. Each row alternates the background color between light blue and dark blue. <HTML> <HEAD><TITLE>Alternate background color</TITLE> </HEAD> <BODY bgcolor="#FFFFFF"> <? /* Author: Christiano Anderson */ /* E-mail: anderss@zaz.com.br */ /* WebSite: http://www.anderson.eti.br */ function BackColor() { static $BackColorValue; if($BackColorValue == "#A0BFFF") { $BackColorValue = "#694FF"; } else { $BackColorValue = "#A0BFFF"; } return($BackColorValue); } print "<TABLE border=\"0\">\n"; for($idrow=0; $idrow < 15; $idrow++) { $RowColor = BackColor(); print "<TR><TD BGCOLOR=\"$RowColor\">"; print "This is the row $idrow</TD></TR>\n"; } print "</TABLE>\n"; ?> </BODY></HTML>
a PHP class that allow to generate table with e.g alternate row and columns colors, various cells dimensions, alignement, set header properties, ecc. <? class HTML_table { // number of the table columns var $col_number = 1; // number of the table rows var $row_number = 1; // style of the table border var $border_style = ""; // table width in absolute or percent var $table_width = ""; // columns widths array var $col_width = array(); // columns names array var $col_name = array(); // alignement of the cells containing column names var $col_name_align = array(); // border style of the cells containing column names var $col_name_border = array(); // style of the TH cells var $col_name_style = array(); // cells contents var $data = array(); // cells background colors var $cell_color = array(); // cells horizontal alignement var $cell_align = array(); // cells vertical alignement var $cell_valign = array(); // cells height var $cell_height = array(); // cell style var $cell_style = array(); /* html code that will be written between <TABLE> und the first tag of the table, e.g. for form */ var $hidden_header = ""; /* html code that will be written between the last first tag of the table and the </TABLE>, e.g. for form */ var $hidden_footer = ""; function HTML_table() { $this->column_width[0] = ""; $this->column_name[0] = ""; } function setTableWidth($width) { $this->table_width = $width; } function setColsNumber($num) { $this->col_number = $num; } function setColWidth($col, $width) { $this->col_width[$col] = $width; if(($col <> 0)&&($this->col_width[0] =="")) {$this->col_width[0] = 0;} } function setColumnsWidth($array) { $col = 0; foreach($array as $k) { $this->setColWidth($col, $k); $col++; } } function setColName($col, $name) { $this->col_name[$col] = $name; if(($col <> 0)&&($this->col_name[0]=="")) {$this->col_name[0] = "&nbsp";} } function setColumnsName($array) { $col = 0; foreach($array as $k) { $this->setColName($col, $k); $col++; } } function setColNameAlign($col, $align) { $this->col_name_align[$col] = $align; if(($col <> 0)&&($this->col_name_align[0]=="")) {$this->col_name_align[0] = "&nbsp";} } function setColumnsNameAlign($array) { $col = 0; foreach($array as $k) { $this->setColNameAlign($col, $k); $col++; } } function setColNameBorder($col, $border) { $this->col_name_border[$col] = $border; if(($col <> 0)&&($this->col_name_border[0]=="")) {$this->col_name_border[0] = "&nbsp";} } function setColNameStyle($col, $style) { $this->col_name_style[$col] = $style; if(($col <> 0)&&($this->col_name_style[0]=="")) {$this->col_name_style[0] = "&nbsp";} } function setColumnsNameStyle($array) { $col = 0; foreach($array as $k) { $this->setColNameStyle($col, $k); $col++; } } function setRowsNumber($num) { $this->row_number = $num; } function setBorderStyle($border) { $this->border_style = $border; } function setCellColor($row, $col, $color) { $this->cell_color[$row][$col] = $color; } function setRowColor($row, $color) { for($col = 0; $col < $this->col_number; $col++) { $this->cell_color[$row][$col] = $color; } } function setColColor($col, $color) { for($row = 0; $row < $this->row_number; $row++) { $this->cell_color[$row][$col] = $color; } } function setCellAlign($row, $col, $align) { $this->cell_align[$row][$col] = $align; } function setCellValign($row, $col, $valign) { $this->cell_valign[$row][$col] = $valign; } function setCellHeight($row, $col, $height) { $this->cell_height[$row][$col] = $height; } function setRowHeight($row, $height) { for($col = 0; $col < $this->col_number; $col++) { $this->setCellHeight($row, $col, $height); } } function insertCell($row, $col, $content) { $this->data[$row][$col] = $content; } function insertRow($row, $content) { $col = 0; foreach($content as $k) { $this->insertCell($row, $col, $k); $col++; } } function insertHiddenHeader($string) { $this->hidden_header .= $string; } function insertHiddenFooter($string) { $this->hidden_footer .= $string; } function returnTableOpenTag() { $output = ""; $output .= "\n".'<TABLE CELLSPACING="1" CELLPADDING="1"'; if($this->border_style <> "") { $output .=" border=\"".$this->border_style."\" "; } if($this->table_width <> "") { $output .="width=\"".$this->table_width."\" "; } $output .= ">\n"; return $output; } function returnTableHeader() { $output = ""; $output .= "<TR align = \"center\">\n"; if(($this->col_width[0] <> "")||($this->col_name[0] <> "")) { for($col = 0; $col < $this->col_number; $col++) { $output .= '<TH'; if($this->col_width[$col] <> "") { $output .= " width=\"".$this->col_width[$col]."\""; } if($this->col_name_style[$col] <> "") { $output .= " style=\"".$this->col_name_style[$col]."\""; } $output .= ">"; if($this->col_name[$col] <> "") { $output .= " ".$this->col_name[$col]; } else { $output .= "&nbsp"; } $output .= "</TH>\n"; } } $output .= "</TR>"; $output .= "\n"; return $output; } function returnRow($row) { $output = ""; for($col = 0; $col < $this->col_number; $col++) { $output .= "<TD"; if($this->cell_color[$row][$col] <> "") { $output .= " bgcolor=\"".$this->cell_color[$row][$col]."\""; } if($this->cell_align[$row][$col] <> "") { $output .= " align=\"".$this->cell_align[$row][$col]."\""; } if($this->cell_valign[$row][$col] <> "") { $output .= " valign=\"".$this->cell_valign[$row][$col]."\""; } if($this->cell_height[$row][$col] <> "") { $output .= " height=\"".$this->cell_height[$row][$col]."\""; } $output .= ">"; $output .= $this->data[$row][$col]; $output .= "&nbsp"."</TD>\n"; } return $output; } function returnHTML() { $output = ""; $output .= $this->returnTableOpenTag(); $output .= $this->hidden_header."\n"; $output .= $this->returnTableHeader(); for($k = 0; $k < $this->row_number; $k++) { $output .= "<TR valign=\"middle\">\n"; $output .= $this->returnRow($k); $output .= "</TR>\n"; } $output .= $this->hidden_footer."\n"; $output .= "</TABLE>\n"; return $output; } } ?>
QueryPrint is a PHP class that prints the results of a SQL query in HTML format. The printing is defined in a seperate module class that can be modified or replaced. QueryPrint also supports multiple page queries allowing the user to decide how many records to show on each page. The previous and next buttons are added automaticaly and as defined by the printing module. Download the class from http://phpclasses.upperdesign.com/browse.html/package/371
Generate almost any HTML table very quickly and painless. See http://www.phazer.dk/php/tables/ for full example and source.
Creating a Table with $x cols per row ?> </table> <? $b = 113 ; //numbers to count for $i = 0; // incrementor $z = 4; // how much cols ? ?> <table> <? while($i < $b) { if($i == 0 || $i == $a) { echo "<tr>"; $a = $a + $z; // the beginning ist always $a + cols per row or zero $e = $a - 1; // the end ist always $a - 1 ; if ($e > $b) // if the end ist geater then our count { $e = $b - 1; //we make $b - 1 and thats the end tag } } echo "<td> ".$i." </td>"; if ($i == $e) { echo "</tr>"; } $i++; } ?> </table> <?
A simple one line row color swapper. <? /*uses the tenery operator and a string comparison to determine the new row color */ $cellbgcolor ="#336699"; //initial color. while ($result = mysql_fetch_object($queryid)) { ?> <tr bgcolor="<?=$cellbgcolor?>"> <? strcmp($cellbgcolor, "#336699") ? $cellbgcolor ="#336699" : $cellbgcolor ="#3377aa"; ?> <td><?=$rresult->field1?></td> </tr> <? }?>