Html_Table Class Reference

contains HTML features More...

Collaboration diagram for Html_Table:

Static Public Member Functions
static	sql2table ($cn, $a_col, $sql, $table_style='class="result"', $a_sql_var=null)
static	test_me ()

Detailed Description

contains HTML features

Definition at line 30 of file html_table.class.php.

Member Function Documentation

sql2table()

static Html_Table::sql2table ( $cn, $a_col, $sql, $table_style = 'class="result"', $a_sql_var = null )

static

 @brief Receives a SQL command and returns a string with the HTML code
 to display it as a table.
 Simple table without any feature (link in certain cell, sort,...)
 @param $cn database object
 @param $a_col header of the column it is an array of array
        indexes are link, name,image, style
 @param $sql query to execute
 @param $table_style style of the table
 @parm $a_sql_var array variable for the $sql DEFAULT NULL

static function test_me()
 {
   $cn=Dossier::connect();
   $order=" order by f_id desc ";
   $url=HtmlInput::get_to_string(array("gDossier","test_select"));
 
   if ( isset($_GET['sb']))
     {
       $order=" order by f_id";
       $img="image/select1.gif";
     }
   else
     {
       $url=$url."&sb=as";
       $img="image/select2.gif";
     }
   $sql="select f_id,name,quick_code from vw_client  $order limit 10";
   echo $sql;
 
 
   echo Html_Table::sql2table($cn,
                              array(
                                    array('name'=>'N° de fiche',
                                          'style'=>'text-align:right',
                                          'link'=>$url,
                                          'image'=>$img),
                                    array('name'=>'Nom',
                                          'style'=>'text-align:right'),
                                    array('name'=>'QuickCode')
                                    )
                              ,
                              $sql
                              );
 }

Definition at line 79 of file html_table.class.php.

  {
    $r='';
    $r=sprintf('<table %s>',$table_style);
    $r.='<tr>';
    for ( $i=0;$i <count($a_col);$i++)
      {
        $content=h($a_col[$i]['name']);
        $style=(isset($a_col[$i]['style']))?$a_col[$i]['style']:"";
        if ( isset($a_col[$i]['image']) && $a_col[$i]['image'] != '')
          {
            $content=sprintf('<img src="%s" border="0"></img>%s',$a_col[$i]['image'],$content);
          }
        if ( isset($a_col[$i]['link']) )
          {
            $content=sprintf('<a href="%s">%s</a>',
                             $a_col[$i]['link'],
                             $content);
            $r.="<th $style>$content</th>";
          }
        else
          $r.= "<th $style>". h($content)."</th>";
      }
    $r.='</tr>';
    $ret=$cn->exec_sql($sql,$a_sql_var);
    for ($i=0;$i<Database::num_row($ret);$i++)
      {
        $r.='<tr>';
        $row=Database::fetch_row($ret,$i);
        for ($e=0;$e<count($row);$e++)
          {
            $style='';$content=h($row[$e]);
 
            if ( isset($a_col[$e]['style']) )
              $style=$a_col[$e]['style'];
                if  ( isset ($a_col[$e]['raw']))
                        $r.='<td $style>'.$row[$e].'</td>';
                else
                        $r.=td($content,$style);
          }
        $r.='</tr>';
      }
    $r.='</table>';
    return $r;
  }

References $a_col, $cn, $e, $i, $r, $ret, $row, $sql, $style, DatabaseCore\fetch_row(), h, DatabaseCore\num_row(), and td().

Referenced by test_me().

Here is the call graph for this function:

test_me()

static Html_Table::test_me ( )

static

Definition at line 124 of file html_table.class.php.

  {
    $cn=Dossier::connect();
    $order=" order by f_id desc ";
    $url=HtmlInput::get_to_string(array("gDossier","test_select"));
 
    if ( isset($_GET['sb']))
      {
        $order=" order by f_id";
        $img="image/select1.gif";
      }
    else
      {
        $url=$url."&sb=as";
        $img="image/select2.gif";
      }
    $sql="select f_id,name,quick_code from vw_client  $order limit 10";
    echo $sql;
 
 
    echo Html_Table::sql2table($cn,
                               array(
                                     array('name'=>'N° de fiche',
                                           'style'=>'text-align:right',
                                           'link'=>$url,
                                           'image'=>$img),
                                     array('name'=>'Nom',
                                           'style'=>'text-align:right'),
                                     array('name'=>'QuickCode')
                                     )
                               ,
                               $sql
                               );
  }

References $_GET, $cn, $img, $order, $sql, $url, and sql2table().

Here is the call graph for this function:

---

The documentation for this class was generated from the following file:

• include/lib/html_table.class.php