Thursday, 2 May 2013

Increment date using while loop in php



 $start_date = "2013-01-01";
  $end_date = "2013-01-20";
  $next_date = $start_date;

  while(strtotime($next_date) <= strtotime($end_date))
  {
    echo "$next_date
";
    $next_date = date ("Y-m-d", strtotime("+5 day", strtotime($next_date)));
  }


Ok in for loop?


$start_date = "2013-01-01";
$end_date = "2013-01-25";
$next_date = $start_date;

for($i=0;$i<=(strtotime($next_date) <= strtotime($end_date));$i++)
{
echo "$next_date
";
$next_date = date ("Y-m-d", strtotime("+2 day", strtotime($next_date)));
}





SUM TWO TIMES IN PHP, SUM TWO TIME VALUES IN PHP

echo sum_the_time('01:45:22', '17:27:03');

function sum_the_time($time1, $time2) {
  $times = array($time1, $time2);
  $seconds = 0;
  foreach ($times as $time)
  {
    list($hour,$minute,$second) = explode(':', $time);
    $seconds += $hour*3600;
    $seconds += $minute*60;
    $seconds += $second;
  }
  $hours = floor($seconds/3600);
  $seconds -= $hours*3600;
  $minutes  = floor($seconds/60);
  $seconds -= $minutes*60;
  // return "{$hours}:{$minutes}:{$seconds}";
  return sprintf('%02d:%02d:%02d', $hours, $minutes, $seconds);


Thursday, 14 March 2013

Phonegap photoswipe with download option script



(function(window, PhotoSwipe){

document.addEventListener('DOMContentLoaded', function(){

var
options = {

getImageCaption: function(el){

var captionText, captionEl, captionTextSRC;

// Get the caption from the alt tag
if (el.nodeName === "IMG"){
captionText = el.getAttribute('alt');
captionTextSRC = el.getAttribute("src");
}
var i, j, childEl;
for (i=0, j=el.childNodes.length; i childEl = el.childNodes[i];
if (el.childNodes[i].nodeName === 'IMG'){
captionText = childEl.getAttribute('alt');
captionTextSRC = childEl.getAttribute("src");
}
}




// Return a DOM element with custom styling
captionEl = document.createElement('div');
captionEl.style.cssText = 'background: red; font-weight: bold; padding: 5px;';
captionEl.appendChild(document.createTextNode("Download"));
//console.log('JJJJJJJJJJJJ'+ captionTextSRC);
//captionEl.onclick = testing;
//var fileTransfer = new FileTransfer();
captionEl.onclick = (function() {
//navigator.notification.alert("Loasdasdsaddsdsdsdgin Successfull");
var fileTransfer = new FileTransfer();
fileTransfer.download(
    captionTextSRC,
    "file://sdcard/"+captionText,
    function(entry) {
       navigator.notification.alert("download complete: " + entry.fullPath);
    },
    function(error) {
       navigator.notification.alert("download error source " + error.source);
        navigator.notification.alert("download error target " + error.target);
        navigator.notification.alert("upload error code" + error.code);
    });

});


//captionEl.appendChild(document.createTextNode(captionText));
return captionEl;

// Alternatively you can just pass back a string. However, any HTML
// markup will be escaped

}

},
instance = PhotoSwipe.attach( window.document.querySelectorAll('#Gallery a'), options );

}, false);


}(window, window.Code.PhotoSwipe));


function testing()
{
navigator.notification.alert("Login Successfull");
}

Wednesday, 13 March 2013

SVN: Authorisation Failed

Use the below command: rm ~/.gnome2/keyrings/login.keyring

Monday, 2 July 2012

How to get the Spanish Character from URL in php?

How to get the Spanish Character from URL in php?

Use utf8_decode("string");

Tuesday, 15 November 2011

set_time_limit in php, set_time_limit in php5, why set_time_limit?

WHY set_time_limit ?
It is used to run the scripts in the file for a particular amount of time. If we just put set_time_limit(1) then the setting will allow the file to run the script for 1 second and if the time exceeds then it will throw the fatal error

Set_time_limit(0) – No time limit will be set, but I didt checked my MAX_EXECUTION_TIME, if there is still problem in the set_time_limit please check with the MAX_EXECUTION_TIME in the php.ini settings.

Let us check some examples
set_time_limit(0);
function ran()
{
$i=100000;
for ($j=0;$j<$i;$j++)
{
echo $j;
}
}
$gg=ran();
?>
>>>>> WONT THROW ANY ERROR


set_time_limit(1);
function ran()
{
$i=100000;
for ($j=0;$j<$i;$j++)
{
echo $j;
}
}
$gg=ran();
?>

>>>>>> HERE WE SET THIS TO 1 SECOND BUT THE SCRIPT NEEDS TO RUN A LOOP FOR 100000 SO IT WILL THROW THE ERROR LIKE BELOW
Fatal error: Maximum execution time of 1 second exceeded in ------------------------------------------------------------------------

Saturday, 29 October 2011

Stored procedure in MYSQL PHP / MYSQLi

Before proceeding with stored procedure, just confirm whether your server is having all the enough latest versions, please check with MYSQL for the same

While trying i found MYSQLi works well when compared to MYSQL.