This show only records between a certain  range for a certain group or client

mysql_select_db($database_reuniomysql, $reuniomysql);
$query_rsphotobuclass = sprintf("SELECT DISTINCT class_ticket_purchases.purchase_ticket_id, class_ticket_purchases.purchase_ticket_title, class_ticket_purchases.purchase_ticket_class_id, class_ticket_purchases.purchase_reunion_year, class_ticket_purchases.purchase_ticket_price FROM class_ticket_purchases WHERE class_ticket_purchases.purchase_ticket_id between '2'  and '4' AND class_ticket_purchases.purchase_ticket_class_id=%s GROUP BY purchase_ticket_id", GetSQLValueString($KTColParam1_rsphotobuclass, "int"));

The bold show only records between a range of 2-4 (2,3,4) for only 1 class (class_id) - must be grouped (ticket_id) to work. range is distinct meaning it will only show items that are unique not the same items over and over again.

Simple show if based on a session  variable

<?php

if (@$_SESSION['kt_use'] == "Family") {

          Show This

 }

?>

Show if then else based on session

  <?php
if (@$_SESSION['kt_use'] == "Family") {

          Show this

} else {

          Else show this

 }

?>

This is a Show if based on 3 conditions of a variable.

One of the difficulties we had was echoing dynamic data into the link in this case the year

<a href=classregs_year_military.php?reunion_year='.$year.'>

So what we did was create a variable $year

<?php $year=$row_rsreunionreg['reunion_year']; ?>

Then we had no issues using it in the If statements


The first condition evaluates the @$row_rsreunionreg['use_reason']
to see if its either for Military or Family use, if neither of these conditions are true then it displays the Record Icon and its link.

The 2 and 3rd condition show what to display based on weather or not its a Military or Family use and displays the appropriate Menu icon and link

For some reason if there is any space between each condition then the icon will not display

<?php
 if (@$row_rsreunionreg['use_reason'] != "Military" AND @$row_rsreunionreg['use_reason'] != "Family"){
echo '<a href=classregs_year.php?reunion_year='.$year.'><img name="list_regs" src="a_registration_report_icon_sm.png" width="28" height="36" border="0" vspace="5" id="list_regs" alt="" />[/url]
                        

                      Registrations';
   }
   if (@$row_rsreunionreg['use_reason'] == "Military") {
      echo '<a href=classregs_year_military.php?reunion_year='.$year.'><img name="list_regs" src="a_registration_report_icon_sm.png" width="28" height="36" border="0" vspace="5" id="list_regs" alt="" />[/url]
                        

                      Registrations';
   }
if (@$row_rsreunionreg['use_reason'] == "Family") {
echo '<a href=classregs_year_family.php?reunion_year='.$year.'><img name="list_regs" src="a_registration_report_icon_sm.png" width="28" height="36" border="0" vspace="5" id="list_regs" alt="" />[/url]
                        

                      Registrations';
   }     
?>

place this code at the beginning of your code:

 <?php
ob_start();
error_reporting( E_ALL ^ (E_NOTICE | E_WARNING | E_DEPRECATED | E_STRICT));
?>

or this

<?php
error_reporting(0);
echo "Sorry there was an ERROR please check
 your entries for the error message";
?>

You can change the echo message to what ever you what.

Sometimes you need the error message to appear while debugging a page in that case use this code:

<?php
error_reporting(E_ALL);
echo "Here is some text";
?>

you can also use this to not display any error - might be helpful for Division by zero errors

<?php
error_reporting(0);
echo "";
?>

This link worked for me in terms of figuring out why the Facebook button wasn't showing up even though we had all the code correctly set on the page

https://www.moorewebexposure.com/internet/facebook-like-button-not-showing/

has to do with who is allowed to see your page - you have to allow everyone to see it in order for it to work - why Facebook does this is beyond me.

Change the name .agree_terms to what ever your checkbox field name is

