Hatred does not cease through hatred at any time.
Hatred ceases through love. This is an unalterable law.— Buddha
MySQL Single Record Transfer Between Databases
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.
dompdf
dompdf is a PHP5 class for rendering HTML/CSS files into PDF. Somehow I’m only learning of this now:
code.google.com/dompdf
Sending Fax with PHP on Windows
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
Icon Generator
Ever want to create some of those iPhone-type shiny candy button icons? Flavor Studios made an online tool to generate them for you! Fill out a form with level of glossiness, background color, image settings, upload your PNG, eureka! Check it out: flavorstudios.com/iphone-icon-generator
Google Maps Doodoo View
Creeping around on Google Maps Street View, I found bird doodoo on the camera in Hollywood on Sunset Blvd near Cassil Pl. Check out the screenshot:
Links
Biking Directions on Google Maps
Google Maps just launched an upgrade that includes bike trails layer and routes optimized for bicycles:
maps.google.com/biking
WP Theme for iPhone/Android
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!
IE Conditional Tags
Internet Explorer has rendering bugs that vary across all versions. Microsoft has included some conditional comment tags that are specific to their IE browsers since IE5. These are really helpful if you need to include a CSS or JS file to fix layout quirks:
<!--[if IE]> Instructions for all IE browsers <![endif]--> <!--[if lte IE 7]> Instructions for IE7 or earlier <![endif]--> <!--[if IE 6]> Instructions for IE6 only <![endif]-->
AS3 Flip Horizontal/Vertical
import flash.geom.Matrix;
public function flipHorizontal ( dsp:DisplayObject ):void {
var matrix:Matrix = dsp.transform.matrix;
matrix.a = -1;
matrix.tx = dsp.width + dsp.x;
dsp.transform.matrix = matrix;
}
public function flipVertical ( dsp:DisplayObject ):void {
var matrix:Matrix = dsp.transform.matrix;
matrix.d = -1;
matrix.ty = dsp.height + dsp.y;
dsp.transform.matrix = matrix;
}
