<?xml version="1.0" encoding="UTF-8"?>    <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
      <channel>
        <title></title>
        <link>https://interactivetools.com/forum/forum-search.php?k=user%3Awillydoit</link>
        <description></description>
        <pubDate>Wed, 13 May 2026 14:45:48 -0700</pubDate>
        <language>en-us</language>
        <atom:link href="https://interactivetools.com/forum/forum-search.php?k=user%3Awillydoit&amp;rss=1" rel="self" type="application/rss+xml" />

                <item>
          <title>facebook share widget issue with dynamic pages</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2243230#post2243230</link>
          <description><![CDATA[<p>Thanks Daniel, that did the trick</p>]]></description>
          <pubDate>Thu, 28 Mar 2019 03:35:32 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2243230#post2243230</guid>
        </item>
                <item>
          <title>facebook share widget issue with dynamic pages</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2243227#post2243227</link>
          <description><![CDATA[<p>Hi all,</p>
<p>I am wanting to add a facebook like and share buttons widget to my pages.  The required code provided by facebook is</p>
<pre class="language-markup"><code>&lt;div id="fb-root"&gt;&lt;/div&gt;
 
&lt;script async defer crossorigin="anonymous" src="<a href="https://connect.facebook.net/en_GB/sdk.js#xfbml=1&amp;version=v3.2" rel="nofollow">https://connect.facebook.net/en_GB/sdk.js#xfbml=1&amp;version=v3.2</a>"&gt;&lt;/script&gt;
&lt;div class="fb-like" data-href="<a href="https://bridlington.net" rel="nofollow">https://bridlington.net</a>" data-layout="button" data-action="like" data-size="large" data-show-faces="true" data-share="true"&gt;&lt;/div&gt;</code></pre>
<p>The above code works fine however and produces the link</p>
<pre class="language-markup"><code><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fbridlington.net%2F&amp;display=popup&amp;ref=plugin&amp;src=like&amp;kid_directed_site=0" rel="nofollow">https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fbridlington.net%2F&amp;display=popup&amp;ref=plugin&amp;src=like&amp;kid_directed_site=0</a></code></pre>
<p>I would like to add this code to dynamically created pages which would mean that data-href value needs to be a variable containing the page url.</p>
<p>I assumed that replacing the static url with</p>
<pre class="language-markup"><code>&lt;?php echo urlencode(thisPageUrl()) ?&gt;</code></pre>
<p>would do the trick but when the share button is pressed having replaced the static url with the above code I get a 404 error and the link produced looks like this</p>
<pre class="language-markup"><code><a href="https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fbridlington.net%2Fhttps%253A%252F%252Fbridlington.net%252Findex.php&amp;display=popup&amp;ref=plugin&amp;src=like&amp;kid_directed_site=0" rel="nofollow">https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fbridlington.net%2Fhttps%253A%252F%252Fbridlington.net%252Findex.php&amp;display=popup&amp;ref=plugin&amp;src=like&amp;kid_directed_site=0</a></code></pre>
<p>It looks like the domain value is being screwed up but I cannot understand why as using the same urlencode code to create a direct link in the "tell a friend" email facility works fine. If I just use the code to display the value on a page it displays the URL as</p>
<pre class="language-markup"><code>https%3A%2F%2Fbridlington.net%2Findex.php</code></pre>
<p>and is not displaying the url values of : and / which I am assuming is the issue</p>
<p>Does anyone know how I can generate a variable I can use that will produce the url in a way that it will display with the : and // instead of %3A and %2F to work with the facebook code.</p>
<p>Thanks in advance for any help provided.</p>]]></description>
          <pubDate>Wed, 27 Mar 2019 05:53:27 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2243227#post2243227</guid>
        </item>
                <item>
          <title>image facilities in tinycme</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2243006#post2243006</link>
          <description><![CDATA[<p>Thanks Daniel,</p>
<p>that worked a treat, I can only think that I had my syntax wrong somewhere, now I have a working version I should be able to build on that for other items.</p>
<p>Thanks again for your help.</p>

<p>Steve</p>]]></description>
          <pubDate>Fri, 08 Feb 2019 01:26:59 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2243006#post2243006</guid>
        </item>
                <item>
          <title>image facilities in tinycme</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2243002#post2243002</link>
          <description><![CDATA[<p>Hi Daniel,</p>
<p>The code I provided works fine, it broke when i tried to add the class= "img-responsive" to it which is a built in element in bootstrap. I will try the css you provided, could it be added to the wysiwyg coding above?</p>
<p>Steve</p>]]></description>
          <pubDate>Thu, 07 Feb 2019 15:39:35 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2243002#post2243002</guid>
        </item>
                <item>
          <title>image facilities in tinycme</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242995#post2242995</link>
          <description><![CDATA[<p>Hi Daniel,</p>
<p>In theory that will be a way to solve the spacing issue however I also need images to be responsive, using bootstrap I can manually add code class="img-responsive" which solves that issue but I cannot expect clients to edit the code and enter this.  I have tried various ways to add this code into the wysiwyg_custom.php code below but it just breaks the file and the toolbar doesnt load.  Is there any way to have class="image-responsive automatically applied to any/all images.</p>
<pre class="language-markup"><code>{ title: 'Image Left',    selector: 'img', styles: {'float': 'left','margin': '0 10px 0 10px'} },</code></pre>
<p>Given that websites these days have to be responsive and that bootstrap is so widely used in website design I am sure there must be a simple solution to this</p>
<p>Thanks again for your help.</p>

<p>Steve</p>]]></description>
          <pubDate>Thu, 07 Feb 2019 08:26:16 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242995#post2242995</guid>
        </item>
                <item>
          <title>image facilities in tinycme</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242979#post2242979</link>
          <description><![CDATA[<p>Hi Daniel,</p>
<p>thanks for that, I have added the tool but it still doesn't provide the facility to add padding to the image to prevent text butting right up to the edge of the image.  Could you advise how we achieve this facility?  I would have thought would be a pretty basic requirement when adding an image so I must be missing something obvious here.</p>

<p>Thanks again</p>
<p>Steve</p>]]></description>
          <pubDate>Tue, 05 Feb 2019 01:28:37 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242979#post2242979</guid>
        </item>
                <item>
          <title>image facilities in tinycme</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242969#post2242969</link>
          <description><![CDATA[<p><span>Hi all,</span></p>
<p><span>I have an issue with the wysiwyg element in that when in the latest cmsb and the new tinymce an image is uploaded and inserted there isnt any facility to apply any padding, or if there is I cannot see it. I understand that plugins can be added but whenever i try it just breaks the toolbar.  Is anyone able to provide the exact syntax and instructions  on how to add the extra image editing features please.</span></p>

<p><span>Thanks in advance for any help provided.</span></p>]]></description>
          <pubDate>Thu, 31 Jan 2019 06:36:26 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242969#post2242969</guid>
        </item>
                <item>
          <title>Import ical feed into cmsb and output to rss</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242888#post2242888</link>
          <description><![CDATA[<p>Hi Dave,</p>
<p>Already looked at those options, I can import the calendar into google and used the app program to create rss feed butit doesnt do a good job and created links go to google instead of the original calendar.</p>
<p>There is a php script ical2rss I think its called but its old yet may be a starting point,  Ill have a look and post it for your thoughts. </p>]]></description>
          <pubDate>Thu, 10 Jan 2019 15:25:22 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242888#post2242888</guid>
        </item>
                <item>
          <title>business of the day rss help required please</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242883#post2242883</link>
          <description><![CDATA[<p>Hi Jerry,</p>
<p>not being a programmer I have used the cookbook for a number of solutions over the years, I will take a look and see if it could be adapted by someone with my knowledge level which is pretty much cut and paste and hope for the best :-)</p>]]></description>
          <pubDate>Thu, 10 Jan 2019 02:04:30 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242883#post2242883</guid>
        </item>
                <item>
          <title>need help with passing of variable using $_session please</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242867#post2242867</link>
          <description><![CDATA[<p>Hi Daniel,</p>
<p>Thanks for looking at this. Unfortunately I posted tne wrong code, it is the script element of the code that causes the issue.</p>]]></description>
          <pubDate>Tue, 08 Jan 2019 16:35:53 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242867#post2242867</guid>
        </item>
                <item>
          <title>Import ical feed into cmsb and output to rss</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242866#post2242866</link>
          <description><![CDATA[<p>Hi all,</p>
<p>We use a tockify calendar on our website and would like to export events to a rss feed. There doesnt seem to be many programs around that convert ical to rss so wondered if it was possible to use cmsb in the middle to make the conversion.</p>
<p>Can anyone advise if it is possible to automatically import an ical feed into cmsb so that it can be sorted into event date order and produce an rss output of events covering a specific number of days?</p>
<p>Thanks in advance</p>]]></description>
          <pubDate>Tue, 08 Jan 2019 15:34:58 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242866#post2242866</guid>
        </item>
                <item>
          <title>business of the day rss help required please</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242863#post2242863</link>
          <description><![CDATA[<p>Hi all,</p>
<p>I have created a rss feed to select a random business as the business of the day, the idea being that I want to create an IFTTT applet to post the rss feed to a facebook page once a day</p>
<p>I can get everything working so far as the rss page and the IFTT side of things however I only want the business-of-day-rss.php to run once a day, I dont want the content to change each time the page is accessed.</p>
<p>How can I achieve it so that;</p>
<p>a) The page is automatically run at a specific time each day?</p>
<p>b) once run the page values stay the same until the page is recreated by the above schedule</p>
<p>I have included an example of my rss code below in case it helps.</p>

