Re: [Jason] How to alternate banners with each pageload using 1x upload field

Thu, 14 Apr 2011 12:27:08 -0700

Hey Jason,

I found this discussion about banner ads and thought I would continue it for our company’s purpose and to expand the topic for anyone that is exploring banner functionality within their website.

This is What We Want to Accomplish:[
-------------------------------------------------------------
Background) We have a client with various product listing pages, each of which has a pagination of 6 to 10 pages.

Goal) To provide 10 different advertising banners (jpegs) per listing page view per pagination click.

Example) Our client has say 70 advertisers for this one particular product listing page. There are a total of 7 paginations clicks (meaning seven different page views for this one product listing category just to be clear). We would like to group ten different RANDOM banners per pagination page. YET, not have a banner advertisement repeat itself throughout the 7 paginations views. Each group of ten banner images will hold a different set of images.

We understand how to pull out the advertisements banners per listing page using Where and Random statements. However, we are not sure how to “group ten random banners” per listing page and “rotate a new group of ten banner images that differ” then the pagination click previously displayed.

We suspect a multidimensional array is required to create the groups of ten then some sort of session variable will be needed to display one group at a time per pagination page view. Then this could loop through and continue per pagination click finally exhausting the full list of advertisers (70 in the case example) and repeat for that listing page.

How difficult is this this type of array to create and combine it with the session variable?

Any light you can shine on this greatly appreciated!

studio-a

Re: [chris] Ordering by Multiple Value Lists

Fri, 17 Dec 2010 09:22:23 -0800

Hi Chris,

Thanks for your input and time. We will create a test page removing all of the Code Jason recommended and try this new code.

For the sake of this tutorial thread, it appears your approach is completely different than the code Jason began the thread topic with, is this correct?

Based on your code, the direction for this solution would be to create a special MySQL query when pulling the records (hence grouping the items which have the same category). Whereas, Jason's method was to use arrays within the PHP to group the items with the same category, is this correct?

We will let you know our efforts with implementing the code and to assist the thread's topic.

Thanks again for your help. You guys really do supply great support!

studio-a

Re: [chris] Ordering by Multiple Value Lists

Wed, 15 Dec 2010 19:32:23 -0800

Hi Chris,

Your example is correct. Any help is greatly appreciated!

Thanks,

studio-a

Re: [Jason] Ordering by Multiple Value Lists

Wed, 15 Dec 2010 14:59:34 -0800

Hi Jason,

Thanks for your input. We read your feedback and it's slightly more than what our client is thinking.

They would like each Category (group) NOT to be split between separated pages. Currently we are limiting the number of listed attractions, but happens is the Category (group) sometimes is divided into two separate pagination (half of the Category (group) on one page an the other half on another page), just the opposite what the client likes.

So we are trying to figure out how to keep a Category (Group) from being divided into two pages. We tried using the limited 'perPage' MySQL query but that does not work. The amount of attractions within a Category (group) will not be limited ONLY the Groups per page.

Does this clarify the functionality we are seeking? We look forward to your feedback.

Thanks,

studio-a

Re: [Jason] Ordering by Multiple Value Lists

Tue, 14 Dec 2010 12:33:21 -0800

Hi Jason,

Thanks again for your help. We do have an additional question. Currently we are limiting the number of attractions listing per page. However, sometimes the pagination breaks one Group into two pages. Below is the code we're using.

	  list($local_attractionsRecords, $local_attractionsMetaData) = getRecords(array(
		'tableName'   => 'local_attractions',
		'perPage'     => '15',
	  ));

We have tried to limit the number of Groups per page in the same manner above, but it losses the pagination links.

We're pretty sure the arrays contribute in some form of matter and we cannot figure out how to limit the number of Groups per page.

If you can shine some light on this additional feature we would appreciate it.

thanks,

studio-a

Re: [Jason] Ordering by Multiple Value Lists

Mon, 13 Dec 2010 16:57:47 -0800

Hi Jason,

Your help is greatly appreciated, but we are not seeing the Group Description or thumbnail for each Group. No errors message either, odd?

We're thinking since we change to the code from your last posting help, perhaps there are more changes within this section of code too? Below is the lines of code for the description and images.

UPDATE: Problem Solved!
-----------------------------------------------------------
After reviewing Jason's code and the CMS Admin it turns out we needed to "change" the Field for the Option Values within the
attractions_categories table FROM "num" TO the field we named "title."

See the attached jpeg for CMS screenshot.

-----------------------------------------------------------

Between the arrays and referencing the two tables things can get a bit confusing for us. Nonetheless, Interactive Tools pulls through and helps us find the solution. Thanks Jason.

You guys rock!

studio-a

Re: [Jason] Ordering by Multiple Value Lists

Mon, 13 Dec 2010 15:40:05 -0800

Hi Jason,

Thanks for the input. Since we are referencing two tables we're not sure which field is correct. Below is the code for all the arrays AND Attached is the CMS cpanel for both tables.

  $categoryNumToRecord=array(); 
  foreach($attractions_categoriesRecords as $categoryRecord){ 
    $categoryNumToRecord[$categoryRecord['num']]=$categoryRecord; 
  }
  
  $orderedGroups=array(); 
   foreach($local_attractionsRecords as $attraction){ 
    $groups = trim($attraction['category'],"\t"); 
       
    if($groups){ //record has groups 
      $groups = explode("\t",$groups); 
          
      foreach($groups as $group){ 
        $orderedGroups[$group][]=$attraction; 
      } 
    } 
    else{ //record has no group 
      $orderedGroups['No Group'][]=$attraction; 
    } 
  }

Can you let us know the correct field you are suggesting.

Thanks,

studio-a

Re: [Jason] Ordering by Multiple Value Lists

Mon, 13 Dec 2010 15:12:35 -0800

Hey Jason,

Thanks for getting back to us. We removed the line for the single record as you mentioned, placed the array you wrote and added the line for

However, we're now getting errors Listed below:

Notice: Undefined index: SeaWorld(R) & Busch Gardens in /pages/attractionsTEST.php on line 127
Warning: Invalid argument supplied for foreach() in /pages/attractionsTEST.php on line 128

The code in reference is Listed below:

Line 127           
Line 128

We appreciate your help and love to work through this problem.

Thanks,

studio-a

Re: [chris] Ordering by Multiple Value Lists

Sat, 11 Dec 2010 22:41:27 -0800

Hi Chris,

Thanks for asking. Below is the code we have been working on. The Group Title and List of Items work fine,
the problem is that we cannot figure out is how to include a Thumbnail Image for the Group Title along with
a Desciption for each Group.

What is happening - the same "thumbnail" and the same "description" is displayed for each Group Title
rather than having a separate image and description for each Group.

We suspect another array is needed?

  list($local_attractionsRecords, local_attractionsMetaData) =getRecords(array( 
    'tableName'   => 'attractions',
	'perPage'     => '10',
      )); 
  
  list($attractions_categoriesRecords, $attractions_categoriesMetaData) = getRecords(array(
    'tableName'   => 'attractions_categories',  
      )); 
   $attractions_categories = @$attractions_categoriesRecords[0]; // get first record

?>


  $orderedGroups=array(); 
   foreach($local_attractionsRecords as $attractions){ 
    $groups = trim($attractions['category'],"\t"); 
       
    if($groups){ //record has groups 
      $groups = explode("\t",$groups); 
          
      foreach($groups as $group){ 
        $orderedGroups[$group][]=$attraction; 
      } 
    } 
    else{ //record has no group 
      $orderedGroups['No Group'][]=$attraction; 
    } 
  } 
?>

 
                        
 $group): ?>

				
				  
					" width="" height="" align="left" alt="alt tag goes here"  />
				  
					" width="" height="" align="left" border="0" alt=""/>

Thanks for your help. We always appreciate your feedback!

studio-a

Re: [InHouse] Ordering by Multiple Value Lists

