Thursday, 14 May 2015

How to view Docuement via Google ?


function google_docview($file_path,$file_name)
{
$file_location=$file_path.$file_name;
echo '<iframe  src="https://docs.google.com/gview?url='.$file_location.'&amp;embedded=true" style="width:100%; height:800px; text-align:center;" frameborder="0"></iframe>';
}

Example
/*
$file_path="sscet.comli.com/L_NOTES/";
$file_name="_1378281542_notes.docx";
google_docview($file_path,$file_name);
*/

Tuesday, 28 April 2015

Difference between On Delete Cascade & On Update Cascade in mysql

My Parent Table
CREATE TABLE parent (
    id INT NOT NULL,
    PRIMARY KEY (id)
) ENGINE=INNODB;
1)

CREATE TABLE child (
    id INT, 
    parent_id INT,
    INDEX par_ind (parent_id),
    FOREIGN KEY (parent_id) 
        REFERENCES parent(id)
        ON DELETE CASCADE
) ENGINE=INNODB;

2)

CREATE TABLE child (
    id INT, 
    parent_id INT,
    INDEX par_ind (parent_id),
    FOREIGN KEY (parent_id) 
        REFERENCES parent(id)
        ON UPDATE CASCADE
) ENGINE=INNODB;

3)

CREATE TABLE child (
        id INT, 
        parent_id INT,
        INDEX par_ind (parent_id),
        FOREIGN KEY (parent_id) 
            REFERENCES parent(id)
            ON UPDATE CASCADE ON DELETE CASCADE
    ) ENGINE=INNODB;

What do these queries (1,2 & 3) mean?? Are they same???

1) means that if the parent is deleted, the child is also deleted 

2) means that if the parent primary key is changed, the child value will also change to reflect that - again in my opinion, not a great idea. If you're changing PRIMARY KEYs with any regularity (or even at all), there's something wrong with your design.

3) Means that if you update or delete the parent, the change is cascaded to the child.

Saturday, 18 April 2015

what is the use of time_sleep_until() function in php ?

The time_sleep_until() function delays execution of the current script until the specified time.

Syntax
time_sleep_until(timestamp)

Example 

Delay the execution of the current script until 10 seconds:

<?php
// wake up ten seconds from now
time_sleep_until(time()+10);
?>

What is the use of sleep() function ?

The sleep() function delays execution of the current script for a specified number of seconds.

Example 
<?php
echo date('h:i:s') . "<br>";

//sleep for 5 seconds
sleep(5);

//start again
echo date('h:i:s');
?>

Friday, 17 April 2015

Inviting facebook friends to your website using javascript SDK

Hi guys,

Today I am going to share some interesting news.  Now a days everyone having a website but they dont know how to market it. I am going to share how to send a invitation about your website to your facebook friends.


Here we follow only 5 Steps

Step 1 : you have to create a application in facebook  – https://developers.facebook.com/apps 
Step 2: After creating facebook application – get your facebook app id 
Step 3 : Insert this  sdk before head tag

<script src="http://connect.facebook.net/en_US/all.js"></script>

Step 4 :

Insert this javascript code in your web page

FB.init({
 appId:'your app id', cookie:true, status:true, xfbml:true
 });
function FacebookInviteFriends()
{
FB.ui({ method: 'send',name: 'Complete Web Tutorials - PHP, Mysql, Ajax, Jquery, HTML, CSS, facebook, twitter',link: 'http://w3lessons.info', description: 'your website description', picture: 'http://w3lessons.info/demo/web2.0.jpg'});
}

Step 5: call the facebookinvitefriends function via this link

<a href="#" onclick="FacebookInviteFriends();">Bring Your Friends</a>

thats it man.. you are done!! Finally Message will appear in your friends inbox like this



Referece Website : 
http://w3lessons.info/2012/10/15/inviting-facebook-friends-to-your-website-using-javascript-sdk/

Place Autocomplete Address Form using google api

Place Autocomplete Address Form
Street address
City
State Zip code
Country

Source

<!DOCTYPE html>
<html>
  <head>
    <title>Place Autocomplete Address Form</title>
    <meta name="viewport" content="initial-scale=1.0, user-scalable=no">
    <meta charset="utf-8">
    <style>
      html, body, #map-canvas {
        height: 100%;
        margin: 0px;
        padding: 0px
      }
    </style>
    <link type="text/css" rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto:300,400,500">
    <script src="https://maps.googleapis.com/maps/api/js?v=3.exp&signed_in=true&libraries=places"></script>
    <script>
