Archive for February 28th, 2007

How to Use the Oracle SQL Developer Tool

Now there is a standalone graphic user interface that you can use to develop your SQL with Oracle databases. The many things you do in Oracle 1 G XE can also be carried out with the Oracle SQL Developer. It is expected to enhance productivity in your Oracle applications….

Rackspace Customized Managed Hosting Solutions Windows & Linux certified, Zero-Downtime Network, 24/7/365 Fanatical Support. Click to chat.

Continue Reading · Add comment

Job Posting: Sapphire Technologies Seeks LAMP Developer (New York, NY)

Company Sapphire Technologies
Location New York, NY
Title LAMP Developer
Summary

We are seeking a candidate who is skilled in LAMP (Linux, Apache, MySQL and PHP). Someone who is confident about building and extending the backend of a personalization platform for a site with an unparalleled combination of scale and complexity that receives a million hits a day. You must have extensive experience programming in a UNIX/Linux environment. You are a self starter who will pick up programming tasks and run with them, collaborating in a team environment with buy-in, checkpoints and testing.

Contact Anthony A. Blewett (anthony [dot] blewett [at] sapphire [dot] com ) for more information.

Link More Information

Continue Reading · Add comment

Felix Geisendorfer’s Blog: Cake 1.2’s Set class eats nested arrays for breakfast!

Felix Geisendorfer has a great functionality note that CakePHP users might want to check out. It’s related to the Set class and how it handles nested arrays.

So far this has been a little dark spot for me in the core and from my previous quick looks at the class I’ve never been quite able to figure out what it’s exact purpose was. Until now all I knew was “well it’s probably some fancy array manipulation code that is somewhat obfuscated and undocumented”. Oh boy, I wish I had spent more time on this earlier. It’s probably one of coolest new features in 1.2 and nobody realizes it.

He starts with a simple example of how the class works with a nested array of user information. Normally, you’d loop through the array and append the values you’d need to another array (like the user’s name), but with Set, it’s as simple as calling the static “extract” method with the “path” to what you want out of the array. A simple one-line replacement for a (normally) three to four line bit of code.

He gives a few other examples using this same user information, grabbing various results and includes one at the end that is very nice indeed - pulling in an XML document, running it through a simple xmltoArray function and pulling out the titles in a few easy lines.

Continue Reading · Add comment

Pierre-Alain Joye’s Blog: Little reminder about PHP references and some thoughts about FUDs

Pierre-Alain Joye has a little reminder posted to his blog today about two posts from planet-debian and Apache that refer to clones/references in PHP4 and PHP5 and some of the misconceptions presented there.

Reading planet-debian and Apache (from Sven and David), I catched two posts about clones and references in php4 and php5. I do not think it is worth to explain again everything here as Sara wrote a very good post already, check it out here.

He mentions his annoyance with articles/posts like these and the impact that it has on PHP as well as the person posting.

I wonder when the OS community in general will be mature enough to stop bitching at each other. And that’s valid for PHP developers, gnome-kde and other well established wars.

Continue Reading · Add comment

Paul Jones’ Blog: New PDO Behavior In PHP 5.2.1

http://www.phpdeveloper.org/form/view/type/addnews
PHPDeveloper.org: PHP News, Views, and Community
In a new post Paul Jones points out some of the new behaviors that the extension is showing in the latest of the PHP 5 seres (version 5.2).

He starts with a code example that would work with a previous version of PHP/PDO that would allow for the binding of a single value to multiple places in the SQL statement. But:

Sadly, this is no longer the case in PHP 5.2.1. For valid reasons of security and stability in memory handling, as noted to me by Wez Furlong, the above behavior is no longer supported. That is, you cannot bind a single parameter or value to multiple identical placeholders in a statement. If you try it, PDO will throw an exception or raise an error, and will not execute the query. In short, you now need to match exactly the number of bound parameters or values with the number of placeholders.

Unfortunately, this is used quite often in Paul’s Solar framework, so an update to the Solar_Sql_Adapter::query() method has had to been made to allow for the binding of multiple items automatically. It works by incrementing the bind location (like “:foo”) with numbers at the end - simple and effective - and you can still pass an array to it and have it automagically work.

Continue Reading · Add comment