Fri, 10 Dec 2010 13:51:51 -0800

Hello,

This thread has been very helpful. However, say if we have a field for the Group Description. This description field is located in the table 'new_category' - How do we include this within the arrays to work properly? It looks simple, yet we cannot get it to work.

For example the output would look something like this:
----------------------------------------------------------------------

Group Title 01 Placement Goes Here
Description: Text will be placed here and continue erat et tristique viverra, turpis purus tincidunt lacus, nec condimentum nisl neque sit amet augue. Ut tellus arcu, tempor ultrices.

- list item for group 01
- list item for group 01
- list item for group 01
- list item for group 01

Group Title 02 Placement Goes Here
Description: Text will be placed here and continue erat et tristique viverra, turpis purus tincidunt lacus, nec condimentum nisl neque sit amet augue. Ut tellus arcu, tempor ultrices.

- list item for group 02
- list item for group 02
- list item for group 02
- list item for group 02
----------------------------------------------------------------------

We look forward to your feedback!

studio-a

Membership Login - Member Report

Tue, 19 Oct 2010 10:42:37 -0700

Hello,

We purchased the Membership Login Plug-in some time ago and we are finally using it on paid project. Our client wanted to know if we can setup a report system to display the login dates for each user. This would be as simple as a page with a list of the user member names (records) and then being able to click the name to link into a detail page which shows the list of dates the member logged in (perhaps even the sever time?).

Has anyone considered this and can provide advice on the setup?

Thanks,

studio-a

Re: [Djulia] Notice: CMSB Upcoming Features and Development Plan

Tue, 14 Sep 2010 15:46:16 -0700

Hello,

Djulia, you read our minds! In fact, I just signed in to find a solution for this EXACT feature. No kidding. We have a client which is a rental home business and we need to include over 30 amenities (check boxes) which will add length to the admin page - makes the page look generic.

I may look into the forum for a solution, even if we had to go into the php that’s fine, but this feature will be a nice improvement!

We really like this application and we’ve been building clients’ websites with CMS Builder since version v1.34 Great work guys!

Thanks

studio-a

Re: [Jason] where filter that uses a field name?

Thu, 24 Jun 2010 19:26:13 -0700

Hi Jason,

We sent you the ftp and cms login info you requested, but we understand things get busy. Attached is the serviceListTest.php file we have been testing using the code you recommended. As we mentioned, the Category Name along with its Summary are displayed when using the URL format (listed below) and your suggested code. However, no Service Titles show up?

For Example: www.mydomain.com/pages/serviceListTest.php?category=Cat Name Here

If anyone can help us we appreciate your time.

Thanks,

studio-a

Re: [Jason] where filter that uses a field name?

Thu, 24 Jun 2010 06:50:13 -0700

Hi Jason,

Thanks so much for your help!

We have implemented the code using within the URL and ONLY the category_name For Example: www.mydomain.com/pages/serviceList.php?category=Cat Name Here

We see the Category Name and its Summary, but the Service Titles and Descriptions are not showing up. We received the standard message (No records were found.) Any idea why? Attached is the serviceListTest.php file. We have commented out various includes in case that was causing complications, but we still do not see the Service Titles and Service Descriptions.

Thanks again for your work and helping us find a solution!

studio-a

Re: [Jason] $selectedCategory and Pagination conflict?

Mon, 21 Jun 2010 12:56:19 -0700

Hi Jason,

We resent you the email.

Looking forward to your reply!

studio-a

Re: [Jason] where filter that uses a field name?

Mon, 21 Jun 2010 12:34:09 -0700

Hi Jason,

Jason asked: Do you want to display all service_categories records? Or just one that has been selected?
studio-a answer: Just the one selected and link with the services titles. Page output display is written below.

PAGE DISPLAY BELOW.
------------------------------------------------------
category_name
summary

service_title
description

service_title
description

service_title
description

<< pagination >>

Jason asked: How are you associating a service_title record with a category?
studio-a answer: We are associating the service titles with the service categories via the drop down list referencing another table (see Admin Set Listed Below AND attached jpg).

