Parsing CSV on PHP

This is a PHP function that you can use in parsing CSV that will return an array.

This will parse even a non Windows CSV format which is difficult to parse with hidden new lines.

Hope this helps a lot!

public function csvToArray($filename='', $delimiter=',') { 
  if (!file_exists($filename) || !is_readable($filename)) return FALSE;
  $header = ''; 
  $data = array(); 

  if (($handle = fopen($filename, 'r')) !== FALSE) :
    $tmpfile = fopen("$filename.tmp", 'w+');
    while(!feof($handle)) {
      $line = trim(fgets($handle));
      $lines = preg_split("(\r|\n|\r\n)", $line);
      foreach ($lines as $row) : 
        fwrite($tmpfile, "$row\n");
      endforeach; 
    }
    fclose($tmpfile);
    fclose($handle);
  endif;

  if (($handle = fopen("$filename.tmp", 'r')) !== FALSE) : 
    while (($row = fgetcsv($handle, 1000, $delimiter)) !== FALSE) {
      if (!@$row[0]) continue; if (!$header) : 
        $header = $row;
      else :
        $data[] = array_combine($header, $row);
      endif;
    }
    fclose($handle);
  endif;

  unlink("$filename.tmp");
  return $data;
}

Code Financial to manage your finances online.

Coders Technology Solutions been developing platforms that will help small and medium scale entrepreneur on managing their businesses, one of which is their Code Financial which is an online solution to manage finances.

Code Financial is totally FREE and can really help you manage your finances. They have 4 major modules such as Sources, Payables, Incomes, and Expenses. The sources are the source of income whether it is a client, institution, or company while payables are institutions, establishments, utilities, etc. which you pay for. They also have flexible reports which you can easily select which sources and payables you want to be included and the summary in which you have a good view of how your finances for the year, monthly, semi-monthly, and daily.

This really help me a lot and hope it can help you too. So, register now and start managing your finances. You can register to http://codefinancial.net/register and please share it with your friends who are in need.

Code URL to shorten your links

I just recently launched my new app - codeurl.net which is very useful for people who wants to shorten links.

One of the key features of this app which is not on the other app like this is the QR Code which you can use to post on your site, etc.. I also have a share functionality for you to share the links from the app itself. There is also a simple analytics to see the number of clicks been made with your links, and more improvements in the future.

You can also customize your links by putting the code that you want using your FREE credits which you can earn by simply register to the app - codeurl.net/register and earn more by inviting friends to sign up - codeurl.net/invite/create

Registration is totally FREE!

Hope you like it and would like to hear comments for improvements.

Download files from URL and save it to the server.

This is a simple script that will download files from a URL then will save it to your own PC or server. Hope this helps a lot.

<?php

$source = 'http://dev.axonitconsulting.com/digitalwallet/images/logo-blue-pink.png';
$destination = './logo-blue-pink.png';

dloadSave($file_source, $file_target);

function dloadSave($source='', $destination='./') {
        $rh = fopen($source, 'rb');
        $wh = fopen($destination, 'wb');
        if ($rh===false || $wh===false) {
           // can't read files
           return false;
        }
        while (!feof($rh)) {
            if (fwrite($wh, fread($rh, 1024)) === FALSE) {
                   // can't write to file
                   return false;
               }
        }
        fclose($rh);
        fclose($wh);
        return true;
    }
?>

How to get the total facebook friends in PHP

This is just a simple script that will retrieve the total facebook friends of specific user using the graph api. We will be using graph api along with the FQL to get the friend count of the user and by doing that we need the facebook id which we can retrieve by authorizing our app with facebook API.

The output is on JSON which we can decode via PHP, please see sample below.
{ "data": [ { "friend_count": 740 } ] }

<?php 
$fbUserId = <your facebook id>;
$json = file_get_contents("https://graph.facebook.com/fql?q=SELECT%20friend_count%20FROM%20user%20WHERE%20uid=$fbUserId");
$json = json_decode($json);
echo @$json->data[0]->friend_count;
?>

Hope this helps, please leave a comment if you like this post.