Archive for May 8th, 2007

Joshua Eichorn’s Blog: Thanks for your thoughts on improving PEAR

Following up from a previous post of his that got lots of great feedback, Joshua Eichorn has posted his own thanks, not only for the responses to his own thoughts but to the PEAR community as a whole.

You’ll be happy to know that were already working on many of your suggestions, Greg’s post on the subject has some more details. I’ll be sharing everyones comments with the rest of the PEAR group at our meeting on the 13th, so if anyone has a suggestion they haven’t submitted yet thats your deadline.

The thing he’s most excited about is the new mentoring program that will introduce new developers to the PEAR-ality of it all and get them involved with both the coding and the community.

Continue Reading · Add comment

Community News: Joomla! 1.5 Beta-2 (Red Barchetta) Released

The latest release of the Joomla! CMS has been announced - version 1.5 Beta-2 has been posted for download.

Joomla! proudly presents its most important coding adrenaline surge to the development and designer community. With today’s release of Joomla! 1.5 Beta-2, we’re shifting gears into turbo mode; an entirely re-factored core, internationalisation, FTP layering, next-generation API and framework that’s so flexible and powerful and, of course, a designer’s dream for unparalleled templating flexibility.

Along with this release (”Red Barchetta”), they also encourage the community to participate and to contribute to the community, giving back their time and skills to help make the CMS even better.

Continue Reading · Add comment

Community News: PHP Remains at 4th in TIOBE Programming Community

As mentioned by the International PHP Magazine, PHP has held strong at its fourth place ranking on the TIOBE Programming Community Index for the month of May.

The TIOBE Programming Community index gives an indication of the popularity of programming languages. The index is updated once a month. The ratings are based on the world-wide availability of skilled engineers, courses and third party vendors. The popular search engines Google, MSN, and Yahoo! are used to calculate the ratings. Observe that the TIOBE index is not about the best programming language or the language in which most lines of code have been written.

PHP kept its ranking right alongside other popular languages like C++, Java and Perl to remain in the top five of the list. Their graph still shows a downward trend for the presence of PHP on the web, but it’s the same trend that can be seen affecting several other languages as well.

Continue Reading · Add comment

Secunia.com: Slackware Update for PHP

Secunia has issued an advisory for Slackware PHP users - an update to the official package to prevent some of the recent security issues corrected in the latest PHP releases.

Slackware has issued an update for php. This fixes some vulnerabilities, which can be exploited by malicious users to manipulate certain data, disclose potentially sensitive information, bypass certain security restrictions, cause a DoS (Denial of Service), or to compromise a vulnerable system, and by malicious people to disclose potentially sensitive information, conduct cross-site scripting attacks, or cause a DoS.

To upgrade your distribution, selected your version from the list provided in the advisory.

Continue Reading · Add comment

Raphael Stolt’s Blog: Transforming data centered XML into SQL statements

In this new post on Raphael Stolt’s blog, he shows a way that you can take XML that holds SQL information (in his example INSERTs and DELETEs) and transforms them into SQL statements via XSL stylesheets.

A canny data import technique that emerged from praxis, while working on the import of data-centered XML resources, is utilitizing the abilities of Xslt. The generation of the required SQL statements actually only needs a simple Xsl stylesheet which might import for an PHP XSLTProcessor object or pass to the xsltproc command line tool. Both further described approaches are based upon the libxslt library and are assuming the use of XSLT 1.0.

He starts with an example bit of XML that has the XSL stylesheet at the top that will be used to transform the data and the information to perform inserts on several “partner” values in the XML below. Following this, he creates a PHP class to load the file and apply the stylesheet.

He also mentions a few different approaches to the same problem - XSLTProcessor class approach returning a single SQL string , xsltproc approach and the XSLTProcessor class approach using the ability to use PHP functions as XSLT functions.

Continue Reading · Add comment