Date: Thu, 13 Nov 2008 22:59:24 +0000 Subject: Changing EOL style to LF --- user_guide/libraries/table.html | 582 ++++++++++++++++++++-------------------- 1 file changed, 291 insertions(+), 291 deletions(-) (limited to 'user_guide/libraries/table.html') diff --git a/user_guide/libraries/table.html b/user_guide/libraries/table.html index 7671d2aab..92fcc9c71 100644 --- a/user_guide/libraries/table.html +++ b/user_guide/libraries/table.html @@ -1,292 +1,292 @@ - - - - - -HTML Table Class : CodeIgniter User Guide - - - - - - - - - - - - - - - - - - - -

- - - - - - - - - - -

- - -
- - - -

- - -

HTML Table Class

- -

The Table Class provides functions that enable you to auto-generate HTML tables from arrays or database result sets.

- -

Initializing the Class

- -

Like most other classes in CodeIgniter, the Table class is initialized in your controller using the $this->load->library function:

- -$this->load->library('table'); -

Once loaded, the Table library object will be available using: $this->table

- - -

Examples

- -

Here is an example showing how you can create a table from a multi-dimensional array. -Note that the first array index will become the table heading (or you can set your own headings using the -set_heading() function described in the function reference below).

- -


-$this->load->library('table');

-

-$data = array(

-             array('Name', 'Color', 'Size'),

-             array('Fred', 'Blue', 'Small'),

-             array('Mary', 'Red', 'Large'),

-             array('John', 'Green', 'Medium')	

-             );

-

-echo $this->table->generate($data);		
-

- -

Here is an example of a table created from a database query result. The table class will automatically generate the -headings based on the table names (or you can set your own headings using the set_heading() function described -in the function reference below).

- -


-$this->load->library('table');

-

-$query = $this->db->query("SELECT * FROM my_table");

-

-echo $this->table->generate($query);		
-

- - -

Here is an example showing how you might create a table using discrete parameters:

- -


-$this->load->library('table');

-

-$this->table->set_heading('Name', 'Color', 'Size');

-

-$this->table->add_row('Fred', 'Blue', 'Small');

-$this->table->add_row('Mary', 'Red', 'Large');

-$this->table->add_row('John', 'Green', 'Medium');

-

-echo $this->table->generate();		
-

- -

Here is the same example, except instead of individual parameters, arrays are used:

- -


-$this->load->library('table');

-

-$this->table->set_heading(array('Name', 'Color', 'Size'));

-

-$this->table->add_row(array('Fred', 'Blue', 'Small'));

-$this->table->add_row(array('Mary', 'Red', 'Large'));

-$this->table->add_row(array('John', 'Green', 'Medium'));

-

-echo $this->table->generate();		
-

- - -

Changing the Look of Your Table

- -

The Table Class permits you to set a table template with which you can specify the design of your layout. Here is the template -prototype:

- -


-$tmpl =  array (

-                    'table_open'          => '<table border="0" cellpadding="4" cellspacing="0">',

-

-                    'heading_row_start'   => '<tr>',

-                    'heading_row_end'     => '</tr>',

-                    'heading_cell_start'  => '<th>',

-                    'heading_cell_end'    => '</th>',

-

-                    'row_start'           => '<tr>',

-                    'row_end'             => '</tr>',

-                    'cell_start'          => '<td>',

-                    'cell_end'            => '</td>',

-

-                    'row_alt_start'       => '<tr>',

-                    'row_alt_end'         => '</tr>',

-                    'cell_alt_start'      => '<td>',

-                    'cell_alt_end'        => '</td>',

-

-                    'table_close'         => '</table>'

-              );

-
-

-$this->table->set_template($tmpl);
-

- -

Note: You'll notice there are two sets of "row" blocks in the template. These permit you to create alternating row colors or design elements that alternate with each -iteration of the row data.

- -

You are NOT required to submit a complete template. If you only need to change parts of the layout you can simply submit those elements. -In this example, only the table opening tag is being changed:

- -


-$tmpl =  array ( 'table_open'  => '<table border="1" cellpadding="2" cellspacing="1" class="mytable">' );

-
-

-$this->table->set_template($tmpl);
-

- -
-

Function Reference

- -

$this->table->generate()

Returns a string containing the generated table. Accepts an optional parameter which can be an array or a database result object.

- -

$this->table->set_caption()

- -

Permits you to add a caption to the table.

- -$this->table->set_caption('Colors'); - -

$this->table->set_heading()

- -

Permits you to set the table heading. You can submit an array or discrete params:

- -$this->table->set_heading('Name', 'Color', 'Size'); -$this->table->set_heading(array('Name', 'Color', 'Size')); - -

$this->table->add_row()

- -

Permits you to add a row to your table. You can submit an array or discrete params:

- -$this->table->add_row('Blue', 'Red', 'Green'); -$this->table->add_row(array('Blue', 'Red', 'Green')); - - -