// This example displays an address form, using the autocomplete feature
// of the Google Places API to help users fill in the information.

var placeSearch, autocomplete;
var componentForm = {
  street_number: 'short_name',
  route: 'long_name',
  locality: 'long_name',
  administrative_area_level_1: 'short_name',
  country: 'long_name',
  postal_code: 'short_name'
};

function initialize() {
  // Create the autocomplete object, restricting the search
  // to geographical location types.
  autocomplete = new google.maps.places.Autocomplete(
      /** @type {HTMLInputElement} */(document.getElementById('autocomplete')),
      { types: ['geocode'] });
  // When the user selects an address from the dropdown,
  // populate the address fields in the form.
  google.maps.event.addListener(autocomplete, 'place_changed', function() {
    fillInAddress();
  });
}

// [START region_fillform]
function fillInAddress() {
  // Get the place details from the autocomplete object.
  var place = autocomplete.getPlace();

  for (var component in componentForm) {
    document.getElementById(component).value = '';
    document.getElementById(component).disabled = false;
  }

  // Get each component of the address from the place details
  // and fill the corresponding field on the form.
  for (var i = 0; i < place.address_components.length; i++) {
    var addressType = place.address_components[i].types[0];
    if (componentForm[addressType]) {
      var val = place.address_components[i][componentForm[addressType]];
      document.getElementById(addressType).value = val;
    }
  }
}
// [END region_fillform]

// [START region_geolocation]
// Bias the autocomplete object to the user's geographical location,
// as supplied by the browser's 'navigator.geolocation' object.
function geolocate() {
  if (navigator.geolocation) {
    navigator.geolocation.getCurrentPosition(function(position) {
      var geolocation = new google.maps.LatLng(
          position.coords.latitude, position.coords.longitude);
      var circle = new google.maps.Circle({
        center: geolocation,
        radius: position.coords.accuracy
      });
      autocomplete.setBounds(circle.getBounds());
    });
  }
}
// [END region_geolocation]

    </script>

    <style>
      #locationField, #controls {
        position: relative;
        width: 480px;
      }
      #autocomplete {
        position: absolute;
        top: 0px;
        left: 0px;
        width: 99%;
      }
      .label {
        text-align: right;
        font-weight: bold;
        width: 100px;
        color: #303030;
      }
      #address {
        border: 1px solid #000090;
        background-color: #f0f0ff;
        width: 480px;
        padding-right: 2px;
      }
      #address td {
        font-size: 10pt;
      }
      .field {
        width: 99%;
      }
      .slimField {
        width: 80px;
      }
      .wideField {
        width: 200px;
      }
      #locationField {
        height: 20px;
        margin-bottom: 2px;
      }
    </style>
  </head>

  <body onload="initialize()">
    <div id="locationField">
      <input id="autocomplete" placeholder="Enter your address"
             onFocus="geolocate()" type="text"></input>
    </div>

    <table id="address">
      <tr>
        <td class="label">Street address</td>
        <td class="slimField"><input class="field" id="street_number"
              disabled="true"></input></td>
        <td class="wideField" colspan="2"><input class="field" id="route"
              disabled="true"></input></td>
      </tr>
      <tr>
        <td class="label">City</td>
        <td class="wideField" colspan="3"><input class="field" id="locality"
              disabled="true"></input></td>
      </tr>
      <tr>
        <td class="label">State</td>
        <td class="slimField"><input class="field"
              id="administrative_area_level_1" disabled="true"></input></td>
        <td class="label">Zip code</td>
        <td class="wideField"><input class="field" id="postal_code"
              disabled="true"></input></td>
      </tr>
      <tr>
        <td class="label">Country</td>
        <td class="wideField" colspan="3"><input class="field"
              id="country" disabled="true"></input></td>
      </tr>
    </table>
  </body>

</html>

Reference URL:
http://ubilabs.github.io/geocomplete/


Wednesday, 1 April 2015

What is the use of preventDefault() ?



The event.preventDefault() method stops the default action of an element from happening.