Python Cheat Sheet

Python Cheat Sheet

Connect to Microsoft SQL Server Using PHP

Connect to Microsoft SQL Server Using PHP

Below Code will connect to the Microsoft Sql Server using php script.

Authenticating with OAuth 2.0 For LinkedIn Api Access using PHP

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

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 

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

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";

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



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