wwwdb.dump

使用perl和C写的基于Web的管理数据库表的程序

Last but not least, you can set <i>attributes</i> to your fields.
This means they can be bold, italics, coloured, aligned and more.

<BR><BR>
But <B>WWWdb</B> can even do more: It gives you the possibility
to mount different applications together to one web-application.

Using this mechanism, you can navigate in a hierachy of categories
or use search-words to find the application or object, you''re
serching for.
',120,NULL);
INSERT INTO wwwdb_doc (id_doc,category,sub_category,description,text,sort_nr,last_change) values (8,'home','overview','WWWdb - Why written?','<p ALIGN=center><FONT color=blue>
Why did I write this tool?
<BR><BR></FONT></P>
Because I use different kinds of databases regulary, I always wished a
tool to maintain the different tables, without typing the
corresponding SQL-statements in any SQL-monitor. It would be nice - I
thought - to have a utilitiy which allows me easily to do this on
different databases - and platforms. <BR><BR>

First I searched the web for tool, doing this. And yes! Some tools are
existing and I tried them out - one after the other. Because I had to
write a contact-database for my company, the most tools did not fit for
us. Some were unflexible with the databases they are using, and others
had a ugly user-interface. So I decided to write my own tool.
<BR><BR>

After playing around with perl and tcl, I decided to make such a thing
as a CGI-script, which gives me the possibillity to use <I>any</I>
WWW-browser (graphic or not) to maintain my database-tables, because it
generates pure HTML, without Java or Javascript.
<BR><BR>
In the meantime the program grew and grew. Many ideas were implemented
and some more still aren''t. 

Now, we can not only manage database-records, WWWdb begins to be a
development tool for whole web-sites',110,NULL);
INSERT INTO wwwdb_doc (id_doc,category,sub_category,description,text,sort_nr,last_change) values (10,'home','overview','The basics of configuring a WWWdb-Application ','Each <B>WWWdb</B>-Application consists of four elements:
<ol>
<li>the session-part</li>
<li>the database-part</li>
<li>the application-part</li>
<li>the application-parameter-part</li>
</ol>

The database-connection is hold in is own configuration-file. It''s
name is <i>&lt;DB-connect&gt;.rc</i>.

The session-id is a sixteen-hex-digit number which is generated 
every time, you connect to <B>WWWdb</B>. If you have your own login,
ou can always use the same session-id.

The configuration of a application is found in a configuration-file
with the name <i>&lt;Application&gt;.rc</i>.

You can pass parameters to the application in the form:
<BR><I>
Param=Value
</I><BR>

Together, they are coded in the URL in the form:
<BR><BR>
<B>
http://&lt;Hostname&gt;/wwwdb/&lt;Session-id&gt;/&lt;DB-connect&gt;/&lt;Application&gt;[;Parameters]
</B>
<BR><BR>

The WWW-server converts this adress and calls  <B>WWWdb</B> with the correct
parameters. They specify, which config-files have to be used and now
the layout can be generated from <B>WWWdb</B>.
<BR><BR>
',130,NULL);
INSERT INTO wwwdb_doc (id_doc,category,sub_category,description,text,sort_nr,last_change) values (14,'home','overview','Session dependant state-information in WWWdb ','Don''t forget to save the data, you want to have for a future Session. But how
can you do this?
<BR><BR>

In the URL you can find a 16-digit hex-identification, which is randomly
generated and is the key for your current session. If you log in,
you can reget your session-id you have previously used. Because this
session-id can be password-protected, a secure data-transport is
guaranteed.

<BR><BR>

Using this session-id you can save state-information, which expires after
a time-range, selected by you. Also you can share session-informations
over different applications, which allows you, to build your own
HTML-application-framework.',190,NULL);
INSERT INTO wwwdb_doc (id_doc,category,sub_category,description,text,sort_nr,last_change) values (11,'home','overview','What elements a config-file does contain? ','The configuration-file has the format of a .ini-file. This means, that
you have sections of the form:

<BR>
<CODE><PRE>
[Section]
</PRE></CODE>

A section binds all parameters together, which have to do with some
application-based type of data. Also subsections are possible too.
They have the following form:

<BR>
<CODE><PRE>
[Section Subsection]
</PRE></CODE>

In the sections the <i>attribute - value</i> assignments are
placed. Two forms are possible:

<ol>
<li>Single-line assignments</li>
<li>Multiple-Line assignments</li>
</ol>

Here an example:
<BR><BR>
<CODE><PRE>
BgColor = red

Values = &lt;&lt;END
Red
Green
Blue
END
</PRE></CODE>

Here, the attribute <CODE>BgColor</CODE> got the value <i>red</i> and
the attribute <CODE>Values</CODE> got a list, containig three elements:
<BR>
<i>red</i>, <i>green</i> and <i>blue</i>.
<BR><BR>',140,NULL);
INSERT INTO wwwdb_doc (id_doc,category,sub_category,description,text,sort_nr,last_change) values (12,'home','overview','How your Application is customized ','Oh yes, all of the layout of your application can be defined in a single
config-file.
<BR>
It consists of the following sections:
<BR><BR>
<TABLE BORDER=1>

 <TR>
  <TH>
    Section
  </TH>
  <TH>
    Description
  </TH>
  <TH>
    Attributes
  </TH>
 </TR>

 <TR>
  <TD>
    Data
  </TD>
  <TD>
    The database-table and which columns we need for browse und update.
  </TD>
  <TD>
    Table-name, Sort-order, Fields for query, Fields fur update
  </TD>
 </TR>

 <TR>
  <TD>
   Browser
  </TD>
  <TD>
   Possibillities of the the data-browser
  </TD>
  <TD>
   Number of Records which are displayed per page
  </TD>
 </TR>

 <TR>
  <TD>
    GUI
  </TD>
  <TD>
    Settings, how to display the desktop
  </TD>
  <TD>
    Background-color, Confirmation after insert, update, delete
  </TD>
 </TR>

 <TR>
  <TD>
   State ...
  </TD>
  <TD>
   Activating or deactivating the different button