$this->table->make_columns()

- -

This function takes a one-dimensional array as input and creates -a multi-dimensional array with a depth equal to the number of -columns desired. This allows a single array with many elements to be -displayed in a table that has a fixed column count. Consider this example:

- -


-$list = array('one', 'two', 'three', 'four', 'five', 'six', 'seven', 'eight', 'nine', 'ten', 'eleven', 'twelve');

-

-$new_list = $this->table->make_columns($list, 3);

-

-$this->table->generate($new_list);

-

-// Generates a table with this prototype

-

-<table border="0" cellpadding="4" cellspacing="0">

-<tr>

-<td>one</td><td>two</td><td>three</td>

-</tr><tr>

-<td>four</td><td>five</td><td>six</td>

-</tr><tr>

-<td>seven</td><td>eight</td><td>nine</td>

-</tr><tr>

-<td>ten</td><td>eleven</td><td>twelve</td></tr>

-</table>

- - - -

$this->table->set_template()

- -

Permits you to set your template. You can submit a full or partial template.

- -


-$tmpl =  array ( 'table_open'  => '<table border="1" cellpadding="2" cellspacing="1" class="mytable">' );

-
-

-$this->table->set_template($tmpl);
-

- - -

$this->table->set_empty()

- -

Let's you set a default value for use in any table cells that are empty. You might, for example, set a non-breaking space:

- -


-$this->table->set_empty("&nbsp;");
-

- -

$this->table->clear()

- -

Lets you clear the table heading and row data. If you need to show multiple tables with different data you should -to call this function after each table has been generated to empty the previous table information. Example:

- -


-$this->load->library('table');

-

-$this->table->set_heading('Name', 'Color', 'Size');

-$this->table->add_row('Fred', 'Blue', 'Small');

-$this->table->add_row('Mary', 'Red', 'Large');

-$this->table->add_row('John', 'Green', 'Medium');

-

-echo $this->table->generate();

-

-$this->table->clear();

-

-$this->table->set_heading('Name', 'Day', 'Delivery');

-$this->table->add_row('Fred', 'Wednesday', 'Express');

-$this->table->add_row('Mary', 'Monday', 'Air');

-$this->table->add_row('John', 'Saturday', 'Overnight');

-

-echo $this->table->generate();
-

- -

- - - - - - + + + + + +HTML Table Class : CodeIgniter User Guide + + + + + + + + + + + + + + + + + + + +

+ + + + + + + + + + +

+ + +
+ + + +

+ + +

HTML Table Class

+ +

The Table Class provides functions that enable you to auto-generate HTML tables from arrays or database result sets.

+ +

Initializing the Class

+ +

Like most other classes in CodeIgniter, the Table class is initialized in your controller using the $this->load->library function:

+ +$this->load->library('table'); +

Once loaded, the Table library object will be available using: $this->table

+ + +

Examples

+ +

Here is an example showing how you can create a table from a multi-dimensional array. +Note that the first array index will become the table heading (or you can set your own headings using the +set_heading() function described in the function reference below).

+ +


+$this->load->library('table');

+

+$data = array(

+             array('Name', 'Color', 'Size'),

+             array('Fred', 'Blue', 'Small'),

+             array('Mary', 'Red', 'Large'),

+             array('John', 'Green', 'Medium')	

+             );

+

+echo $this->table->generate($data);		
+

+ +

Here is an example of a table created from a database query result. The table class will automatically generate the +headings based on the table names (or you can set your own headings using the set_heading() function described +in the function reference below).

+ +


+$this->load->library('table');

+

+$query = $this->db->query("SELECT * FROM my_table");

+

+echo $this->table->generate($query);		
+

+ + +

Here is an example showing how you might create a table using discrete parameters:

+ +


+$this->load->library('table');

+

+$this->table->set_heading('Name', 'Color', 'Size');

+

+$this->table->add_row('Fred', 'Blue', 'Small');

+$this->table->add_row('Mary', 'Red', 'Large');

+$this->table->add_row('John', 'Green', 'Medium');

+

+echo $this->table->generate();		
+

+ +

Here is the same example, except instead of individual parameters, arrays are used:

+ +


+$this->load->library('table');

+

+$this->table->set_heading(array('Name', 'Color', 'Size'));

+

+$this->table->add_row(array('Fred', 'Blue', 'Small'));

+$this->table->add_row(array('Mary', 'Red', 'Large'));

+$this->table->add_row(array('John', 'Green', 'Medium'));

+

+echo $this->table->generate();		
+

+ + +

Changing the Look of Your Table

+ +

The Table Class permits you to set a table template with which you can specify the design of your layout. Here is the template +prototype:

+ +


