How we did it:
For any feedback, any questions, any notes or just for chat - feel free to follow us on social networks
Michael James Hernandez, John Viescas
"Master every business SQL skill you need! Grouping, totaling, summaries, modifying databases, integrating data from multiple tables, and much more! Includes video introduction, 2+ hours of expert audio commentary, 200+ animated figures, 100+ self review questions, 100+ exercises, searching, hyperlinking, and more."--Container.
This is the second edition of David Powers' highly-respected PHP Solutions: Dynamic Web Design Made Easy. This new edition has been updated by David to incorporate changes to PHP since the first edition and to offer the latest techniques—a classic guide modernized for 21st century PHP techniques, innovations, and best practices. You want to make your websites more dynamic by adding a feedback form, creating a private area where members can upload images that are automatically resized, or perhaps storing all your content in a database. The problem is, you're not a programmer and the thought of writing code sends a chill up your spine. Or maybe you've dabbled a bit in PHP and MySQL, but you can't get past baby steps. If this describes you, then you've just found the right book. PHP and the MySQL database are deservedly the most popular combination for creating dynamic websites. They're free, easy to use, and provided by many web hosting companies in their standard packages. Unfortunately, most PHP books either expect you to be an expert already or force you to go through endless exercises of little practical value. In contrast, this book gives you real value right away through a series of practical examples that you can incorporate directly into your sites, optimizing performance and adding functionality such as file uploading, email feedback forms, image galleries, content management systems, and much more. Each solution is created with not only functionality in mind, but also visual design. But this book doesn't just provide a collection of ready-made scripts: each PHP Solution builds on what's gone before, teaching you the basics of PHP and database design quickly and painlessly. By the end of the book, you'll have the confidence to start writing your own scripts or—if you prefer to leave that task to others—to adapt existing scripts to your own requirements. Right from the start, you're shown how easy it is to protect your sites by adopting secure coding practices. What you’ll learn Updates to the first edition with the latest PHP techniques for modern, dynamic web design Create dynamic websites with design and usability in mind, as well as functionality Understand how PHP scripts work, giving you confidence to adapt them to your own needs Bring online forms to life, check required fields, and ensure user input is safe to process Upload files and automatically create thumbnails from larger images Manage website content with a searchable database Who this book is for This is a "must have" reference book for any Web developer using PHP scripting language. If you have read the first edition classic, then this update will bring you the latest PHP techniques and best practices. If you are new to dynamic web design with PHP, then David will introduce you to the core techniques and methods for dynamic PHP web sites, ready for the 21st century! Table of Contents What Is PHP—And Why Should I Care? Getting Ready to Work with PHP How to Write PHP Scripts Lightening Your Workload with Includes Bringing Forms to Life Uploading Files Using PHP to Manage Files Generating Thumbnail Images Pages That Remember: Simple Login and Multipage Forms Getting Started with MySQL Connecting to MySQL with PHP and SQL Creating a Dynamic Online Gallery Managing Content Formatting Text and Dates Pulling Data from Multiple Tables Managing Multiple Database Tables Authenticating Users with a Database
Paul DuBois, Stefan Hinz, Carsten Pedersen
An updated manual for those preparing for the two MySQL certification tests for MySQL 5 covers the principles, concepts, and techniques of the open-source database program to prepare for the core certification examinations, covering such areas as database management, installation, security, optimization, data types, client/server concepts, and disaster prevention. Original. (Advanced)