How to find difference between two date in php

$beginDate = date("Y-m-d");
$endDate = "2011-10-30";

echo daysDifference($endDate, $beginDate);

function daysDifference($endDate, $beginDate)
{

   //explode the date by "-" and storing to array
   $date_parts1=explode("-", $beginDate);
   $date_parts2=explode("-", $endDate);
   //gregoriantojd() Converts a Gregorian date to Julian Day Count
   $start_date=gregoriantojd($date_parts1[1], $date_parts1[2], $date_parts1[0]);
   $end_date=gregoriantojd($date_parts2[1], $date_parts2[2], $date_parts2[0]);
   return $end_date - $start_date;                     
}

How to Get the Current Page Name in php

<?php
function curPageName() {
 return substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1);
}

echo "The current page name is ".curPageName();
?>

How to Get the Current Page URL in PHP

<?php
function curPageURL() {
 $pageURL = 'http';
 if ($_SERVER["HTTPS"] == "on") {$pageURL .= "s";}
 $pageURL .= "://";
 if ($_SERVER["SERVER_PORT"] != "80") {
  $pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"];
 } else {
  $pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];
 }
 return $pageURL;
}
?>

<?php
  echo curPageURL();
?>

Submit Form without Refreshing Page with Jquery

Contact.html

<div id="preview"> </div>
<div id="formbox">
<form id="form" action="submit.php" method="post">
Name
<input type="text" name="name" />
Email
<input type="text" name="email" />
Message
<textarea name="message"></textarea>
<input type="submit" value="Submit">
</form>
</div>

Contacts

Table contains name, email, message and created data etc.

CREATE TABLE `contact` (
`id` int(11) AUTO_INCREMENT PRIMARY KEY,
`name` varchar(255) UNIQUE KEY,
`email` varchar(100),
`message` text UNIQUE KEY,
`created_date` int(11),
)

submit.php

Contails simple PHP code. Inserting values into contacts table.

<?php
include("db.php");
if($_SERVER["REQUEST_METHOD"] == "POST")
{
$name=mysql_real_escape_string($_POST['name']);
$email=mysql_real_escape_string($_POST['email']);
$message=mysql_real_escape_string($_POST['message']);
if(strlen($name)>0 && strlen($email)>0 && strlen($message)>0)
{
$time=time();
mysql_query("INSERT INTO contact (name,email,message,created_date) VALUES('$name','$email','$message','$time')");
echo "<h2>Thank You !</h2>";
}
}
?>

Validate Plugin

Here the collaboration of jQuery validate and form plug-in.

<script type="text/javascript" src="http://ajax.googleapis.com/
ajax/libs/jquery/1.5/jquery.min.js"></script>
<script type="text/javascript" src="jquery.form.js"></script>
<script type="text/javascript" src="jquery.validate.js"></script>
<script type="text/javascript">
$('document').ready(function()
{
$('#form').validate(
{
rules:
{
"name":{
required:true,
maxlength:40
},
"email":{
required:true,
email:true,
maxlength:100
},
"message":{
required:true
}},

messages:
{
"name":{
required:"This field is required"
},
"email":{
required:"This field is required",
email:"Please enter a valid email address"
},
"message":{
required:"This field is required"
}},

submitHandler: function(form){
$(form).ajaxSubmit({
target: '#preview',
success: function() {
$('#formbox').slideUp('fast');
}
});
}

})
});
</script>

db.php

PHP database configuration file

<?php
$mysql_hostname = "Host name";
$mysql_user = "UserName";
$mysql_password = "Password";
$mysql_database = "Database Name";
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database");
mysql_select_db($mysql_database, $bd) or die("Could not select database");
?>

Convert seconds to Hour:Minute:Second in php

<?php

$init = 685;
$hours = floor($init / 3600);
$minutes = floor(($init / 60) % 60);
$seconds = $init % 60;

echo "$hours:$minutes:$seconds";
?>

How to CONVERT seconds to minutes in php

<?
$seconds = "150";
$minutes = floor($seconds/60);
$secondsleft = $seconds%60;
if($minutes<10)
    $minutes = "0" . $minutes;
if($secondsleft<10)
    $secondsleft = "0" . $secondsleft;
echo "$minutes:$secondsleft minutes";
?>

In Datagrid Pagination and Sorting with Ajax in PHP

                                                                         Index.php

<style>
.selected{
    color:#F00;
    font-weight:bold;
    background-color:#09F;
}
.selected a{
    color:#FFF;
}
.not_selected{
    color:#000;
    background-color:#F9F;
}
.not_selected a{
    color:#FFF;
}
th{
    background-color:#FFC;
    text-align:center;
}
</style>
<script>
window.onload= function()
{
    Ajax("1","id","DESC");
}

