PHP Magazin 1/06: ext/mysqli, der neue Leim

Mit der neuen Ausgabe des PHP Magazins, die am heutigen Tag an den Kiosken erscheint, beleuchten wir den Einsatz der neuen ext/mysqli Extension in PHP. Kai Voigt, Trainer und Consultant bei MySQL, führt Sie auf sechs Seiten durch die neue Extension, die ab PHP 5 zur Verfügung steht und speziell auch die neuen Features von MySQL 4.1 unterstützt.

Weitere Themen in dieser Ausgabe:

  • GPS für Webseiten (Google Sitemaps)
  • Eigene Streamwrapper in PHP realisieren
  • Vorstellung des PHP Frameworks PRADO
  • Location Based Services mit PHP
  • PHP Extensions im Eigenbau
  • und und und …

Seit ein bis zwei Ausgaben hat auch das Grafikteam des Software & Support Verlags fleissig Hand an das Layout gelegt und das Erscheinungsbild des Magazins weiter optimiert. Das Magazin kommt frischer daher und featured Autoren auch durch die Darstellung ihrer Gesichter. Somit bekommt das Magazin eine weitere persönliche Note und Sie können sich eher ein Bild davon machen, wer hinter den Artikeln steckt.

Das Magazin gibt es an jedem gut sortierten Kiosk oder ist über die Website zu beziehen. Über Feedback zum neuen Layout freue ich mich an meine E-Mail Adresse

International PHP Magazine: PDF editions available

Congratulations to Masoud and his whole team at S&S Media, the publishing house that’s very active in the IT area and also supports PHP through:

The website was relaunched today. In the past, the magazine was available as a true print edition (really nice offset print in full colour, not just a laser printer output) every two months (as the German edition I’m responsible for is also available in this frequency) and had a PDF version as „a plus“ (included with a new feature article every month). Now, they entirely switched to PDF and will now be published every month.

I think this is a step in the right direction, especially in a global world-wide view. Print distribution around the globe is at high cost, so PDF is the right format to go on with.

My personal point of view, though, is that I love printed stuff. Perhaps this has to do with Germany’s long history in the area of printed media, but I like the haptic feeling that you will have when opening a nice book or magazine while drinking a cup of tea especially on cold days. :-)

So, for the German PHP Magazin (which has independant topics in contrast to the international issue) in future I will love to receive the printed issues in my mailbox and I’m currently preparing our colour laser printer for the new issue of the International PHP Magazine. :-)

Great job done, Masoud!

MySQL Cluster and RegEx slides

Here are the slides from our fellow Alexander Aulbach. The cluster slides are available both in German and English. Feel free to contact him directly if you have any questions.

MySQL Cluster (German language): MySQL-Cluster.pdf
MySQL Cluster (English language): MySQLCluster_en.pdf
Chomsky Typ3 Sprachen oder „Hab Spaß mit RegEx“: KomskyTyp-3Sprachen.pdf

Did you know that MySQL Cluster has been available since MySQL 4 within the Max distribution (IIRC 4.1 series)? So just
grab your copy at (of course the new 5.x series :-) and play with the

Slides from International PHP Conference, part 1

As promised, here’s now the first part of the slides from the International PHP Conferences. The sessions I gave were the introduction for the Management Day, „100,000 SQLite installations – lessons learned“ (and where the borders are in regards to the usage of MySQL) and „WebServices with PHP5“.

Download Management Day slides: phpconf05_managementday.pdf
Download SQLite slides: phpconf05_sqlite.pdf
Download WebServices with PHP5 talk: phpconf05_webservices_php5.pdf

International PHP Conference 2005: it’s over

Zeev wearing a ThinkPHP lenyard
Yesterday, the International PHP Conference 2005 closed its doors. So far,
it was very nice to see all the people again and have some good time. Luckily, there was enough free beer at the VIP
Reception and the PHP Lounge. :-) This year, we introduced some new events:

