<table width="800" border="0" cellpadding="5">
<tr>
<td><img src="images/image1.jpg" width="150" height="250" alt="image 1" /></td>
 <td><a href="event1.htm">Event # 1Title</a><br />List Page Description<br />
Date and Time<br />
</td>
</tr>
<tr>
<td><img src="images/image2.jpg" width="150" height="250" alt="image 2" /></td>
<td><a href="event2.htm">Event # 2 Title</a><br />List Page Description<br />
Date and Time</td>
  </tr>
</table>

<table width="800" border="0" cellpadding="5">
<tr>
<td><img src="images/image1.jpg" width="150" height="250" alt="image 1" /></td>
 <td><a href="event1.htm">Event # 1Title</a><br />List Page Description<br />
Date and Time<br />
</td>
</tr>
</table>

<table width="800" Align="center" border="0" cellpadding="5">
<?PHP foreach ($eventsRecords as $record): ?>
<tr>
<td>
<img src="images/image1.jpg" width="150" height="250" alt="image 1" /></td>
 <td><a href="event1.htm">Event # 1Title</a><br />List Page Description<br />
Date and Time<br />
</td>
</tr>
<?PHP endforeach; ?> 
</table>

<table width="800" border="0" cellpadding="5">
<?PHP foreach ($eventsRecords as $record): ?>
<tr>
<td><img src="images/image1.jpg" width="150" height="250" alt="image 1" /></td>
 <td><a href="<?PHP echo $record['_link'] ?>"><?PHP echo $record['title'] ?></a><br /><?PHP echo
$record['list_page_description'] ?><br />
<?PHP echo $record['date_and_time'] ?><br />
</td>
</tr>
<?PHP endforeach; ?> 
</table>

<?php foreach ($record['image'] as $index => $upload): ?>

<img src="<?PHP echo $upload['thumbUrlPath'] ?>" width="<?PHP echo $upload['thumbWidth'] ?>" height="<?PHP echo
$upload['thumbHeight'] ?>" alt="" /><br />

<?PHP endforeach ?>

<table width="800" border="0" cellpadding="5">
<?PHP foreach ($eventsRecords as $record): ?>
<tr>
<td>
<?php foreach ($record['image'] as $index => $upload): ?>

<img src="<?PHP echo $upload['thumbUrlPath'] ?>" width="<?PHP echo $upload['thumbWidth'] ?>" height="<?PHP echo
$upload['thumbHeight'] ?>" alt="" /><br />

<?PHP endforeach ?>
</td>
 <td><a href="<?PHP echo $record['_link'] ?>"><?PHP echo $record['title'] ?></a><br />
<?PHP echo $record['date_and_time'] ?><br /><?PHP echo $record['list_page_description'] ?>>
</td>
</tr>
<?PHP endforeach; ?> 
</table>

<table width="800" Align="center" border="0" cellpadding="5">
<tr>
<td><img src="images/image1.jpg" width="150" height="250>" alt="" /></td>
 <td><a href="event1.htm">Event # 1Title</a><br />List Page Description<br />
Date and Time<br />
</td>
</tr>
<tr>
<td><img src="images/image2.jpg" width="150" height="250&gt;" alt="" /></td>
<td><a href="event2.htm">Event # 2 Title</a><br />List Page Description<br />
Date and Time</td>
  </tr>
</table>

    
<table border="0" cellspacing="0" cellpadding="0" width="690"> 
 <tr> 
<!-- Insert This Code -->
  <td> 
   <input type="submit" name="action=save" value="<?PHP _e('Save as Copy') ?>" 
          onclick="document.getElementById('num').value='';
document.getElementById('preSaveTempId').value='1234567890abc'" 
          class="inputButton" /> 
  </td> 
<!-- End of Insert-->
  <td align="right"> 
   <input type="submit" name="action=save" value="<?PHP _e('Save') ?>" class="inputButton" /> 
   <input type="button" name="cancel" value="<?PHP _e('Cancel') ?>" class="inputButton" 
             onclick="window.location='?menu=<?PHP print urlencode($menu) ?>'" /> 
  </td> 
 </tr> 
</table> 
</form> 
 
<?PHP showWysiwygGeneratorCode() ?>

     'where'    => " hidden = '0' ", 

SELECT num, CONCAT_WS(" ", code, product, format) FROM cms_tablename

SELECT CONCAT_WS(" ", code, product, format), CONCAT_WS(" ", code, product, format) FROM cms_tablename

$escapedProductName = mysql_real_escape_string( $productsRecord['name'] );

'allowSearch' => false,
'where' => " product = '$escapedProductName' ", 

<a href='<a href='videos.php?num=<?php echo $exhibitionsRecord['num'] ?>'>WATCH THE VIDEO FROM THIS EXHIBITION</a>

<?php header('Content-type: text/html; charset=utf-8'); ?> 
<?php 

  // load viewer library 
  $libraryPath = 'cmsAdmin/lib/viewer_functions.php'; 
  $dirsToCheck = array('/path_to_your_server/','','../','../../','../../../'); 
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }} 
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); } 
  
// load records 
  list($exhibitionsRecords, $exhibitionsMetaData) = getRecords(array( 
    'tableName'   => 'exhibitions', 
  )); 
  $exhibitionsRecord = @$exhibitionsRecords[0]; // get first record 
  $escapedExhibitionName = mysql_real_escape_string( $exhibitionsRecord['exhibition_name'] );  
  
 
 // load records 
  list($videosRecords, $videosMetaData) = getRecords(array( 
    'tableName'   => 'videos', 
    'allowSearch' => '0', 
'where' => " exhibition_name = '$escapedExhibitionName' ",  
  )); 
 
?>

<table>
   <?php foreach ($videosRecords as $record): ?>
<tr> 
<td>     
<?php foreach ($record['list_image'] as $upload): ?>
<a href="<?php echo $record['_link'] ?>"><img src="<?php echo $upload['thumbUrlPath2'] ?>" width="<?php echo
$upload['thumbWidth2'] ?>" height="<?php echo $upload['thumbHeight2'] ?>" alt="" /></a>
<?php endforeach; ?>
</td>
<td><a href="<?php echo $record['_link'] ?>"><?php echo $record['video_title'] ?></a><br /></td>
</tr>
<tr>
<td colspan="2">
<?PHP echo maxWords($record['description'], 25);
?>...<a href="<?php echo $record['_link']; ?>">Read More...</a></td>
</tr>
<tr>
<td colspan="2"><hr align="center" width="300" color="#99945e"/></td>
</tr>
<?php endforeach; ?>
</table>

'allowSearch' =>  false,

// load records
  list($common_informationRecords, $common_informationMetaData) = getRecords(array(
    'tableName'   => 'common_information',
    'allowSearch' => '0',
    'limit'       => '1',
  ));
  $common_informationRecord = @$common_informationRecords[0]; // get first record

// load records
  list($masthead_background_image_bankRecords, $masthead_background_image_bankMetaData) = getRecords(array(
    'tableName'   => 'masthead_background_image_bank',
  ));

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<?php $recnum = $common_informationRecord['masthead_background'] ?>
<td  background="<?php foreach ($masthead_background_image_bankRecords as $record ): ?><?php if ($record['num'] ==
$recnum): ?><?php foreach ($record['image'] as $upload): ?><?PHP echo $upload['urlPath'] ?><?PHP endforeach; ?><?php
endif ?><?PHP endforeach; ?>" >

<img src="<?php foreach ($common_informationRecord['masthead_image'] as $upload): ?><?PHP echo $upload['urlPath'] ?>"
width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" alt="" <?PHP endforeach; ?>">
</td>
</tr>
</table>

beta_lookupRelatedFields(array(   
    'table'      => 'e_blast_events_notice',   
    'recordList' => &$e_blast_events_noticeRecords,   
    'fieldList'  => array( 'venue' )   
  
  )); 
  $e_blast_events_noticeRecord = @$e_blast_events_noticeRecords[0]; // get first record 

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  
  require_once "/your_path_to/cmsAdmin/lib/viewer_functions.php";

 list($e_blast_events_noticeRecords, $e_blast_events_noticeMetaData) = getRecords(array(
    'tableName'   => 'e_blast_events_notice',
    'where'       => whereRecordNumberInUrl(1),
    'limit'       => '1',
  ));
 
  ?>
<?php if ($e_blast_events_noticeRecords): ?>
<?php
  beta_lookupRelatedFields(array(   
    'table'      => 'e_blast_events_notice',   
    'recordList' => &$e_blast_events_noticeRecords,   
    'fieldList'  => array( 'venue' )   
  
  )); 
  $e_blast_events_noticeRecord = @$e_blast_events_noticeRecords[0]; // get first record 

?>  
<?php endif ?>

<?php
  // show error message if no matching record is found
  if (!$e_blast_events_noticeRecord) {
    header("HTTP/1.0 404 Not Found");
    print "Record not found!";
    exit;
  }

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<?php if (empty($e_blast_events_noticeRecord['venue'])): ?>   
No Venue Information is available.   
<?php else: ?>   
 <div align="left"> Venue Information: <br />

    <?php foreach ($e_blast_events_noticeRecord['venue'] as $venue): ?> 
         
        <?php echo $venue['venue_name'] ?><br />
        <?php echo $venue['venue_address'] ?><br />
        <?php echo $venue['venue_contact_e_mail'] ?>  <br />
        <?php echo $venue['venue_phone'] ?><br />
         Directions: <br /><?php echo $venue['venue_travel_directions'] ?> <br />
        <a href="<?php echo $venue['venue_map_url'] ?>">Click / Tap for a Map</a><br />
   
    <?php endforeach ?> 
  </div>
<?php endif ?>

The 
<?php if ($e_blast_events_noticeRecords): ?>
 <?php beta_lookupRelatedFields(array(   
    'table'      => 'e_blast_events_notice',   
    'recordList' => &$e_blast_events_noticeRecords,   
    'fieldList'  => array( 'venue' )   
  
  )); 
  $e_blast_events_noticeRecord = @$e_blast_events_noticeRecords[0]; // get first record   
  ?>
<?php endif ?>

<?php $venue = $e_blast_events_noticeRecord['venue']; ?>
                 <?php echo $venue['venue_name'] ?><br />
        <?php echo $venue['venue_address'] ?><br />
        <?php echo $venue['venue_contact_e_mail'] ?>  <br />
        <?php echo $venue['venue_phone'] ?><br />
         Directions: <br /><?php echo $venue['venue_travel_directions'] ?> <br />
        <a href="<?php echo $venue['venue_map_url'] ?>">Click / Tap for a Map</a><br />

<?php $venue = $e_blast_events_noticeRecord['venue']; ?>

<?php echo $venue['venue_name']; ?>

<?php if ($venue['venue_name']): ?>
<?php echo $venue['venue_name']; ?>
<?php endif; ?>  

<?php echo $e_blast_events_noticeRecord['venue']['venue_name']; ?>

<?php
  
  require_once "/hsphere/local/home/apbcweb/artistsofpalmbeachcounty.org/cmsAdmin/lib/viewer_functions.php";

  list($e_blast_events_noticeRecords, $e_blast_events_noticeMetaData) = getRecords(array(
    'Table name'   => 'e_blast_events_notice',


  ));

?>
 <?php if ($e_blast_events_noticeRecords): ?>
<?php 
   beta_lookupRelatedFields(array(   
    'table'      => 'e_blast_events_notice',   
    'recordList' => &$e_blast_events_noticeRecords,   
    'fieldList'  => array( 'venue' )   
  
  )); 
  $e_blast_events_noticeRecord = @$e_blast_events_noticeRecords[0]; // get first record 
  
?>
<?php endif; ?> 

 <?php foreach ($e_blast_events_noticeRecords as $record): ?> 
<?php $venue = $record['venue']; ?>
       
      Location:<br />
      <?php echo $venue['venue_name']; ?><br />
 <span class="body-text"><?php echo $venue['venue_address'] ?><br />
<?php endforeach ?>

<?php if ($e_blast_events_noticeRecords): ?> 

<?php 
   beta_lookupRelatedFields... 

<?php if ($venue['venue_image']): ?>
<?php foreach ($venue['venue_image'] as $upload): ?>
<img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo
$upload['thumbHeight'] ?>" alt="" /><br />
<?php endforeach ?> <?php endif; ?>

<?php foreach ($venue_address_book['venue_image'] as $upload): ?>

<?php foreach ($venue['venue_image'] as $upload): ?> 

<hr align="left" width="300" color="#FF0000">

<font color=”#FF0000" ><b>YOUR HEADER TEXT</b></font>

<tr>
 <!-- Insert This Code -->
<td bgcolor="lightgrey" colspan='2'>
<font size="5"><b>LEGEND</b></font>
<font size="3"> All fields in this editor are color coded according to where they will appear on the events web pages
<hr>
<font color="red">Special Information Only</font>
<font color="darkorchid">Public List Page Only</font>
<font color="green">Members standard form only</font>
<font color="yellow">Appears on all Pages</font> 
 </font>
<!-- End of Insert-->
</td>
</tr> 

<font size="3" color="Red"><b>Your Field Label</b></font>

<?php 
   
 require_once "your server _path /cmsAdmin/lib/viewer_functions.php"; 
 
  list($categoryRecords, $selectedCategory) = getCategories(array( 
    'Table name'           => 'category', 
    'selectedCategoryNum' => '',         // defaults to getNumberFromEndOfUrl() 
    'categoryFormat'      => 'showall',  // showall, onelevel, twolevel 
  )); 
 
?> 

<!-- category menu --> 
  <h3>Nested Menu</h3> 
  <?php foreach ($categoryRecords as $categoryRecord): ?> 
 
    <?php echo str_repeat("&nbsp; &nbsp; &nbsp;", $categoryRecord['depth']); ?> 
 
    <?php if ($categoryRecord['_isSelected']): ?><b><?php endif; ?> 
    <a href="<?php echo $categoryRecord['_link'] ?>"><?php echo $categoryRecord['name'] ?></a> 
    <?php if ($categoryRecord['_isSelected']): ?></b><?php endif; ?> 
    <br /> 
  <?php endforeach; ?> 
<!-- /category menu -->

  <!-- unordered list --> 
  <h3>Unordered List Menu</h3> 
  <ul> 
  <?php foreach ($categoryRecords as $categoryRecord): ?> 
    <?php echo $categoryRecord['_listItemStart'] ?> 
 
    <?php if ($categoryRecord['_isSelected']): ?> 
      <b><a href="<?php echo $categoryRecord['_link'] ?>"><?php echo $categoryRecord['name'] ?></a></b> 
    <?php else: ?> 
      <a href="<?php echo $categoryRecord['_link'] ?>"><?php echo $categoryRecord['name'] ?></a> 
    <?php endif; ?> 
 
    <?php echo $categoryRecord['_listItemEnd'] ?> 
  <?php endforeach; ?> 
  </ul> 
  <!-- /unordered list -->

<?php if (!$selectedCategory): ?> 
  No record selected 
<?php endif; ?> 
 
<?php if ($selectedCategory): ?> 
 
  <h3><?php echo $selectedCategory['name'] ?></h3> 
  <?php echo $selectedCategory['content'] ?> 
 
<?php endif; ?>

<a href="/path/to/viewer.php?<?php echo $categoryRecord['filename'] ?>-<?php echo $categoryRecord['num'] ?>">

viewer.php?filename-here-123

'where' => 'active ="1"' . ' AND `show` ="1" ', 

  <td> 
   <input type="submit" name="action=save" value="<?php _e('Save as Copy') ?>" 
          onclick="document.getElementById('num').value='';
document.getElementById('preSaveTempId').value='1234567890abc'" 
          class="inputButton" /> 
  </td> 

<table border="0" cellspacing="0" cellpadding="0" width="690"> 
 <tr> 
 <!-- Insert This Code -->
 <td> 
   <input type="submit" name="action=save" value="<?php _e('Save as Copy') ?>" 
          onclick="document.getElementById('num').value='';
document.getElementById('preSaveTempId').value='1234567890abc'" 
          class="inputButton" /> 
  </td> 
<!-- End of Insert-->
  <td align="right"> 
   <input type="submit" name="action=save" value="<?php _e('Save') ?>" class="inputButton" /> 
   <input type="button" name="cancel" value="<?php _e('Cancel') ?>" class="inputButton" 
             onclick="window.location='?menu=<?php print urlencode($menu) ?>'" /> 
  </td> 
 </tr> 
</table> 
</form> 
 
<?php showWysiwygGeneratorCode() ?>

    <input type="submit" 
          name="action=save" 
          value="<?php et('Save As Copy') ?>"  
          onclick="document.getElementById('num').value='';
document.getElementById('preSaveTempId').value='1234567890abc'"  
          class="button" />  

  <div style="float:right"> 
<!-- Insert This Code -->
    <input type="submit" 
          name="action=save" 
          value="<?php et('Save As Copy') ?>"  
          onclick="document.getElementById('num').value='';
document.getElementById('preSaveTempId').value='1234567890abc'"  
          class="button" />  
<!-- End of Insert-->
      <input class="button" type="submit" name="_action=save" value="<?php et('Save') ?>"  /> 
     <input class="button" type="button" name="cancel" value="<?php et('Cancel') ?>" 
onclick="window.location='?menu=<?php print urlencode($menu) ?>'" /> 
  </div>

 <?php header('Content-type: text/html; charset=utf-8'); ?>
<?php 
/require_once "/path_to_your/cmsAdmin/lib/viewer_functions.php";

$query = "INSERT INTO cms_table_name (field_1) VALUES 

(‘field_1_value1'),
(‘field_1_value2’),
(‘field_1_value3’),
(‘field_1_value4’)”;
mysql_query($query) or die("MySQL Error: " .mysql_error(). " with query $query\n");

?>

$query = "INSERT INTO cms_table_name (field_1,field_2) VALUES

(‘field_1_value1',‘field_2_value1'),
(‘field_1_value2’,‘field_2_value2'),
(‘field_1_value3’,‘field_2_value3'),
(‘field_1_value4’,‘field_2_value4')”;
mysql_query($query) or die("MySQL Error: " .mysql_error(). " with query $query\n");

?> 

SELECT num, rule
  FROM `<?php echo $TABLE_PREFIX ?>rules_list`

SELECT num, rule
  FROM `<?php echo $TABLE_PREFIX ?>rules_list`
WHERE `group` LIKE '%guide%'

SELECT num, CONCAT(DATE_FORMAT(`presentation_date`, '%b %D, %Y'), ' - ', presentation_title)
  FROM `<?php echo $TABLE_PREFIX ?>all_presentations`
WHERE hidden = 0
ORDER BY presentation_date DESC

'ignoreHidden' => true, // don't hide records with hidden flag set

'where'    => " hidden = '1' ",

<style type="text/css">
.pad { border-right: 20px solid transparent;
}
.padr { padding-right:20px;
}
</style>

<div  style="float:left"><div class="padr"  style="float:none"> <?php foreach ($record['head_shot'] as $index =>
$upload): ?><img src="<?php echo htmlencode($upload['thumbUrlPath2']) ?>" width="<?php echo $upload['thumbWidth2'] ?>"
height="<?php echo $upload['thumbHeight2'] ?>" alt="" /><?php endforeach ?></div>
</div>
<div><?php echo $record['content'] ?></div>

<?PHP echo $pagesRecord['page_title']; ?> 
<?PHP echo $pagesRecord['meta_keywords']; ?> and
<?PHP echo $pagesRecord['meta_description']; ?>

<title><?PHP echo $pagesRecord['page_title']; ?> </title>
<META NAME="KeyWords" CONTENT="<?PHP echo $pagesRecord['meta_keywords']; ?>"> 
<META NAME="Description" CONTENT="<?PHP echo $pagesRecord['meta_description']; ?>"> 

<?PHP foreach ($other_eventsRecords as $record): ?>
                           <p align="left"><a class="special" href="<?PHP echo $record['url'] ?>"><?PHP echo
$record['organization_name'] ?></a><br />
                       <?PHP endforeach ?> 
 

 'where'       => whereRecordNumberInUrl(1),
 'limit'       => '1', 

$other_eventsRecord = @$other_eventsRecords[0]; // get first record

'where'       => whereRecordNumberInUrl(1), 

 list($your_tableRecords, $your_tableMetaData) = getRecords(array( 
    'Table name'   => 'your_table', 
    'where'       => whereRecordNumberInUrl(1), 
    'limit'       => '1', 
  ));

allowSearch => false, 

 list($your_tableRecords, $your_tableMetaData) = getRecords(array( 
    'Table name'   => 'your_table', 
    'limit'       => '1', 
    'allowSearch' => false, 
  ));

 <table>
 <?PHP foreach ($your_table_nameRecords as $record): ?>
 <tr>
<td><div align="left"><span class="your_css" ><?PHP echo date("D, M jS, Y g:i a", strtotime($record['your_first_
field'])) ?></span></div></td>
                               <td><div align="left"><span class="your_css" >Location: <?PHP echo $record['l
your_second_ field'] ?></span> 
</div>
</td>
</tr><?PHP endforeach ?>
</table>

<?php if(!preg_match("/^https:\/\//i", $record['web_site_link_url'] )):?>
 <?PHP  if  (!preg_match("/^http:\/\//i", $record['web_site_link_url'])) {
 $record['web_site_link_url'] = "http://" . $record['web_site_link_url'];   } ?>

<?PHP endif ?>

<a href="<?PHP echo $record['web_site_link_url'] ?>"><?PHP echo $record['web_site_link_text'] ?></a> 

<?php if(!preg_match("/^https:\/\//i", $yourRecord['web_site_link_url'] )):?>
<?PHP  if  (!preg_match("/^http:\/\//i", $yourRecord['web_site_link_url'])) {
 $yourRecord['web_site_link_url'] = "http://" . $yourRecord['web_site_link_url'];   } ?>
<?PHP endif ?>
<a href="<?php echo $yourRecord['web_site_link_url'] ?>"><?php echo $yourRecord['web_site_link_text'] ?></a>

<?php if(!preg_match("/^https:\/\//i", $upload['info1'] )):?>
<?php if  (!preg_match("/^http:\/\//i", $upload['info1'])) {
 $upload['info1'] = "http://" . $upload['info1'];   } 
?><?php endif ?>

<a href="<?php echo $upload['info1'] ?>"><img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo
$upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="" /></a>

<?php if(!preg_match("/^https:\/\//i", $your_tableRecord['web_site_link_url'] )):?>
<?PHP  if  (!preg_match("/^http:\/\//i", $your_tableRecord['web_site_link_url'])) {
 $your_tableRecord['web_site_link_url'] = "http://" . $your_tableRecord['web_site_link_url'];   } ?>
<?php endif ?>
<a href="<?php echo $your_tableRecord['web_site_link_url'] ?>"><?php echo $your_tableRecord['web_site_link_text'] ?></a>

<?php if(!preg_match("/^https:\/\//i", $record['web_site_link_url'] )):?>

!preg_match("/^http:\/\//i", $record['web_site'] 

$record['web_site_link_url'] = "http://" . $record['web_site_link_url']

 <a href="<?PHP echo $record['web_site_link_url'] ?>"><?PHP echo $record['web_site_link_text'] ?></a> 

              <?php function ensure_url($url)
        { if(!preg_match("/^https:\/\//i", $url ))
         { 
  if (!preg_match("/^http:\/\//i", $url)) { 
    $url = "http://" . $url; 
  } }
  return $url; 
}
  ?> 

<?php echo ensure_url($record['your_link_field']) ?>

<?php echo ensure_url($your_tableRecord['your_link_field']) ?>

http://www.mysite.com/visualartists.php?sort_discipline=V

<?PHP
  require_once "/hsphere/local/home/web/mysite.com/cmsAdmin/lib/viewer_functions.php";

  list($artistsRecords, $artistsMetaData) = getRecords(array(
    'Table name'   => 'artists',
// Insert This Code
'where' => "discipline_code LIKE '%" .mysql_real_escape_string(@$_REQUEST['sort_discipline']). "%'",
// End of Insert
 ));
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

http://www.mysite.com/visualartists.php?sort_letter=A&sort_discipline=V

'where' => "last_name LIKE '%" .mysql_real_escape_string(@$_REQUEST['sort_discipline']). "%'",
'where' => "last_name LIKE '%" .mysql_real_escape_string(@$_REQUEST['sort_letter']). "%' AND discipline_code = '"
.mysql_real_escape_string(@$_REQUEST['sort_discipline']). "'",

'where' => "last_name LIKE '" .mysql_real_escape_string(@$_REQUEST['sort_discipline']). "%'",

'where' => "last_name LIKE '" .mysql_real_escape_string(@$_REQUEST['sort_letter']). "%' AND discipline_code = '"
.mysql_real_escape_string(@$_REQUEST['sort_discipline']). "'",

<?PHP if (!$artistsRecords): ?> 
<div class="body-text-bold" align="center"><?PHP echo 
 "Sorry, but no active members were found who match this category.<br /><br />"; ?> 
<?PHP endif ?><div>

<?PHP foreach ($pub_category_listRecords as $record): ?>
<?PHP if ($record['group_code'] == "book"): ?> 
  <?PHP echo $record['fieldA'] ?> 
<?PHP elseif ($record['group_code'] == "CD"): ?> 
  <?PHP echo $record['fieldB'] ?> 
<?PHP elseif ($record['group_code'] == "Magazine"): ?> 
  <?PHP echo $record['fieldC'] ?> 
<?PHP else: ?> 
  <?PHP echo $record['fieldD'] ?> 
  Sorry, couldn't find a match for '<?PHP echo $record['group_code'] ?>' 
<?PHP endif ?>
 <?PHP endforeach; ?>

<?PHP if ($pub_category_listRecord['group_code'] == "book"): ?> 
  <?PHP echo $pub_category_listRecord['fieldA'] ?> 
<?PHP elseif ($pub_category_listRecord['group_code'] == "CD"): ?> 
  <?PHP echo $pub_category_listRecord['fieldB'] ?> 
<?PHP elseif ($pub_category_listRecord['group_code'] == "Magazine"): ?> 
  <?PHP echo $pub_category_listRecord['fieldC'] ?> 
<?PHP else: ?> 
  <?PHP echo $pub_category_listRecord['fieldD'] ?> 
  Sorry, couldn't find a match for '<?PHP echo $pub_category_listRecord['group_code'] ?>' 
<?PHP endif ?>

list($artistsRecords, $artistsMetaData) = getRecords(array(
'Table name'   => 'artists',
// Insert This Code
 'where'    => " hidden = '0' ", 
'orWhere'    => " hidden = '1' ", 
   ));
// End of Insert

 <?PHP if ($record['hidden'] == '1'): ?> and <?PHP if ($record['hidden'] == '0'): ?> 

after your ‘foreach ‘statements to show the records that match either criteria, like this:

<?PHP foreach ($artistsRecords as $record ): ?>
<?PHP if ($record['hidden'] == '1'): ?>
<?PHP echo $record['last_name'] ?>, <?PHP echo $record['first_name'] ?>
<?PHP endif ?>
<?PHP endforeach; ?>

'debugSql' => true,

  // load records from 'blog'
list($blogRecords, $blogMetaData) = getRecords(array(
  'tableName'         => 'blog',
  'loadUploads'       => true,
  'allowSearch'       => false,
  'ignoreHidden'      => true,  // don't hide records with hidden flag set
  'ignorePublishDate' => true,  // don't hide records with publishDate > now
  'ignoreRemoveDate'  => true,  // don't hide records with removeDate < now
));

list($yourRecords, $yourDetails) = getRecords(array( 
  'Table name'   => 'yourTable', 
 // Insert This Code
 'limit'       => '1', 
// End of Insert
));

### Change Password

 ### Automatic Log Off and Redirect
user_logoff("http://www.my_site.com/logout_index.php");

 

<?php
$count_my_page = ("aboutpagecounter.txt");
$hits = file($count_my_page);
$hits[0] ++;
$fp = fopen($count_my_page , "w");
fputs($fp , "$hits[0]");
fclose($fp);?>

<?php echo $hits[0]; ?>

<?php incrementCounterField('your_table_name', 'your_field_name', $your_table_name Record['num']); ?>

<?php if ($_SERVER['REMOTE_ADDR'] != '127.0.0.1') { incrementCounterField('your_table_name', 'your_field_name',
$your_tableRecord['num']); } ?>

<?php echo $your_table_name['your_field_name '] ?>

list($counterRecords, $counterMetaData) = getRecords(array(
    'Table name'   => 'counter',
    'where'       => whereRecordNumberInUrl(1),
    'limit'       => '1',
  ));
  $counterRecord = @$counterRecords[0]; // get first record

<?php incrementCounterField('counter', 'your_field_name', $counter Record['num']); ?>

<?php if ($_SERVER['REMOTE_ADDR'] != '127.0.0.1') { incrementCounterField('counter' 'your_field_name',
$counterRecord['num']); } ?>

<?php echo $counter['your_field_name '] ?>

<?php  $CMS_USER = getCurrentUserFromCMS();   ?>

<?php if( $CMS_USER['isAdmin'] && $record['your_field_name'] > 0): ?>This page was viewed <?php echo
$record['your_field_name'] ?> time<?php if($record[your_field_name'] == 1): ?><?php else :?>s<?php endif ?><?php endif
?>

function incrementCounterFieldBy($tablename, $fieldname, $recordNumber, $amount = 1) { 
  global $VIEWER_NAME; 
 
  // error checking 
  if (!$tablename)    { die(__FUNCTION__ . ": No 'tablename' value specified!"); } 
  if (!$fieldname)    { die(__FUNCTION__ . ": No 'fieldname' value specified!"); } 
  if (!$recordNumber) { die(__FUNCTION__ . ": No 'recordNumber' value specified!"); } 
 
  // update counter 
  $escapedTableName = mysql_escape(getTableNameWithPrefix($tablename)); 
  $query  = "UPDATE `$escapedTableName` SET `$fieldname` = IFNULL(`$fieldname`,0) + $amount"; 
  $query .= " WHERE `num` = '" .mysql_escape($recordNumber). "'"; 
  $result = @mysql_query($query); 
  if (!$result) { die(__FUNCTION__ . " MySQL Error: ". htmlspecialchars(mysql_error()) . "\n"); } 
  if (!mysql_affected_rows()) { 
    die(__FUNCTION__ . ": Couldn't find record '" .htmlspecialchars($recordNumber). "'!"); 
  } 
 
}

<?PHP function textLimit($string, $length, $replacer = '...')
{
if(strlen($string) > $length)
return (preg_match('/^(.*)\W.*$/', substr($string, 0, $length+1), $matches) ? $matches[1] : substr($string, 0, $length))
. $replacer;

return $string;
} 

 ?>

 
<?PHP echo textLimit($record['your_field'], 100) ?>

<p>WYSIWYG content blah, blah, blah ... <a href="<?php echo $record['_link']; ?>”>Read More</a>></p>

<?php function cutText($string, $setlength) {
$length = $setlength;
if($length<strlen($string)){
while (($string{$length} != " ") AND ($length > 0)) {
$length--;}
if ($length == 0) return substr($string, 0, $setlength);
else return substr($string, 0, $length);}
else return $string; }
?>

<?php echo cutText($record['my_field']= preg_replace("|</p>\s*$|i", "...</p>", $record['my_field'] ), 90); ?> 

<?php 
  $html = preg_replace("|</p>\s*$|i", "", $record['my_field'] ); 
  $html = cutText($html, 90); 
  $html = $html . "...</p>"; 
  echo $html; 
?>

  <?PHP
  function maxWords($textOrHtml, $maxWords) { 
  $text = strip_tags($textOrHtml); 
  $words = preg_split("/\s+/", $text, $maxWords+1); 
  if (count($words) > $maxWords) { unset($words[$maxWords]); } 
  $output = join(' ', $words); 
 
  return $output; 
  } 
?> 

<?PHP  echo maxWords($record['content'], 5); 
?>
If you want to add  ...more and a link, use something like this:

<?PHP  echo maxWords($record['content'], 5); 
?>...<a href="<?php echo $record['_link']; ?>”>Read More</a>

<?PHP  echo maxWords($record['content'], 5); 
?>...<a class="read-more" href="http://www.your_site.com/your_detail_page.php?<?php echo $record['num'] ?>">(Read
More)</a>

 $text = strip_tags($textOrHtml); 

$text = strip_tags($textOrHtml, '<br />'); 

 $text = strip_tags($textOrHtml, '<br /><p>'); 

 <?PHP  
  function maxWords($textOrHtml, $maxWords) { 
    $text=str_replace("<p>","*P*",$textOrHtml); 
    $text= str_replace("</p>","*/P*",$text); 
    $text = strip_tags($text);   
    $words = preg_split("/\s+/", $text, $maxWords+1);   
    if (count($words) > $maxWords) { unset($words[$maxWords]); }   
    $output = join(' ', $words);   
    $output=str_replace("*P*","<p>",$output); 
    $output=str_replace("*/P*","</p>",$output); 
    $output.="</p>"; 
 
    return $output;   
  }   
?>

    

<?PHP  
function wordCount($textOrHtml) {  
  $text = strip_tags($textOrHtml, "<b></b><i></i>");  
  $words = preg_split("/\s+/", $text);  
 
  return count($words); 
}  
?>

<?php $word1 = $common_informationRecord['words'] ?>  
<?PHP echo maxWords($record['description'], $word1); ?> 
<?php if (wordCount($record['description']) > $word1) : ?>...<a href="<?php echo $record['_link']; ?>">Read
More</a><?php endif ?> 

<?php if (wordCount($record['description']) > $word1) : ?>...<a href="<?php echo $record['_link']; ?>">Read
More</a><?php else :?> <a href="<?php echo $record['_link']; ?>">Your Text Here</a><?php endif ?> 

<?PHP 
list($your_tableRecords, $your_tableMetaData) = getRecords(array(
    'tableName'   => your_table',

  ));

  if (!$your_tableRecords) { 
    header("Location: http://www.example.com/newurl.php"); 
    exit; 
  } 
?>

<?PHP 
list($your_tableRecords, $your_tableMetaData) = getRecords(array(
    'tableName'   => your_table',

  ));

if($your_tableMetaData['totalRecords'] == 1)
 {
header("Location: http://www.example.com/newurl.php");
exit;
}
?>

<?php if($portfolio_title_detailsMetaData['totalRecords'] == 1):?>
<?php foreach ($portfolio_title_detailsRecords as $record): ?>
<?php $group_code= $record['group_code'] ?>
<?php endforeach; ?>
<?php header("Location: http://www.your_domain.com/your_new_page.php?group_code=$group_code&no_back=1");
exit;
?>

<?php  $var1= $_REQUEST['group_code']; ?>
Use $var1 however you see fit.

<?php  $var2= $_REQUEST['no_back']; ?>
<?php if (!$var2 == 1 ):?>
Your code to hide...
<?php endif ?>

<?php
$old_group = ''; // init blank var.
foreach ($eventsRecords as $record):
$group = $record['type']; // load sub-group value from record.
if ($group != $old_group) { // If different from the last sub-group value, print the sub-group name.
echo "<h2>$group</h2>";
}?>
<a href="<?php echo $record['_link'] ?>"><?php echo $record['title'] ?></a>
<?php echo $record['preview'] ?>
<br /><br />
<?php $old_group = $group; // retain sub-group name before moving to new record. ?>
<?php endforeach ?>

<?php
$old_group = ''; // init blank var.
foreach ($eventsRecords as $record):
$group = $record['type']; // load sub-group value from record.
if ($group != $old_group && $record['type'] == "Group 1") { // If different from the last sub-group value, and equals
Group 1, print the sub-group name.
echo "<h2>Group 1 text </h2>";}

if ($group != $old_group && $record['type'] == "Group 2") { echo "<h2>Group 2 text</h2>";}

if ($group != $old_group && $record['type'] == "Group 3") { echo "<h2>Group 3 text</h2>";}

if ($group != $old_group && $record['type'] == "Group 4") { echo "<h2>Group 4 text</h2>";}
?>
<a href="<?php echo $record['_link'] ?>"><?php echo $record['title'] ?></a>
<?php echo $record['preview'] ?>
<br /><br />
<?php $old_group = $group; // retain sub-group name before moving to new record. ?>
<?php endforeach ?>

<?php $old_group = ''; ?>

<?php foreach ($eventsRecords as $record): ?> 

<?php $group = $record['type'];  ?>
 
<?php if ($group != $old_group && $record['type'] == "Group1"): ?> 

<div align="center"><?php foreach ($graphicsRecord['group_1_graphic'] as $upload): ?>
 <img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo
$upload['thumbHeight'] ?>" alt='' /><br /><br /></div>
<?php endforeach ?>  <?php endif ?> 

<?php if ($group != $old_group && $record['type'] == "Group 2"): ?> 

<div align="center"><?php foreach ($graphicsRecord['group_2_graphic'] as $upload): ?>
<img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo
$upload['thumbHeight'] ?>" alt='' /><br /><br /></div>
<?php endforeach ?>  <?php endif ?> 

<?php if ($group != $old_group && $record['type'] == "Group 3"): ?>
<div align="center"><?php foreach ($graphicsRecord['group_3_graphic'] as $upload): ?>
<img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo
$upload['thumbHeight'] ?>" alt='' /><br /><br /></div>

 <?php endforeach ?>  <?php endif ?> 

<?php

 list($accountsRecords, $accountsMetaData) = getRecords(array(
    'tableName'   => 'accounts',

  ));

 list($board_of_director_positionsRecords, $board_of_director_positionsMetaData) = getRecords(array(
    'tableName'   => 'board_of_director_positions',
   ));

  $directorposition = array_filter(array_pluck($board_of_director_positionsRecords, 'position')); ?>

?php foreach ($directorposition as $position): ?> 

<h3 class="your_class_1"><?php echo strtoupper($position); ?></h3>

<?php foreach ($accountsRecords as $record): ?>

<?php if ($record['board_of_director_position_1:label'] == $position || $record['board_of_director_position_2:label'] ==
$position) : ?>

<span class="your_class_2"><?php echo strtoupper($record[full_name']); ?></span>   
<?php endif ?>
                                             
<?php endforeach ?> <hr />   
<?php endforeach ?> 

  $faqgroup = array_filter(array_pluck($faq_categoriesRecords, 'category'));

<?php foreach ($faqgroup as $group): ?> 
<h1 class="your_class_1"><?php echo strtoupper($group); ?></h1>
<?php foreach ($faqRecords as $record): ?>
<?php if ($record['category:label'] == $group) : ?>
<?php $question = htmlspecialchars($record['question']); ?> <span class="your_class_2"><?php echo strtoupper($question);
?></span>
<div align="left" class="your_class_3"><?php echo maxWords($record['answer'], 25); ?>
<?php if (wordCount($record['answer']) > 25) : ?><a class="special" href="<?php echo $record['_link']; ?>"><span
class="body-text-bold-10">... read more</span></a><?php endif; ?>
</div>   
<?php endif ?>
                                             
<?php endforeach ?>
<hr />   
<?php endforeach ?> 

<?PHP
function maxWords($textOrHtml, $maxWords) {
$text = strip_tags($textOrHtml);
$words = preg_split("/\s+/", $text, $maxWords+1);
if (count($words) > $maxWords) { unset($words[$maxWords]); }
$output = join(' ', $words);

return $output;
}
?>

<?PHP
function wordCount($textOrHtml) {
$text = strip_tags($textOrHtml, "<b></b><i></i>");
$words = preg_split("/\s+/", $text);

return count($words);
}
?>

<?php $bgColor = (@$bgColor == '#F8F8F8') ? '#EFEFEF' : '#F8F8F8'; ?>

Then you can display it like this: <?php echo $bgColor ?> 

<table>
<tr>
<th>title</th>
<th>name</th>
<th>phone</th>
<th>email</th>
</tr>
<?php foreach ($contact_listRecords as $record): ?>
<?php $bgColor = (@$bgColor == '#F8F8F8') ? '#EFEFEF' : '#F8F8F8'; ?>
<tr bgcolor="<?php echo $bgColor ?>">
<td><?php echo $record['title'] ?></td>
<td><?php echo $record['name'] ?></td>
<td><?php echo $record['phone'] ?></td>
<td><a href="mailto:<?php echo $record['email'] ?>"><?php echo $record['email'] ?></a></td> 
</tr>
<?php endforeach; ?>
</table> 

<table width="100%" border="0" cellpadding="0">
<?php foreach ($your_tableRecords as $record): ?>

<?php $float = (@$float == 'left') ? 'right' : 'left'; ?>
<?php $pad = (@$pad == 'padl') ? 'padr' : 'padl'; ?>
<tr>
<td >
<div class="<?php echo $pad ?>" style="float:<?php echo $float ?>"><div style="float:none"> <?php foreach
($record['image_1'] as $upload): ?><img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo
$upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt='' /><?php endforeach ?></div></div> <div
align="center" style="text-align:left"><?php echo strtoupper($record['headline']); ?><?php
<?php  echo $record['content'); ?></div></td>
</tr>

<?php endforeach; ?>  
</table>

.padl { border-right: 20px solid transparent; border-left: 20px solid transparent; border-bottom: 10px solid
transparent; }
.padr {  border-left: 20px solid transparent; border-bottom: 10px solid transparent; }    

<?php echo $record['createdBy.fullname'] ?>

In the foreach loop.

And for a detail page, it’s:

<?php echo $yourtableRecord['createdBy.fullname'] ?>

According to Dave Edis:

It loads the record of the "owner" from createdByUserNum and adds all those fields with a "createdBy." prefix. 

If, like me you need to have a Last Name and a First Name for sorting and display purposes, you can add the 2 fields
"first_name" and" last_name" to the "User Accounts" editor and then modify the createdBy code to: 

<?php echo $record['createdBy.first_name'] ?>&nbsp;<?php echo $record['createdBy.last_name'] ?>

or

<?php echo $yourtableRecord['createdBy.first_name'] ?>&nbsp;<?php echo $yourtableRecord['createdBy.last_name'] ?>

You can now display and sort your "User Account" record list by the new "last name" and "first_name" fields and even
delete the "fullname" field from the "User Accounts" table if you don't feel you will ever need it for anything. Just
don't forget to enter the new information before you delete the "fullname" field.

NOTE: You can also use this technique in the LisPage fields that show at the top of your records lists in a multi-record
editor to show the author's name instead of the createdByUserNum

Welcome <?php echo $CURRENT_USER['first_name']; ?>&nbsp;<?php echo $CURRENT_USER['first_name']; ?>,

<?php
  
  require_once "/your path/cmsAdmin/lib/viewer_functions.php";

list($homepageRecords, $homepageMetaData) = getRecords(array(
    'Table name'   => 'homepage',
    'where'       => whereRecordNumberInUrl(1),
    'limit'       => '1',
  ));
  $homepageRecord = @$homepageRecords[0]; // get first record


 list($yourlistingsRecords, $yourlistingsMetaData) = getRecords(array(
    'Table name'   => 'yourlistings',
   
  ));

?>

<?php echo $homepageRecord['your_first_field'] ?><br />
<?php echo $homepageRecord['your_second_field'] ?><br />
<?php echo $homepageRecord['your_third_field'] ?>

<?php foreach ($yourlistingsRecords as $record): ?>
<?php echo $record['your_first_field'] ?><br />
<?php echo $record['your_second_field'] ?><br />
<?php echo $record['your_third_field'] ?>
<?php endforeach; ?>

 'where'       => whereRecordNumberInUrl(1),

 'limit'       => '1',

<?php $title = htmlspecialchars($record['title']); ?>

<?php $title = ($your_tableRecord['title']); ?>

<?php $title = htmlspecialchars($your_tableRecord['title']); ?>

<?php echo strtoupper($title); ?>

<?php echo strtoupper(date("D, M jS, Y", strtotime($e_blastRecord['press_release_publish_date']))) ?>

<?php 
  $time = strtotime( $e_blastRecord['press_release_publish_date'] ); 
  $date = date("D, M jS, Y", $time); 
  $uppercaseDate = strtoupper( $date ); 
  echo $uppercaseDate; 
?>

<?php echo ucfirst(strtolower($title)); ?>

<?php echo ucwords(strtolower($title)); ?>

 $maximages = ($common_informationRecord['thumbnails_per_page']);
 list($portfolio_imagesRecords, $portfolio_imagesMetaData) = getRecords(array(
    'Table name'   => 'portfolio_images',
    'perPage' => $maximages,
    
  ));

 'where'       => whereRecordNumberInUrl(1), 

    <?php if ($portfolio_imagesMetaData['totalPages'] > 1): ?>
  
This is Page <?php echo $portfolio_imagesMetaData['page'] ?> of <?php echo $portfolio_imagesMetaData['totalPages'] ?>
                     
<?php if ($portfolio_imagesMetaData['nextPage']): ?> 
<br /><a href="<?php echo $portfolio_imagesMetaData['nextPageLink'] ?>">Click Here to See More of My Work.
                    
</a> 
                   
<?php endif ?>
<?php if ($portfolio_imagesMetaData['prevPage']): ?> 
<br /><a href="<?php echo $portfolio_imagesMetaData['prevPageLink'] ?>">Click Here to See My Previous Portfolio
Page.</a> 
                    
<?php endif ?> 
<?php endif ?>

<table>
<tr>
<?php  
$photosPerPage = 6;  
$photoPage = @$_REQUEST['photoPage'] ? $_REQUEST['photoPage'] - 1 : 0;  
$firstIndex = $photoPage * $photosPerPage;  
if ($firstIndex > sizeof($your_tableRecord['images'])-1 || $firstIndex < 0) { $firstIndex = 0; $photoPage = 0; } 
$lastIndex = min($firstIndex + $photosPerPage, sizeof($your_tableRecord['images'])) - 1;  
foreach (range($firstIndex, $lastIndex) as $photoIndex):  
$upload = $your_tableRecord['images'][$photoIndex]  
?>  
<td align="center"><div class="pic"><a href="<?php echo $upload['urlPath'] ?>" rel="enlargeimage::click"
rev="photoload"><img src="<?php echo $upload['thumbUrlPath'] ?>" alt='' width="<?php echo $upload['thumbWidth'] ?>"
height="<?php echo $upload['thumbHeight'] ?>" align="middle" class="displayed" /></a></div></td>  
<?php $maxCols=3; if (@++$count % $maxCols == 0): ?>  
</tr><tr>  
<?php endif ?>  
<?php endforeach; ?>  
</tr></table>  
<p><br />
<form action="?num=<?php echo $your_tableRecord['num'] ?>" method="post"> 
<?php if ($firstIndex > 0): ?>  
<a href="?photoPage=<?php echo $photoPage; ?>&=<?php echo $your_tableRecord['num'] ?>">&lt;&lt; Click/Tap for previous
page</a>  
<?php endif ?>  
Page <input type="text" name="photoPage" value="<?php echo($photoPage + 1); ?>" style="width: 25px;" /><input
type="submit" value="Go" /> of <?php echo(ceil(sizeof($your_tableRecord['images']) / $photosPerPage)); ?>  
<?php if ($lastIndex < sizeof($your_tableRecord['images']) - 1): ?>  
<a href="?photoPage=<?php echo $photoPage+2; ?>&=<?php echo $your_tableRecord['num'] ?>">Click/Tap for next page
&gt;&gt;</a><br />  
<?php endif ?> 
</form>

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  
  require_once "/path_to_your/cmsAdmin/lib/viewer_functions.php";
  

  list($common_informationRecords, $common_informationMetaData) = getRecords(array(
    'tableName'   => 'common_information',
    'allowSearch'=> false,
    'limit'       => '1',
  ));
  $common_informationRecord = @$common_informationRecords[0]; // get first record
  
 
  // load records
  list($bookRecords, $bookMetaData) = getRecords(array(
    'tableName'   => 'book',
    'where'       => whereRecordNumberInUrl(1),
    'limit'       => '1',
    
  ));
  $bookRecord = @$bookRecords[0]; // get first record
  

?>

<table width="975" border="0" align="center" cellpadding="5">
  
  <tr>
    <td width="474" valign="top"><div align="center"><br /><?php if ($bookRecord['images']): ?><span
class="body-text-bold-9">
    <?php echo $common_informationRecord['book_image_thumbnails_instructions'] ?></span><?php endif ?> <br /> <br />
        </div>
     </td></tr></table>

<table width="950" border="0" align="center">
  <tr>
    <td valign="top">
         <?php  
$photosPerPage = $common_informationRecord['images_per_book_page'];  
$photoPage = @$_REQUEST['photoPage'] ? $_REQUEST['photoPage'] - 1 : 0;  
$firstIndex = $photoPage * $photosPerPage; 
$lastIndex = min($firstIndex + $photosPerPage, sizeof($bookRecord['images'])) - 1;  
?>     

<?php if ((ceil(sizeof($bookRecord['images']) / $photosPerPage)) > 1): ?><form action="?num=<?php echo
$bookRecord['num'] ?>" method="post"> 
<?php if ($firstIndex > 0): ?>  
<a href="?photoPage=<?php echo $photoPage; ?>&=<?php echo $bookRecord['num'] ?>"><?php echo
$common_informationRecord['previous_message'] ?></a>  
<?php endif ?>  

<span class="body-text-bold-9">Page  <input type="text" name="photoPage" value="<?php echo($photoPage + 1); ?>"
style="width: 25px;" /> of <?php echo(ceil(sizeof($bookRecord['images']) / $photosPerPage)); ?></span>

<?php if ($lastIndex < sizeof($bookRecord['images']) - 1): ?>  <input type="submit" value="Go" />
<!-- NOTE: You can use  <input type="submit" value="" /> above if you want the word Go to disappear -->
<a href="?photoPage=<?php echo $photoPage+2; ?>&=<?php echo $bookRecord['num'] ?>"><?php echo
$common_informationRecord['next_message'] ?></a><br />  
<?php endif ?> 
</form> 
<?php endif ?>    
    
    <table  border="0" cellspacing="3" cellpadding="3"> 
<tr>
  

<?php

if ($firstIndex > sizeof($bookRecord['images'])-1 || $firstIndex < 0) { $firstIndex = 0; $photoPage = 0; } 
 
foreach (range($firstIndex, $lastIndex) as $photoIndex):  
@$upload = $bookRecord['images'][$photoIndex]  
?>  


<td align="left"  valign="bottom">

<a title="<span class=&quot;body-text-9&quot;><?php echo $upload['info1'] ?></span>" href="<?php echo
$upload['thumbUrlPath2'] ?>"" 

rel="enlargeimage"

rev="targetdiv:loadarea" > <img src="<?php echo $upload['thumbUrlPath'] ?>" alt=""  width="<?php echo
$upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight']?>" border="0" style="margin-bottom: 5px" /> </a>

</td>
<?php $maxCols=3; if (@++$count % $maxCols == 0): ?></tr><tr><?php endif; ?>
<?php endforeach ?>
</tr>
</table>

<p></td>
    <td width="400"><table border="0" cellpadding="5" cellspacing="0" width="25%">
          
<tr>
<td align="left" valign="top" ><div align="left">
             
     
<div align="center" id="loadarea"  style="width: 400px; height: 500px;">
   
        <?php $upload = @$bookRecord['images'][$firstIndex] ?>
             
              <img src="<?php echo $upload['thumbUrlPath2'] ?>" alt="" border="0" /> <br /> <br />
            
            
</div> </td>
    
  </tr>
</table></td>
  </tr>
</table>

input, select { background-color:transparent; border:none; } 

<< prev - page 1 of 5 - next >>

<< prev - page 1 of 5 - next >> go to page #__

<< prev - page 1 - next >> 1, 2, 3, 4, 5

<< prev 1 2 3 4 next >>

<!-- START PAGINATION CODE --> 
 <?php if ($your_tableMetaData['prevPage']): ?> 
   <a href="<?php echo $your_tableMetaData['prevPageLink'] ?>">&lt;&lt; prev</a> 
 <?php else: ?> 
   &lt;&lt; prev 
 <?php endif ?> 
  
 <?php  
    if (@!$_GET['page']): $current_page = "1"; 
    else: $current_page = $_GET['page'];    
  endif;  ?> 
  
<?php foreach (range(1,$your_tableMetaData['totalPages']) as $page): ?>  
  <?php if ($page == $current_page): ?> 
     <strong><?php echo $page; ?></strong> 
   <?php else: ?> 
     <a href="?page=<?php echo $page; ?>"><?php echo $page; ?></a> 
   <?php endif ?> 
<?php endforeach; ?> 
 
 <?php if ($your_tableMetaData['nextPage']): ?> 
   <a href="<?php echo $your_tableMetaData['nextPageLink'] ?>">next &gt;&gt;</a> 
 <?php else: ?> 
   next &gt;&gt; 
 <?php endif ?> 
<!-- /END PAGINATION CODE -->

<a class="your_class" href="javascript:history.go(-1)">Back</a>

list($newsRecords, $newsMetaData) = getRecords(array(  
    'Table name'   => 'news',  
    'offset' => 4,

<?php $recipe = ($table_of_contentsRecord['recipe']); ?>
<?php
$config = array();
$config['AutoFormat.Linkify'] = true;

$recipe = htmlPurify($recipe, $config);
echo $recipe;
?>

<?php $recipe = ($table_of_contentsRecord['recipe']); ?>
<?php
$recipe = preg_replace("|(https?://[\w\-@:%\+.~#?&//=]+)|", '<a href="\\1">\\1</a>', $recipe); 
echo $recipe;
?>

  <?php
ini_set("highlight.comment", "#000");
ini_set("highlight.default", "#000");
ini_set("highlight.html", "#000");
ini_set("highlight.keyword", "#000;");
ini_set("highlight.string", "#000");
?>

code {
font-family: Verdana, sans-serif; color: #000000; font-size: 1em; font-weight:normal;
}
.snippet {
font-family: Verdana, sans-serif; color: #000000; font-size: 1em; font-weight:normal;
 margin: 0px 0px 0px 15px;
    padding: 8px 12px;
    border: 1px dashed #305555;
    background-color: #54ccf2;
    display: block;
    overflow-x: auto;
}

  <?php
ini_set("highlight.comment", "#000");
ini_set("highlight.default", "#000");
ini_set("highlight.html", "#000");
ini_set("highlight.keyword", "#000;");
ini_set("highlight.string", "#000");
?>
                      <table align="center" width="75%" border="0" cellpadding="0">
                        <?php foreach ($table_of_contentsRecords as $record): ?>
                        <tr>
                          <td align="left" valign="top"><!--remove all remaining line breaks from the code not converted
to <br /> in wordprocessor-->
                            
                            <?PHP $record['recipe'] = preg_replace("[]", "", $record['recipe'] );  // insert <b-r>
(remove the dash) between [ and ] for the code to work ?>
                            <?PHP $record['recipe'] = preg_replace("[]", "", $record['recipe'] );  // insert <b-r/>
(remove the dash) between [ and ] for the code to work ?>
                            <?PHP $record['recipe'] = preg_replace("[]", "", $record['recipe'] );  // insert <b-r />
(remove the dash) between [ and ] for the code to work ?>
                            
                            <!--replace the valid <br in the code segment -->
                            
                            <?PHP $record['recipe'] = preg_replace("[z-x]i", "", $record['recipe'] ); // insert <b-r />
(remove the dash) between " and ", and remove the dash between z and x for the code to work ?> 
                            <?PHP
$newUnixTime  = strtotime($record['createdDate']); // seconds since 1970 to createdDate 
$updateUnixTime  = strtotime($record['updatedDate']); // seconds since 1970 to updatedDate
$pastUnixTime = strtotime(date('Y-m-d', strtotime("-30 day")));
$newdifference = $newUnixTime - $pastUnixTime ;
$updatedifference = $updateUnixTime - $pastUnixTime ;
?>
                            <?php if (!$record['recipe'] ): ?>
                            <h2 align="center" class="Heading-Black">
                              <?php $topic = htmlspecialchars($record['topic']); ?>
                              <?php echo strtoupper($topic); ?></h2>
                            <?php else: ?>
                            
                            <hr color="#000000" align="center" width="600" />
                            
                            <!-- Check For New Or Revised Date -->
                            
                            <?php if ($record['new'] == 1  && $newdifference  >= 0): ?>
                            <span class="Medium-Text-Bold-Red">NEW</span><span class="Medium-Text-Bold"> - </span>
                            <?php endif ?>
                            <?php if ($record['revised'] == 1  && $updatedifference  >= 0): ?>
                            <span class="Medium-Text-Bold-Red">REVISED</span><span class="Medium-Text-Bold"> - </span>
                            <?php endif ?>
                            
                            <!-- End Date Check --> 
                            
                            <div align="center" style="width:60%; text-align:left;"><span class="Medium-Text-Bold">
                            <?php $topic = htmlspecialchars($record['topic']); ?>
                            <?php echo strtoupper($topic); ?>
                            <?PHP if ($record['heirarchy'] == "Sub Topic"): ?>
                            - <?php echo date("M jS, Y", strtotime($record['updatedDate'])) ?>
                            <?php endif ?>
                            </span>
                            
                            <?php endif ?>
                            <span class="Medium-Text">
                            <?php
$recipe = $record['recipe'];
$recipe = wordwrap($recipe, 120) ;
$recipe = highlight_string($recipe, true);

// Added per Daniel Loewe 12/27/18 to create links from URLs
 $config = array();
$config['AutoFormat.Linkify'] = true;                    
// split on opening blockquote
$chunks = explode('q-z-l', $recipe); // remove the dashes between the q, z and l for the code to work

// loop through each chunk
foreach ($chunks as $key => $chunk) {

  // split chunk on end blockquote
  $tmp = explode('l-z-q', $chunk); // remove the dashes between the q, z and l for the code to work
  
   // did we find an ending blockquote?
  if (count( $tmp ) > 1) {

    // purify content after blockquote
    $tmp[1] = htmlPurify($tmp[1], $config);
  }
  else {

    // purify only element
    $tmp[0] = htmlPurify($tmp[0], $config);
  }
  // replace ending blockquote
  $chunks[ $key ] = implode('l-z-q', $tmp);
}

// replace opening blockquote
$recipe = implode('q-z-l', $chunks); // remove the dashes between the q, z and l for the code to work

// reset block quotes
$recipe = str_replace('q-z-l', '<blockquote class="snippet"> ', $recipe);  // remove the dashes between the q, z and l
for the code to work
$recipe = str_replace('l-z-q', '</blockquote> ', $recipe); // remove the dashes between the q, z and l for the code to
work
 ?>
<?php echo $recipe; ?>
 
                            </div></td>
                        </tr>
                        <?php endforeach; ?>
                      </table>

  <?php
ini_set("highlight.comment", "#000");
ini_set("highlight.default", "#000");
ini_set("highlight.html", "#000");
ini_set("highlight.keyword", "#000;");
ini_set("highlight.string", "#000");
?>
                      
                      <!--remove all remaining line breaks from the code not converted to <br /> in wordprocessor-->
                      <?php $recipe = ($table_of_contentsRecord['recipe']); ?>
                      <?PHP $recipe = preg_replace("[]", "", $recipe );  // insert <b-r> (remove the dash) between [ and
] for the code to work ?> 
                      <?PHP $recipe = preg_replace("[]", "", $recipe // insert <b-r/> (remove the dash) between [ and ]
for the code to work ?> 
                      <?PHP $recipe = preg_replace("[]", "", $recipe ); // insert <b-r /> (remove the dash) between [
and ] for the code to work ?> 
                      
                      <!--replace the valid <br in the code segment -->
                      <?PHP $recipe = preg_replace("[z-x]i", "", $recipe ); // insert <b-r /> (remove the dash) between
" and ", and remove the dash between z and x for the code to work ?> 
                      <?php $recipe = wordwrap($recipe, 120) ; ?>
                      <?php $recipe = highlight_string($recipe, true); ?>
                      <?php                   
  $config = array();
$config['AutoFormat.Linkify'] = true;                    
// split on opening blockquote
$chunks = explode('q-z-l', $recipe); // remove the dashes between the q, z and l for the code to work

// loop through each chunk
foreach ($chunks as $key => $chunk) {

  // split chunk on end blockquote
  $tmp = explode('l-z-q', $chunk); // remove the dashes between the q, z and l for the code to work
  
   // did we find an ending blockquote?
  if (count( $tmp ) > 1) {

    // purify content after blockquote
    $tmp[1] = htmlPurify($tmp[1], $config);
  }
  else {

    // purify only element
    $tmp[0] = htmlPurify($tmp[0], $config);
  }
  // replace ending blockquote
  $chunks[ $key ] = implode('l-z-q', $tmp); // remove the dashes between the q, z and l for the code to work
}

// replace opening blockquote
$recipe = implode('q-z-l', $chunks); // remove the dashes between the q, z and l for the code to work

// reset block quotes
$recipe = str_replace('q-z-l', '<blockquote class="snippet"> ', $recipe);  // remove the dashes between the q, z and l
for the code to work
$recipe = str_replace('l-z-q', '</blockquote> ', $recipe); // remove the dashes between the q, z and l for the code to
work
 ?>
                      <table align="center" width="100%" border="0">
                        <tr><td>
                        <span class="Medium-Text-Bold"><b>
                            <?php $topic = htmlspecialchars($table_of_contentsRecord['topic']); ?>
                            <?php echo strtoupper($topic); ?> - <?php echo date("M jS, Y",
strtotime($table_of_contentsRecord['updatedDate'])) ?></span>
                            
                            
                            </td></tr>
                        <tr>
                          <td class="Medium-Text"><?php echo $recipe; ?></td>
                        </tr>
                      </table>

#header {background-image:url(../images/your_image.jpg)};
}

h1{
    color: #c0c0c0;
    font-size = 2em;
    text-align: center;
}
__

Addhandler application/x-httpd-php.css 

<link rel="stylesheet" type="text/css" href="your_css_folder/your_css_file.css" />

<link rel="stylesheet" type="text/css" href="your_css_folder/your_css_file.php" />

   

<?php

header("Content-type: text/css");
?>

<?php header('Content-type: text/html; charset=utf-8'); ?>

<?php
  
  require_once "path_to_your/cmsAdmin/lib/viewer_functions.php";

  list($common_informationRecords, $common_informationMetaData) = getRecords(array(
    'tableName'   => 'common_information',
    'where'       => whereRecordNumberInUrl(1),
    'limit'       => '1',
  ));
  $common_informationRecord = @$common_informationRecords[0]; // get first record

  // show error message if no matching record is found
  if (!$common_informationRecord) {
    print "Record not found!";
    exit;
  }

?>
<?php 
header("Content-type: text/css");
?>

#header {background-image:url(<?php foreach ($common_informationRecord['page_background_image'] as $upload): ?>
http://www.your_site.com/<?php echo $upload['thumbUrlPath'] ?><?php endforeach ?>)};
}

h1{
    color: #<?php echo $common_informationRecord['heading_color'] ?>;
    font-size = <?php echo $common_informationRecord['heading_size'] ?>;
    text-align: center;
}
 

:focus {
outline: 0;
} 
__

<?php $count = 0; ?>
<?php foreach ($your_tableRecords as $record ): ?
<?php  // in the code \.[a-z0-9-]+)*(\.[a-z]{2,4}) 2 is the minimum and 4 is the maximum characters after the period to
account for TLDs like .us and .info
$email_address = $record['email_address'];
if(!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$", $email_address)) {
  
echo $record['email_address'] ;
$count++;
}
?>
<?php endforeach ?>
<br /> <br />
There are <?php echo $count ?> invalid email addresses in this list.

http://www.virtuosimedia.com/dev/php/37-tested-php-perl-and-javascript-regular-expressions

    

<?php echo str_replace('*school_name*',$schoolRecord['title'],$record['content']);?>

    

<?php echo str_replace('*school_name*',$schoolRecord['title'],$your_tableRecord['content']);?>

<?php echo str_replace('*var1*',$source_tableRecord['source_field'],$target_tableRecord['target_field']);?>

?<?php echo $source_tableRecord['num'] ?>%23