BRADINO » Search Results » explode

Google Analytics API

BRADINO — Tue, 09 Dec 2008 20:43:01 +0000

Unfortunately Google Analytics does not have an API yet... However I will show you a quick and dirty way to get the data you need. The idea is basically to setup an automated report from within Google Analytics, which will email a CSV file attachment, that you can download and parse with a script. For this example I will use the Zend Mail class because I love Zend Mail and it is free.

So the first step is to schedule the report. For this simple example we will use the default Visitors Report. So login to your Google Analytics account, click Visitors on the main left nav, then click the Email icon up at the top of the report, see screenshot below:

Google Analytics Screenshot

Now let's get to the code. First step is to connect to your POP mail server and get the new messages. Don't forget to download the latest version of Zend at http://framework.zend.com.

include ('Zend/Mail/Storage/Pop3.php');

$params = array('host' => "mail.domain.com", 'user' => "info@domain.com", 'password' => "secret");

$mail = new Zend_Mail_Storage_Pop3($params);

$num = $mail->countMessages();

In a production environment, you would want some logic to verify that the number of messages is greater than 0, loop through the messages, etc but for this tutorial I have omitted these items for brevity. So next we need to download the first message and get its parts.

$message = $mail->getMessage(1);

$parts = $message->countParts();

Next we spin through the parts, looking for the attachment.

for($b=1; $b<=$parts; $b++){

$part = $message->getPart($b);

$headers = $part->getHeaders();

if (!empty($headers['Content-Disposition']) || !empty($headers['content-disposition'])){

Then we parse the CSV file to an array for simple looping:

$csv = base64_decode($part->getContent());

$lines = explode("\n",$csv);

$data = array();

foreach ($lines as $line){

$data[] = explode(',',$line);

}

The previous code checks the email account, downloads the CSV attachment and parses it to an array. That is all going to stay the same but the matching below will change depending on your needs. For this simplistic example, I am going to get the number of visits from yesterday.

$yesterday = date('F j',mktime(0, 0, 0, date('m'), date('d')-1, date('Y')));

foreach ($data as $row){

if ($row[0] == '"'.$yesterday){

$visits = $row[2];

echo "VISITS: {$visits}";

}

}

So that's basically it. Of course in production you would probably want to write the Google Analytics data to a database or whatever, but you get the point! Hopefully Google Analytics will get an API soon, but until then, this works like a champ!

Geocoding: Location to Latitude/Longitude

BRADINO — Thu, 25 Sep 2008 17:09:20 +0000

Both Google and Yahoo offer free geocoding services. Geocoding is the process of getting the latitude/longitude coordinates for a particular address or location. With the latitude/longitude coordinates you can fun things like plot markers on a map, calculate distances between points, etc. I have created two simple standalone functions to geocode an address, one for Google and one for Yahoo. Both require an API key.

Google Documentation Google API Key Yahoo Documentation Yahoo API Key

// API KEYS

$googleKey = "INSERT-API-KEY";

$yahooKey = "INSERT-API-KEY";

// ARRAY OF LOCATION PARAMETERS

$params = array();

$params['address'] = "2470 E Street";

$params['city'] = "San Diego";

$params['state'] = "CA";

$params['zip'] = "92102";

// GEOCODING USING GOOGLE

$coords = geocodeGoogle($params,$googleKey);

echo "Latitude: {$coords['latitude']}
\n";

echo "Longitude: {$coords['longitude']}
\n";

// GOOGLE GEOCODE FUNCTION

function geocodeGoogle($params,$key){

$location = strtolower(str_replace(' ','+',"{$params['address']}, {$params['city']}, {$params['state']}, {$params['zipcode']}"));

$url = "http://maps.google.com/maps/geo?q={$location}&output=csv&key={$key}";

$response = file_get_contents($url);

$parts = explode(',',$response);

return array('latitude' => $parts[2], 'longitude' => $parts[3]);

}

// GEOCODING USING YAHOO

$coords = geocodeYahoo($params,$yahooKey);

echo "Latitude: {$coords['latitude']}
\n";

echo "Longitude: {$coords['longitude']}
\n";

// YAHOO GEOCODE FUNCTION

function geocodeYahoo($params,$key){

$location = strtolower(str_replace(' ','+',"{$params['address']}, {$params['city']}, {$params['state']}, {$params['zipcode']}"));

$url = "http://local.yahooapis.com/MapsService/V1/geocode?appid={$key}&location={$location}&output=php";

$response = file_get_contents($url);

$data = unserialize($response);

return array('latitude' => $data['ResultSet']['Result']['Latitude'], 'longitude' => $data['ResultSet']['Result']['Longitude']);

}

geocoding geocode altitude/longitude latitude longitude

PHP Screen Scraping

BRADINO — Mon, 02 Jun 2008 18:20:47 +0000

I had a request recently for help with scraping a little content from http://www.newyork411.com :)

So here we go. This time I made a quick PHP class with some basic functions to grab the source fo the page as well as fetchBetween, fetchAfter, fetchAll, etc. You can get the latest version of the class at http://www.bradino.com/downloads/cScrape.txt - be sure to rename it to cScrape.php. If there is an interest I can continue to develop this class a tool for screens craping with PHP.

Anyway so here we go scraping all the companies from this page http://www.newyork411.com/Ad_Agencies_Production_Companies/category-cid-50553.htm as well as the details of each company, found by clicking on the company.

Step 1 - Initialize the class and fetch the page:

include ('cScrape.php');

$scrape = new Scrape();

$url = 'http://www.newyork411.com/Ad_Agencies_Production_Companies/category-cid-50553.htm';

$scrape->fetch($url);

$data = $scrape->removeNewlines($scrape->result);

Step 2 - find your anchor and get the chunk of html that contains what you want

$data = $scrape->fetchBetween(','

',$data,true);

$rows = $scrape->fetchAllBetween(','',$data,true);

Step 3 - parse out the individual values and print out the first record for demo

foreach ($rows as $id => $row){

$record = array();

$cells = $scrape->fetchAllBetween(','',$row,true);

$record['company'] = strip_tags($cells[1]);

$url = 'http://www.newyork411.com' . $scrape->fetchBetween(''">',$cells[1],false);

$url = str_replace(' ','%20',$url);

$scrape->fetch($url);

$data2 = $scrape->removeNewlines($scrape->result);

$data2 = $scrape->fetchBetween('

','

',$data2,true);

$data2 = $scrape->fetchAfter('',$data2,false);

$details = explode('
',$data2);

$record['address'] = $details[0];

$location = explode(',',$details[1]);

$record['city'] = trim($location[0]);

$location = explode(' ',trim($location[1]));

$record['state'] = trim($location[0]);

$record['zip'] = trim($location[1]);

for($i=2; $i<=5; $i++){

$detail = trim($details[$i]);

if(substr($detail,0,6)=='Phone:') $record['phone'] = str_replace('Phone: ','',$detail);

else if(substr($detail,0,4)=='Fax:') $record['fax'] = str_replace('Fax: ','',$detail);

else if(substr($detail,0,4)=='Web:') $record['web'] = strip_tags(str_replace('Web: ','',$detail));

else if(substr($detail,0,6)=='Email:') $record['email'] = strip_tags(str_replace('Email: ','',$detail));

}

print_r($record);

die();
}

php scrape screen scraping php screen scrape

Javascript Split Function

BRADINO — Tue, 20 Nov 2007 07:16:11 +0000

The Javascript split() function works much the same as the php split() or explode() functions. Basically you take a string at break it up everywhere the delimiter character occurs and return the new strings in an array. So for example, let's say you have a string like this:

Which is obviously a simple a pipe-delimited string of colors. So to make this into an array we would use the split function.

var colorArray = colorString.split("|");

Now you have a simple array of colors and can access them as you would any array, either in a loop or by the numeric index, whatever...

var message = "My favorite color is " + colorArray[3] ;
alert(message);

javascript split javascript explode split javascript string manipulation

Apache Mod Rewrite

BRADINO — Sat, 24 Mar 2007 21:53:36 +0000

One if the cleanest ways to setup a site is to use mod_rewrite in Apache. I am going to show you a simple way to do this using an htaccess file and a little PHP. First step is to make an htaccess file with the following code:

RewriteEngine on
RewriteCond %{SCRIPT_FILENAME} !-f
RewriteCond %{SCRIPT_FILENAME} !-d
RewriteRule ^(.*)$ index.php?loc=$1

Now everything that is not a folder or a file will get passed to the index.php file as $_GET['loc']. You could change the index.php to any file you like and the ?loc= to some other variable if you like.

Next you need to groom the url. Do not leave out this step. You are injecting the url into your script... I suggest something solid like the following:

$url = preg_replace('/[^[:alnum:]\-\/]/', '', $_GET['loc']);
?>

So now you have the url into your script safely so you need to break it apart. You are basically going to pass variables here. All you have to do is explode on the forward slash. You can do it simply like this:

$parts = explode('/',$url);
$section = $parts[0];
$subsection = $parts[1];
?>

mod rewrite modrewrite mod-rewrite apache php clean urls seo

PHP chunk_split function

BRADINO — Mon, 26 Feb 2007 05:19:57 +0000

chunk_split

(PHP 3 >= 3.0.6, PHP 4, PHP 5)

chunk_split -- Split a string into smaller chunksDescriptionstring chunk_split ( string body [, int chunklen [, string end]] )

Can be used to split a string into smaller chunks which is useful for
e.g. converting base64_encode() output to match RFC
2045 semantics. It inserts end (defaults to
"\r\n") every chunklen characters (defaults to
76). It returns the new string leaving the original string untouched.

Example 1. chunk_split() example

// format $data using RFC 2045 semantics
$new_string = chunk_split(base64_encode($data));

See also str_split(),
explode(), split(),
wordwrap() and
RFC 2045.

PHP explode function

BRADINO — Mon, 26 Feb 2007 05:10:36 +0000

explode

(PHP 3, PHP 4, PHP 5)

explode -- Split a string by stringDescriptionarray explode ( string delimiter, string string [, int limit] )

Returns an array of strings, each of which is a substring of
string formed by splitting it on
boundaries formed by the string delimiter.
If limit is set, the returned array will
contain a maximum of limit elements with
the last element containing the rest of
string.

If delimiter is an empty string (""),
explode() will return FALSE. If
delimiter contains a value that is not contained
in string, then explode() will
return an array containing string.

If the limit parameter is negative, all components
except the last -limit are returned. This feature
was added in PHP 5.1.0.

Although implode() can, for historical reasons,
accept its parameters in either order,
explode() cannot. You must ensure that the
delimiter argument comes before the
string argument.

Note:
The limit parameter was added in PHP
4.0.1

Example 1. explode() examples

// Example 1
$pizza = "piece1 piece2 piece3 piece4 piece5 piece6";
$pieces = explode(" ", $pizza);
echo $pieces[0]; // piece1
echo $pieces[1]; // piece2

// Example 2
$data = "foo:*:1023:1000::/home/foo:/bin/sh";
list($user, $pass, $uid, $gid, $gecos, $home, $shell) = explode(":", $data);
echo $user; // foo
echo $pass; // *

Example 2. limit parameter examples

$str = 'one|two|three|four';

// positive limit
print_r(explode('|', $str, 2));

// negative limit (since PHP 5.1)
print_r(explode('|', $str, -1));

The above example will output:

Array
(
[0] => one
[1] => two|three|four
)
Array
(
[0] => one
[1] => two
[2] => three
)

Note: This function is
binary-safe.

See also
preg_split(),
str_split(),
strtok(), and
implode().

PHP fbsql_field_flags function

BRADINO — Mon, 26 Feb 2007 05:09:56 +0000

fbsql_field_flags

(PHP 4 >= 4.0.6, PHP 5)

fbsql_field_flags -- Get the flags associated with the specified field in a resultDescriptionstring fbsql_field_flags ( resource result [, int field_offset] )

Gets the flags associated with the specified field in a result.

Parameters

result

A result pointer returned by fbsql_list_fields().

field_offset

The numerical offset of the field. The field index starts at 0.

Return Values

Returns the field flags of the specified field as a single word per flag
separated by a single space, so that you can split the returned value
using explode().

PHP fgetcsv function

BRADINO — Mon, 26 Feb 2007 05:08:45 +0000

fgetcsv

(PHP 3 >= 3.0.8, PHP 4, PHP 5)

fgetcsv -- Gets line from file pointer and parse for CSV fieldsDescriptionarray fgetcsv ( resource handle [, int length [, string delimiter [, string enclosure]]] )

handle

A valid file pointer to a file successfully opened by fopen(),
popen(), or fsockopen().

length (Optional)

Must be greater than the longest line (in characters) to be found in the CSV file
(allowing for trailing line-end characters). It became optional in PHP 5. Omitting
this parameter (or setting it to 0 in PHP 5.0.4 and later) the maximum line length
is not limited, which is slightly slower.

delimiter (Optional)

Set the field delimiter (one character only). Defaults as a comma.

enclosure (Optional)

Set the field enclosure character (one character only). Defaults as a double quotation mark. Added in PHP 4.3.0.

Similar to fgets() except that
fgetcsv() parses the line it reads for fields
in CSV format and returns an array containing
the fields read.

fgetcsv() returns FALSE on error, including
end of file.

Note:
A blank line in a CSV file will be returned as an array
comprising a single null field, and will not be treated
as an error.

Example 1. Read and print the entire contents of a CSV file

$row = 1;
$handle = fopen("test.csv", "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$num = count($data);
echo "<p> $num fields in line $row: <br /></p>\n";
$row++;
for ($c=0; $c <$num; $c++) {
echo $data[$c] . "<br />\n";
}
}
fclose($handle);

fgetcsv() has been binary safe since PHP 4.3.5

Note:
Locale setting is taken into account by this function. If
LANG is e.g. en_US.UTF-8, files in
one-byte encoding are read wrong by this function.

Note: If you are having problems
with PHP not recognizing the line endings when reading files either on or
created by a Macintosh computer, you might want to enable the
auto_detect_line_endings
run-time configuration option.

See also explode(), file(),
pack() and fputcsv().

PHP imap_thread function

BRADINO — Mon, 26 Feb 2007 04:57:45 +0000

imap_thread

(PHP 4 >= 4.1.0, PHP 5)

imap_thread -- Returns a tree of threaded messageDescriptionarray imap_thread ( resource imap_stream [, int options] )

Gets a tree of a threaded message.

Parameters

imap_stream

An IMAP stream returned by
imap_open().

options

Return Values

imap_thread() returns an associative array containing
a tree of messages threaded by REFERENCES, or FALSE
on error.

Every message in the current mailbox will be represented by three entries
in the resulting array:

$thread["XX.num"] - current message number

$thread["XX.next"]

$thread["XX.branch"]

Examples

Example 1. imap_thread() Example

// Here we're outputting the threads of a newsgroup, in HTML

$nntp = imap_open('{news.example.com:119/nntp}some.newsgroup', '', '');
$threads = imap_thread($nntp);

foreach ($threads as $key => $val) {
$tree = explode('.', $key);
if ($tree[1] == 'num') {
$header = imap_headerinfo($nntp, $val);
echo "<ul>\n\t<li>" . $header->fromaddress . "\n";
} elseif ($tree[1] == 'branch') {
echo "\t</li>\n</ul>\n";
}
}

imap_close($nntp);