function Ajax(Page,Field,Ord)
{
    var xmlhttp;
    if(window.XMLHttpRequest)
    {
        xmlhttp = new XMLHttpRequest();
    }else
    {
        alert("Browser Not Support");
        return false;
    }
   
    xmlhttp.onreadystatechange = function()
    {
        if(xmlhttp.readyState==4)
        {
            document.getElementById("data").innerHTML = xmlhttp.responseText;
        }
    }
    xmlhttp.open("POST","data.php?page="+Page+"&fld="+Field+"&ord="+Ord,true);
    xmlhttp.send();
}
</script>
<div id="data"></div>

                                                                data.php

<?php

mysql_connect("localhost","root","") or die("Connection Error".mysql_error());
mysql_select_db("exam") or die("Database Connection Error".mysql_error());


$sql = "SELECT * FROM admin";
$rs = mysql_query($sql) or dir("Select Error.".mysql_error());
$count = mysql_num_rows($rs);

$per_page = 2;
if($_GET['page'])
{
    $page = $_GET['page'];
}else
{
    $page = 1;
}
$pages = $count;
$pages = ceil($pages/$per_page);

if($_GET['ord']=="DESC" && $_GET['fld']!="id")
{
    $ord = "ASC";
}else
{
    $ord = "DESC";
   
}
if($_GET['fld']=="uname")
{
    $order_by = $_GET['fld'];
}else
{
    $order_by = "id";
}

$sql2 = "SELECT * FROM admin order by ".$order_by." ".$ord." LIMIT " . (($page - 1) * $per_page) . ", $per_page";
$rs2 = mysql_query($sql2) or dir("Select Error.".mysql_error());

?>
    <table width="40%" cellpadding="2" cellspacing="2" border="1">
        <tr>
            <th><a href="Javascript:Ajax(<?=$_GET['page'];?>,'uname','<?=$ord;?>')">Firstname</a></th>
            <th>Lastname</th>
            <th>Password</th>
           </tr>
<?
while($row=mysql_fetch_array($rs2))
{
    extract($row);
    ?>
    <tr>
        <td><?=$uname;?></td>
        <td><?=$lname;?></td>
        <td><?=$pass;?></td>
    </tr>
    <?
}
?>
</table>
<?php
if($count>$per_page)
{
    ?>
    <table width="5%" cellpadding="2" cellspacing="2" border="1"><tr><?
for($i=1;$i<=$pages;$i++)
{
    ?>
    <td <?php if($i==$page){ ?>class="selected"<? }else{ ?>class="not_selected"<? } ?>  ><a href="Javascript:Ajax(<?=$i;?>,'<?=$order_by;?>','<?=$ord;?>')"><?=$i;?></a></td>
    <?
}
?>
</tr></table>

    <?
}
?> 

Submit a Form without Refreshing page with jQuery and Ajax.

  jQuery and Ajax script take a look at dataString

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.0/jquery.min.js"></script>
<script type="text/javascript" >
$(function() {
$(".submit").click(function() {
var name = $("#name").val();
var username = $("#username").val();
var password = $("#password").val();
var gender = $("#gender").val();
var dataString = 'name='+ name + '&username=' + username + '&password=' + password + '&gender=' + gender;

if(name=='' || username=='' || password=='' || gender=='')
{
$('.success').fadeOut(200).hide();
$('.error').fadeOut(200).show();
}
else
{
$.ajax({
type: "POST",
url: "join.php",
data: dataString,
success: function(){
$('.success').fadeIn(200).show();
$('.error').fadeOut(200).hide();
}
});
}
return false;
});
});
</script>

HTML Code

<form method="post" name="form">
<ul><li>
<input id="name" name="name" type="text" />
</li><li>
<input id="username" name="username" type="text" />
</li><li>
<input id="password" name="password" type="password" />
</li><li>
<select id="gender" name="gender">
<option value="">Gender</option>
<option value="1">Male</option>
<option value="2">Female</option>
</select>
</li></ul>
<div >
<input type="submit" value="Submit" class="submit"/>
<span class="error" style="display:none"> Please Enter Valid Data</span>
<span class="success" style="display:none"> Registration Successfully</span>
</div></form>

join.php

<?php
if($_POST)
{
$name=$_POST['name'];
$username=$_POST['username'];
$password=$_POST['password'];
$gender=$_POST['gender'];
mysql_query("SQL insert statement.......");
}else { }

?>

Jquery Submit() method Example

$('#formid').submit(function() {
  alert('I am submitted');
  return false;
});

<!DOCTYPE html>
<html>
<head>
<script src="http://code.jquery.com/jquery-latest.js"></script>
 
