Skip to main content

Posts

Get Latitude & Longitude from address

function getLatLong($address){     $prep_addr = str_replace(' ','+',$address);     $geocode = file_get_contents('http://maps.google.com/maps/api/geocode/json?address='.$prep_addr.'&sensor=false');     $output= json_decode($geocode);     $lat = $output->results[0]->geometry->location->lat;     $long = $output->results[0]->geometry->location->lng;     return array("latitude" => $lat, "longitude" => $long); }

Read .docx file as string

I found it after googling for a day, finally a function that reads the .docx file and return you a string. Hats off to the original author of this function. function readDocx($file_name){     $striped_content = '';     $content = '';     if(!$file_name || !file_exists($file_name))         return false;     $zip = zip_open($file_name);     if (!$zip || is_numeric($zip))         return false;     while ($zip_entry = zip_read($zip)) {         if (zip_entry_open($zip, $zip_entry) == FALSE)             continue;         if (zip_entry_name($zip_entry) != "word/document.xml")             continue;         $content .= zip_entry_read($zip_entry, zip_entry_filesize($zip...

Convert object to multi dimensional array

   /**     *     * Convert an object to an array     *     * @param    object  $object The object to convert     * @reeturn      array     *     */      function  objectToArray (  $object  )     {         if( ! is_object (  $object  ) && ! is_array (  $object  ) )         {             return  $object ;         }         if(  is_object (  $object  ) )     ...

JSON array of objects

It can be a situation where you got a array of data that should be sent in the JSON format to server via ajax, then you can do the following <script type="text/javascript" > groups = ['A', 'B', 'C']; users  = ['user1', 'user2', 'user3']; //required format is  [{"group_name" : "A", "leader" : "user1"}, {"group_name" : "B", "leader" : "user2"}, {"group_name" : "C", "leader" : "user3"}] group_leaders = new Array(); len = groups.length; for(var i = 0; i < len; i++ ){     group_leaders.push({"group_name" : groups[i], "leader" : users[i]}); } alert(JSON.stringify(group_leaders)); </script> Here you can test here http://jsfiddle.net/sailesh/6wXdY/

Windows Azure SQL Database PDO

I faced a problem while trying to connect Windows Azure SQL Database from local system using PDO. Here I'm using PHP 5.4+ and Apache 2.4 on Windows 8. I didn't find better tutorial for trouble shooting. Following are the steps that explains you what to do.. Download php_pdo_sqlsrv_54_ts.dll and placed it in php/ext directory. Here you can find it http://www.microsoft.com/en-us/download/details.aspx?id=20098 Download SQLSRV30.EXE and extracted to php/ext directory Open the php/php.ini file and added the following line extension=php_pdo_sqlsrv_54_ts.dll It needs Microsoft SQL Server 2012 Native Client, to go further. So download it from http://www.microsoft.com/en-us/download/confirmation.aspx?id=29065 for 32bits(x86) http://go.microsoft.com/fwlink/?LinkID=239647&clcid=0x409 for 64bits(x64) http://go.microsoft.com/fwlink/?LinkID=239648&clcid=0x409 Restart the Apache server. Write the following code in php file to connect. $server_url = "xxxxxx...

Download file using PHP

Downloading a file can be done in two ways: Direct download Indirect download Direct Download: Assumptions: File location: c:/xampp/htdocs/project/docs/test.doc URL: http://localhost/project/docs/test.doc Code:   <a href='http://localhost/project/docs/test.doc'>click here</a> Indirect Download: (recommended) Assumptions: File location: c:/xampp/htdocs/project/docs/test.doc PHP file for the download code: location: c:/xampp/htdocs/project/download.php <?php   $file_name = $_GET['file'];   $file_path = "docs/".$file_name;  //setting the content type   header('content-type: application/octet-stream');   //downloads file as attachment   header("content-disposition: attachment; filename='$file_name'");   //actual file path   readfile($file_path); ?> Note: content-type application/octet-stream can be used for any type of file. To use the above file for download. Create link like as be...

PHP Best Practices

This guide will give you solutions to common  PHP  design problems. It also provides a sketch of an application layout that I developed during the implementation of some  project s. php .ini quirks Some settings in the  php .ini control how  PHP  interpretes your scripts. This can lead to unexpected behaviour when moving your application from development to the productive environment. The following measures reduce dependency of your code on  php .ini settings. short_open_tag Always use the long  PHP  tags:  php echo "hello world"; ?> Do not use the echo shortcut  . asp_tags Do not use ASP like tags:  <% echo "hello world"; %> gpc_magic_quotes I recommend that you include code in a global include file which is run before any $_GET or $_POST parameter or $_COOKIE is read. That code should check if the gpc_magic_quotes option is enabled and run all $_GET, $_POST and $_COOKIE values through the  stripslashes ...