> If you go the resilient route with everything you end up with code that lo... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

masklinn on July 15, 2011 | parent | context | favorite | on: PHP to deprecate MySQL extension

> If you go the resilient route with everything you end up with code that looks like Java code.

Meh. Prepared statements are useful when you'll use the it multiple times through rebinding, and for one-shots it's easy enough to have a function taking a parameterized query and an array and doing the annoying crap internally.

Then you just write:

    $result = executeSQL($somePDOObject,
        "INSERT INTO folks (name, addr, city) values (:name, :addr, :city);",
        array("name" => $name, "addr" => $addr, "city" => $city);

eropple on July 15, 2011 [–]

This is actually fairly close to what I do in my own code (I actually extend the PDO object, but same idea). The example I gave was just using the base PDO library instead.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact