Thanks for your expert eye ... and my bad :(

I am using a text field for the date rather than datetime. :( :(

I would never have spotted this in my lifetime.

Thank you very much. Much appreciated.

Regards

Terry

That is strange, is it not?

$thisyear should start from 2020 because the operators being used are "greater than or equal to" therefore if 2020 is in the database, it should start at 2020 but if it is not, then it should start at 2021.

When I write it long-hand (as per below) it works as intended. That is the reason that I posted this query because it's not working in CMSB.

	    <?php include getcwd()."/includes/mysql_cyclones_connect.php";
			$date = DATE('Y');
			$futuredate = DATE('Y') +4;
			$query = "SELECT * FROM names WHERE year >= $date AND year <= $futuredate";
			$result = $con->query($query);
			$row = $result->fetch_assoc();

			$CycloneList = array(); 

			foreach ($result as $row) { 
				$Year = $row['year'];
					if (!array_key_exists($Year, $CycloneList)) { 
						$CycloneList[$Year] = array(); 
					}
				$CycloneList[$Year][] = $row; 
			}
		?>

Regards

Terry

It is meant to show the current year +4 years i.e. 2020 - 2024.

What I do not understand is why this code does not produce that result.

The code below actually shows every record in the database up to 2023 and not 2020-2024.

	$thisyear = DATE('Y');
	$futuredate = DATE('Y') +4;

	list($storm_namesRecords, $storm_namesMetaData) = getRecords(array(
	'tableName'   => 'storm_names',
	'loadUploads' => true,
	'allowSearch' => false,
	'where' => 'storm_year >= "'.$thisyear.'"' and 'storm_year <= "'.$futuredate.'"',
	'orderBy'	=>	'storm_year ASC, storm_name ASC',
	));

I need to display a list of names per year for a four-year period, starting at whatever the current year is. 

I tried the following but this returned every year in the database from 2004 to 2024.

	$thisyear = DATE('Y');
	$futuredate = DATE('Y') +4;

	list($storm_namesRecords, $storm_namesMetaData) = getRecords(array(
	'tableName'   => 'storm_names',
	'loadUploads' => true,
	'allowSearch' => false,
	'where' => 'storm_year >= "'.$date.'"' and 'storm_year <= "'.$futuredate.'"',
	'orderBy'	=>	'storm_year ASC, storm_name ASC',
	));

I then tried the following which returns 2020 - 2023. If I change the 'futuredate' to +5 years, it does the trick but I am wondering what is the correct syntax?

	$thisyear = DATE('Y');
	$futuredate = DATE('Y') +4;

	list($storm_namesRecords, $storm_namesMetaData) = getRecords(array(
	'tableName'   => 'storm_names',
	'loadUploads' => true,
	'allowSearch' => false,
	'where' => "storm_year BETWEEN '$thisyear' AND '$futuredate'",
	'orderBy'	=>	'storm_year ASC, storm_name ASC',
	));

Thanks

Terry

Much appreciated.

Shuffle is cool but it shows all the uploads.

Thanks

Terry

Thanks for your help Zicky.

Why that should affect the CMSB output I have no idea but it works.

Terry

Your CSS does almost the same as mine except that it does not appear inline but as a list. After once I replace part of my original (below) to your CSS it makes it inline.

    .breadcrumb li ul {      display: inline;      margin: 0;      padding: 0;      float: left;    }

HOWEVER, the breadcrumb display generated by  CMSB still appears in reverse order. Clearly the solution has to be in the CSS which I cannot locate so I am wondering whether there is an equivalent to an orderBy where clause to make the breadcrumb appear in the correct sequence.

Thanks

Terry

My breadcrumb is displaying in reverse order when I style it hroizontally. If I left it as an unordered list, it would be correct.

Rather than getting Projects >> 2015-2020 >> City >> Main Square. I am getting Main Square >> City >> 2015-2020 >> Projects.

How do I rectify this? My CMSB code is:

<?php
    $ThisPage = $_SERVER['REQUEST_URI'];
    $NumberOfHyphens = substr_count($ThisPage, "-");
    $ThisPageQueryString = explode("?", $ThisPage);
    if($NumberOfHyphens = 0) {
        $ProjName = $ThisPageQueryString[1];
    } else {
        $ProjName = str_replace("-", " ", $ThisPageQueryString[1]);
    }

  // load record from 'navigation_menu'
  list($navigation_menuRecords, $navigation_menuMetaData) = getRecords(array(
    'tableName'   => 'navigation_menu',
    'limit'       => '1',
    'where'=> 'name="'.$ProjName.'"',
  ));
  $navigation_menuRecord = @$navigation_menuRecords[0]; // get first record

  $CurrentPageNum = $navigation_menuRecord['num'];

  // load records from 'navigation_menu'
  list($navigation_menuRecords, $selectedNavigation_menu) = getCategories(array(
    'tableName'            => 'navigation_menu',
    'categoryFormat'       => 'breadcrumb', 
    'selectedCategoryNum'  => $CurrentPageNum,
  ));
?>

      <ul class="breadcrumb">
        <?php foreach ($navigation_menuRecords 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>

 My CSS is:

    .breadcrumb li ul {
      display: inline;
      margin: 0;
      padding: 0;
      float: left;
    }
    .breadcrumb li {
      list-style-type: none;
    }
    .breadcrumb li ul li {
      padding-right: 10px;
    }
    .breadcrumb li ul li:after {
    content: " > ";
    font-weight: bold;
    font-size: 75%;
    font-family: 'Arial Black';
}

Thanks

Thanks for shedding light on this.

I created a separate section editor and then dumped that into a dropdown list ... but then I had to comb through scores of documents so I quickly dropped the idea. I've settled for duplicating.

Regards

Terry

I need to list PDF documents across multiple pages. Rather than having to upload multiple copies of the same document, is there a way to link to one single document? At the moment, I have an upload field for umlimited number of uploads in each record of a Multi Editor which ideally I would like to keep because it keeps an association with the page.

The only other way I can think of is to create separate upload records database with keywords, so as to filter which documents go on which page according to a unique key ... which then is problematic because I will want to use across more than one page so the filter would not work.

Is there a way to achieve this in CMSB?

Here is an illustration of how it is vs how I would like it to be:

CURRENT SITUATION

• Page 1 - FactoryDrawingZ.pdf
• Page 7 - FactoryDrawingZ_001.pdf
• Page 16 - FactoryDrawingZ_002.pdf

PREFERRED SITUATION

• Page 1 - FactoryDrawingZ.pdf
• Page 7 - FactoryDrawingZ.pdf
• Page 16 - FactoryDrawingZ.pdf

Thanks

Terry

Just above where I've placed this horizontal menu, I want to use the same getRecords array above it to output the "home" URL behind the page logo. I've done this using the first code below which does the trick. However a few lines later I am repeating the array to remove the LIMIT clause in order to populate the complete navigation menu using the second set of code. What I want to confirm is if there are any known problems with with CMSB if I called this the second time?

Thanks

<?php
  // load records from 'navigation_menu'
  list($navigation_menuRecords, $navigation_menuMetaData) = getRecords(array(
    'tableName'   => 'navigation_menu',
    'limit'       => '1',
    'loadUploads' => true,
    'allowSearch' => false,
  ));
?>

    <div class="box2">
        <div class="container"> 
        <?php foreach ($home_pageRecord['logo'] as $index => $upload): ?>
            <h1 class="navbar-brand navbar-brand_"><?php foreach ($navigation_menuRecords as $record): ?><a href="<?php echo htmlencode($record['url']) ?>"><?php endforeach ?><img src="<?php echo htmlencode($upload['urlPath']) ?>" alt="<?php echo htmlencode($upload['info1']) ?>"><span><?php echo htmlencode($upload['info1']) ?></span></a></h1>
        <?php endforeach ?>
        </div>
    </div>

  <?php
  // load records from 'navigation_menu'
  list($navigation_menuRecords, $selectedNavigation_menu) = getCategories(array(
    'tableName'            => 'navigation_menu', //
    'categoryFormat'       => 'showall',  // showall, onelevel, twolevel, breadcrumb
    'defaultCategory'      => 'first',    // Enter 'first', a category number, or leave blank '' for none
    'ulAttributes'         => 'class="submenu"',      // add html attributes to <ul> tags, eg: 'class="menuUL"' would output <ul class="menuUL">
    'liAttributesCallback' => 'customMenuLIAttr',      // ADVANCED: custom function to return li attributes, eg: 'myLiAttr' and function myLiAttr($category) { return "id='li_uniqueId_{$category['num']}'"; }
  ));
  function customMenuLIAttr($category) {
    global $GLOBALS;
    return ($category['_hasChild'])? " class=\"active sub-menu\"" : "" ;
  }
  ?>

    <div class="menuBox">  
        <div class="container"> 
            <nav class="navbar navbar-default navbar-static-top tm_navbar clearfix" role="navigation">
                <ul class="nav sf-menu clearfix">
                <?php foreach ($navigation_menuRecords as $categoryRecord): ?>
                  <?php echo $categoryRecord['_listItemStart'] ?>
                  <?php if($categoryRecord['_hasChild'] && $categoryRecord['depth'] == '0'): ?>
                    <b><a href="<?php echo $categoryRecord['url'] ?>"><?php echo $categoryRecord['name'] ?></a></b><span></span>
                  <?php elseif($categoryRecord['_hasChild'] && $categoryRecord['depth'] > '0'): ?>
                    <b><a href="<?php echo $categoryRecord['url'] ?>"><?php echo $categoryRecord['name'] ?><span></span></a></b>
                <?php else: ?>
                    <b><a href="<?php echo $categoryRecord['url'] ?>"><?php echo $categoryRecord['name'] ?></a></b>
                  <?php endif ?>
                  <?php echo $categoryRecord['_listItemEnd'] ?>
                <?php endforeach; ?>
              </ul>
        </div>
    </div


I got this sorted last night and here is how I achieved it ... first by using two of the advanced options to insert classes into the nested <ul> tags and into the <li> tags which have submenu items.

 // load records from 'navigation_menu'
  list($navigation_menuRecords, $selectedNavigation_menu) = getCategories(array(
    'tableName'            => 'navigation_menu', //
    'categoryFormat'       => 'showall',  // showall, onelevel, twolevel, breadcrumb
    'defaultCategory'      => 'first',    // Enter 'first', a category number, or leave blank '' for none
    
    // advanced options (you can safely ignore these)
    'ulAttributes'         => 'class="submenu"',      // add html attributes to <ul> tags, eg: 'class="menuUL"' would output <ul class="menuUL">
    'liAttributesCallback' => 'customMenuLIAttr',      // ADVANCED: custom function to return li attributes, eg: 'myLiAttr' and function myLiAttr($category) { return "id='li_uniqueId_{$category['num']}'"; }
  ));

  function customMenuLIAttr($category) {
    global $GLOBALS;
    return ($category['_hasChild'])? " class=\"active sub-menu\"" : "" ;
  }

This is how the code looked when the classes were inserted into the <ul> and <li> tags. The remaining thing to achieve is the placement of the <span></span> tags.

<ul class="nav sf-menu clearfix"> // this is hardcoded in
 <li class="active sub-menu"><a href="#">Home</a><span></span> // class inserted by the CMSB getCategories function:: 'liAttributesCallback' => 'customMenuLIAttr',
  <ul class="submenu"> // class inserted by the CMSB getCategories function:: 'ulAttributes'=>'class="submenu"',
    <li><a href="#">Lorem ipsum dolor sit<span></span></a>
     <ul class="submenu"> // class inserted by the CMSB getCategories function:: 'ulAttributes'=>'class="submenu"',
      <li><a href="#">Lorem ipsum dolor sit</a></li>
      <li><a href="#">Conse ctetur adipisicing</a></li>
      <li><a href="#">Elit sed do eiusmod tempor</a></li>
      <li><a href="#">Incididunt ut labore</a></li>
      <li><a href="#">Et dolore magna aliqua</a></li>
     </ul>  
    </li>
    <li><a href="#">Conse ctetur adipisicing</a></li>
    <li><a href="#">Elit sed do eiusmod tempor</a></li>
    <li><a href="#">Incididunt ut labore</a></li>
    <li><a href="#">Et dolore magna aliqua</a></li>
   </ul>
  </li>
  <li><a href="#">About</a></li>
  <li><a href="#">Blog</a></li>
  <li><a href="#">Gallery</a></li>
  <li><a href="#">Contacts</a></li>
</ul>

The <span></span> tags is then controlled by CSS to insert a triangle pointing down or to the right to indicate that the menu was either a dropdown or expandable horizontally. For the dropdown menu it is to be inserted after the anchor tag is closed i.e. <a href="#">XX</a><span></span>. While for the horizontal expansion it must occur before the anchor tag closes i.e. <a href="#">YY<span></span></a>. To achieve this, I used conditional statements to determine the category depth and specify where to place the span tags.

<ul class="nav sf-menu clearfix">
<?php foreach ($navigation_menuRecords as $categoryRecord): ?>
  <?php echo $categoryRecord['_listItemStart'] ?>
  <?php if($categoryRecord['_hasChild'] && $categoryRecord['depth'] == '0'): ?>
    <b><a href="<?php echo $categoryRecord['url'] ?>"><?php echo $categoryRecord['name'] ?></a></b><span></span>
  <?php elseif($categoryRecord['_hasChild'] && $categoryRecord['depth'] > '0'): ?>
    <b><a href="<?php echo $categoryRecord['url'] ?>"><?php echo $categoryRecord['name'] ?><span></span></a></b>
<?php else: ?>
    <b><a href="<?php echo $categoryRecord['url'] ?>"><?php echo $categoryRecord['name'] ?></a></b>
  <?php endif ?>
  <?php echo $categoryRecord['_listItemEnd'] ?>
<?php endforeach; ?>
</ul>

This has taken me six days to figure out costing me a delay I could not afford.

Me thinks that had I gotten expert help from the authors of CMSB, this would have been solved a long time ago. Perhaps there is a new support policy that I have not read?

Terry

I appreciate your assistance. I will experiment with this and let you know.

Regards

Terry

Thanks for your response. I will check this out - though I am using JQuery on the page to do similar things.

I always have problems with the Category Menu classes and there seems to be no instructions on them. I may switch to a multi menu editor and accomplish it that way.

Thanks again for your response.

Terry

I need to add the following classes highligted in red to a CMSB generated category menu when the level 1 item has a child and span tags when the item irrespective of level has a children/children. How do I accomplish this?

                <ul class="nav sf-menu clearfix">
                    <li class="active sub-menu"><a href="index.html">Home</a><span></span>
                        <ul class="submenu">
                            <li><a href="#">Lorem ipsum dolor sit<span></span></a>
                              <ul class="submenu">
                                    <li><a href="#">Lorem ipsum dolor sit</a></li>
                                    <li><a href="#">Conse ctetur adipisicing</a></li>
                                    <li><a href="#">Elit sed do eiusmod tempor</a></li>
                                    <li><a href="#">Incididunt ut labore</a></li>
                                    <li><a href="#">Et dolore magna aliqua</a></li>
                              </ul>  
                            </li>
                            <li><a href="#">Conse ctetur adipisicing</a></li>
                            <li><a href="#">Elit sed do eiusmod tempor</a></li>
                            <li><a href="#">Incididunt ut labore</a></li>
                            <li><a href="#">Et dolore magna aliqua</a></li>
                        </ul>
                    </li>
                    <li><a href="index-1.html">About</a></li>
                    <li><a href="index-2.html">Blog</a></li>
                    <li><a href="index-3.html">Gallery</a></li>
                    <li><a href="index-4.html">Contacts</a></li>
                </ul>


  // load records from 'navigation_menu'
  list($navigation_menuRecords, $selectedNavigation_menu) = getCategories(array(
    'tableName'            => 'navigation_menu', //
    'categoryFormat'       => 'showall',  // showall, onelevel, twolevel, breadcrumb
    'defaultCategory'      => 'first',    // Enter 'first', a category number, or leave blank '' for none
    
    // advanced options (you can safely ignore these)
    'rootCategoryNum'      => '',      // Only categories _below_ this one will be shown (defaults to blank or 0 for all)
    'ulAttributes'         => 'class="submenu"',      // add html attributes to <ul> tags, eg: 'class="menuUL"' would output <ul class="menuUL">
    'selectedCategoryNum'  => '',      // this record number is returned as the "selected category", defaults to getLastNumberInUrl()
    'ulAttributesCallback' => '',      // ADVANCED: custom function to return ul attributes, eg: 'myUlAttr' and function myUlAttr($category) { return "id='ul_uniqueId_{$category['num']}'"; }
    'liAttributesCallback' => '',      // ADVANCED: custom function to return li attributes, eg: 'myLiAttr' and function myLiAttr($category) { return "id='li_uniqueId_{$category['num']}'"; }
    'loadCreatedBy'        => false,   // loads createdBy.* fields for user who created category record (false is faster)
    'loadUploads'          => true,    // loads upload fields, eg: $category['photos'] gets defined with array of uploads (false is faster)
    'ignoreHidden'         => false,   // false = hide records with 'hidden' flag set, true = ignore status of hidden flag when loading records
    'debugSql'             => false,   // display the MySQL query being used to load records (for debugging)
  ));

Thanks

Terry

Thanks for taking the time to respond.

If you were to remove the PHP code, the HTML code that remains is correct:

<a href=""></a>

Having not found a solution in the last week since posting this, I've altered the design on the page template and removed this horizontal menu.

Regards

Terry

I am running a horizontal navigation menu at the top of my page and then another in the footer. The top navigation menu is using "showall" as the categoryFormat while the footer menu is using "onelevel". I am using the same table (navigation_menu) for both menus.

In the viewer URL of one section, the footer menu is behaving schizophrenically. For records 1, 4, 5, 6 it does a "showall" in the footer but for the other records it does a "onelevel" display. The code I am using for the footer navigation menu is below. Can you tell me why it sometimes displays all records and sometimes only one level?

<?php
  // load records from 'navigation_menu'
  list($navigation_menuRecords, $selectedNavigation_menu) = getCategories(array(
    'tableName'            => 'navigation_menu',
    'categoryFormat'       => 'onelevel', 
    'defaultCategory'      => '',
    
    // advanced options (you can safely ignore these)
    'rootCategoryNum'      => '',     
    'ulAttributes'         => '',     
    'selectedCategoryNum'  => '',     
    'ulAttributesCallback' => '',     
    'liAttributesCallback' => '',     
    'loadCreatedBy'        => false,  
    'loadUploads'          => true,   
    'ignoreHidden'         => false,  
    'debugSql'             => false,  
  ));
?>

<?php foreach ($navigation_menuRecords as $categoryRecord): ?>
    <?php if ($categoryRecord['target']) {
        $target = 'target="';
        $target .= $categoryRecord['target'];
        $target .= '"';
    } else {$target="";}
    ?>
  <?php echo $categoryRecord['_listItemStart'] ?>
    <a href="<?php echo $categoryRecord['page_url'] ?>" <?php echo $target;?>><?php echo $categoryRecord['name'] ?></a>
  <?php echo $categoryRecord['_listItemEnd'] ?>
<?php endforeach; ?>

Thanks

Terry

Scrutinising my code again I see that was 'missing' from the on which worked.

Regards

Terry

Now my HTML tags are showing up on the web page. I deleted those sections created new WYSYWYGS and re-entered the data and there is no change.

See attached the screenshot.

How do I mend this broken WYSYWYG?

Thanks

Terry

Thanks for your response. I see that while the WHERE clause is no longer part of the code generator it can still be added back as per the older version. Good news!

Looking at it some more, I thought that using the WHERE clause was not the most efficient method because in the event that I added another course then I could need that hardcode that into the template and FTP it to the server, so I used an associative array to group the courses instead and that works much better and is a one-stop shop. For reference, in the event that anyone else is looking for a similar solution, here is what I did:

First create the associative array:

          $ValMeals = array(); 

          foreach ($valentines_dayRecords as $meal) { 
            $ValCourse = $meal['course']; 

            if (!array_key_exists($ValCourse, $ValMeals)) { 
             $ValMeals[$ValCourse] = array(); 
            } 

            $ValMeals[$ValCourse][] = $meal; 
          } 


Then loop through it:

    <?php foreach ($ValMeals as $courses => $meals): ?>
    <h4><?php echo $courses; ?></h4>
    <?php foreach ($meals as $meal): ?> 
      <div class="name-wrap">
          <div class="box">
              <h6 class="box_aside"><?php echo htmlencode($meal['name_of_dish']) ?></h6>
              <span class="box_right"></span>
          </div>
          <p class="brd"><?php echo htmlencode($meal['description']) ?></p>
      </div>
        <?php endforeach ?> 
        <br><br>
      <?php endforeach ?>

The output was the following with one set of code rather than having to repeat the code for each course, if I were using the WHERE clause.

    STARTERS
    Soup of the Day (v)
    Smoked Salmon and Prawn Cocktail
    Ham Hock Terrine, Apple Relish and Toast
    Baked Camembert

    MAIN
    7oz Ribeye Steak
    Baked Chicken Breast
    Roast Monkfish
    Gnocchi

    DESSERT
    Chocolate Pot and Dipping Fruit
    Sticky Toffee Pudding with Vanilla Ice-cream
    Passion Fruit Pannacotta
    Cheeseboard

Best regards

Terry

I can't find a way in the code generator for a WHERE statement ... so, can you tell me how I might group stuff? I am running a food menu categorised as Starters, Mains, Desserts. I want to achieve the following grouping for all three courses which previously I would have used a WHERE statement:

COURSE (e.g. Starts, Mains or Desserts)

Item

Item

Item

The cumbersome way I am doing it, is to hard code the Course name first and then use:

<h4>Starters</h4>
<?php if ($record['course']=="Starters"): ?>
    <div class="name-wrap">
        <div class="box">
            <h6 class="box_aside"><?php echo htmlencode($record['name_of_dish']) ?></h6>
            <span class="box_right"></span>
        </div>
        <p class="brd"><?php if($record['description']):?><?php echo htmlencode($record['description']) ?><?php endif; ?></p>
    </div>
<?php endif; ?>


Thanks

Terry

That's a brilliant piece of programming in CMSB. Makes life so much easier.

This solution works well.

Thanks

Terry