PHP and MySQL Web Development.pdf
Master today's best practices for succeeding with PHP 5.5 and MySQL 5.6 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, walk through designing, creating, accessing, and programming MySQL databases. Part III turns to e-commerce, adding extensive new coverage of web security, plus up-to-the-minute discussions of authentication and secure transactions. A full section of advanced PHP techniques addresses everything from networking and filesystem interaction to image generation and session control. The authors conclude with primers on real-world development and debugging, followed by ten start-to-finish case studies, from authentication to content management, personalized PDFs to web services and Web 2.0 apps.
PHP and MySQL Web Development, 5th Edition Introduction 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 E-commerce and Security 14 Running an E-commerce Site 15 E-commerce Security Issues 16 Web Application Security 17 Implementing Authentication with PHP and MySQL 18 Implementing Secure Transactions with PHP and MySQL Part IV Advanced PHP Techniques 19 Interacting with the File System and the Server 20 Using Network and Protocol Functions 21 Managing the Date and Time 22 Generating Images 23 Using Session Control in PHP 24 Other Useful Features Part V Building Practical PHP and MySQL Projects 25 Using PHP and MySQL for Large Projects 26 Debugging 27 Building User Authentication and Personalization: Social Bookmarking 28 Building a Shopping Cart 29 Building a Content Management System 30 Building a Web-Based Email Service 31 Building a Mailing List Manager 32 Building Web Forums 33 Generating Personalized Documents in Portable Document Format (PDF) 34 Connecting to Web Services with XML and SOAP 35 Building Web 2.0 Applications with Ajax Part VI: Appendices A Installing PHP5 and MySQL5 B Web Resources