Wednesday, 15 July 2015

Remove file extension from url using htaccess ?

RewriteEngine on 
RewriteCond %{REQUEST_FILENAME} !-d 
RewriteCond %{REQUEST_FILENAME}\.php -f 
RewriteRule ^(.*)$ $1.php

How to get Duplicate Record From Mysql Database ?

Use this query to get duplicate record-

SELECT mobile, count(id) as total_count FROM servicecall
GROUP BY mobile HAVING total_count > 1

Wednesday, 8 July 2015

How to set multiple google maps on single web page using javascript ?

script type="text/javascript" src="http://maps.googleapis.com/maps/api/js?sensor=true"></script>


<script type="text/javascript">
// Enable the visual refresh
google.maps.visualRefresh = true;
// Set the Map variable
var map;
var infowindow = new google.maps.InfoWindow();
function initialize() {
var myOptions = {
zoom: 8,
mapTypeControl: true,
scrollwheel: true,
streetViewControl : true,
mapTypeId: google.maps.MapTypeId.ROADMAP,
styles:[
{ featureType: "water", stylers: [ { color: "#8DC4E1", hue: 0.1 } ] },
{ featureType: "landscape.natural", stylers: [ { color: "#F4F3EF", lightness: +100 } ] },
{ featureType: "road.local", stylers: [ { color: "#FFF" } ] }
],
};
var all = [
["4605 S Tamiami Trail, Sarasota, FL 34231, USA", "27.287359", "-82.530634"],
["8519 state road 70 east bradenton fl 34211", "27.439685", "-82.452375"],
];
var infoWindow = new google.maps.InfoWindow;
map = new google.maps.Map(document.getElementById('map_canvas'), myOptions);
map1 = new google.maps.Map(document.getElementById('map_canvas1'), myOptions);
// Set the center of the map
var pos = new google.maps.LatLng(27.287359, -82.530634);
var pos1 = new google.maps.LatLng(27.439685, -82.452375);
map.setCenter(pos);
map1.setCenter(pos1);
function closeinfocallback(infowindow)
{
return infowindow.close();
}
function infoCallback(infowindow, marker,map)
{
return function() {
infowindow.open(map, marker);
};
}
function setMarkers(map, all,i)
{

var name = all[i][0];
var lat = all[i][1];
var lng = all[i][2];
var latlngset;
latlngset = new google.maps.LatLng(lat, lng);
var marker = new google.maps.Marker({
position: latlngset,
map: map,
});
var content = '<div class="map-content"><h3>' + name + '</h3></div>';
var infowindow = new google.maps.InfoWindow();
infowindow.setContent(content);
google.maps.event.addListener(marker, 'click', infoCallback(infowindow, marker,map));

}
// Set all markers in the all variable
setMarkers(map, all,'0');
setMarkers(map1, all,'1');
}
// Initializes the Google Map
google.maps.event.addDomListener(window, 'load', initialize);
</script>




<div id="map_canvas1" style="height: 300px; width: 100%;">  </div>

<div id="map_canvas" style="height: 300px; width: 100%;">  </div>

Tuesday, 7 July 2015

How to send mail using PHP ?

You can use this Script to send mail !

$headers = "From: Company name<info@domainname.com>\r\n" .
"Reply-to: Customer<info@domainname.com>\r\n" .
'X-Mailer: PHP/' . phpversion() . "\r\n" .
"MIME-Version: 1.0\r\n" .
"Content-Type: text/html; charset=utf-8\r\n" .
"Content-Transfer-Encoding: 8bit\r\n\r\n";
$subject="Service Invoice";

$to ="amit******@gmail.com";
mail($to,"Subject","Test Mail" ,$headers);

Saturday, 4 July 2015

What is SSL ?

Secure Sockets Layer (SSL). cryptographic protocols which provide secure communications on the Internet.


How we can increase the execution time of a PHP script ?


I have given you some function using them you can increase the execution time of a PHP script.Default time for execution of a PHP script is 30 seconds.These are -

1.set_time_limit()//change execution time temporarily.

2.ini_set()//change execution time temporarily.

3. By modifying `max_execution_time' value in PHPconfiguration(php.ini) file.//change execution time permanent.

Tuesday, 30 June 2015

How to check cURL enabled or disabled ?

You can use this script to get CURL status..

<?php
echo 'Curl: ', function_exists('curl_version') ? 'Enabled' : 'Disabled';
?>

What is cURL and how use ?

cURL is a library that lets you make HTTP requests in PHP. Everything you need to know about it (and most other extensions) can be found in the PHP manual.


How to use :-

The first Curl script we are going to look at is the simplest Curl script that is actually useful - it will load a web page, retrieve the contents, then print it out. So, keeping the four-step Curl process in mind, this equates to:

Initialise Curl

Set URL we want to load

Retrieve and print the URL

Close Curl

Here is how that looks in PHP code:

<?php
    $curl = curl_init();
    curl_setopt ($curl, CURLOPT_URL, "http://www.php.net");
    curl_exec ($curl);
    curl_close ($curl);
?> 

How To make sub-string in PHP ?

string substr ( string $string , int $start [, int $length ] )

Returns the portion of string specified by the start and length parameters.

<?php
echo substr('abcdef', 1);     // bcdef
echo substr('abcdef', 1, 3);  // bcd
echo substr('abcdef', 0, 4);  // abcd
echo substr('abcdef', 0, 8);  // abcdef
echo substr('abcdef', -1, 1); // f

?>

Monday, 22 June 2015

PHP Date Function Some days previous

Use the strtotime method provided by PHP.

<?php

echo date('Y-m-d', strtotime('-5 days')); // It shows 5 days previous date

echo date('Y-m-d', strtotime('+5 days')); // It shows 5 days Next date

?>