Out of curiosity I asked another friend, a team lead, how things where going with their PHP MySQL project, for which they had planned to have most of their business logic in stored procedures. I got an email in reply stating something along the lines: "Our developers found that mysqli does not support stored procedures correctly. We use PDO.". Well, the existing documentation from PHP 5.0 times is not stellar, I confess. But still, that's a bit too much... it ain't that difficult. And, it works.

He describes the three parameters (IN, OUT and INOUT) and gives some examples of setting/getting them from your SQL statements. They're all still set up using the query method on your connection as well as handling the result sets that come back and working with prepared statements.

The IN-clause is only supported when I wrap my statement with Zend_Db_Select, which is something I rarely do. Part of the reason is that I still don't feel comfortable writing my SQL in a DSL which doesn't really do anything besides wrapping a string into an object and IMHO it doesn't add to readability either. And the other reason is that I don't plan to run this import against any other database than MySQL. Which is why I don't see the need for abstraction either.

He shows some failing code where the IN isn't populated correctly when an array is passed in and the warnings that come with it. He solution's pretty simple, though - rewrite the query string before sending it with the correct number of bind locations ("?") for the number of parameters. In the comments, other approaches are suggested including using a simple select() call or tricking the bindings with a special kind of array.

Responsible for designing, developing, and maintaining complex Web applications. Duties can include: meeting with customers to understand application requirements, developing technical specifications for application, programming application, testing that application satisfies requirements, is secure, and is accessible to all users, interfacing Web application with a Database Management System (DBMS), and documenting application and creating user manuals. Develop, support, and administer database server software. Provide help desk support for faculty, staff and graduate students. Serve as a member of the Department of Mathematics Web Committee. Supervise one regular service staff member. Assign, instruct and review the work of staff.

Qualifications

Required:

• Bachelor's degree.
• One year experience designing and interfacing database applications that interact with the web, and database administration.
• Experience developing database-driven web applications using PHP and MySQL or PostgreSQL.
• UNIX and Linux web server experience.
• Good oral/written communication skills.
• Capable of working both independently and with others, while managing multiple projects.

Preferred:

• Experience with CGI scripting in Perl.
• Knowledge of Shell scripting, Java, Subversion, XML.

Additional Information:

• FLSA: Exempt (Not Eligible For Overtime)
• Retirement Eligibility: TIAA/CREF Contribution Waiting Period.

See this page for more information: http://purdue.taleo.net/careersection/wl/jobdetail.ftl?lang=en&job=42620

They discuss a range of authentication types - all the way from simple authentication out to cryptographic and multi-factor authentication. They wrap it up with a look at how you can choose the appropriate authentication methods for your applications as well.

I've seen several sites moving more and more to the next step up from the basic level of authentication up to even just the multi-factor. The more levels of security you can put on your application the better, especially if you're housing any kind of personal data about your users.

Following release of the PHP Developers Meeting in Paris (November 11th and 12th, 2005), the International PHP Magazine polled the community to find out What they were looking our for, the most, in PHP 6?

The results of the poll suggest almost an equal weightage to all of the points noted in the developer meeting minutes. Of the 809 members polled, 15-20% of the respondents were looking out for OO functionality changes, functionality cleanup, performance boost, Security enhancements, and unicode support, in that order. Only 7% were keen to see additions made to the PHP engine. Less than 3% clicked on the "others" option.

The votes were pretty close, with "Functionality" only barely edging out "Performance Boost". "OO Functionality Changes", however, topped the list with points to spare.]]> Mon, 13 Mar 2006 07:41:50 -0600 http://www.phpdeveloper.org/news/4978 http://www.phpdeveloper.org/news/4978 this post on the Sitepoint PHP Blog, Harry Fuecks makes a quick mention of another blog post dealing with the enhancements in PHP6 and another handy feature he noticed as well.

Pierre-Alain Joye picked this one up last week, and it needs repeating. For PHP6 the following are already gone from CVS: Register globals, Magic quotes, Safe mode.

As blogged a while back, you'll find these changes discussed here. Nice use of carrot and stick in fact - for the pain on fixing your apps to run under PHP6, you get Unicode.

The other feature he's noticed pertains to the php.ini settings file that PHP uses:

Just noticed a new ini setting here: "allow_url_include - PHP_INI_SYSTEM Available since PHP 6.0.0." Excellent! That eliminates another major source of exploits (perhaps the biggest) have moaned about that before here and here.]]> Mon, 13 Mar 2006 07:31:38 -0600 http://www.phpdeveloper.org/news/4819 http://www.phpdeveloper.org/news/4819 last part of their "Abstract Classes in PHP" series today - "Working with PHP5".

In this last part of the series, I'll explain the key points of abstract classes in PHP 5, and additionally provide you with some hands-on examples. This should give you a clear idea of how to utilize them within the powerful Object Model implemented in the latest version of PHP.

They start with an overview of the PHP5 object model and how it make sabstract classes much easier than before. They continue, mentioning a "pointless and unusual" practice of calling class methods out of context. Finally, they set up an example of the use of an abstract class in the structure of the PHP5 object model...]]> Thu, 09 Feb 2006 06:47:12 -0600 http://www.phpdeveloper.org/news/4658 http://www.phpdeveloper.org/news/4658 Davey Shafik has his personal look back at his year in 2005 and what kinds of things he accomplished.

Just like Last Year I'm jumping on the bandwagon again.

Despite the fact that it is hard to top some of the feats I managed last year (I for one, am not planning to marry anybody else!) it has been a very productive and exciting year for me.

Of the things he mentions, here's a few of the more memorable ones:

• the release of the PHP_CompatInfo and Crtx_PEAR_Channel_Frontend packages
• the release of the PHAR/PHP_Archive packages/utilities
• public releases of his Cerebral Cortex framework
• The release of his Tooltip.js library
• and, finally, his being included in the development of the Zend Framework team.

So, thanks to Davey, especially for all his work - especially on the PHAR/PHP_Archive project - it's already proved invaluable to the community as a whole...]]> Fri, 13 Jan 2006 07:08:47 -0600