So you've got a spiffy new web application? Customers are raving about how cool everything looks and how neat all the new functionality is! In fact, you've just passed the one month mark and new customers are streaming to your site. Congratulations!

Two months pass, and then it happens. You get your first call from a customer, angry that the site is "crawling"; that it takes fifteen seconds for the search results to appear. Then the emails start coming in confirming that the site is displaying some error message about too many connections.

Think it can't happen to you? Think again. All web applications have their breaking points, and you need to know how to properly diagnose your schema and streamline your application code.

In this session, you'll learn:

• how to diagnose MySQL database performance bottlenecks using a variety of tools
• how to identify and FIX problem SQL code
• best practices for writing streamlined, efficient SQL code that takes advantage of MySQL's strengths
• about advanced index concepts
• how to build an effective indexing strategy
• how to choose appropriate storage engines for different types of data
• how to adjust choice MySQL server parameters to squeeze the most performance out of your application
• how to plan for growth, in your code and in your index strategy

Managing and querying XML data just got easier than ever with the combination of PHP and DB2 Viper (next generation data server from IBM). In this session we will take a look at the new capabilites now available for PHP developers using the powerful new XQuery language and we will take a tour of the PHP interfaces and optimizations for using DB2. We will discuss how these features can be leverage to rapidly develop applications in a Service-Oriented Architecture (SOA).

PHP has become amazingly popular due to its simple pragmatic approach to solving the web problem. As the web evolves and users demand even more dynamic web applications, the need for PHP keeps growing. People want richer web applications, they want AJAX, JSON and client-side magic to turn what used to be a series of linked pages into something resembling a desktop application.

In this talk Rasmus will cover the basic building blocks PHP 5 provides for building rich web applications and show how to use these features to build a very rich and very fast web app.

In this presentation Sam will provide a technical overview of the architecture and features of Quercus. Potential use cases will also be explored, with technical details provided for using Quercus as a PHP engine only, as well as the use of Quercus for leveraging existing backend Java deployments.

This talk will primarily focus on introducing the audience to the PDO extension and the demonstration of its capabilities and features. This will include the installation procedure, database connection instantiation, query execution process for both retrieval and modification operations. Demonstration of prepared statements in the various formats supported and the many different ways PDO can allow the query results to be fetched. As part of the tutorial the reason behind PDO will be explained and its advantage over single-database driver or user-land wrappers reviewed.

Developing and delivering large scale robust web applications requires organizations to change directions quickly during development, communicate and adapt to feedback from customers. If the product development process is time-consuming and heavy-weight, it makes it difficult for teams to respond to change fast enough. In this talk Gunjan Doshi provides a detailed overview to concepts of agile software development and agile methods; especially the way it relates to the PHP world. He walks you through a step by step approach to how Community Connect Inc. develops software on time, budget and of highest quality and at the same time meeting business expectations. The talk is based on his vast experience as a senior agile coach and now head of product development at Community Connect Inc. Some of the practices that will be covered in this session are iterative and incremental delivery, test-driven development, continuous integration, pair programming etc.

Metaprogramming is a handy approach for object-relational mapping tools, web-programming frameworks, and other problem domains where building a new programming language on top of an old one becomes the shortest route to a solution.

PHP's 'solve the web problem' aesthetic makes some metaprogramming tasks difficult, but it nevertheless has a large collection of features that let you programmatically tweak syntax, style, and other coding aspects.

This talk starts you on the road to metaprogramming nirvana by exploring techniques including:

• magic methods
• stream wrappers
• SPL interfaces
• various experimental extensions

This discussion will cover the building of a Financial Services website using OSS tools. As we examine the competitive technology choices, we will weigh the benefits of using each of these tools to process sensitive financial data. We will then move into the discussion of building an OSS site covering the development teams and tools, operational issues, eCommerce setup, current data transfer trends, and most importantly the security infrastructure needed to work with or in todays financial institutions. Finally we will address the financial rationale and acceptance of OSS tools inside an enterprise and any pitfalls and considerations that need to be addressed inside the OSS Enterprise.

This session teaches you how to detect and debug PHP scripts with the free open source tool Xdebug, which is an extension to PHP. The first part will deal with some of the internals of the extension to explain how it gathers information from the PHP Engine. The second part of the session will cover detecting problems in your scripts by showing how Xdebug provides debugging aides in the form of stack/function traces, dumps of variables, modified PHP functions. In the last part I will show the remote debugger capabilities of Xdebug, where you can: set breakpoints on functions, methods and file/line compabinations; watch execution details such as stack frames, per-frame information; run PHP code to modify the current state of your script and evaluating error messages. On top of this you will also see how you can use Xdebug's profiler to find bottlenecks in your applications. No knowledge of C is required to follow this session, but some basic knowledge would be beneficial for the first part.

There is always a gap between emerging technologies and how they benefit businesses. Often times, newer technologies have a hard time finding their place in the corporate world. In this session, Jaisen will uncover all of the buzz surrounding AJAX and JSON. He will be speaking about ways that these technologies can benefit your business. He will also cover ways to get prepared for the implementation of these technologies into your business.

Salesforce.com’s AppExchange provides partners and developers with a direct way to reach almost 400,000 paying on-demand application users. With this opportunity in mind, thousands of developers are creating composite applications using salesforce.com data and web services, and delivering these applications to customers via the AppExchange. Salesforce.com’s recently released PHP Toolkit makes AppExchange the ideal platform for PHP developers looking to reach the huge, untapped market for on-demand business applications. This session will discuss how to write on-demand PHP applications using the AppExchange Web services API, and how to take these applications to market via the AppExchange directory.

Web Services and PHP were a love at third or fourth sight. There are several options, and they all have their strenghts and weaknesses. This presentation uses a non-nonsense approach to introduce the basic concepts, analyze the different Web Services packages and modules available for PHP, and offering best practices how to avoid common traps. Also, interoperability with Web Services implementations in other technologies (e.g. .NET) will be covered.

As the number of cyber attacks from both amateur hackers and organized cyber terrorists is moving to new heights, enterprises have rushed to protect their networks with firewalls, VPNs, and Intrusion Detection Systems (IDSs) solutions. However their web applications are often left neglected. According to Gartner, more than 75% of Internet attacks today occur through web applications due to insecure code and a general neglect of application security. Web applications are open by nature so that enterprises can conduct business; however, this openness allows hackers to exploit vulnerabilities and attack databases that store sensitive customer and corporate information.

Though the past several years have witnessed the development of a number of solutions in response to the compounding increases in risk, exposure, and liability, each approach has drawbacks that make it difficult for security executives and QA professionals to determine how to best protect their systems. In this presentation, John will discuss the rise of application vulnerabilities and offer his opinion on the critical role of systematic assessment and remediation of these vulnerabilities across enterprise applications.

The topic of the session is to introduce the collaborative publishing online systems. These systems gather in a single online tool a collaborative working system, a content management system and a rendering engine, which allows to create on-the-fly, ready-to-print documents.

The usage of such systems in the publishing industry creates substantial values ; in fact, it allows the manager to apply a defined policy and to gather its teams, to simplify and standardize processes and worlflows, to reduce its publishing costs.

After having presented the large amount of areas in which these systems may be useful with real cases as examples, we will think about the strategical consequences of such a technology. The second part of the session will illustrate how PHP is the dedicated language to build such systems, merging every components in a single tool.

L'objet de cette session est de faire un état des lieux des plateformes collaboratives destinées au monde de l'édition. Ces plateformes fédèrent en un même outil en ligne, des outils de travail collaboratif permettant de travailler autour d'une ou de plusieurs publications, des outils de gestion de contenu permettant de les alimenter et enfin des moteurs de rendu générant des documents prêts à imprimer.

L'utilisation de telles plateformes dans le cadre de publications externes ou internes est génératrice de valeur, en permettant au manager d'affirmer une politique et de fédérer des équipes, d'harmoniser sa politique éditoriale et de réduire ses coûts de production.

Après avoir présenté les nombreuses applciations de ces plateformes à travers d'exemples concrets, nous réfléchirons aux répercussions stratégiques d'une telle technologie. La dernière partie de la session met en scène le développement d'une telle plateforme et illustre comment PHP vient s'imposer comme le langage de référence pour associer les différents composants d'une telle solution.

In this talk, you'll learn why maintaining other people's PHP code is akin to the ninth circle of hell, and how to write your own code so as not to inflict that on others. We'll cover:

• why PHP code tends toward the unmaintainable
• the use and abuse of coding conventions
• the use and abuse of classes
• the use and abuse of exceptions
• levels of granularity in modularization
• designed code versus organic code
• refactoring for maintainability

Businesses need a great deal of flexibility and agility to continue to succeed, support their employees and work with customers and partners. There is a constant, growing requirement for applications to respond to specific, immediate business situations. In many cases, the business must develop and deploy these applications in a few days, and tinker with them as the situation evolves. The lifetime of these applications may be a few days or weeks. We use the term situational application to describe these applications. The process by which they are developed and their lifecylcle is radically different from more traditional packaged applications and in-house, enterprise applications.

PHP (LAMP) is an increasingly popular approach to building situational applications. These applications access data specific to the application, in an embedded database, and access enterprise data and applications through a Service Oriented Architecture (SOA). This approach supports rapid, iterative development of the situational application. The development often occurs within a department or line of business. In many cases, development occurs on a personal computer. This approach offers tremendous flexibility.

Deployment and delivery of situational applications from department or personal computers can be extremely problematic. An unmanaged population of situational applications can degrade the performance of operational enterprise applications. The load on the situational applications may vary tremendously over time, requiring server management and reconfiguration in the department. Regulatory compliance and compliance with corporate policies, e.g. audit, may not be possible without governance of applications and data access.

In this paper, we describe two key technologies for enabling the flexibility of situational applications without compromising enterprise application and data management. The first technology is a simple set industry standard programming model concepts -- the Service Component Architecture and Service Data Objects. These concepts simplify the development of PHP applications. The simplification is especially powerful for situational applications in an enterprise. The standards simplify development of applications accessing embedded data and enterprise services. The second technology is a set of data center components for managing and governing deployed situational applications. Deployment to the infrastructure is simple for the end-user. Thus, the enterprise achieves the flexibility of situational development in departments or lines of business, and achieves the benefits of governed delivery.

The presentation will include an end-to-end demonstration of the process and technology.

Columbia University is located in the city of New York. It strives to serve the interests of the city's residents, but many underpriviliged young adults will never walk it's beautiful main campus.

PHP serves as an ideally, suitable programming language to bridge this gap. Together with Workforce Outsourcing, a not-for-profit that aims to help underpriveliged young adults obtain a quality education and learn real-world skills.

I chose PHP as a core course to teach because it's open source, free, and (with a smile) has the ironically least educational discount of all software.

Native Unicode support is the main feature in the upcoming PHP 6. Come to this session and find out what this means for you and how you can take advantage of it. This talk will provide an overview of the most salient features of the Unicode support and illustrate the new internationalization features with a variety of demos on topics such as:

• Character set conversion
• Text boundary analysis
• Working with international dates and calendars
• Transliteration and text normalization
• Working with character sets and properties