</head>
<body>
<div id="container">
 
  <form action="submit.php">
    <div>
      <input type="submit" />
    </div>
  </form>
  <span></span>
<script>
 
    $("form").submit(function() {
      alert("This is a submit");
       return false;
    });
</script>
</div>
</body>
</html> 

Very simple PHP pagination

$per_page = 1;
$page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
$pages = implode(mysql_fetch_assoc(mysql_query("SELECT COUNT(*) FROM register")));
$pages = ceil($pages / $per_page);
$querystring = "";
foreach ($_GET as $key => $value) {
    if ($key != "page") $querystring .= "$key=$value&amp;";
}
echo "Pages: ";
for ($i = 1; $i <= $pages; $i++) {
    echo "<a " . ($i == $page ? "class=\"selected\" " : "");
    echo "href=\"?{$querystring}page=$i";
    echo "\">$i</a> ";
}
$result = mysql_query("SELECT * FROM register LIMIT " . (($page - 1) * $per_page) . ", $per_page");


echo "<table border='1'>
<tr>
<th>Username</th>
<th>Address</th>
<th>Area</th>
<th>Email</th>
<th>City</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['uname'] . "</td>";
  echo "<td>" . $row['address'] . "</td>";
  echo "<td>" . $row['area'] . "</td>";
  echo "<td>" . $row['email'] . "</td>";
  echo "<td>" . $row['city'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);

How to get time from seconds in php

 <?php 
function Sec2Time($time){
  if(is_numeric($time)){
    $value = array(
      "years" => 0, "days" => 0, "hours" => 0,
      "minutes" => 0, "seconds" => 0,
    );
    if($time >= 31556926){
      $value["years"] = floor($time/31556926);
      $time = ($time%31556926);
    }
    if($time >= 86400){
      $value["days"] = floor($time/86400);
      $time = ($time%86400);
    }
    if($time >= 3600){
      $value["hours"] = floor($time/3600);
      $time = ($time%3600);
    }
    if($time >= 60){
      $value["minutes"] = floor($time/60);
      $time = ($time%60);
    }
    $value["seconds"] = floor($time);
    return (array) $value;
  }else{
    return (bool) FALSE;
  }
}

/* How To Use */
$array = Sec2Time(185);

echo "<pre>";
print_r($array); 

?>
///////// OUTPUT ///////

Array
(
    [years] => 0
    [days] => 0
    [hours] => 0
    [minutes] => 3
    [seconds] => 5
)

How to use PUSH in Javascript

<select name="sub_cat_id" id="sub_cat_id"  multiple="multiple">
                <option value="1">Dhirendra</option>
                <option value="2">Prashant</option>
                <option value="3">Darshak</option>
</select>

var combo1 = document.getElementById("sub_cat_id");
var len = combo1.length
        var i
        var chosen = new Array();
        var j=0;
        for (i = 0; i < len; i++) {
        if (combo1[i].selected) {
        chosen.push(combo1[i].value)
       
        }
        }

Automatic Logout after 1 minutes of inactive PHP

Logout after 1 minutes.

$_SESSION['last_click']=time();
if(($_SESSION['last_click'] + 1*60) < time())
{
session_destroy();
header("location:index.php");
}

Display data dynamically in Matrix form using PHP

<?php
    $i="";
    $display_columns = 3;
    $sqlm="SELECT * FROM tr_teams ORDER BY id";
    $rsm=mysql_query($sqlm) or die("Database Error".mysql_error());
    $count = mysql_num_rows($rsm);
    $padding = ($display_columns-1)-(($count-1)%$display_columns);                 
             
    echo '<table width="90%" class="plan">';
    while($row=mysql_fetch_array($rsm))
    { 
        if($i%$display_columns == 0)
            echo '<tr>';
            echo '<td>';                      
          
            echo $row['team_name'];
          
            echo '</td>';
             
        if($i%$display_columns == $display_columns-1)
            echo '</tr>';
            $i++;
    }
        if($padding!=0)
        { 
            for($i=0;$i<$padding;$i++)
                echo '<td></td>';
                echo '</tr>';
        }
    echo '</table>';
?>    

How to Get Parameters Values in HTML with Javascript

<a href="get.html?name=Dhirendra">Test</a>
<SCRIPT LANGUAGE=JAVASCRIPT TYPE="TEXT/JAVASCRIPT">

function gup( name )
{
  name = name.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
  var regexS = "[\\?&]"+name+"=([^&#]*)";
  var regex = new RegExp( regexS );
  var results = regex.exec( window.location.href );
  if( results == null )
    return "";
  else
    return results[1];
}
var frank_param = gup( 'name' );
//alert(frank_param);
document.write(frank_param);
</script>