Wednesday, 31 August 2016

How To Type Hindi in HTML page

Here The code for hindi typing into a HTML tag..

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<script type="text/javascript" src="https://www.google.com/jsapi">
</script>
<script type="text/javascript">

// Load the Google Transliterate API
google.load("elements", "1", {
packages: "transliteration"
});

function onLoad() {
var options = {
sourceLanguage:
google.elements.transliteration.LanguageCode.ENGLISH,
destinationLanguage:
[google.elements.transliteration.LanguageCode.HINDI],
shortcutKey: 'ctrl+g',
transliterationEnabled: true
};

// Create an instance on TransliterationControl with the required
// options.
var control =
new google.elements.transliteration.TransliterationControl(options);

// Enable transliteration in the textbox with id
// 'transliterateTextarea'.
control.makeTransliteratable(['transliterateTextarea']);
control.makeTransliteratable(['transliterateTextarea2']);
}
google.setOnLoadCallback(onLoad);
</script>
</head>
<body>
Type in Hindi (Press Ctrl+g to toggle between English and Hindi)<br>
<textarea id="transliterateTextarea" style="width:600px;height:200px"></textarea>
<input type="text" id="transliterateTextarea2" name="sunil">
</body>
</html>

Friday, 11 December 2015

Show clock using PHP

Show Current Time On Webpage Using PHP with Javascript

Timer Function:-

function ajaxcall(){

$.ajax({

url: 'getTime.php',

success: function(data) {

data = data.split(':');

$('#hours').html(data[0]);

$('#minutes').html(data[1]);

$('#seconds').html(data[2]);

}

});

}

setInterval('ajaxcall()',1000);

</script>

gettime.php

<?php

date_default_timezone_set('Asia/Calcutta');

echo $date = date('h:i:s A');

Friday, 28 August 2015

How to upload large amount of data within seconds into mysql database USING csv file

Using this php script you can upload thousands of record within a second

1. HTML form for upload csv file -

<form name="import" method="post" enctype="multipart/form-data">
        <input type="file" name="file" /><br />
        <input type="submit" name="submit" value="Submit" />
    </form>

2. PHP Script FOr Execution -
<?php
    $con = mysql_connect('localhost','root','123456'); //database Connections
if(!$con){die(mysql_error());
}
else
{
mysql_select_db('test',$con);
}


    if(isset($_POST["submit"]))
    {
$status=2;
move_uploaded_file($_FILES["file"]["tmp_name"],
      "/var/www/html/importviaexcel/upload/" . $_FILES["file"]["name"]);
    $file_path="/var/www/html/importviaexcel/upload/" . $_FILES["file"]["name"]; //file & folder name Where csv uploaded

echo "My file - ".$file_path;
$table="csv";
$fp = file("$file_path");
$total_count=count($fp);
echo "Total record - ".count($fp);
$sql_load =     " LOAD DATA INFILE '".$file_path."'" .
            "IGNORE INTO TABLE " . $table .
            " FIELDS TERMINATED BY " . "','" .
            // " LINES TERMINTED BY " . "\r\n" .
            " IGNORE 1 LINES
            ( @no,@name,@mobile,@email)
            set
            no = @no,
            name = @name,
            mobile = @mobile,
            email = @email,
            status = '2'
            ";

$result = mysql_query($sql_load, $con);

$upload_rec=mysql_affected_rows();
$duplicate=$total_count-$upload_rec;
echo "Total - $total_count </br>Upload - $upload_rec </br> duplicate - $duplicate ";


    }
?>

Hope it will Helpful for you.

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>

// 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>

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';
?>