demo
templates
install
contact
Home Help Setup Pages Table

Setup - Pages Table

The name of the database table to hold the information for each page.

The default structure is:

  `id`  - unique record identifier
  `dir`  - the name of the page (this page is "/help/setup/_pages_table") limit=127 characters
  `page_title` the title shown on the title bar and in many search engine listings. limit=127 characters
  `last_visit` - time and date of last page view
  `page_views` - page veiw count
  `last_edit`  - date and time of last page edit
  `keywords` - "user added" field
  `description` - "user added" field

All of these fields are available to the template, and can be included with the PHP command:

  <?php echo "$description"; ?>

by replacing the variable "description' with the desired variable.

For more user-added fields, edit the database setup table entry "edit_header" to add the text input field for "newField" as shown:

<tr><td colspan="3" nowrap>
  Keywords: <input name="keywords" type="text" id="keywords" size="40" value="$keywords"  />
  Description: <input name="description" type="text" id="description" size="40" value="$description" />
  NEW FIELD: <input name="newField" type="text" id="description" size="40" value="$newField" />
  <input name="fieldlist" type="hidden" id="fieldlist" value="keywords,description,newField" />
</td></tr>

The database must have the field added, using the "Run an SQL" in the database manager, issue a command such as:

  ALTER TABLE `beta_pages` ADD `newField` TEXT

... where "newField" is the name of the variable to be added.

Add it to the template with:

  <?php echo "$newField"; ?>

(the filemanager can be used to edit the template if the file permissions have been set properly)