Monday, October 16, 2017
Friday, October 6, 2017
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| $serverName = "*****.*****.****.**";//Host Name | |
| $uid = "mtcdb";//User Name | |
| $pwd = "******";//Password | |
| $databaseName = "Mobile_Dev";//Database Name | |
| $connectionInfo = array("UID" => $uid, | |
| "PWD" => $pwd, | |
| "Database" => $databaseName); | |
| /* Connect using SQL Server Authentication. */ | |
| $conn = sqlsrv_connect($serverName, $connectionInfo); | |
| if( $conn ) | |
| { | |
| echo "Connected"; | |
| } | |
| else | |
| { | |
| echo "<pre>"; | |
| die( print_r( sqlsrv_errors(), true)); | |
| } | |
| //var_dump($conn);exit; | |
| $tsql = "SELECT * FROM users"; | |
| /* Execute the query. */ | |
| $stmt = sqlsrv_query($conn, $tsql); | |
| if ($stmt) { | |
| echo "Statement executed.<br>\n"; | |
| } else { | |
| echo "Error in statement execution.\n"; | |
| die(print_r(sqlsrv_errors(), true)); | |
| } | |
| /* Iterate through the result set printing a row of data upon each iteration. */ | |
| while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_NUMERIC)) { | |
| // print_r($row);exit; | |
| echo "Col1: " . $row[0] . "\n"; | |
| echo "Col2: " . $row[1] . "\n"; | |
| echo "Col3: " . $row[2] . "<br>\n"; | |
| echo "-----------------<br>\n"; | |
| } | |
| /* Free statement and connection resources. */ | |
| sqlsrv_free_stmt($stmt); | |
| sqlsrv_close($conn); |
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
 |
| 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
Step2: Using the below PHP code to get the LinkedIn access Token to access there apis
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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> | |
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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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") |
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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /* | |
| * This is the child process, it'll be launched | |
| * from the parent process. | |
| */ | |
| /* Do some work */ | |
| echo "large process is running"; | |
| ?> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?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"); | |
| ?> |
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";
$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
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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/Python27/python.exe | |
| print("Content-type: text/html") | |
| print("") | |
| print("<html><head>") | |
| print("") | |
| print("</head><body>") | |
| print("Hello from Python27 .") | |
| print("</body></html>") |
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
Subscribe to:
Posts (Atom)