How to calculate no of working days in php?

function getWorkingDays($startDate, $endDate){
   $begin=strtotime($startDate);
   $end=strtotime($endDate);
   if($begin>$end){
     echo "tartdate is in the future! 
";
      return 0;
   }else{
      $no_days=0;
      $weekends=0;
      while($begin<=$end){
         $no_days++; // no of days in the given interval
         $what_day=date("N",$begin);
         if($what_day>6) { // 6 and 7 are weekend days
            $weekends++;
         };
         $begin+=86400; // +1 day
      };
      $working_days=$no_days-$weekends;
      return $working_days;
   }
}

How to find last day of month in jquery datetime picker?

function getLastDayOfYearAndMonth(year, month){
    return(new Date((new Date(year, month + 1, 1)) - 1)).getDate();
}

How to find your mobile number?

உங்கள் மொபைல் எண் மறந்துவிட்டதா?
***********************************

"உங்கள் மொபைல் எண் திரையில் தோன்ற அழுத்துங்கள்"

Idea சேவையைப் பயன்படுத்துபவர்கள் *1#

Bsnl சேவையைப் பயன்படுத்துபவர்கள் *888#

Aircel சேவையைப் பயன்படுத்துபவர்கள் *131#

Videocon சேவையைப் பயன்படுத்துபவர்கள் *1#

Airtel சேவையைப் பயன்படுத்துபவர்கள் *121*9#

Reliance சேவையைப் பயன்படுத்துபவர்கள் *1#

Virgin Mobile சேவையைப் பயன்படுத்துபவர்கள் *1#

Vodafone சேவையைப் பயன்படுத்துபவர்கள் *131*0#

Tata DoComo சேவையைப் பயன்படுத்துபவர்கள் *580#

How to make Bitly Url using Google API

