Demonstration

Return to database2 manual …

These tables are available for public testing. Some tables are available for public edit, as well!

If you encounter offensive or illegal content on this page please send a mail to soletan@nihilum.de requesting its proper modification to exclude concerned parts of content.

Next there is a read-only view on previous table:

The following two tables are hosted in a locally driven MySQL server. Note: There is a hidden filter applied, thus some available records might be missing in this list.

This second table is using new column type related to link in a single record from previous table.

Take a look at the page's source to see how to embed tables like these.

You might asking yourself whether or not this demonstration page is properly protected from SQL injection attacks as it allows unauthenticated users to update records in databases. Well, database2 is separating SQL code and queried data using prepared statements with input parameter markers bound with user-provided data on executing the statements. Due to this separation user-provided data cannot adjust used SQL statements.

By introducing support for new option aliasing to declare arbitrary SQL terms for listing computed data next to column data everyone capable of writing a page might use this feature to inject malicious SQL code. Due to introducing such a risk it is disabled in configuration by default requiring explicit activation.