Hakan Ardo > DBIx-HTMLView-LATEST > DBIx::HTMLView::CGIListView

Download:
DBIx-HTMLView-LATEST.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Source  

NAME ^

  DBIx::HTMLView::CGIListView - A List user interface for DBI databases

SYNOPSIS ^

  $view=new DBIx::HTMLView::CGIReqEdit($script, $dbi, $cgi);
  print $view->view_html;

DESCRIPTION ^

This is a database viewer/editer using the CGI interface and HTML forms to present the user interface to the user. It's a very simple interface. At the top all the tables of the database are listed to allow the user to select which one to edit (including a + sign for adding a new post, and at the bottom the selected table is listed. If the table has more than defined in {'rows'}, output is split into pages. Every post has a link to allow you to show, edit or delete them. There is also a link to add new posts to the table.

To be able to use this you need a cgi script that sets up a few things and decides which editor to use to edit single posts and to insert default values and so on... For a simple such script see View.cgi.

This is a subclass to DBIx::HTMLView::CGIView. =head1 METHODS

$view->rows($nr)

Specifies how many rows should be displayed on one page. Default is 50.

$view->flds_to_view(@flds)

Specifies which flds to view by listing there names. Default is to view all fields of a post but none of the relations.

$view->extra_sql($extra)

If you want to add some extra SQL clauses to the end of the select command they can be given here. This can be used to specify in which order the posts should appear by giving an ORDER clause.

$view->restrict_tabs($tabs_to_show)

If you don't want all tabels to show up at the top of the editor you can here specify which you want there by letting $tabs_to_show be an array ref to an array liste the names of those tables.

Note that this is not a secure way to prevent users from getting access to the tables as some simple tampering with the html forms passed to the user will bring up the other tables as well for editing.

$view->view_html

Returns the html code for the editor as specified by previous methods.

syntax highlighting: