Add and edit articles using the same form

Having a simple list of articles is of no real use in a CMS. You have to be able to add, delete  and also edit pages using a simple interface. When you created the listing using the NeXTensio List Wizard in the previous tutorial page, in the first step, you specified a file to use for the form: detail_art.php. After testing the page in the wizard, you may have noticed that when you click on the add / edit links, the browser points to the detail_art page, which is, for the moment, blank. Also, the delete buttons seem to have no effect whatsoever.

To create this page, you will use the NeXTensio List's counterpart: the Create NeXTensio Form Wizard, which will create all of the required elements.

Before you start this wizard, you should secure this page, in the same manner as the article listing page: apply the Restrict Access to Page server behavior A server behavior is a reusable component for server-side development. They add blocks of code to your pages for accomplishing specific tasks. Dreamweaver comes with several default server behaviors and the InterAKT extensions add many more to this list., based on user name and password.

Once you've got your page secured, click on the Create NeXTensio Form Wizard from the MX Kollection tab of the Insert panel, and configure it as follows:

1. In the wizard's first step, enter details regarding the table to use, and the means to access it:
   • Select the connection you've defined for your site in the Connection drop-down menu.
   • Select the page_pag table, as the table on which the insert/update/delete operations will take place.
     
     
2. In the second step of the wizard, you have to define the columns that will be used in the transactions, and what form fields will be used:
   • For the idpag_pag, which is the self-foreign key that determines the parent article or the one that is currently inserted, the user should not be allowed to type values directly. To avoid this, you should set its form element to Menu. By using a menu, you can use dynamic data, and restrict the choices to available ones. Once you select the menu element in the Display as drop-down, two new buttons will become available: Add new recordset A recordset is the result of executing an SQL query A query is a SQL command that will extract information from the tables of a database. Essentially, a query is a request for information from your database.. It is composed of multiple rows, each row having multiple columns. The columns presented in the query result depend on the column list declared in the query (they can belong to different tables). The number of rows and their order depend on the query conditions (WHERE, GROUP BY, HAVING, ORDER). The recordset acts as a source of dynamic data The InterAKT Dynamic Data tool is a replacement for the standard dynamic data dialog. It is used in the MX Kollection 3, to provide a unified way of building mark-ups, or place holders. These are recordset fields, server or session variables, and other types of dynamic data that are replaced at runtime by their corresponding values in web applications. and Menu properties. Click on the Add recordset button to create a new recordset, that retrieves all entries having the idpag_pag foreign key A foreign key is a field from a database table that refers to (or targets) a specific key, usually the primary key A primary key is one or more table columns whose values uniquely identify each record in a table. In general, a primary key is defined on a single column, but it is not uncommon to have it defined on two columns., in another table. This is a convenient way of logically linking information from related tables in the same database. For instance, a table that stores information about products can contain a foreign key that references the primary key field in a table that stores manufacturers. This way, each product has an associated manufacturer – its associated foreign key points to the unique identifier of the manufacturer. Please note that the foreign key is not unique, but the referenced field (the primary key in the referenced table) usually is. equal with 0. This is done in a similar manner to the recordset created for the navigation menu.
   • Once you have created the recordset, you can click on the Menu properties button and define which filed is to be used for the labels, and which for the values. Configure the dialog box to use the title_pag column as label, and the id_pag as value. Also change its label to something more suggestive (e.g. Parent article)..
   • The second form field to alter is body_pag. Set it to be displayed on page as text area, and change its label to Page content.
   • The visible_pag form field only has two options: visible and invisible. This is stored in the database A database refers to data organized and stored on a computer that can be searched and retrieved by a computer program. Most industrial-strength and many smaller database applications can be addressed using SQL (Structured Query Language). as 1 and 0. Due to the user interface, the field is configured as a checkbox (as set in the list). To make it more suggestive, you will change the element to a menu, which contains two options: Visible and Invisible.
     Choose Menu in the Display as drop-down menu, and then click the Menu Properties button to add the two items: label - Visible, value - 1, and label - Invisible, value - 0.
   • The last field, storing the date of the article's insertion should be automatically completed with the current date. To achieve this, first set the Display as option to text, and in the Default value, enter the following mark-up: {NOW}. This will be replaced at runtime with the actual date.
     
     
3. The wizard's third step deals with applying validation rules on the form fields. As there are no fields with special requirements, you can safely skip this step. Also, if you do not have MX Form Validation installed, there is no third step of the wizard.
4. In the final step you can specify some display settings, or leave the fields at their default.
   
   

Now click on the Finish button to close the wizard's dialog box, and add all elements into the page. In Dreamweaver, you will have now all of the HTML form elements and some server behaviors. This page allows you to add, edit and delete entries. It can be called either from the article listing page, to edit or delete a specific record, whose ID is passed through an URL parameter, or directly, in which case, it will act as a normal insertion form:

Because you've applied the Restrict Access to page server behavior, you cannot simply preview the page in the browser, as it would redirect The redirect server behavior loads a new site page after a transaction A transaction is a group of SQL statements whose effects are logically connected. Anything from simple queries to inserting, and deleting operations can be considered a transaction, as well as more complex groups of several statements which accomplish a specific task. is executed. For instance, users could be automatically redirected to their inbox after they log in to the website. you to the login page. Once you login though, visit the Article listing page, and click on the edit link aside one of the articles. A page similar to the following will be displayed for the update operation:
 

Now, through these two pages, you can completely administer the articles.