$GoogleApiKey = $appkey;
$postData = array('longUrl' => $currenturl, 'key' =>$GoogleApiKey);
$jsonData = json_encode($postData);
$curlObj = curl_init();
curl_setopt($curlObj, CURLOPT_URL, 'https://www.googleapis.com/urlshortener/v1/url');
curl_setopt($curlObj, CURLOPT_RETURNTRANSFER, 1);
//As the API is on https, set the value for CURLOPT_SSL_VERIFYPEER to false. This will stop cURL from verifying the SSL certificate.
curl_setopt($curlObj, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($curlObj, CURLOPT_HEADER, 0);
curl_setopt($curlObj, CURLOPT_HTTPHEADER, array('Content-type:application/json'));
curl_setopt($curlObj, CURLOPT_POST, 1);
curl_setopt($curlObj, CURLOPT_POSTFIELDS, $jsonData);
$response = curl_exec($curlObj);
$json = json_decode($response);
curl_close($curlObj);
return $json->id;

How to find prime numbers between two numbers with sliding effect?

<?php
$min = 0;
$max = 10;
if(isset($_POST) && isset($_POST["prime"])){
$min = (isset($_POST["min"])) ?$_POST["min"]:$min;
$max = (isset($_POST["max"])) ?$_POST["max"]:$max;
}
?>
<link rel="stylesheet" href="//code.jquery.com/ui/1.10.4/themes/smoothness/jquery-ui.css">
<script src="//code.jquery.com/jquery-1.10.2.js"></script>
<script src="//code.jquery.com/ui/1.10.4/jquery-ui.js"></script>
<style type='text/css'>
  aside{
    font-size: 14px;
    font-family:Arial;
  }
  .main{
    margin: 0 auto;width:90%;
    
    -webkit-border-radius: 20px; -moz-border-radius: 20px; border-radius: 20px;
    border:1px solid #000000;background-color:#0D020D;
    padding: 20px;
  }
  #prime_no{
    height: 200px;
    overflow-y: scroll;
  }
  .main1{
    margin: 0 auto;width:90%;
    height:150px;
    -webkit-border-radius: 20px; -moz-border-radius: 20px; border-radius: 20px;
    border:1px solid #000000;background-color:#0D020D;
    padding: 20px;
  }
  .oran{
    border:0; color:#f6931f; font-weight:bold;
  }
  .white{
    border:0; color:#FFFFFF; font-weight:bold;
  }
  .mgroup{
    /*border:1px solid red;*/
    margin:0 auto;
    width:50%;
    padding:10px;
  }
  .mgroup label{
    border:0; color:#FFFFFF; font-weight:bold;
  }

  .css_button {
    margin : 0px 0px 0px 150px;
    
    font-family:Arial;
    font-weight:normal;
    -moz-border-radius: 8px;
    -webkit-border-radius: 8px;
    border-radius: 8px;
    border: 1px solid #3866A3;
    padding: 9px 18px;
    text-shadow:1px 1px 0px #5E5E5E;
    -moz-box-shadow:inset 1px 1px 0px 0px #BEE2F9;
    -webkit-box-shadow:inset 1px 1px 0px 0px #BEE2F9;
    box-shadow:inset 1px 1px 0px 0px #BEE2F9;
    font-weight:normal;
    text-decoration:none;
    cursor: pointer;
    background:-webkit-linear-gradient(90deg, #468ccf 5%, #63b8ee 100%);
    background:-moz-linear-gradient(90deg, #468ccf 5%, #63b8ee 100%);
    background:-ms-linear-gradient(90deg, #468ccf 5%, #63b8ee 100%);
    background:linear-gradient(180deg, #63b8ee 5%, #468ccf 100%);
    filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#63b8ee', endColorstr='#468ccf');
    /*background-color:#468ccf;*/
    color:#FFFFFF;
    display:inline-block;
  }
  .css_button:hover {
    background:-webkit-linear-gradient(90deg, #63b8ee 5%, #468ccf 100%);
    background:-moz-linear-gradient(90deg, #63b8ee 5%, #468ccf 100%);
    background:-ms-linear-gradient(90deg, #63b8ee 5%, #468ccf 100%);
    background:linear-gradient(180deg, #468ccf 5%, #63b8ee 100%);
    filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#468ccf', endColorstr='#63b8ee');
    /*background-color:#63b8ee;*/
  }
  .css_button:active {
    position:relative;
    top:1px;
  }

  .textbox { 
    background: white;
    font-weight:bold;
    border: 1px solid #ffa853; 
    border-radius: 3px; 
    box-shadow: 0 0 3px 1px #ffa853; 
    color: #666; 
    outline: none; 
    height:23px; 
    width: 100px; 
  } 
</style>
<aside>
  <center><h3>Prime Number</h3></center>
<div class='main'>
  <div id="range" class="oran"></div><br>
  <div id="slider-range"></div><br>
  <div id="prime_no" class="white"></div><br>
</div>
<br>
<div class='main1'>
  <form action="" method="post" onsubmit="return ck_min();">
    <div class="mgroup">
            <label for="name">Minimum Value</label>
    <input type='text' placeholder="Min Value" maxlength='5' class="textbox" name='min' id='min'  onkeyup = "if (/\D/g.test(this.value)) this.value = this.value.replace(/\D/g,'')">    
        </div>
    <div class="mgroup">
            <label for="name">Minimum Value</label>
    <input type='text' placeholder="Max Value" maxlength='5' class="textbox" name='max' id='max'  onkeyup = "if (/\D/g.test(this.value)) this.value = this.value.replace(/\D/g,'')">
        </div>
    <div class="mgroup">
            <input type='submit' class="css_button" value='Enter' name='prime'>
        </div>
  </form>
</div>
  <script type='text/javascript'>
  var minval = <?php echo $min; ?>;
  var maxval = <?php echo $max; ?>;
  $(function() {
    isPrime(minval,maxval);   
    $( "#slider-range" ).slider({
    range: true,
    min: minval,
    max: maxval,
    values: [ minval, maxval ],
    slide: function( event, ui ) {
      $( "#range" ).html( "Min No : " + ui.values[ 0 ] + " - Max No : " + ui.values[ 1 ] );
      isPrime(ui.values[ 0 ],ui.values[ 1 ]);
    }
    });
    $( "#range" ).html( "Max No : " + $( "#slider-range" ).slider( "values", 0 ) + " - Min No : " + $( "#slider-range" ).slider( "values", 1 ) );
  });
  
  function ck_min(){
    var mi = $("#min").val();
    var mx = $("#max").val();
    mi = parseInt(mi);
    mx = parseInt(mx);
    if (mi && mx) {
    
    if (mi > mx) {
     alert("Min val should be less than Max val and Max Val should be greater than Min Val");
     return false;
    }else{
     return true;
    }
    }else{
    return false;
    }
    
  }
  function isPrime(a,b) {
    var temp = new Array();   
    var x=0
      for(i=a; i<=b; i++){
    if(isPrimeno(i)){
      temp[x]=i;
      x++;
    }
    }
    var str = "Prime No : ";
    for(y=0;y<temp.length;y++){
    str += temp[y];
    if (temp.length-1>y) {
      str += " , ";
    }
    
    }
    $("#prime_no").html(str);
    
  }
  
  function isPrimeno(numb){
    for(var i=2; i<= Math.sqrt(numb); i++){
    if(numb%i ==0){
      return false;
    }
    }
    return true;
  }
  
  </script>
</aside>

MySQL IF function

MySQL IF function
Syntax: IF(expr,if_true_expr,if_false_expr)
Example:
SELECT IF(1 = 2,'true','false'); -- false
SELECT IF(1 = 1,' true','false'); -- true

MySQL Query GROUP BY day / month / year

Method I :
SELECT count('id') as cnt,order_status,order_date FROM `product_order` 
group by MONTH(order_date) 
Method II :
SELECT count('id') as cnt,order_status,order_date FROM `product_order` 
group by DATE_FORMAT(order_date, '%m')
Method III:
SELECT SQL_NO_CACHE YEAR(record_date), MONTH(record_date), COUNT(*) FROM stats 
GROUP BY YEAR(record_date)*100 + MONTH(record_date)

SELECT YEAR(date_column), MONTH(date_column), COUNT(*)
FROM date_table
GROUP BY DATE_FORMAT(date_column, '%Y%m')