PDO (PHP Data Objects) && Prepared Statements

A prepared statement s, essentially, the template of an SQl statement that has been pre-parsed and compiled and is ready to be executed by passing it the appropriate date.
Steps:
1. Create Prepared Statement (replacing your data with a set of markers uch as question marks, or named entities.
2. Load Data in the statement
3. Execute


// Example
$clean = array();

if (ctype_al[ha($_POST['username']))
{
        $clean['username'] = $_POST['username'];
}

// Set a named placeholder in the SQL statement for username
$sql = 'SELECT * FROM users WHERE username = :username';

// Assume the database handler exists; prepare the statement
$stmt = $dbh->prepare($sql);

// Bind a value for the parameter
$stmt->bindParam(':username', $clean['username']);

// Execute and fetch results
$stmt->execute;
$results = $stmt->fetchAll();

The Genetic Code (ISAAC ASIMOV)

Almost finished the book. Don't see point to read about DNA, molecules. Not everything is clear in the book for me..

Brothers Karamazov (Fyodor Dostoevsky)

I've read this book in high school (in Russian Language). I was in Williamsburg a month ago and bought 2 books(used) from street seller for $5. I re-read Brother Karamazovin English and like it.

Computer Build

I always wanted to assembly computer for myself. So about 3 weeks ago I start researching on computer parts. Newegg is very resourfsul website. After debating I decided to go with DUAL CORE (QUAD CORE for the same price has lower speed, less cache and most of the application don't run on more than one core). So I chosed Inter Core 2 DUO E7200 (Wolfdale) (here is good article that compate Intel Core 2 Duo E7200 (Wolfdale) and Intel Core 2 Quad Q9300 (Yorkfield)

List of Computer Parts:
- Memory CORSAIR 4GB (2 x 2GB) 240-Pin DDR2 SDRAM DDR2 1066 (PC2 8500) Dual Channel Kit Desktop Memory Model TWIN2X4096-8500C5 - Retail
- Harddrive Seagate Barracuda 7200.12 ST31000528AS 1TB 7200 RPM SATA 3.0Gb/s 3.5" Internal Hard Drive - OEM
- Tower Computer Case Rosewill R5601-BK 0.8mm Japanese Cold Rolled Steel Screw-less Dual 120mm Fans ATX Mid Tower Computer Case - Retail
- MotherBoard GIGABYTE GA-EP45-UD3P LGA 775 Intel P45 ATX Intel Motherboard - Retail
- VideoCard Kensington 62630 3 ft. 6 Outlets 70 joules Guardian Basic Strip - Retail
- Processor Intel Core 2 Duo E8500 Wolfdale 3.16GHz LGA 775 65W Dual-Core Processor Model BX80570E8500 - Retail
- PowerSupply Rosewill RP600V2-S-SL 600W ATX12V v2.01 SLI Ready Power Supply - Retail

It took me about about 2 hours to assemble the computer (started from first try). The assembling process was very interested. After that I install Ubuntu 9.04 OS and Sun VirtualBox with Windows XP.

BLITHE SPIRIT

Yesterday (06/12/2009) after work I saw Broadway show Blithe Spirit. Angela Lansbury as Madame Arcati. It was funny show with British accent. I had fun. Comming back on TimeSquare I saw new that Pittsburg Penguins won a Stanley Cup.

Tour De Brooklyn 2009

I pick my nephew Felix at 7am on Manhattan beach and we pedal to Surf and West 19 (Keyspan building on Coney Island). The weather was great and about 2,500 people participate in the event.

I've register here for the tour and Felix weren't. So Felix got register, we ate some snack and ride 23 miles. Prospect park was the main area rest area. The tour ended by 1pm.

X Window Restart

To restart X Window (CTRL + ALT + BACKSPACE) or
/etc/init.d/$GDM restart. Replace $DM with gdm or kdm.