<p>Thanks in advance for any help provided.</p>
<pre class="language-php"><code>

  // load records from 'advertisers'
  list($advertisersRecords, $advertisersMetaData) = getRecords(array(
    'tableName'   =&gt; 'advertisers',
    'limit'       =&gt; '1',
    'orderBy'     =&gt; 'RAND()',
    'loadUploads' =&gt; false,
    'allowSearch' =&gt; false,
	  'where' =&gt; 'listing LIKE "%Standard Listing%"',
  ));

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

return $output;
}
?&gt;
&lt;rss version="2.0" <a>xmlns:atom="http://www.w3.org/2005/Atom</a>"&gt;
  &lt;channel&gt;
    &lt;title&gt;Business of the Day&lt;/title&gt;
    &lt;link&gt;<a href="https://www.mysite.net" rel="nofollow">https://www.mysite.net</a>&lt;/link&gt;
    &lt;description&gt;Business of the Day&lt;/description&gt;
    &lt;pubDate&gt;&lt;?php echo date('r') ?&gt;&lt;/pubDate&gt;
    &lt;language&gt;en-us&lt;/language&gt;

    &lt;?php foreach ($advertisersRecords as $record): ?&gt;
    &lt;item&gt;
      &lt;title&gt;&lt;?php echo htmlencode($record['title']) ?&gt;&lt;/title&gt;
      &lt;link&gt;https://&lt;?php echo $_SERVER['HTTP_HOST']; ?&gt;/&lt;?php echo $record['_link'] ?&gt;&lt;/link&gt;
      &lt;description&gt;  &lt;![CDATA[&lt;?php echo maxWords ($record['description'],60) ?&gt;&lt;br&gt; &lt;a href="http://&lt;?php echo $_SERVER['HTTP_HOST']; ?&gt;/&lt;?php echo $record['_link'] ?&gt;" target="_blank"&gt; Read more..&lt;/a&gt;]]&gt;&lt;/description&gt;
      &lt;pubDate&gt;&lt;?php echo date('r', strtotime($record['createdDate'])) ?&gt;&lt;/pubDate&gt;
      
    &lt;/item&gt;
    &lt;?php endforeach ?&gt;
  &lt;/channel&gt;