+$tmpl =  array (

+                    'table_open'          => '<table border="0" cellpadding="4" cellspacing="0">',

+

+                    'heading_row_start'   => '<tr>',

+                    'heading_row_end'     => '</tr>',

+                    'heading_cell_start'  => '<th>',

+                    'heading_cell_end'    => '</th>',

+

+                    'row_start'           => '<tr>',

+                    'row_end'             => '</tr>',

+                    'cell_start'          => '<td>',

+                    'cell_end'            => '</td>',

+

+                    'row_alt_start'       => '<tr>',

+                    'row_alt_end'         => '</tr>',

+                    'cell_alt_start'      => '<td>',

+                    'cell_alt_end'        => '</td>',

+

+                    'table_close'         => '</table>'

+              );

+
+

+$this->table->set_template($tmpl);
+

+ +

Note: You'll notice there are two sets of "row" blocks in the template. These permit you to create alternating row colors or design elements that alternate with each +iteration of the row data.

+ +

You are NOT required to submit a complete template. If you only need to change parts of the layout you can simply submit those elements. +In this example, only the table opening tag is being changed:

+ +


+$tmpl =  array ( 'table_open'  => '<table border="1" cellpadding="2" cellspacing="1" class="mytable">' );

+
+

+$this->table->set_template($tmpl);
+

+ +
+

Function Reference

+ +

$this->table->generate()

Returns a string containing the generated table. Accepts an optional parameter which can be an array or a database result object.

+ +

$this->table->set_caption()

+ +

Permits you to add a caption to the table.

+ +$this->table->set_caption('Colors'); + +

$this->table->set_heading()

+ +

Permits you to set the table heading. You can submit an array or discrete params:

+ +$this->table->set_heading('Name', 'Color', 'Size'); +$this->table->set_heading(array('Name', 'Color', 'Size')); + +

$this->table->add_row()

+ +

Permits you to add a row to your table. You can submit an array or discrete params:

+ +$this->table->add_row('Blue', 'Red', 'Green'); +$this->table->add_row(array('Blue', 'Red', 'Green')); + + +

$this->table->make_columns()

+ +

This function takes a one-dimensional array as input and creates +a multi-dimensional array with a depth equal to the number of +columns desired. This allows a single array with many elements to be +displayed in a table that has a fixed column count. Consider this example:

+ +


+$list = array('one', 'two', 'three', 'four', 'five', 'six', 'seven', 'eight', 'nine', 'ten', 'eleven', 'twelve');

+

+$new_list = $this->table->make_columns($list, 3);

+

+$this->table->generate($new_list);

+

+// Generates a table with this prototype

+

+<table border="0" cellpadding="4" cellspacing="0">

+<tr>

+<td>one</td><td>two</td><td>three</td>

+</tr><tr>

+<td>four</td><td>five</td><td>six</td>

+</tr><tr>

+<td>seven</td><td>eight</td><td>nine</td>

+</tr><tr>

+<td>ten</td><td>eleven</td><td>twelve</td></tr>

+</table>

+ + + +

$this->table->set_template()

+ +

Permits you to set your template. You can submit a full or partial template.

+ +


+$tmpl =  array ( 'table_open'  => '<table border="1" cellpadding="2" cellspacing="1" class="mytable">' );

+
+

+$this->table->set_template($tmpl);
+

+ + +

$this->table->set_empty()

+ +

Let's you set a default value for use in any table cells that are empty. You might, for example, set a non-breaking space:

+ +


+$this->table->set_empty("&nbsp;");
+

+ +

$this->table->clear()

+ +

Lets you clear the table heading and row data. If you need to show multiple tables with different data you should +to call this function after each table has been generated to empty the previous table information. Example:

+ +


+$this->load->library('table');

+

+$this->table->set_heading('Name', 'Color', 'Size');

+$this->table->add_row('Fred', 'Blue', 'Small');

+$this->table->add_row('Mary', 'Red', 'Large');

+$this->table->add_row('John', 'Green', 'Medium');

+

+echo $this->table->generate();

+

+$this->table->clear();

+

+$this->table->set_heading('Name', 'Day', 'Delivery');

+$this->table->add_row('Fred', 'Wednesday', 'Express');

+$this->table->add_row('Mary', 'Monday', 'Air');

+$this->table->add_row('John', 'Saturday', 'Overnight');

+

+echo $this->table->generate();
+

+ +

+ + + + + + \ No newline at end of file -- cgit v1.2.3-24-g4f1b

CodeIgniter User Guide Version 1.7

HTML Table Class

Initializing the Class

Examples

Changing the Look of Your Table

Function Reference

$this->table->generate()

$this->table->set_caption()

$this->table->set_heading()

$this->table->add_row()

$this->table->make_columns()

$this->table->set_template()

$this->table->set_empty()

$this->table->clear()

CodeIgniter User Guide Version 1.7

HTML Table Class

Initializing the Class

Examples

Changing the Look of Your Table

Function Reference

$this->table->generate()

$this->table->set_caption()

$this->table->set_heading()

$this->table->add_row()

$this->table->make_columns()

$this->table->set_template()

$this->table->set_empty()

$this->table->clear()