by Luke Welling (Author), Laura Thomson (Author), Laura Thomson (Author), Luke Welling (Author)
Master today's best practices for succeeding with PHP 7 and MySQL 5.7 web database development! Long acknowledged as the clearest, most practical, and most down-to-earth guide to PHP/MySQL web development, the brand-new fifth edition of PHP and MySQL Web Development fully reflects the latest versions of PHP and MySQL. Maintaining the approach that has made this book so successful through, Luke Welling and Laura Thomson add extensive new coverage of security, cloud and mobile development, and using the PEAR repository's massive resources. Part I offers a crash course in using PHP, including data storage/retrieval, arrays, strings, regular expressions, code reuse, objects, and error/exception handling. Next, Part II walks you through designing, creating, accessing, and programming MySQL databases. Part III turns to web application security, adding new information on web security risks, instructions on how to build a secure web application, and up-to-the-minute discussions of cryptography and implementing authentication in PHP and MySQL. A full section on advanced PHP techniques addresses everything from networking and filesystem interaction to internationalization and localization, generating images, and PHP frameworks and components. The authors conclude with step-by-step walkthroughs of several real-world projects - from automated testing, to building user authentication and personalization, to building a web-based email service, to integrating with social media, to building web forums and shopping carts, and even to designing an API for your web applications. Contents at a Glance Part I Using PHP 1 PHP Crash Course 2 Storing and Retrieving Data 3 Using Arrays 4 String Manipulation and Regular Expressions 5 Reusing Code and Writing Functions 6 Object-Oriented PHP 7 Error and Exception Handling Part II Using MySQL 8 Designing Your Web Database 9 Creating Your Web Database 10 Working with Your MySQL Database 11 Accessing Your MySQL Database from the Web with PHP 12 Advanced MySQL Administration 13 Advanced MySQL Programming Part III Web Application Security 14 Web Application Security Risks 15 Building a Secure Web Application 16 Cryptography Basics 17 Implementing Authentication with PHP and MySQL Part IV Advanced PHP Techniques 18 Interacting with the File System and the Server 19 Using Network and Protocol Functions 20 Managing the Date and Time 21 Internationalization and Localization 22 Generating Images 23 Using Session Control in PHP 24 Frameworks and Components 25 Other Useful Features Part V Building Practical PHP and MySQL Projects 26 Using PHP and MySQL for Large Projects 27 Debugging and Logging 28 Automated Testing, Continuous Integration, and Continuous Deployment 29 Building User Authentication and Personalization 30 Building a Web-Based Email Service with Laravel 31 Social Media Integration Sharing and Authentication 32 Building Web Forums with Simple MVC 33 Building a Shopping Cart 34 Designing an API for Your Web Applications Part VI: Appendix A Installing Apache, PHP and MySQL
Format: Paperback
Pages: 1008
Edition: 4
Publisher: Addison Wesley
Published: 01 Oct 2008
ISBN 10: 0672329166
ISBN 13: 9780672329166
Book Overview: PHP and MySQL Web Development teaches you to develop dynamic, secure, commercial Web sites. Using the same accessible, popular teaching style of the three previous editions, this book has been thoroughly updated to reflect the rapidly changing landscape of MySQL and PHP. The fourth edition of PHP and MySQL Web Development includes updated examples and coverage of recent versions of PHP, through PHP 5.3, as well as new coverage of PHP security and Web 2.0 social networks.
Lead Authors
Laura Thomson is a senior software engineer at Mozilla Corporation. She was formerly a principal at both OmniTI and Tangled Web Design, and she has worked for RMIT University and the Boston Consulting Group. She holds a Bachelor of Applied Science (Computer Science) degree and a Bachelor of Engineering (Computer Systems Engineering) degree with honors.
Luke Welling is a web architect at OmniTI and regularly speaks on open source and web development topics at conferences such as OSCON, ZendCon, MySQLUC, PHPCon, OSDC, and LinuxTag. Prior to joining OmniTI, he worked for the web analytics company Hitwise.com, at the database vendor MySQL AB, and as an independent consultant at Tangled Web Design. He has taught computer science at RMIT University in Melbourne, Australia, and holds a Bachelor of Applied Science (Computer Science) degree.
Contributing Authors
Julie C. Meloni has been developing web-based applications since the Web first saw the light of day and remembers the excitement surrounding the first GUI web browser. She has authored numerous books and articles on web-based programming languages and database topics, including the bestselling Sams Teach Yourself PHP, MySQL and Apache All in One.
Adam DeFields is a consultant specializing in web application development, project management, and instructional design. He lives in Grand Rapids, Michigan where he runs Emanation Systems, LLC, a company he founded in 2002. He has been involved with web development projects using several different technologies, but has developed a strong preference toward PHP/MySQL-based projects.
Marc Wandschneider is a freelance software developer, author, and speaker who travels the globe working on interesting projects. In recent years, a lot of his attention has been focused on writing robust and scalable web applications, and in 2005 he wrote a book called Core Web Application Programming with PHP and MySQL. He was was previously the main developer of the SWiK open source community site.