/* CSS .agree_terms */
.agree_terms {
  width: 90px;
  height: 26px;
  background: #333;
  margin: 20px auto;
  position: relative;
  border-radius: 50px;
  box-shadow: inset 0px 1px 1px rgba(0, 0, 0, 0.5), 0px 1px 0px rgba(255, 255, 255, 0.2);
}
.agree_terms:after {
   content: 'NO';
   color: #F6F8F6;
   position: absolute;
   right: 15px;
   z-index: 0;
   font: 12px/26px Arial, sans-serif;
   font-weight: bold;
   text-shadow: 1px 1px 0px rgba(255, 255, 255, 0.15);
}
.agree_terms:before {
  content: 'Agree';
  color: #4FF453;
  position: absolute;
  left: 5px;
  z-index: 0;
  font: 12px/24px Arial, sans-serif;
  font-weight: bold;
}
.agree_terms label {
   content: 'Click';
   display: block;
   width: 40px;
   height: 10px;
   cursor: pointer;
   position: absolute;
   top: 3px;
   left: 3px;
   z-index: 1;
   background: #fcfff4;
   background: -webkit-linear-gradient(top, #fcfff4 0%, #dfe5d7 40%, #b3bead 100%);
   background: linear-gradient(to bottom, #fcfff4 0%, #dfe5d7 40%, #b3bead 100%);
   border-radius: 50px;
   -webkit-transition: all 0.4s ease;
   transition: all 0.4s ease;
   box-shadow: 0px 2px 5px 0px rgba(0, 0, 0, 0.3);
   color: rgba(0,0,0,1.00);
}
.agree_terms input[type=checkbox] {
  visibility: hidden;
}
.agree_terms input[type=checkbox]:checked + label {
  left: 43px;
}

/* end .agree_terms CSS */

<!-- .agree_terms HTML -->

   <section title=".agree_terms">
    <!-- .agree_terms -->
    <div class="agree_terms"> 
      <input type="checkbox" value="1" id="agree_terms" form="form1" name="check" checked />
      <label for="agree_terms"></label>
    </div>
    <!-- end .agree_terms -->
</section>

    <!-- end .agree_terms HTML -->

found at https://codepen.io/bbodine1/pen/novBm

The first css setting sets the basic button look and feel

The second setting sets the hover state of the button itself


.green_submit_buttonRM {
   font-size: 13px;
   font-weight: 500;
   height: auto;
   line-height: 15px;
   border-radius: 5px;
   display: inline-block;
   padding-top: 5px;
   padding-right: 10px;
   padding-bottom: 5px;
   padding-left: 10px;
   background-color: rgba(79,244,83,0.80);
   color: rgba(0,0,0,1.00);
   font-family: "Lucida Grande", "Lucida Sans Unicode", "Lucida Sans", Verdana, sans-serif;
   font-style: normal;
   font-variant: normal;
   border-collapse: collapse;
}

.green_submit_buttonRM:hover {
   border: 1px solid #999;
   color: #000;
   background-color: rgba(11,247,128,1.00);
}

To create a responsive table, add a container element with overflow-x:auto around the <table>:

Example
<div style="overflow-x:auto;">
  <table>
    ...
  </table>
</div>

You can also do this based on the current date



<?php  //expired date start
if(strtotime($row_rsecho_listing['listing_renewal_date']) <= strtotime('now')) {
?>

Expired on <?php echo formatDate($row_rsecho_listing['listing_renewal_date']); ?>
 
<?php // else expired date
} else { ?>

Expires on <?php echo formatDate($row_rsecho_listing['listing_renewal_date']); ?>

<?php }
// end expired date end
?>

Download the mobile_detect.php file and place it where you want on your server.

Here's the show if scripting

 <?php include("mobile_script/Mobile_Detect.php");  // Check for any mobile device.
$detect = new Mobile_Detect(); ?>


<?php if ($detect->isMobile()) { ?>

   show if mobile

<?php } else {  ?>

   show if desktop

   <?php } ?>