Thursday, September 21, 2017

Authenticating with OAuth 2.0 For LinkedIn Api Access using PHP

LinkedIn Oauth 2.0 PHP Access

Follow these steps to enable your application to make
authenticated API calls to LinkedIn using OAuth 2.0:

Step 1: Configuring your LinkedIn application.

Create application in linkedin Developers Panel Link.

After Clicking on Create App. Fill the form information.

Once you save your configuration, your application will be assigned a unique "Client ID" and "Client Secret" value.

Step2: Using the below PHP code to get the LinkedIn access Token to access there apis

	<?php

	error_reporting(-1);
	echo " testing";

	/**
	*
	*The below is the url to get the Authorization code using our LinkedIn App Details
	*/
	$url="https://www.linkedin.com/".
	'oauth/v2/authorization?response_type=code&client_id=81vfvatntv3k0&'
	. 'redirect_uri=http://localhost/servers/link.php&state=DCEeFWf45A53sdfKef424';


	$code=$_GET['code'];
	if(isset($code)){

	$myUrl = "https://www.linkedin.com/oauth/v2/accessToken";



	$myData = array(
	'grant_type' => 'authorization_code',
	'code' => $code,
	'redirect_uri' => '********',//Redirect Url
	'client_id'=>'CLINETId',//Linkedin App Client Id
	'client_secret'=>'******'//Linkedin App Secret Key
	);

	$myHeaders = array(

	'Content-type: application/x-www-form-urlencoded'
	);

	$handle = curl_init();
	curl_setopt($handle, CURLOPT_URL, $myUrl);

	curl_setopt($handle, CURLOPT_HTTPHEADER, $myHeaders);
	curl_setopt($handle, CURLOPT_RETURNTRANSFER, true);
	curl_setopt($handle, CURLOPT_SSL_VERIFYHOST, false);
	curl_setopt($handle, CURLOPT_SSL_VERIFYPEER, false);

	curl_setopt($handle, CURLOPT_POST, true);
	//curl_setopt($handle, CURLOPT_POSTFIELDS, $myData);
	curl_setopt($handle, CURLOPT_POSTFIELDS, http_build_query($myData));

	$response = curl_exec($handle);
	$code = curl_getinfo($handle, CURLINFO_HTTP_CODE);

	print "return code = $code <br/>";
	print "response = <br/> $response <br/><br/>";



	$myRespArr = json_decode($response, true);
	print "<pre>";
	print_r($myRespArr['access_token']);
	print "</pre>";

	exit;


	}
	?>
	<html>
	<head>
	<title>Linkedin Api </title>
	</head>
	<body>
	<a href="<?php echo $url?>">Click Link
	</a>
	</body>
	</html>

view raw oauthlinkedin.php hosted with ❤ by GitHub

Friday, September 8, 2017

Reading Excel Spreadsheets with Python

Excel & Python

Reading an Excel Spreadsheet

In this section, we will look at a function that demonstrates reads the Excel sheet data and convert that data into XML file.

We Used the following libraries to do the above functionality

Openpyxl : Openpyxl is a Python library for reading and writing Excel 2010 xlsx/xlsm/xltx/xltm files.
xml.etree.ElementTree: To create the xml tree elements
datetime: to conver the date time column values to specified format

	from openpyxl import load_workbook
	import datetime

	import xml.etree.cElementTree as ET
	wb = load_workbook(filename = 'Sku Assignment 8.24 Furniture Content.xlsx')

	sheet = wb.get_sheet_by_name('Output Sheet')#sheet name

	root = ET.Element("skuProducts")

	i=0
	for rowOfCellObjects in sheet.rows:
	doc = ET.SubElement(root, "skuProduct"+str(i))
	j=0

	for cellObj in rowOfCellObjects:
	print(cellObj.coordinate, cellObj.value)
	print type(cellObj.value)

	datatype = type(cellObj.value)
	if( datatype is unicode):
	ET.SubElement(doc, cellObj.coordinate).text = cellObj.value
	elif( datatype is long):
	print int(cellObj.value)
	ET.SubElement(doc, cellObj.coordinate).text = str(int(cellObj.value))
	elif isinstance(cellObj.value, datetime.date):
	#print cellObj.value.strftime('%m/%d/%Y')
	#pass
	ET.SubElement(doc, cellObj.coordinate).text = str(cellObj.value.strftime('%m/%d/%Y'))

	else:
	print "pass"
	pass



	j=j+1

	i=i+1
	print('--- END OF ROW ---')

	tree = ET.ElementTree(root)
	tree.write("filename.xml")

view raw convert.py hosted with ❤ by GitHub

Thursday, September 7, 2017

PHP popen() Function

popen in php

Parallel processing in PHP Using popen() Function

Since PHP does not offer native threads, we have to get creative to do parallel processing.

There will be scenarios where PHP takes much time to complete a task. Example scenarios are attaching a large file and and sending an email, or processing a large video file

to make thumbnails. Imagine a user having to wait until PHP finishes the all that job.

All the heavy work might being going on at the server.

But, if a user doesn't see any activity on a page for some time, they might think that the page is not working and leave the page. In such cases, we can make use of a background process.

Example of popen as a Async processing


	<?php

	/*
	* This is the child process, it'll be launched
	* from the parent process.
	*/

	/* Do some work */
	echo "large process is running";

	?>

view raw child.php hosted with ❤ by GitHub

	<?php
	echo "\n doning the work in Main file\n";
	echo date("h:i:s");echo "\n";
	$commandName="/var/www/html/main.php"; //Provide full path of the php file
	$handle = popen('php ' . $commandName , 'r');
	echo date("h:i:s");


	?>

