Simple Calendar

Set-up the variables:

<?php
  $monthNames = Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"); 

  if (!isset($_REQUEST["year"])) { 
    $_REQUEST["year"]  = date("Y"); 
  }
  
  $cYear  = $_REQUEST["year"];
               
  $prev_year = $cYear - 1;  
  $next_year = $cYear + 1;

  // list the holidays
  $holidays = array(
    array(1,23),    // jan
    array(),        // feb
    array(),        // march
    array(5,6,9),   // apr
    array(1),       // may
    array(12),      // june
    array(),        // july
    array(21,27),   // aug
    array(),        // sept
    array(),        // oct
    array(1,2,30),  // nov
    array(25,30,31) // dec
  );
?>

Create the calendar:

<div style="text-align:center;">
   <table style="width:848px; margin-left:auto; margin-right:auto;">
   <tr>
      <td style="text-align:left; width:33.3%">
         <a href="<?php echo $_SERVER["PHP_SELF"] . "?year=" . $prev_year; ?>">Previous</a>
      </td>
      <td style="text-align:center; width:33.4%">
         <strong><?php echo $cYear; ?></strong>
      </td>
      <td style="text-align:right; width:33.3%">
         <a href="<?php echo $_SERVER["PHP_SELF"] . "?year=" . $next_year; ?>">Next</a>
      </td>
   </tr>
   </table>   
   
   <div style="width:848px; height:696px; margin-left:auto; margin-right:auto;">   
   <?php  
      $ctr = 1;
     
      foreach($monthNames as $monthName)
      {
   ?>
         <div id="calendar_div" name="calendar_div" style="float:left; border:solid 1px #000; height:230px;">
         <table style="width:210px;">
            <tr>
               <td align="center">
                 <table width="100%" border="0" cellpadding="2" cellspacing="2">
                  <tr align="center">
                    <td colspan="7" style="color:#fff; background-color:#999;"><strong><?php echo $monthName; ?></strong></td>
                  </tr>
                  <tr>
                    <td style="color:#fff; background-color:#999; text-align:center;"><strong>S</strong></td>
                    <td style="color:#fff; background-color:#999; text-align:center;"><strong>M</strong></td>
                    <td style="color:#fff; background-color:#999; text-align:center;"><strong>T</strong></td>
                    <td style="color:#fff; background-color:#999; text-align:center;"><strong>W</strong></td>
                    <td style="color:#fff; background-color:#999; text-align:center;"><strong>T</strong></td>
                    <td style="color:#fff; background-color:#999; text-align:center;"><strong>F</strong></td>
                    <td style="color:#fff; background-color:#999; text-align:center;"><strong>S</strong></td>
                  </tr>

                  <?php
                     // The mktime() function returns the Unix timestamp for a date
                     // syntax: mktime(hour,minute,second,month,day,year,is_dst) 
                     $timestamp = mktime(0,0,0,$ctr,1,$cYear);
                     
                     // formats a local time/date
                     // syntax: date(format,timestamp) 
                     $maxday    = date("t",$timestamp);
                     
                     // returns an array that contains date and time information for a Unix timestamp
                     // syntax: getdate(timestamp)                  
                     $thismonth = getdate ($timestamp);               
                     
                     // The returning array contains ten elements with relevant information needed when formatting a date string:
                     // [seconds] - seconds
                     // [minutes] - minutes
                     // [hours] - hours
                     // [mday] - day of the month
                     // [wday] - day of the week
                     // [year] - year
                     // [yday] - day of the year
                     // [weekday] - name of the weekday
                     // [month] - name of the month                  
                     $startday  = $thismonth['wday'];

                     for ($i=0; $i<($maxday+$startday); $i++) {      
                     
                        // highlight the days that are "holidays"
                        if(in_array(($i - $startday + 1),$holidays[$ctr-1])) {
                           $str = "style='background-color: red; color: #fff;'";
                        }
                        else{
                           $str = "";
                        }
                       
                        // check if is the start of the week, if yes, create new row
                        if(($i % 7) == 0 ) {
                           echo "<tr>\n";
                        }
                        
                        if($i < $startday) {
                           echo "<td></td>\n";
                        }
                        else{
                           echo "<td align='center' valign='middle' height='20px' $str>". ($i - $startday + 1) . "</td>\n";
                        }
                        
                        if(($i % 7) == 6 ){ 
                           echo "</tr>\n";
                        }
                     }  
                   ?>
                 </table>
               </td>
            </tr>
         </table>
         </div>
   <?php 
         $ctr++; 
      } 
   ?>
   <br style="clear: both;" />
   </div>   
</div> 

Preview:

Attached Files:

• calendar.php

Further reading:

• PHP Date
• PHP mktime

Check if it is a valid AJAX request

public function is_ajax()
{
   return (isset($_SERVER['HTTP_X_REQUESTED_WITH']) && $_SERVER['HTTP_X_REQUESTED_WITH'] == "XMLHttpRequest");
}

Further Reading:
Do all browsers support PHP's $_SERVER['HTTP_X_REQUESTED_WITH']?

