Wednesday, 26 July 2017

How to disabe right click using jquery ?

Please visit below link to get solution -

http://codeforphpdevelopers.com/disable-right-click-f12-ctrlu/

Wednesday, 7 June 2017

what is cron job ? how to set it .

A cron job is a Linux command for scheduling a task to be executed sometime in the future.Cron Jobs are used for scheduling tasks to run on the server. They're most commonly used for automating system maintenance. However, they are also relevant to web application development. There are many situations when a web application may need certain tasks to run periodically such as Notification mail , newsletter etc.

Syntax : -

5 * * * * /usr/bin/php /www/codeforphp/cron/cron.php > /dev/null 2>&1 ( file path )

OR

5 * * * * php /home/codeforphp/public_html/testtt.php

OR

5 * * * * curl http://codeforphpdevelopers.com/testtt.php

NOTE : -
in windows server , you can use scheduler for cron job.

Saturday, 3 December 2016

How to send Mail using SMTP in Codeigniter ?

Please Find following php script for send mail using SMTP

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class SendMail extends CI_Controller {

public function __construct()
{
parent::__construct();

$config = Array(
'protocol' => 'smtp',
'smtp_host' => 'ssl://smtp.googlemail.com',
'smtp_port' => 465,
'smtp_user' => 'amit*******@gmail.com',
'smtp_pass' => '**********',
'mailtype' => 'html',
'charset' => 'iso-8859-1'
);
$this->load->library('email', $config);
}

public function index()
{

$this->email->from('amit@example.com', 'Amit Chouhan');
$this->email->to('to@gmail.com ');
$this->email->cc('cc@gmail.com');

$this->email->subject('Email Test');
$this->email->message('Testing the email class.');

$this->email->send();

}

}
?>

Email preferences are available at
https://www.codeigniter.com/user_guide/libraries/email.html

Thursday, 27 October 2016

How to Remove Visual Composer's shortcodes from the Post Content ?

As we need to remove Visual Composer's shortcodes from the Post Content , we need to follow the below steps -

1. put the following code in functions.php

functions.php
function get_the_post_content($postdata='')
{
$postdata1 = strip_tags(do_shortcode($postdata));
$postdata1 = trim(preg_replace('/\s+/',' ', $postdata1 ));
return $postdata1;
}

2. you can get the post content on any page by integrating the below code
page.php

<?php if( have_posts() ):

while( have_posts() ): the_post();
the_title(); // showing post title

echo get_the_post_content($post->post_content); // post content

or

echo get_the_post_content(get_the_content()); // post content

endwhile;
endif; wp_reset_query(); ?>

Wednesday, 14 September 2016

How to read excel file without uploading on server

The following code includes three columns namely as " name , contact , email " as shown the below screenshot

index.php

</div>

<tbody>

<tr>

<th>Read Excel</th>

<td>

</td>

</tr>

<tr>

<td>

</td>

</tr>

</tbody>

</table>

</div>

</div>

</div>

</div>

</div>

</form>

upload.php

<html>

<head>

<title>Read Excel File</title>

</head>

<body>

<?php

set_include_path(get_include_path() . PATH_SEPARATOR . 'Classes/');

include 'PHPExcel/IOFactory.php';

// This is the file path to be uploaded.

//$inputFileName = 'discussdesk.xlsx';

$inputFileName=$_FILES["file"]["tmp_name"];

try {

$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);

} catch(Exception $e) {

die('Error loading file "'.pathinfo($inputFileName,PATHINFO_BASENAME).'": '.$e->getMessage());

}

$allDataInSheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

$arrayCount = count($allDataInSheet); // Here get total count of row in that Excel sheet

<table>

<tr>

<th>Name</th><th>Contact</th><th>Email</th>

</tr>

<?php

for($i=2;$i<=$arrayCount;$i++){

$name = trim($allDataInSheet[$i]["A"]);

$contact=trim($allDataInSheet[$i]["B"]);

$email=trim($allDataInSheet[$i]["C"]);

<tr>

</tr>

<?php

}

</table>

<body>

</html>

you can also download the zip file of the above code..

Click Here to Download

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

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

?>

How To create Constant in PHP ?

Constants are like variables except that once they are defined they cannot be changed or undefined.

<?php

//The example below creates a constant with a case-sensitive name

define("PI", 3.14);

echo PI;

//The example below creates a constant with a case-insensitive name

define("PI", 3.14,true);

echo pi;

?>

What is variable and how to declare in php ?

Variables are "containers" for storing information.

<?php
$str = "Hello world!";
$x = 10;
$y = 15.5;
?>

NOTE : -

the variable $str will hold the value Hello world!
the variable $x will hold the value 10
and the variable $y will hold the value 15.5.

Rules for variable declaration:

A variable starts with the $ sign, followed by the name of the variable
A variable name must start with a letter or the underscore character
A variable name cannot start with a number
A variable name can only contain alpha-numeric characters and underscores (A-z, 0-9, and _ )
Variable names are case-sensitive ($age and $AGE are two different variables)