<?php echo "<?xml version='1.0'?>\n"; ?>
Sample List Viewer - Instructions:
- Remove any fields you don't want displayed. (Most list pages only have title and link fields.)
- Rearrange remaining fields to suit your needs.
- Copy and paste code into previously designed page (or add design to this page).
<?php
require_once "viewer_functions.php";
$options = array(); // NOTE: see online documentation for more details on these options
$options['tableName'] = ''; // (REQUIRED) MySQL tablename to list record from. Example: 'article';
$options['titleField'] = ''; // (optional) MySQL fieldname used in viewer url for search engines. Example: 'title' would display: viewer.php/article_title_here-123
$options['viewerUrl'] = 'Page.php'; // (optional) URL of viewer page. Example: '/articles/view.php';
$options['perPage'] = ''; // (optional) The number of records to display per page. Example: '5'; Defaults to 10.
$options['orderBy'] = ''; // (optional) Fieldnames to sort by. Example: 'field1, field2 DESC, field3';
$options['pageNum'] = ''; // (optional) Page number of results to display. Example: '1'; Defaults to number on end of url, then 1
$options['where'] = ''; // (ADVANCED) Additional MySQL WHERE conditions. Example: 'fieldname = "value"'
$options['useSeoUrls'] = ''; // (ADVANCED) Set this to '1' for search engine friendly urls: view.php/123 instead of view.php?123 (not supported on all web servers, and viewerUrl must be absolute path such as '/path/viewer.php')
list($listRows, $listDetails) = getListRows($options);
?>
List Viewer
<?php foreach ($listRows as $record): ?>
link : <?php echo $record['_link'] ?>
<?php endforeach ?>
<?php if ($listDetails['noRecordsFound']): ?>
No records were found!
<?php endif ?>
<?php if ($listDetails['invalidPageNum']): ?>
Results page not found, start over >>.
<?php endif ?>
<?php if ($listDetails['prevPage']): ?>
<< prev
<?php else: ?>
<< prev
<?php endif ?>
- page <?php echo $listDetails['page'] ?> of <?php echo $listDetails['totalPages'] ?> -
<?php if ($listDetails['nextPage']): ?>
next >>
<?php else: ?>
next >>
<?php endif ?>
Sample Page Viewer - Instructions:
- Remove any fields you don't want displayed.
- Rearrange remaining fields to suit your needs.
- Copy and paste code into previously designed page (or add design to this page).
<?php
require_once "viewer_functions.php";
$options = array(); // NOTE: see online documentation for more details on these options
$options['tableName'] = ''; // (REQUIRED) MySQL tablename to list record from. Example: "article";
$options['recordNum'] = ''; // (optional) Record number to display. Example: "1"; Defaults to number on end of url, then 1
$options['where'] = ''; // (ADVANCED) MySQL WHERE conditions to use INSTEAD of recordNum to look up record. Example: "fieldname = 'value'"
$record = getRecord($options);
?>
Page Viewer
<?php if ($record): ?>
<?php endif ?>
<?php if (empty($record)): ?>
No record found!
<?php endif ?>
$fieldSchema) {
if (@$fieldSchema['type'] != 'upload') { continue; } // skip all but upload fields
$labelOrName = @$fieldSchema['label'] ? $fieldSchema['label'] : $fieldname;
?>
<?php foreach (getUploads($options['tableName'], '', $record['num']) as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<?php elseif ($upload['isImage']): ?>
<?php else: ?>
Download <?php echo $upload['filename'] ?>
<?php endif ?>
<?php endforeach ?>
$fieldSchema) {
$skipField = !is_array($fieldSchema) || // not a field definition, table metadata field
in_array($fieldSchema['type'], $fieldTypesSkipped) || // skip field types that aren't displayed
in_array($fieldname, $fieldNamesSkipped); // skip internal field names that aren't displayed
if ($skipField && $fieldname != 'num') { continue; }
// get field code
$labelOrName = @$fieldSchema['label'] ? $fieldSchema['label'] : $fieldname;
if ($fieldSchema['type'] == 'date') {
array_push($fieldCode, "$labelOrName:
\n");
array_push($fieldCode, " \n");
}
else {
array_push($fieldCode, "$labelOrName:
\n");
}
}
return $fieldCode;
}
?>