Using CodeIgniter and MySQL Stored Procedure

1. Create the Product object: Create a file under "application/libraries" named Lproduct.php
   

   <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
   
   class Lproduct {
       private $_id = "";
       private $_category = "";
       private $_category_id = "";
       private $_brand = "";
       private $_brand_id = "";
       private $_product_desc = "";
   
       public function get_id() {
           return $this->_id;
       }
   
       public function set_id($_id) {
           $this->_id = $_id;
       }
   
       public function get_category() {
           return $this->_category;
       }
   
       public function set_category($_category) {
           $this->_category = $_category;
       }
   
       public function get_category_id() {
           return $this->_category_id;
       }
   
       public function set_category_id($_category_id) {
           $this->_category_id = $_category_id;
       }
   
       public function get_brand() {
           return $this->_brand;
       }
   
       public function set_brand($_brand) {
           $this->_brand = $_brand;
       }
   
       public function get_brand_id() {
           return $this->_brand_id;
       }
   
       public function set_brand_id($_brand_id) {
           $this->_brand_id = $_brand_id;
       }
   
       public function get_product_desc() {
           return $this->_product_desc;
       }
   
       public function set_product_desc($_product_desc) {
           $this->_product_desc = $_product_desc;
       }
   }
   

2. Create the Model: Create a file under "application/models" named mproduct.php
   

   <?php
   class Mproduct extends CI_Model {
   
       private $_product = null;
   
       public function set_product(Lproduct $product)
       {
           $result = FALSE;
   
           $temp = $product->get_id();
           if ( empty($temp) )
           {
               $data = array(
                   $product->get_product_desc(),
                   $product->get_category_id(),
                   $product->get_brand_id()
               );
   
               try
               {
                   // fix for multi-calls
                   $this->db->reconnect();
   
                   // call the stored procedure
                   $this->db->query("CALL addProduct(?,?,?,@pProdId)", $data);
                   
                   // get the stored procedure returned output
                   $query = $this->db->query('SELECT @pProdId AS product_id');
                   $row = $query->row();
                   if(!empty($row->product_id))
                   {
                       $result = TRUE;
                   }
               }
               catch ( Exception $error_string )
               {
   
               }
           }
           else
           {
               $data = array(
                   $product->get_id(),
                   $product->get_product_desc(),
                   $product->get_category_id(),
                   $product->get_brand_id()
               );
   
               try
               {
                   // fix for multi-calls
                   $this->db->reconnect();
   
                   // call the stored procedure
                   $this->db->query("CALL updateProduct(?,?,?,?,@pResult)", $data);
   
                   // get the stored procedure returned output
                   $query = $this->db->query('SELECT @pResult AS result');
                   $row = $query->row();
                   if(!empty($row->result))
                   {
                       $result = TRUE;
                   }
               }
               catch ( Exception $error_string )
               {
   
               }
           }
   
           $this->_product = $product;
   
           return $result;
       }
   }
   

   
   

ArrayList to String

Create the sample data:

ArrayList arrLst = new ArrayList();

string strCommaDelimited = "";

for(int x=0; x<5; x++)
{
   arrLst.Add(x);
}

Convert ArrayList to String Array:

string[] tmpStringArray = (string[])arrLst.ToArray(typeof(string));

Convert String Array created to String:

strCommaDelimited = String.Join(",", tmpStringArray);

Add Inline CSS to Controls

To add inline css to controls:
<Control>.Attributes.Add("style","<your inline css here>")

Sample:

Table tbl = new Table();

tbl.Attributes.Add("style","float:left")

Further Reading:
Set HTML Attributes for Controls

Creating dynamic HTML table

Set-up the table:

Table tbl = new Table();
tbl.CssClass = "grdVwTable";    // the css class
tbl.CellSpacing = 0;            // the cellspacing
tbl.CellPadding = 2;            // the cellpadding
tbl.GridLines = GridLines.Both; // set the gridlines/borders

Create the row and column for the table head:

TableRow tr = new TableRow();
TableHeaderCell th1 = new TableHeaderCell();
th1.Text = "Sample text";
tr.Cells.Add(th1);

Add the row created to the table:

tbl.Rows.Add(tr);

Set which row is in the thead

tbl.Rows[0].TableSection = TableRowSection.TableHeader;

Create the row and column for the table body:

TableRow trows = new TableRow();
TableCell tc1 = new TableCell();
tc1.Text = confidential;
trows.Cells.Add(tc1);

Add the row created to the table:

tbl.Rows.Add(trows);

Change default timezone

date_default_timezone_set — Sets the default timezone used by all date/time functions in a script

bool date_default_timezone_set ( string $timezone_identifier )

date_default_timezone_set('Asia/Manila');

$script_tz = date_default_timezone_get();

if (strcmp($script_tz, ini_get('date.timezone'))) {
   echo 'Script timezone differs from ini-set timezone.';
} else {
   echo 'Script timezone and ini-set timezone match.';
}

List of Supported Timezones