The Management Day: you know, attendees usually are not only the smaller or mid-sized companies. Mostly, companies
like Deutsche Telekom, Siemens and other companies send 3-10 people from their department to this Conference to catch
up with the latest hot development in the PHP scene. This year, we tried to provide a separate day fully dedicated to the
topic „PHP in the Enterprise“. I think we pretty much succeeded. We invited companies like T-Online (a subsidiary company of
Deutsche Telekom), HypoVereinsbank (one of Europe’s largest banks), Pangora GmbH (a subsidiary company of Lycos Europe),
EurotaxxGlass’s (they publish the well-known Schwacke book for used cars) and Amadeus Fire AG to let them talk about their
usage of PHP (or better, the LAMP stack because some heavily rely at their core on PHP+MySQL) in their company and how
they think that PHP fulfills their needs and where PHP has to improve. At the beginning of this day and as this day was only
in German language, I provided a renewal of my talk „10 years of PHP and MySQL in Germany“ (which I gave at LinuxTag) where
I provided a closer look into how the PHP business here in Germany has been developing in the last 7 years and what will perhaps
follow in the next years. After the company sessions, the Management Day closed with a discussion panel and some sponsored
free drinks and food (by my company).

PHP Code Camp: Software&Support and I had the following question which led to the PHP Code Camp: „How can we give the people/community an understanding of how you write a PHP extension in C?“. Thanks to Marcus Börger, Johannes Schlüter, Derick
Rethans and Ilia Alshanetsky the attendees could learn how to write a PHP extension. From what I have heard, the PHP Code Camp (which started at 4.30 pm and ended around 9 pm with some free beer and pizza) was pretty well perceived, and I hope that we will
repeat that next year. Thanks again to Marcus, Johannes, Derick and Ilia for supporting this event.

Can anyone remember the nice girls from Brazil back in 2003? Well, we replaced the girls with the PHP Lounge where we set up an environment with a bunch of sockets, free beer, nice music and some of the PHP pros acting as coaches where you could discuss the PHP problems you might have been experiencing in your company and talking about your current projects. I joined the PHP lounge together with some CIO of a department of S**mens (he’s been attending the Conference for years and I really enjoy talking with him about his latest projects), drinking some beer and talking with some guys from Intergenia about bug and request tracking, CVSSpam and Scrum.

Finally, my company was a silver sponsor at this Conference, having our own booth (where you could win two iPod shuffles – congrats to Dirk and Arne!) and providing free PHP5 posters, PHP stickers and ThinkPHP lenyards for special persons (kudos Zeev). :-) We did not
only provide those dogfood for community, but also presented our commercial services. Of course, this year we also provided exhibition booths for OpenSource projects like Hardened PHP, Horde and others.

It was a great pleasure for me to meet Zeev, Marcus, Derick and all the others again and I hope that we’ll see again next year!
Thanks to Sebastian for setting up a Flickr group of the International PHP Conference.
Follow the HOWTO and add
your photos from the Conference there. :-)

This year we were giving some sessions (/me with „100,000 SQLite installations – lessons learned“, „WebServices with PHP5“ and
Alex Aulbach about MySQL Cluster). We’ll post the slides soon on this blog, so stay tuned.

Enterprise OpenSource: PHP/LAMP Support for corporate businesses

More and more companies are discovering LAMP as an enterprise-grade, OpenSource stack to built mission-critical applications on it.
Web development companies are developing LAMP applications for businesses like Disney, Deutsche Telekom,, Lufthansa and such.
But what about a professional support with guaranteed response times up to 2 hours? That’s where our PHP/LAMP support is targeted at, including support for databases like MySQL for example.

We provide support for enterprise companies that have their own development department, but need someone who is helping them
if they experience problems while developing their application, including application management and monitoring. The support
program is for an unlimited number of servers in your company.

If you are an ISV or SI with your own PHP developers, then this support is also for you: we can assist you through the support
and provide reliable knowledge and responsibility for PHP. The support program is divided into Basic, Professional and Gold. 24/7
on request.

If you are on this year’s International PHP Conference, please contact us on our
booth, visit the website or contact us directly.

Economic journals become aware of LAMP – in one of the biggest PHP markets of the world: Germany

PHP has been used in the business for years. In fact, we and many other companies provided business-critical solutions based on PHP (or LAMP) for several years now. Magazines
like PHP Magazin or web sites like or, not forgetting the world’s first PHP Conference that took place here in Germany provided the fruitful ground for a market that continously attracted larger businesses searching for
a fast, reliable and easy-to-deploy solution for their critical business processes.

General IT magazines like iX or c’t had several articles about PHP in the past,
even the Computerwoche had several
news items/articles about PHP and MySQL.

It’s very satisfying to see that now economic journals like the German Wirtschaftswoche notice the OpenSource LAMP stack
and define it as a serious competitor to .NET, Java & Co. The article is titled „Open-Source-Software: IT-Infrastruktur vor dem Umbruch“ and available at

The overall success of the usage of PHP and the popular LAMP stack (Linux, Apache, MySQL, PHP) wouldn’t be possible with the help of thousands of people who have fun
contributing code, insights, documentation pieces, tutorials, FAQs, sessions on Conferences and sharing their time to learn from each other. Thanks to all,
and I’m glad to see some of you on next week’s International PHP Conference.

„PHP Collaboration Project“ vs. „PHP Community Process“

Frankly, PCP reminds me on an idea I had 6 to 12 months ago and briefly discussed it with Zak Greant (who discussed it with one of the inventors of the JCP, the Java Community Process with its JSR’s), IIRC Stig Bakken and others. We called it „PHP Community Process“. My basic concern was that while we have PEAR and PECL, there is no „controlled“ way of implementing PHP packages/specifications that may emerge to some kind of an industry standard. PEAR was a good beginning but with the recent acknowledge from industry vendors I think we need some kind of „JCP“ (have a look at „PHP-170“ where we ported the JSR-170 standard for content management to PHP which recently stepped into the Apache Incubator process on the project Jackrabbit) for PHP. PEAR contains working packages for direct use, the JCP with its JSRs contains also only specifications with APIs while the implementation can be done by anyone – with the new OOP functionality in PHP5 like abstract classes, interfaces etc. this is no problem as our port of JSR-170 proves.

In contrast, the „PHP Collaboration Project“ seems to be a good beginning, but I think at the end we need some kind of a process where both the community and so called „expert groups“ consisting of subject matter experts (i.e. from companies) are working out a specification along with an API and a reference implementation. At the end of the day, this will hopefully lead into stable APIs for packages/reference implementations.

I don’t say that the PHP world should simply copy the JCP 1-to-1, but I think it would be good to think about specifications and APIs instead of „frameworks“ (there’s always more than 1 solution in the PHP world) as the „PHP Collaboration Project“ does.

What do you think? Please post comments or mail me at

PS: the way PEAR and PECL have developed in the last months is really awesome. Great work, guys!


Mayflower auf der Systems 2005

Der Software & Support Verlag veranstaltet auf der Systems die SDA Area. Dieser eigenständige Bereich innerhalb der Systems dreht sich rund um die Themen Softwareentwicklung und IT Architektur. Björn Schotte hält einen Vortrag über „LAMP im Unternehmenseinsatz für geschäftskritische Applikationen“. Termin: 27. Oktober 2005, 13:00 Uhr. Die SDA Area befindet sich in Halle 2.

Daneben sind wir als Partner-Aussteller am Stand von MySQL und präsentieren unsere allgemeinen und branchenspezifischen Lösungen im Bereich der Webapplikationen. Besuchen Sie uns in Halle A3, Stand 162. Wenn Sie einen Gesprächstermin wünschen, so sprechen Sie uns an.

The SAP developer’s guide to PHP

I was doing some research with Google’s new blog search and came over to Craig Cmehil’s blog talking about a new book published by SAP press: The SAP developer’s guide to PHP. The book is talking about:

So what does the book offer?

  • Introduction to PHP
  • SAPRFC module in practice
  • Connections with PHP to the SAP system
  • Unique example application

The full story is over here. We’ll have some review about this book in one of the next issues of PHP Magazin.