&lt;/rss&gt;</code></pre>]]></description>
          <pubDate>Tue, 08 Jan 2019 05:20:06 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242863#post2242863</guid>
        </item>
                <item>
          <title>need help with passing of variable using $_session please</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242854#post2242854</link>
          <description><![CDATA[<p>Hi all,</p>
<p>let me say at the outset that I have no php coding skills so all my work tends to be guesswork so please excuse any ignorance or lack of knowledge displayed.</p>
<p>my ultimate goal with this is to be able pass a variable into a form in an inline frame.  At the moment I am just trying to get the variable transfer to work.</p>
<p>I have the following header code in the host page which draws record info from the url, ie business-detail-test.php?New-Advertiser-313</p>
<pre class="language-php"><code>&lt;?php header('Content-type: text/html; charset=utf-8'); ?&gt;
&lt;?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
  
  // load viewer library
  $libraryPath = 'cmsb/lib/viewer_functions.php';
  $dirsToCheck = array('/home/sites/4b/4/4af2cde633/public_html/','','../','../../','../../../');
  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 record from 'advertisers'
  list($advertisersRecords, $advertisersMetaData) = getRecords(array(
    'tableName'   =&gt; 'advertisers',
    'where'       =&gt; whereRecordNumberInUrl(0),
    'loadUploads' =&gt; true,
    'allowSearch' =&gt; false,
    'limit'       =&gt; '1',
  ));
  $advertisersRecord = @$advertisersRecords[0]; // get first record
  if (!$advertisersRecord) { dieWith404("Record not found!"); } // show error message if no record found

?&gt;
&lt;?php
	session_start();

$_SESSION['email_address2']=($advertisersRecord['email_address']) ;

?&gt;</code></pre>
<p>I have created a simple test page (test.php) to test the $_session element works correctly which is coded as</p>
<pre class="language-php"><code>&lt;?php
	session_start();
echo $_SESSION['email_address2'];

	
?&gt;</code></pre>

<p>This seems to work as expected with test.php displaying the records email address.</p>
<p>within the original page "business-detail-test.php?New-Advertiser-313" I have to include an enquiry form which has been created using coffee cups web form builder software which by default brings a created form into a page via the use of an inline frame.  The code they provide for doing this is as shown below which I will now refer to as<strong> formcode1</strong></p>
<pre class="language-php"><code>&lt;script type="text/javascript"&gt;document.write(unescape("%3Ciframe id=\"fb_iframe\" src=\"availability-request.php" + window.location.search + "\" width=\"100%\" height=\"1158\"allowtransparency=\"true\" scrolling=\"no\" frameborder=\"0\"%3E&amp;lt;a href=\"availability-request.php\" title=\"availability-request\"&amp;gt;Check out my CoffeeCup Form&amp;lt;/a&amp;gt;%3C/iframe%3E"));&lt;/script&gt;
&lt;noscript&gt;
  &lt;iframe height="1158" style="border:none; background:transparent; overflow:hidden; width:100%;"
  id="fb_iframe" src="/availability-request/availability-request.html"&gt;
    &lt;a href="availability-request.php" title="availability-request"&gt;Check out my CoffeeCup Form&lt;/a&gt;
  &lt;/iframe&gt;
&lt;/noscript&gt;</code></pre>
<p>For some reason, when <strong>formcode1</strong> is added to my "business-detail-test.php?New-Advertiser-313" my test.php page no longer displays the email address assigned in the $_session code from which I assume that the $_session data is no longer being set but havent a clue why adding the above to the page would stop this from happening.</p>
<p>Through process of elimination I have found that the part of formcode1 which is causing the issue seems to be the code below as removing that element allows test.php to work again but I cannot see any reason why loading the iframe should stop $_session from working.</p>
<pre class="language-markup"><code>&lt;noscript&gt;
  &lt;iframe height="1158" style="border:none; background:transparent; overflow:hidden; width:100%;"
  id="fb_iframe" src="/availability-request/availability-request.html"&gt;
    &lt;a href="availability-request.php" title="availability-request"&gt;Check out my CoffeeCup Form&lt;/a&gt;
  &lt;/iframe&gt;
&lt;/noscript&gt;	</code></pre>
<p>the coffee cup form is processed by a file called form.cfg.php and it is this file that I want to ultimately transfer the $_session value into so that the form can be sent to the correct email. I assume that all I need to do is copy the code from test.php into the top of form.cfg.php to be able to use the variable to within that page but I need to ascertain why I am losing the variable content from the $_session element.</p>
<p>Sorry if I have made the whole thing confusing by trying to give as much information as possible but to clarify i just need to know why adding an iframe to a page would break the $_session code.</p>
<p>Thanks in advance for any help provided, I know I can resolve the issue by just coding the form into the page by hand but the coffee cup solution provides a lot of functionality that I would prefer not to lose.</p>]]></description>
          <pubDate>Mon, 07 Jan 2019 07:19:53 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242854#post2242854</guid>
        </item>
                <item>
          <title>RSS feed issues</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242849#post2242849</link>
          <description><![CDATA[<p>Hi Daniel,</p>
<p>Thanks, that sorted the issue, beginning to think it's time I was put out to pasture :-)</p>]]></description>
          <pubDate>Fri, 04 Jan 2019 08:46:03 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242849#post2242849</guid>
        </item>
                <item>
          <title>RSS feed issues</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242846#post2242846</link>
          <description><![CDATA[<p>Hi all,</p>
<p>I am trying to set up an RSS feed using the cmsb rss feed generator but am running into all sorts of issues.</p>
<p>For a start, if I include the following line </p>
<pre class="language-php"><code>&lt;?php header('Content-type: application/xml; charset=utf-8'); ?&gt;&lt;?php echo '&lt;'.'?xml version="1.0" encoding="UTF-8"?&gt;'; ?&gt;</code></pre>
<p>I get an error "error on line 35 at column 118: Document is empty"</p>
<p>When testing the page with rss viewers there doesn't seem to be any content in the feed yet the foreach routine looks fine to me.  The location of the feed is <a href="https://www.bridlington.net/bridlington-news.xml" rel="nofollow">https://www.bridlington.net/bridlington-news.xml</a> if someone would be kind enough to take a look and advise where the problem lies i would be most grateful.</p>
<p>The code for the page is below if it helps.</p>
<p>Thanks in advance for any help provided</p>
<pre class="language-php"><code>&lt;?php header('Content-type: application/xml; charset=utf-8'); ?&gt;
&lt;?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
  
  // load viewer library
  $libraryPath = 'cmsb/lib/viewer_functions.php';
  $dirsToCheck = array('/home/sites/4b/4/4af2cde633/public_html/','','../','../../','../../../');
  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 from 'current_news'
  list($current_newsRecords, $current_newsMetaData) = getRecords(array(
    'tableName'   =&gt; 'current_news',
    'orderBy'     =&gt; '',   // use default database order
    'loadUploads' =&gt; false,
    'allowSearch' =&gt; false,
  ));

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

return $output;
}
?&gt;
&lt;?php header('Content-type: application/xml; charset=utf-8'); ?&gt;&lt;?php echo '&lt;'.'?xml version="1.0" encoding="UTF-8"?&gt;'; ?&gt;
&lt;rss version="2.0" <a>xmlns:atom="http://www.w3.org/2005/Atom</a>"&gt;
  &lt;channel&gt;
	  &lt;<a>atom:link</a> href="<a href="https://bridlington.net/bridlington-news.xml" rel="nofollow">https://bridlington.net/bridlington-news.xml</a>" rel="self" type="application/rss+xml" /&gt;
    &lt;title&gt;Bridlington news from Bridlington.net&lt;/title&gt;
    &lt;link&gt;<a href="https://www.bridlington.net/" rel="nofollow">https://www.bridlington.net/</a>&lt;/link&gt;
    &lt;description&gt;Bridlington.net providing Bridlington news and information.&lt;/description&gt;
    &lt;pubDate&gt;&lt;?php echo date('r') ?&gt;&lt;/pubDate&gt;
    &lt;language&gt;en-us&lt;/language&gt;
	  	


    &lt;?php foreach ($current_newsRecords as $record): ?&gt;
    &lt;item&gt;
      &lt;title&gt;&lt;?php echo htmlencode($record['title']) ?&gt;&lt;/title&gt;
      &lt;link&gt;https://&lt;?php echo $_SERVER['HTTP_HOST']; ?&gt;/&lt;?php echo $record['_link'] ?&gt;&lt;/link&gt;
      &lt;description&gt;  &lt;![CDATA[&lt;?php echo maxWords ($record['content'],60) ?&gt; &lt;a href="https://&lt;?php echo $_SERVER['HTTP_HOST']; ?&gt;&lt;?php echo $record['_link'] ?&gt;" target="_blank"&gt;Read more..&lt;/a&gt;]]&gt;&lt;/description&gt;
      &lt;pubDate&gt;&lt;?php echo date('r', strtotime($record['createdDate'])) ?&gt;&lt;/pubDate&gt;
      
    &lt;/item&gt;
    &lt;?php endforeach ?&gt;
  &lt;/channel&gt;
&lt;/rss&gt;</code></pre>]]></description>
          <pubDate>Thu, 03 Jan 2019 08:36:54 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242846#post2242846</guid>
        </item>
                <item>
          <title>info from two tables on one page</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242765#post2242765</link>
          <description><![CDATA[<p>Hi Daniel,</p>
<p>Thanks for the tips, issue is now fixed.</p>
<p>Thanks again</p>
]]></description>
          <pubDate>Fri, 14 Dec 2018 02:02:28 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242765#post2242765</guid>
        </item>
                <item>
          <title>info from two tables on one page</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242755#post2242755</link>
          <description><![CDATA[<p>Hi Daniel,</p>
<p>The search filter works if I use the title field, however to expand a little.</p>
<p>I am using two tables to provide information on the list page and I wanted both tables to be filtered on the same field ie "category"</p>
<p>so</p>
<p>table 1 = "information_pages" contains lots of records that each have a category field to allow me to filter and list records with the same category value ie all records relating to Beaches</p>
<p>table 2 - "information_section_headers" which contains  a number of records (1 for each category value) containg title and description text relevant to that category.</p>
<p>both those tables use a third table "categories_list" to provide a drop down selection for the category value. ie Beaches, Harbour, shopping etc</p>
<p>I have done this to ensure that any new categories created are automatically available when creating records in tables 1 &amp; 2</p>
<p>What I am looking to achieve is to create a menu link such as "information-pages.php?category=Beaches" and have the page display the listings of all records where the category value matches Beaches in table 1 and also provide the title and description text from table 2 from the record which has the category value Beaches.</p>
<p>For whatever reason the records from table 1 "information_pages" display correctly but I cannot get any content from table 2 to display on the page.  I am sure it is something simple that I am doing wrong or missing due to my lack of knowledge in php and sql so any help provided in the simplest form so even I can understand would be very much appreciated.</p>
<p>At the moment my head code is</p>
<pre class="language-markup"><code> list($information_section_headersRecords, $information_section_headersMetaData) = getRecords(array(
    'tableName'   =&gt; 'information_section_headers',
    'where'       =&gt; '',
    'loadUploads' =&gt; false,
    'allowSearch' =&gt; true,
    'limit'       =&gt; '1',
  ));
  


  // load records from 'information_pages'
  list($information_pagesRecords, $information_pagesMetaData) = getRecords(array(
    'tableName'   =&gt; 'information_pages',
    'orderBy'     =&gt; 'RAND()',
    'loadUploads' =&gt; true,
    'allowSearch' =&gt; true,
  ));
</code></pre>
<p>and my display code is</p>
<pre class="language-markup"><code>                    &lt;?php foreach ($information_section_headersRecords as $record): ?&gt;
    title here &lt;?php echo htmlencode($record['title']) ?&gt;&lt;br/&gt;
      
     content here &lt;?php echo $record['content']; ?&gt;&lt;br/&gt;
		
      &lt;?php endforeach ?&gt;  




          &lt;?php foreach ($information_pagesRecords as $record): ?&gt;
            &lt;li&gt;
            &lt;?php foreach ($record['uploads'] as $index =&gt; $upload): ?&gt;
          &lt;?php if ($index &gt;= 1) { continue; } // limit uploads shown ?&gt;
            
             
                &lt;a data-description="data-description" data-largesrc="&lt;?php echo htmlencode($upload['thumbUrlPath2']) ?&gt;" data-title="&lt;?php echo htmlencode($record['title']) ?&gt;" href="#"&gt;
                    &lt;img alt="&lt;?php echo htmlencode($record['title']) ?&gt;" src="&lt;?php echo htmlencode($upload['thumbUrlPath2']) ?&gt;" /&gt;
                &lt;/a&gt;
                &lt;?php endforeach ?&gt;
                &lt;h3&gt;
                    &lt;?php echo htmlencode($record['title']) ?&gt; &lt;br&gt;
					&lt;?php echo htmlencode($record['telephone']) ?&gt;
                &lt;/h3&gt;  
                &lt;div class="gallery1-content"&gt;
                    &lt;div&gt;
                        &lt;h3&gt;
                           &lt;?php echo htmlencode($record['title']) ?&gt;
                        &lt;/h3&gt;
                      
                        &lt;p&gt;
                            &lt;?PHP echo maxWords($record['content'],50) ?&gt; &lt;br&gt;
							&lt;?php echo htmlencode($record['telephone']) ?&gt;&lt;br&gt;
							&lt;?php echo htmlencode($record['contact_email']) ?&gt;
                        &lt;/p&gt;
                        &lt;a href="&lt;?php echo $record['_link'] ?&gt;"class="btn btn-primary"&gt;Read More..&lt;/a&gt;
                            
                            
                            
                        &lt;p&gt;&lt;/p&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/li&gt;
            &lt;?php endforeach ?&gt; </code></pre>]]></description>
          <pubDate>Thu, 13 Dec 2018 02:42:31 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242755#post2242755</guid>
        </item>
                <item>
          <title>info from two tables on one page</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242744#post2242744</link>
          <description><![CDATA[<p>Hi all,</p>
<p>I have a small issue in that I have a table with a field called category, the value of which is populated from a drop down list from another table, using the demo code the page looks like the code below and all works as expected except! the value I want to filter against is the field "category" and I cannot get that to work.</p>
<p>I want to filter by test-1.php?category=History but it doesnt work, if I run the page without filters the list is produced correctly and the page shows two values for category which are in the format</p>
<p>Category (value): 5<br />Category (label): Airport Routes</p>
<p>If I try  test-1.php?category=History I get no results found and if I try  test-1.php?category=2 the record displayed is filtered on the "record number" not the category value</p>
<p>What I need to be able to do is to apply a search filter in the html link that filters against the value held in Category (label)</p>
<p>I suspect it is something to do the fact that the field "category" is holding a value from another table but I don't know what to do to turn it into a value I can filter against. In the field editor for category I have selected "num" for the field option values and for field option labels I have title if the helps</p>
<p>Thanks in advance for any help provided</p>
<pre class="language-php"><code>&lt;?php header('Content-type: text/html; charset=utf-8'); ?&gt;
&lt;?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
  
  // load viewer library
  $libraryPath = 'cmsb/lib/viewer_functions.php';
  $dirsToCheck = array('/home/sites/4b/1/128ffc9a32/public_html/','','../','../../','../../../');
  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 record from 'information_section_headers'
  list($information_section_headersRecords, $information_section_headersMetaData) = getRecords(array(
    'tableName'   =&gt; 'information_section_headers',
    'where'       =&gt; whereRecordNumberInUrl(0),
    'loadUploads' =&gt; false,
    'allowSearch' =&gt; false,
    'limit'       =&gt; '1',
  ));
  $information_section_headersRecord = @$information_section_headersRecords[0]; // get first record
  if (!$information_section_headersRecord) { dieWith404("Record not found!"); } // show error message if no record found

?&gt;
 &lt;/head&gt;


&lt;body&gt;

  

  &lt;!-- STEP2: Display Record (Paste this where you want your record to appear) --&gt;
    &lt;h1&gt;Multiple Data List Headers - Detail Page Viewer&lt;/h1&gt;
      Record Number: &lt;?php echo htmlencode($information_section_headersRecord['num']) ?&gt;&lt;br/&gt;
      Title: &lt;?php echo htmlencode($information_section_headersRecord['title']) ?&gt;&lt;br/&gt;
     
      Content: &lt;?php echo $information_section_headersRecord['content']; ?&gt;&lt;br/&gt;
      Category (value): &lt;?php echo $information_section_headersRecord['category'] ?&gt;&lt;br/&gt;
      Category (label): &lt;?php echo $information_section_headersRecord['category:label'] ?&gt;&lt;br/&gt;
     
&lt;/body&gt;
&lt;/html&gt;
</code></pre>]]></description>
          <pubDate>Tue, 11 Dec 2018 09:24:59 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242744#post2242744</guid>
        </item>
                <item>
          <title>strugling with multi option search.</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242718#post2242718</link>
          <description><![CDATA[<p>Thanks Dave, but I havent a clue what you have done :-(  as I am not a programmer I may need you to sort this for me, is it likely to be a big job? I will contact you next week with more details if that's okay.</p>]]></description>
          <pubDate>Fri, 30 Nov 2018 06:02:09 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242718#post2242718</guid>
        </item>
                <item>
          <title>strugling with multi option search.</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242704#post2242704</link>
          <description><![CDATA[<p>Hi Dave,</p>
<p>thanks for your help but the solution doesn't help unfortunately, perhaps if I explain further.</p>
<p>I am not looking to provide a filtered list where "serviced_accommodation_facilities" contains selection1 OR selection2 OR selection3</p>
<p>I need to produce a list where the values contained within "serviced_accommodation_facilities" contains selection1 AND selection2 AND selection3 etc</p>
<p>Unfortunately my sql and php knowledge are extremely limited so I may be making a simple mistake somewhere.</p>
<p>I believe the bootstrap multi-option code is simply to present the list of option in a way that allows multiple selections to be made from the list and doesn't incorporate anything to do with the interrogation of the table to provide the results.</p>
<p>It may be that the best way to resolve the issue is to forget my coding attempts and start from scratch.</p>
<p>I think the help I need is in how to code the options that have been selected so that they can be compared against the content of each records "serviced_accommodation_facilities" field and only show the records where "serviced_accommodation_facilities" contains checks against ALL the items in the list.</p>
<p>Any help or pointer in the right direction is appreciated</p>
]]></description>
          <pubDate>Wed, 28 Nov 2018 03:24:04 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242704#post2242704</guid>
        </item>
                <item>
          <title>strugling with multi option search.</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242671#post2242671</link>
          <description><![CDATA[<p>Hi all,</p>
<p>I am trying to create a search filter against certain values in a table field.</p>
<p>I can get the following code to work but it is only allowing search against a single value. </p>
<pre class="language-markup"><code>&lt;form method="POST" action="&lt;?php echo $_SERVER['PHP_SELF'] ?&gt;"&gt;
&lt;select name = "serviced_accommodation_facilities" &gt; 
&lt;option value=""&gt;Please Choose a Category&lt;/option&gt;
&lt;?php foreach (getListOptions('advertisers', 'serviced_accommodation_facilities') as $value =&gt; $label): ?&gt; 
     ') as $value =&gt; $label): ?&gt; 
     
&lt;option value = "&lt;?php echo $value;?&gt;" &lt;?php selectedIf($value, @$_REQUEST['serviced_accommodation_facilities']);?&gt;&gt;
    
&lt;?php echo $label; ?&gt;&lt;/option&gt; 
     
&lt;?php endforeach ?&gt; 
 
&lt;/select&gt; 

&lt;input type="submit" name="submit" value="Search" &gt;
&lt;/form&gt;</code></pre>
<p>However I want to use a multi select option using bootstrap multiselect, I can get the list to display and select multiple values however when I do the search It doesnt filter anything out, it just displays all the records even when just one element is selected.</p>
<p>I know it must be something simple and probably immediately obvious to someone with php or mysql knowledge, neither of which I have so my efforts tend to originate in copying code from somewhere and then trying to get it to work via trial and error, only this time I am pulling my hair out and getting nowhere but seem so close.</p>
<p>My multi list code is shown below, if someone can advise where the issue is and why the above option works and the below one doesn't I would be extremely grateful. I am assuming it is nothing to do with the headers etc given that the above filter does work.</p>

<p>As always, thanks in advance for any help provided</p>
<p>I have noticed that the working filter uses </p>
<pre class="language-markup"><code>&lt;select name = "serviced_accommodation_facilities" &gt; </code></pre>
<p>and the multi list version uses</p>
<pre class="language-php"><code>&lt;select  id = "serviced_accommodation_facilities" multiple="multiple"  &gt; </code></pre>
<p>is this relevant?</p>
<pre class="language-markup"><code>		
			&lt;!-- Multi Selection Form --&gt;
			
			&lt;!-- Initialize the plugin: --&gt;
&lt;script type="text/javascript"&gt;
    $(document).ready(function() {
        $('#serviced_accommodation_facilities').multiselect();
    });
&lt;/script&gt;	

&lt;form method="POST" action="&lt;?php echo $_SERVER['PHP_SELF'] ?&gt;"&gt;
				
				
&lt;select  id = "serviced_accommodation_facilities" multiple="multiple"  &gt; 	
			
&lt;option value="" disabled selected&gt;Required Facilities&lt;/option&gt;

&lt;?php foreach (getListOptions('advertisers', 'serviced_accommodation_facilities') as $value =&gt; $label): ?&gt; 
     
&lt;option value = "&lt;?php echo $value;?&gt;" &lt;?php selectedIf($value, @$_REQUEST['serviced_accommodation_facilities']);?&gt;&gt;
    
&lt;?php echo $label; ?&gt;&lt;/option&gt; 
     
&lt;?php endforeach ?&gt; 
 
&lt;/select&gt; 




&lt;input type="submit" name="submit" value="Search" &gt;
&lt;/form&gt;</code></pre>]]></description>
          <pubDate>Mon, 19 Nov 2018 06:34:52 -0800</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242671#post2242671</guid>
        </item>
                <item>
          <title>help needed with basic search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242573#post2242573</link>
          <description><![CDATA[<p>Thanks both,</p>
<p>Issue resolved.</p>]]></description>
          <pubDate>Tue, 23 Oct 2018 06:06:20 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242573#post2242573</guid>
        </item>
                <item>
          <title>help needed with basic search</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242564#post2242564</link>
          <description><![CDATA[<p>Hi all,</p>
<p>I am trying to create a list from a page link, ie stock-listings.php?willows=1 AND stock_type=New</p>
<p>I can get the link to work if searching against just one record but cannot get it to work when trying to search against two values, I have tried using &amp;, AND, and and even , between the values but nothing works for me I am obviously missing something in respect of correct syntax but cannot see what.</p>
<p>Both searches work on their own but not when I try to combine them.</p>
<p>The search needs to be carried out from values within the link not the display page, I am sure the solution is simple but all google searches seem to relate to doing the filtering within the code on the listing page not the link which is what I need.</p>
<p>Can this be done? if so any help to achieve this would be appreciated.</p>
<p>Thanks in advance.</p>]]></description>
          <pubDate>Wed, 17 Oct 2018 03:28:31 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242564#post2242564</guid>
        </item>
                <item>
          <title>if else script to control display of form in an iframe.</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242402#post2242402</link>
          <description><![CDATA[<p>That has worked beautifully thanks ever so much. </p>]]></description>
          <pubDate>Sat, 18 Aug 2018 04:06:46 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242402#post2242402</guid>
        </item>
                <item>
          <title>if else script to control display of form in an iframe.</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2242398#post2242398</link>
          <description><![CDATA[<p>Hi all,</p>
<p>I have created a checkbox that clients can check or uncheck to control whether a vacancy enquiry form is displayed within the detail page.</p>
<p>I have tried to create an if else statement to dictate whether the form/iframe is displayed I can get it to display a test message based on </p>
<p><code> &lt;?PHP if ($advertisersRecord['show_vacancy_enquiry_form'] == "1") { echo"display form"}</code></p>
<p><code>  else <br />{ echo "do not display form"; }	?&gt;</code></p>
<p>however when i try to use this to control the display of the following code it does not work, the page simply doesn't load.</p>
<p><code>&lt;script type="text/javascript"&gt;
<br />						document.write(unescape("%3Ciframe id=\"fb_iframe\" src=\"availability-request.php" + window.location.search + "\" width=\"100%\" height=\"1027\"allowtransparency=\"true\" scrolling=\"no\" frameborder=\"0\"%3E&amp;lt;a href=\"availability-request.php\" title=\"availability-request\"&amp;gt;Check out my CoffeeCup Form&amp;lt;/a&amp;gt;%3C/iframe%3E"));
																				&lt;/script&gt;<br />&lt;noscript&gt;
  &lt;iframe <br />height="1027" <br />style="border:none; background:transparent; overflow:hidden; <br />width:100%;"
  id="fb_iframe" src="availability-request/availability-request.html"&gt;
<br />    &lt;a href="availability-request.php" title="availability-request"&gt;Check out my CoffeeCup Form&lt;/a&gt;
<br />  &lt;/iframe&gt;
&lt;/noscript&gt;	</code></p>
<p>In a nutshell I just want a simple if else script that says if the display box value is 1 show the form, else omit the code and carry on after the form section.  I have tried what I thought was required below but I am obviously missing something. Can anyone see where I am going wrong?</p>
<p><code> &lt;?PHP if ($advertisersRecord['show_vacancy_enquiry_form'] == "1")<br /> {
<br />
&lt;script type="text/javascript"&gt;
						document.write(unescape("%3Ciframe id=\"fb_iframe\" src=\"availability-request.php" + window.location.search + "\" width=\"100%\" height=\"1027\"allowtransparency=\"true\" scrolling=\"no\" frameborder=\"0\"%3E&amp;lt;a href=\"availability-request.php\" title=\"availability-request\"&amp;gt;Check out my CoffeeCup Form&amp;lt;/a&amp;gt;%3C/iframe%3E"));
																				&lt;/script&gt;<br />
&lt;noscript&gt;
  &lt;iframe height="1027" style="border:none; background:transparent; overflow:hidden; width:100%;"
  id="fb_iframe" src="availability-request/availability-request.html"&gt;
    &lt;a href="availability-request.php" title="availability-request"&gt;Check out my CoffeeCup Form&lt;/a&gt;
  &lt;/iframe&gt;
&lt;/noscript&gt;<br />	

}
<br />else { echo "&amp;nbsp;"; }	?&gt;</code></p>
<p>Thanks in advance for any/all help provided.</p>]]></description>
          <pubDate>Fri, 17 Aug 2018 05:23:42 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2242398#post2242398</guid>
        </item>
              </channel>
    </rss>
  