2010.07.30

Resetting Android’s Google Account

By underblob @ 6:59pm — Categories: Mobile
Tags: ,

This applies to Android 1.6. If you need to switch your phone to a new Google account, follow these two steps:

Main drawer » Settings » Applications » Manage Apps » Google Apps » Clear Data
Main drawer » Settings » Data Synchronization

Once you get to Data Synchronization, it will prompt you to create a Google account or login to your existing account.
Warning: This will re-synch all your Google data… GMail, Calendar, and Contacts.

2010.06.24

CSS Snippet for Drop Shadow

By underblob @ 6:04pm — Categories: Design, HTTP, Tech
Tags: , , , ,

Use this snippet to add drop shadows to elements for Mozilla, Webkit, and browsers that support CSS3:

	-moz-box-shadow: 1px 2px 3px #666;
	-webkit-box-shadow: 1px 2px 3px #666;
	box-shadow: 1px 2px 3px #666;
	/* box-shadow: X Y blur hex; */

CSS Snippet for Rounded Corners

By underblob @ 5:54pm — Categories: Design, HTTP, Tech
Tags: , , , , ,

Use this CSS to apply rounded corners to Mozilla, Webkit, and browsers that support CSS3:

	-moz-border-radius: 3px;
	-webkit-border-radius: 3px;
	border-radius: 3px;

2010.06.21

XAMPP php.ini

By underblob @ 9:44am — Categories: LAMP, Tech

Note to self: when installing XAMMP for development on your legacy apps, be sure to set PHP short tags in php.ini:

short_open_tag = On

2010.06.02

jQuery iFrame access

By underblob @ 4:16pm — Categories: Javascript, Tech
Tags: ,

Trying to manipulate the iframe from a jQuery script running inside the iframe. Here is how to get a handle on the iframe with jQuery when you have id attribute iframe-id-attribute set on the iframe:

var ifr = $( '#iframe-id-attribue', window.parent.document );

2010.05.21

MySQL Single Record Transfer Between Databases

By underblob @ 2:45pm — Categories: LAMP, Tech

I had a couple records disappear and needed to pull them from backup. The client had already made extensive changes to the database via CMS so I couldn’t copy over the whole database without overwriting all of their changes. Here is the SQL I came up with to transfer a single record:

INSERT INTO target_db.table
SELECT backup_db.table.* 
FROM backup_db.table
WHERE backup_db.table.id = '{000}'

Replace target_db with the name of the database you are copying to.
Replace backup_db with the name of the backup database you are copying from.
Replace table with the name of the table you are handling.
Replace {000} with the id field value of the record to transfer.

2010.04.19

dompdf

By underblob @ 5:20pm — Categories: LAMP, Tech

dompdf is a PHP5 class for rendering HTML/CSS files into PDF. Somehow I’m only learning of this now:
code.google.com/dompdf

2010.04.02

Sending Fax with PHP on Windows

By underblob @ 1:07pm — Categories: LAMP, Tech
Tags: , , , ,

UPDATE 2010.06.21: This article was written for Fax Console on Windows XP, has not been tested against Windows 7 Fax and Scan.

I had a project that I needed to fax documents from a PHP application. We had our own Windows XP box running XAMPP (LAMP for Windows) so I could install whatever and configure however we needed. I searched high and low for a tutorial on how to send fax from PHP on Windows. The PHP COM documentation and MSDN Library left something to be desired so I thought I would put a little something together for posterity…

First thing I discovered was the handy COM class in PHP that allows you to manipulate Windows applications. Pretty cool.

Then I went over to the MSDN Library to see how I can send a fax. Enter the FaxDocument COM Object. The most important property of the FaxDocument object is Body. This property allows you to attach any document or image file (.doc, .txt, .pdf, .jpg, .tif, etc.) for faxing by defining the path to the file.

The next part that was essential for our application was to create a dynamic cover page for each outgoing fax. Instead of rendering a PDF on the server for each outgoing fax, there is a FaxDocument property called CoverPage that allows you to use a Windows template cover page file (.COV). You can create your own .COV file using Windows application Fax Cover Page Editor, which can be found in the Start Menu:

Start Menu -> Programs -> Accessories -> Communications -> Fax -> Fax Cover Page Editor
Or in the system here:
C:\WINDOWS\system32\fxscover.exe

The only catch is that you need to define the UNC to the .COV file in FaxDocument.CoverPage. What the heck is a UNC path? UNC stands for Uniform Naming Convention and is specific to Windows and Windows networking. The format goes something like this: \\COMPUTERNAME\SharedFolder\Resource

Notice that the part of the path immediately following the COMPUTERNAME is a SharedFolder. It is essential that you turn on sharing for the folder that contains the file(s) that you want to use for your FaxDocument.CoverPage. Right-click on the folder you want to share:

Properties (contextual menu) -> Sharing (tab) -> Share this folder on the network (checkbox)

The COMPUTERNAME can be found on Windows by right-clicking on ‘My Computer’:

Properties (contextual menu) -> Computer Name (tab)

When you are testing your PHP script, you can test your UNC path by having PHP echo it. Copy your UNC path and paste it into the Run box found here: Start menu -> Run

If it does not open your .COV file in Windows’ Fax Cover Page Editor application, something is wrong and you need to examine your UNC path, .COV filename and sharing properties.

Here is the final PHP code:

$obj_faxdoc = new COM ( "FaxComEx.FaxDocument" );
$obj_faxdoc->DocumentName = "Fax from PHP"; // This is the name that will appear in the Windows Fax Console
$obj_faxdoc->Sender->Title = "Quote"; // This is a field defined in the .COV
$obj_faxdoc->CoverPageType = 1; // This specifies the .COV location: 0 = No cover page, 1 = Local, 2 = Server
$obj_faxdoc->CoverPage = "\\\\COMPUTERNAME\\SharedFolder\\Template.COV"; // Don't forget double backslash
$obj_faxdoc->Subject = "Fax for John Doe"; // This is a field in the .COV and also shows in Fax Console
$obj_faxdoc->Note = "Please review the following fax."; // This is a field in the .COV
$obj_faxdoc->Body = "/path/to/faxable/file.pdf"; // The path to the file you want to fax
$obj_faxdoc->Recipients->Add ( "888-555-2134", "John Doe" );
$obj_faxdoc->Submit ( "" );

Links

php.net – PHP COM class
msdn.microsoft.com – FaxDocument COM object
xampp.org – LAMP for Windows
en.wikipedia.org – UNC definition

2010.03.16

Biking Directions on Google Maps

By underblob @ 9:48am — Categories: HTTP, Mobile, Tech
Tags: , , ,

Google Maps just launched an upgrade that includes bike trails layer and routes optimized for bicycles:
maps.google.com/biking

2010.03.01

WP Theme for iPhone/Android

By underblob @ 4:39pm — Categories: Mobile, Tech, WordPress

New WP theme released for iPhone and Android designed with touch-screen phones in mind:
bravenewcode.com/wptouch

Update: Just installed this theme on underblob. It is actually installed as a plug-in and not as a theme, which makes a lot more sense. The plug-in auto-detects user agent string and spits out the wptouch theme if you are viewing on a mobile device. This way it preserves your existing theme for peeps coming in on their desktop browsers. Pretty clever!

Older Posts »