tailieunhanh - PHP and MySQL Web Development - P4

PHP and MySQL Web Development - P4: PHP and MySQL Web Development teaches the reader to develop dynamic, secure, commercial Web sites. Using the same accessible, popular teaching style of the first edition, this best-selling book has been updated to reflect the rapidly changing landscape of MySQL and PHP. | xvi Contents Altering Tables After Creation 218 Deleting Records from the Database 219 Dropping Tables 220 Dropping a Whole Database 220 Further Reading 220 Next 221 10 Accessing Your MySQL Database from the Web with PHP 223 How Web Database Architectures Work 224 The Basic Steps in Querying a Database from the Web 227 Checking and Filtering Input Data 227 Setting Up a Connection 228 Choosing a Database to Use 230 Querying the Database 230 Retrieving the Query Results 231 Disconnecting from the Database 232 Putting New Information in the Database 232 Other Useful PHP-MySQL Functions 236 Freeing Up Resources 236 Creating and Deleting Databases 236 Other PHP-Database Interfaces 236 Using a Generic Database Interface PEAR DB 237 Further Reading 240 Next 240 11 Advanced MySQL 241 Understanding the Privilege System in Detail 241 The user Table 242 The db and host Tables 243 The tables_priv and columns_priv Tables 244 Access Control How MySQL Uses the Grant Tables 245 Updating Privileges When Do Changes Take Effect 246 Making Your MySQL Database Secure 246 Contents xvii MySQL from the Operating System s Point of View 247 Passwords 247 User Privileges 248 Web Issues 248 Getting More Information About Databases 249 Getting Information with SHOW 249 Getting Information About Columns with DESCRIBE 251 Understanding How Queries Work with EXPLAIN 251 Speeding Up Queries with Indexes 254 General Optimization Tips 254 Design Optimization 255 Permissions 255 Table Optimization 255 Using Indexes 255 Use Default Values 255 Use Persistent Connections 256 Other Tips 256 Different Table Types 256 Loading Data from a File 257 Backing Up Your MySQL Database 257 Restoring Your MySQL Database 257 Further Reading 258 Next 258 III E-commerce and Security 12 Running an E-commerce Site 261 What Do You Want to Achieve 261 Types of Commercial Web Sites 261 Online Brochures 262 Taking Orders for Goods or Services 265 Providing Services and Digital Goods 268 Adding Value to Goods or Services 268