Skip to Content
Expert PHP and MySQL®
book

Expert PHP and MySQL®

by Andrew Curioso, Ronald Bradford, Patrick Galbraith
March 2010
Intermediate to advanced
622 pages
15h 16m
English
Wrox
Content preview from Expert PHP and MySQL®

Chapter 2. Advanced PHP Concepts

WHAT'S IN THIS CHAPTER?

  • Using iterators

  • Making classes behave like arrays

  • Understanding Lambda-style functions

  • Using True lambda functions and closures

This chapter covers several concepts that can lead to better coding practices and cleaner, more manageable code. They are used in various chapters throughout the rest of the book and several of the concepts take advantage of the built-in functionality of the Standard PHP Library (SPL). Specifically, the four interfaces provided by the SPL allow programmers to easily utilize PHP's ability to iterate through data and create a data structure that behaves exactly like a PHP array.

This chapter also uses standard language constructs available in PHP 5.3.0 called lambda functions. Lambda functions are useful when they are used as closures to create dynamic functionality.

A fictitious book club database is used as the example for this chapter. The application is simple; it provides the minimal functionality and keeps the least amount of information about the books possible. This chapter goes over simple use cases.

A PROBLEM THAT NEEDS SOLVING

Loops are used in a typical PHP application to iterate directly through result sets fetched from MySQL:

<?php
$conn = mysql_connect( 'localhost', 'mysql_user',
                       'mysql_password', 'database' );
$result = mysql_query('SELECT * FROM 'example_table'', $conn);
if ( $result )
  while ( $row = mysql_fetch_assoc($result) ) {
    // Execute logic or display row
}
?>

The highlighted approach is ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Jump Start PHP Environment

Jump Start PHP Environment

Bruno Skvorc
PHP 7: Real World Application Development

PHP 7: Real World Application Development

Doug Bierer, Altaf Hussain, Branko Ajzele
PHP 7 Programming Blueprints

PHP 7 Programming Blueprints

Jose Palala, Martin Helmich

Publisher Resources

ISBN: 9780470563120Purchase book