Beginning PHP and MySQL 5: From Novice to ProfessionalBeginning PHP 5 and MySQL 5: From Novice to Professional, Second Edition, offers a comprehensive guide to two of the most prominent open source technologies on the planet: the PHP scripting language and the MySQL database server. Updated to introduce the features found in MySQL 5, which is MySQL's most significant release to date, this second edition shows readers how to take advantage of both technologies to build powerful, manageable, and stable web applications. Essentially three books in one, the second edition includes comprehensive discussions about PHP 5, MySQL 5, and demonstrates how these two popular open source technologies work together to create powerful websites.The book is packed with practical examples and insight into the real-world challenges faced by developers. Based on the author's seven years experience working with these technologies, readers will repeatedly return to this book as a valuable instructional tool and reference guide. TOC:An Introduction to PHP.- Installing and Configuring PHP.- PHP Basics.- Functions.- Arrays.- Object-Oriented PHP.- Advanced OOP Features.- Error and Exception Handling.- Strings and Regular Expressions.- Working with the File and Operating System.- PEAR.- Forms and Navigational Cues.- Authentication.- Handling File Uploads.- Networking with PHP.- PHP and LDAP.- Session Handlers.- Templating with Smarty.- Web Services.- Secure PHP Programming.- SQLite.- Introducing MySQL.- Installing and Configuring MySQL.- MySQL Administration.- The Many MySQL Clients.- MySQL Table Structures and Datatypes.- Securing MySQL.- PHP's mysql Library.- PHP's mysqli Library.- Stored Procedures.- Triggers.- Views.- Practical Database Queries.- Indexes and Searching.- Transactions.- Importing and Exporting Data. |
Contents
CHAPTER | 5 |
Installing and Configuring Apache and PHP | 9 |
ANCHAPTER | 11 |
Copyright | |
48 other sections not shown
Other editions - View all
Common terms and phrases
Apache application array assigned associative array attribute binary boolean browser chapter character client column command connection consider constructor create database server datatype Default value delete delimiter determines e-mail echo employee enabled error example follows execute extension fopen format function returns header IMAP InnoDB input INSERT installation integer interface introduced Jason Keep in mind language LDAP link_id Linux Listing located method modify MyISAM MySQL database MySQL server NULL object-oriented offers operating option output package parameter parsing password PEAR PHP script PHP_INI_ALL PHP_INI_SYSTEM PHP's privileges programming query regular expression resource result set retrieve Scope SELECT sendmail session Smarty specified SQLite statement storage engine stored procedure string syntax syslog template timestamp trigger Unix UPDATE uploaded username VARCHAR variable Web Services webuser Windows WSDL