PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (5th Edition) Год издания: 2017 Автор: Ullman Larry Жанр или тематика: Программирование Издательство: Peachpit Press ISBN: 0134301846 Серия: Visual QuickPro Guide Язык: Английский Формат: PDF Качество: Издательский макет или текст (eBook) Интерактивное оглавление: Да Количество страниц: 1197 Описание: This book teaches you how to develop dynamic web sites with PHP and MySQL, covering the knowledge that most developers might require. In keeping with the format of the Visual QuickPro series, the information is discussed using a step-by-step approach with corresponding images. The focus has been kept on real-world, practical examples, avoiding “here’s something you could do but never would” scenarios. As a practicing web developer myself, I wrote about the information that I use and avoided those topics immaterial to the task at hand. As a practicing writer, I made certain to include topics and techniques that I know readers are asking about. The structure of the book is linear, and the intention is that you’ll read it in order. It begins with three chapters covering the fundamentals of PHP (by the second chapter, you will have already developed your first dynamic web page). After that, there are four chapters on SQL (Structured Query Language, which is used to interact with all databases) and MySQL. Those chapters teach the basics of SQL, database design, and the MySQL application in particular. Then there’s one chapter on debugging and error management, information everyone needs. This is followed by a chapter introducing how to use PHP and MySQL together, a remarkably easy thing to do. The following five chapters teach more application techniques to round out your knowledge. Security, in particular, is repeatedly addressed in those pages. The next two chapters expand your newfound knowledge into subjects that, though not critical, are ones you’ll want to pick up in time regardless. Finally, I’ve included two example chapters, in which the heart of different web applications are developed, with instructions.
Примеры страниц
Оглавление
Introduction Chapter 1 Introduction to PHP Basic Syntax Sending Data to the Browser Writing Comments What Are Variables? Introducing Strings Concatenating Strings Introducing Numbers Introducing Constants Single vs. Double Quotation Marks Basic Debugging Steps Review and Pursue Chapter 2 Programming with PHP Creating an HTML Form Handling an HTML Form Conditionals and Operators Validating Form Data Introducing Arrays For and While Loops Review and Pursue Chapter 3 Creating Dynamic Web Sites Including Multiple Files Handling HTML Forms, Revisited Making Sticky FormsCreating Your Own Functions Review and Pursue Chapter 4 Introduction to MySQL Naming Database Elements Choosing Your Column Types Choosing Other Column Properties Accessing MySQL Review and Pursue Chapter 5 Introduction to SQL Creating Databases and Tables Inserting Records Selecting Data Using Conditionals Using LIKE and NOT LIKE Sorting Query Results Limiting Query Results Updating Data Deleting Data Using Functions Review and Pursue Chapter 6 Database Design Normalization Creating Indexes Using Different Table Types Languages and MySQL Time Zones and MySQL Foreign Key ConstraintsReview and Pursue Chapter 7 Advanced SQL and MySQL Performing Joins Grouping Selected Results Advanced Selections Performing FULLTEXT Searches Optimizing Queries Performing Transactions Database Encryption Review and Pursue Chapter 8 Error Handling and Debugging Error Types and Basic Debugging Displaying PHP Errors Adjusting Error Reporting in PHP Creating Custom Error Handlers PHP Debugging Techniques SQL and MySQL Debugging Techniques Review and Pursue Chapter 9 Using PHP with MySQL Modifying the Template Connecting to MySQL Executing Simple Queries Retrieving Query Results Ensuring Secure SQL Counting Returned Records Updating Records with PHP Review and PursueChapter 10 Common Programming Techniques Sending Values to a Script Using Hidden Form Inputs Editing Existing Records Paginating Query Results Making Sortable Displays Review and Pursue Chapter 11 Web Application Development Sending Email Handling File Uploads PHP and JavaScript Understanding HTTP Headers Date and Time Functions Performing Transactions Review and Pursue Chapter 12 Cookies and Sessions Making a Login Page Making the Login Functions Using Cookies Using Sessions Improving Session Security Review and Pursue Chapter 13 Security Methods Preventing Spam Validating Data by Type Validating Files by Type Preventing XSS AttacksUsing the Filter Extension Preventing SQL Injection Attacks Securing Passwords with PHP Review and Pursue Chapter 14 Perl-Compatible Regular Expressions Creating a Test Script Defining Simple Patterns Using Quantifiers Using Character Classes Finding All Matches Using Modifiers Matching and Replacing Patterns Review and Pursue Chapter 15 Introducing jQuery What Is jQuery? Incorporating jQuery Using jQuery Selecting Page Elements Event Handling DOM Manipulation Using Ajax Review and Pursue Chapter 16 An OOP Primer Fundamentals and Syntax Working with MySQL The DateTime Class Review and PursueChapter 17 Example—Message Board Making the Database Writing the Templates Creating the Index Page Creating the Forum Page Creating the Thread Page Posting Messages Review and Pursue Chapter 18 Example—User Registration Creating the Templates Writing the Configuration Scripts Creating the Home Page Registration Activating an Account Logging In and Logging Out Password Management Review and Pursue Appendix A Installation Installation on Windows Installation on macOS Managing MySQL Users Testing Your Installation Configuring PHP Configuring Apache Index
Visual QuickPro Guide - Ullman Larry - PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (5th Edition) [2017, PDF, ENG] download torrent for free and without registration
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum