Feeds

Core Web Application Development With PHP and MySQL

Solid overview

3 Big data security analytics techniques

Book review PHP and MySQL provide the development language and database components of the LAMP (Linux, Apache, MySQL and PHP/Perl/Python) stack that drives huge chunks of the web. Over the years they have each evolved and grown in complexity and functionality and yet they are still tied together to provide a powerful and flexible platform for web applications.

Core Web Application Development book cover Aimed at the developer who wants to get to grips with building dynamic web applications, this is not a book that’s pitched at those who don’t know their mark-up. While there’s no prior knowledge of PHP assumed, the author does assume some existing knowledge of HTML and programming in general. There's little background assumed on the database side of things, not even of basic SQL. If you’ve ever hacked together a few static web pages using HTML and CSS, and have used at least one programming language then you'll find the book pitched at around the right level.

The book is organised into five distinct sections, the first of which is an introduction to PHP 5 (the latest version of the language). Starting with the absolute basics of entering simple PHP scripts, it proceeds rapidly through datatypes, control structures, functions, objects, arrays, character sets and web forms. While the emphasis is on learning the language, the context is always firmly focused on solving the kinds of problems that web developers have to face (hence the chapter on character sets in a section otherwise devoted to the language itself).

The second section of the book then shifts attention to databases. A couple of chapters discuss alternative databases (including Oracle and PostgreSQL) and introduce some of the fundamentals of relational databases, including a quick SQL tutorial. The rest of the section includes discussion of database design, transaction processing and, of course, the practicalities of using PHP with MySQL.

Part three moves on to look at some of the broader issues of web application design, including n-tier architectures, user interface design, session and user management, and the vexed issue of security (including specific coverage of SQL injection attacks). A variety of other topics – such as regular expressions, XML handling, web services, cookies and session management – are lumped together in the fourth section.

The final section of the book brings the disparate topics together in three sample web apps: a blogging engine, an appointment manager and a shopping cart application. Having the sample applications at the end of the book, rather than as a common thread that runs throughout, is a wise choice. Firstly, it means the snippets of code in the earlier section neatly encapsulate a given topic rather than attempting to build up piece-meal into something bigger. Secondly, it also means that chapters can be read standalone rather than having to be followed sequentially to understand what’s happening in the code.

Core Web Application Development With PHP and MySQL

Verdict: Overall the choice of topics provides a good solid overview both of the specifics of PHP and MySQL and also the broader issues of web application development. This makes the book a much more useful proposition than separate PHP and MySQL introductions.

Author: Marc Wandschneider

Publisher: Prentice Hall PTR

ISBN: 0131867164

Media: Book

List Price: £35.99

Reg price: £28.79

Top three mobile application threats

More from The Register

next story
This time it's 'Personal': new Office 365 sub covers just two devices
Redmond also brings Office into Google's back yard
Inside the Hekaton: SQL Server 2014's database engine deconstructed
Nadella's database sqares the circle of cheap memory vs speed
Oh no, Joe: WinPhone users already griping over 8.1 mega-update
Hang on. Which bit of Developer Preview don't you understand?
Microsoft lobs pre-release Windows Phone 8.1 at devs who dare
App makers can load it before anyone else, but if they do they're stuck with it
Half of Twitter's 'active users' are SILENT STALKERS
Nearly 50% have NEVER tweeted a word
Internet-of-stuff startup dumps NoSQL for ... SQL?
NoSQL taste great at first but lacks proper nutrients, says startup cloud whiz
IRS boss on XP migration: 'Classic fix the airplane while you're flying it attempt'
Plus: Condoleezza Rice at Dropbox 'maybe she can find ... weapons of mass destruction'
Ditch the sync, paddle in the Streem: Upstart offers syncless sharing
Upload, delete and carry on sharing afterwards?
Microsoft TIER SMEAR changes app prices whether devs ask or not
Some go up, some go down, Redmond goes silent
prev story

Whitepapers

Top three mobile application threats
Learn about three of the top mobile application security threats facing businesses today and recommendations on how to mitigate the risk.
Combat fraud and increase customer satisfaction
Based on their experience using HP ArcSight Enterprise Security Manager for IT security operations, Finansbank moved to HP ArcSight ESM for fraud management.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
SANS - Survey on application security programs
In this whitepaper learn about the state of application security programs and practices of 488 surveyed respondents, and discover how mature and effective these programs are.