ADMIN SETUP BELOW.
------------------------------------------------------
table 01 = service_categories
textfield within this table = category_name
textbox within this table = summary

table 02 = service_titles
droplist within this table = category (this is being dynamically populated from table 01 textfield category_name - see attached image for cross table setup)
textfield within this table = service_title
textbox within this table = description

Looking forward to your help.

studio-a

P.S. We have the page working, but the pagination is now causing a problem. See other post at: http://www.interactivetools.com/forum/gforum.cgi?post=81347#81347

Re: [Jason] $selectedCategory and Pagination conflict?

Mon, 21 Jun 2010 12:11:11 -0700

Hi Jason,

We emailed you the actual link. We mistakenly called you chris, he also replied to another post. Sorry about.

We look forward to your feedback.

studio-a

Re: [chris] $selectedCategory and Pagination conflict?

Sun, 20 Jun 2010 14:08:53 -0700

Hello,

We are experiencing the same problem with including the category number within the URL and then trying to use the pagination. We have tried the solution Dave wrote - placing the "&lastNum=0" at the end of nexp/prev links, but this has not helped. In fact, with Dave’s recommendation in place and when the “next” link is clicked we receive an HTTP 404 Not Found error. The example URL is displayed below.

http://www.mydomain.com/pages/list.test.php?service_categories=5&page=2&lastNum=0

We are using CMS Builder v2.04. Why would we get a 404 error? If we remove the “&lastNum=0” the page displays, but with the wrong category content (category 2 is display when it should be category 5). Are we missing some additional code within the php file?

Attached is our sample file. You’ll note a list section is commented out, that’s another complication with an additional table. One thing at a time, pagination first.

Any help in getting our page to work with proper pagination is appreciated!

Thanks,

studio-a

Re: [chris] where filter that uses a field name?

Fri, 18 Jun 2010 21:29:30 -0700

Hi Chris,

Thanks for getting back with us. We have uploaded the php file for the test listing page. You will note a variety of php lines of code rendered out.

We are interested in using the URL with the category number and name with the SEO/readability.

BELOW IS OUR SETUP.

table 01 = service_categories
textfield within this table = category_name
textbox within this table = summary

table 02 = service_titles
droplist within this table = category (this is being dynamically populated from table 01 textfield category_name)
textfield within this table = service_title
textbox within this table = description

Our objective is to create List Pages for EACH Service Category while displaying the category_name and summary at the top of each page followed by the list of service_titles and descriptions associated with the dynamically created category_name(s) grouping. In addition, we will need to include the page links.

As you can see within the php test page we have the information for the page created, we're just not sure how to query the database since we are using two tables. Let me ask, "Using two tables for this dynamic menu setup - is this a good strategy? Is there a better way to offer the client a dynamic way of creating interactive menus?"

Thanks for your help and time. We look forward to hearing your reply!

studio-a

Re: [Perchpole] Categories and Subcategories

Fri, 18 Jun 2010 17:19:36 -0700

Hello,

We have been reading this thread and it has the content of information we are seeking, but it’s not been clarified. IF someone can fill in the missing pieces we sure would appreciate your help.

What’s missing are just a few elements from Dave and Perchole comments. For example, the comment Perchole made in his Step 5 using the code below appears as if we know the our category name (YOURCATEGORY). We thought the idea was to allow One Table to Dynamically populate the other Table’s particular field and then to list all the records in the second table accordly with the dynamically populated field. Are we reading the intentions for this thread correctly?

'where' => "category = 'YOURCATEGORY'",

The other information missing is the PHP code from Carrie so that’s a bit confusing too. Dave did bring to comment more code for the where statement, but how do we actually use it?

'where' => " parentCategory = '" .getNumberFromEndOfUrl() . "'",

BELOW IS OUR SETUP.

table 01 = service_categories
textfield within this table = category_name

table 02 = service_titles
droplist within this table = category (this is being dynamically populated from table 01 textfield category_name)
textfield within this table = service_title
textbox within this table = description

Our objective is to create List Pages for EACH Service Category while displaying the service_titles and descriptions associated with the dynamically created category_name(s) filtering.

Anyone who can help please do. We look forward to hearing from you.

Thanks for your time!

studio-a

Re: [ryan_dot] where filter that uses a field name?

Fri, 18 Jun 2010 14:13:26 -0700

Hello,

I have been reading this thread and I think it has the solution we need, but I am not sure. If I understand correctly, this is the case:

Some of the names and titles have been changed for communication purposes.
Category = plant_training_services
Course = courses

-----------------------------------------------------------------------------------------------------------------------
01. There are TWO tables: (1) Category and the other (2) Course
02. Inside of the Courses Table is a dropdown menu which is populated by the other table’s (Category) field titled “catergory_name”
03. The Courses need to be sorted by the associated Category field in the List View page.
04. Is this Correct? If so, this is EXACTLY what we are trying to accomplish. However, filtering the Courses with Category is not working for us. We must be doing something wrong.

Is the code below setting up a way for the “where” statement to filter the Category Table's field with the Course list (the Courses per Category)?

$escapedSection = mysql_real_escape_string( @$plant_training_servicesRecord['section'] );

We have tried to use the URL filter as written below, but since the category_name is from another table it does not work. Is this correct?

listPage.php?catergory_name=catNameGoesHere

Any help is appreciated!

studio-a

P.S.
Jason assisted us in another matter for this same project at http://www.interactivetools.com/iforum/P81157#81157 if anyone is interested in reading additional information using two tables stucture. Now, IF we can only filter the listing!?

Re: [Jason] Filtering one most recent record per category

Tue, 08 Jun 2010 15:45:56 -0700

You Guys Rock!

When we created the navigation we didn’t realize the snags while listing of Services and Categories menu, but Jason you solved our problem! Reading your code helps us improve our entry level of php skills too.

Everyone here has always been very helpful and we cannot say thank you enough. CMS Builder fits our company’s needs and we continue to sell it every chance we can. You guys take suggestions and make this product even better. We have a good majority of the plug-ins and look forward to new features for the upgrades. Interactive Tools is simply good business!

Thanks again for your help!

studio-a

Re: [Jason] Filtering one most recent record per category

Tue, 08 Jun 2010 15:04:50 -0700

Hi Jason,

Thanks for asking. We will need to limit the number of Service Titles per category.

Your help is greatly appreciate!

studio-a

Re: [Jason] Filtering one most recent record per category

Tue, 08 Jun 2010 14:13:46 -0700

Hi Jason,

Thanks for the help, setting things up in an array works perfectly! Although, there is ONE thing that we’re not sure how to handle.

We thought we could control how many Service Titles will be displayed by using the “limit” tag within the query ( 'limit' => '8', ) but this limits the Services Titles AND the Service Categories? We absolutely need to limit the number of Service Titles that are displayed.

Attached is the php file (note: we are using this as an include)

Thanks again for your assistance!

studio-a

Re: [Jason] Filtering one most recent record per category

Tue, 08 Jun 2010 12:09:43 -0700

Hi Jason,

You are correct regarding the "category field that comes from another table in the database" but not exactly about our objective.

We are trying to generate a list of Service Categories names followed with a list of Service Title names. There is a total of five (5) Service Categories and unlimited number of Service Title names.

Within the CMS we have a table for Categories and a table for Services. We have a required field with as a drop down list which is populated by the Service Categories table. This is how we thought to associate the Service Titles with the Service Categories. The client needs both of these to be dynamic.

Below is a visual for the text display version and there is an attached image for CSS the layout. Keep in mind, the Service Titles will be associated to only one (1) Service Category and do NOT have to be in any order.

Service Categories 01
Service Title (A)
Service Title (B)
Service Title (F)

Service Categories 02
Service Title (E)
Service Title (C)
Service Title (H)

Service Categories 03
Service Title (G)
Service Title (D)
Service Title (I)

We look forward to your help!

studio-a