view raw main.php hosted with ❤ by GitHub

Make popen as synchronous

The below code will wait until child process completed.

echo date("h:i:s");echo "\n";
$ph = popen('php ' . $commandName , 'r') or die($php_errormsg);
while (! feof($ph)) {
$s = fgets($ph) or die($php_errormsg);
}
pclose($ph) or die($php_errormsg);
echo date("h:i:s");echo "\n";

Friday, September 1, 2017

Install mysql-python in windows

To Enable the mysql extension related python need to run the below command

pip install mysqlclient

If you are trying to use mysqlclient on WINDOWS with this failure,

"_mysql.c(29) : fatal error C1083: Cannot open include file: 'my_config.h': N
such file or directory"

try to install the lower version instead:

pip install mysqlclient==1.3.4

Configure Apache web server for Python on Windows

Run Python script as CGI program with Apache2.4 in Windows

1. Install Python and Apache

Python: http://python.org/download/.

Apache: http://httpd.apache.org/download.cgi

2. Configure Apache to run Python CGI

The next step is to edit ‘httpd.conf’ apache configuration file located in the apache
install directory in the conf directory.

Uncomment the below line
#LoadModule cgi_module modules/mod_cgi.so

After Uncomment
LoadModule cgi_module modules/mod_cgi.so

Search the httpd.conf file for the line

Options Indexes FollowSymLinks

Add ExecCGI to the end of the line. After adding total line looks like below

Options Indexes FollowSymLinks ExecCGI

Next, search for the following:

#AddHandler cgi-script .cgi

Uncomment this line by removing the # in front of the line,
and add a .py to the end of the line. The new line should look like this:

AddHandler cgi-script .cgi .py

Search for the line: ScriptAlias /cgi-bin/ /whatever-path/ – when you find it,
comment out the line: that is add a # in front of the line:
(or)Other wise add the below line

ScriptAlias /cgi-bin/ "C:/Apache2.4/cgi-bin/"

3. Restart Apache

4. Run the sample python file

Here is an example assuming Python is installed in the C:\Python27 location

	#!/Python27/python.exe


	print("Content-type: text/html")
	print("")
	print("<html><head>")
	print("")
	print("</head><body>")
	print("Hello from Python27 .")
	print("</body></html>")

view raw test.py hosted with ❤ by GitHub

Save this file as test.py to your htdocs folder under your apache installation directory.
Open your web browser and type in your apache host
(and :port if the port is something other than 80) followed by test.py,
for example: http://localhost/test.py

PHP Array insert, delete, view operation using php array functions

PHP Array Functions

Insert the array element, View the array values and delete the array value using php array functions

Function Name	Description
array_search()	Searches an array for a given value and returns the key
array_splice()	Removes and replaces specified elements of an array

Sample php array functions code

	<?php
	class arrayFunctions{

	public $dialedCustomers;

	function __construct($array) {
	$this->dialerCustomersCount=$array;

	}

	public function getValue(){
	var_dump($this->dialerCustomersCount);
	}

	public function insertData($value)
	{
	$this->dialerCustomersCount[]=$value;

	}
	public function checkValue($searchValue)
	{
	return array_search($searchValue, $this->dialerCustomersCount);

	}
	public function deleteValue($deleteIndex){
	array_splice($this->dialerCustomersCount, $deleteIndex, 1);

	}

	}

	$input = array("red", "green", "blue", "yellow");
	$values= new arrayFunctions($input);

	$values->insertData("57@1000");
	$values->getValue();


	//checking the value

	$status=$values->checkValue("green");
	$values->getValue();
	if($status != false){
	$values->deleteValue($status);
	$values->getValue();
	}

view raw array.php hosted with ❤ by GitHub

Lamp MAK

Thursday, September 21, 2017

Authenticating with OAuth 2.0 For LinkedIn Api Access using PHP

Authenticating with OAuth 2.0 For LinkedIn Api Access using PHP

Follow these steps to enable your application to make
authenticated API calls to LinkedIn using OAuth 2.0:

Friday, September 8, 2017

Reading Excel Spreadsheets with Python

Reading an Excel Spreadsheet

Thursday, September 7, 2017

PHP popen() Function

Parallel processing in PHP Using popen() Function

Example of popen as a Async processing

Make popen as synchronous

Friday, September 1, 2017

Install mysql-python in windows

Configure Apache web server for Python on Windows

Run Python script as CGI program with Apache2.4 in Windows

PHP Array insert, delete, view operation using php array functions

PHP Array Functions

Sample php array functions code

Blog Archive

About Me

Thursday, September 21, 2017

Authenticating with OAuth 2.0 For LinkedIn Api Access using PHP

Authenticating with OAuth 2.0 For LinkedIn Api Access using PHP

Follow these steps to enable your application to makeauthenticated API calls to LinkedIn using OAuth 2.0:

Friday, September 8, 2017

Reading Excel Spreadsheets with Python

Reading an Excel Spreadsheet

Thursday, September 7, 2017

PHP popen() Function

Parallel processing in PHP Using popen() Function

Example of popen as a Async processing

Make popen as synchronous

Friday, September 1, 2017

Install mysql-python in windows

Configure Apache web server for Python on Windows

Run Python script as CGI program with Apache2.4 in Windows

PHP Array insert, delete, view operation using php array functions

PHP Array Functions

Sample php array functions code

Follow these steps to enable your application to make
authenticated API calls to LinkedIn using OAuth 2.0: