Phát triển web với PHP và MySQL - p 2

CONTENTS Web Database Architecture 180 Architecture 180 Further Reading 182 Next 182 8 Creating Your Web Database 183 A Note on Using the MySQL Monitor 185 How to Log In to MySQL 185 Creating Databases and Users 187 Creating the Database 187 Users and Privileges 187 Introduction to MySQL’s Privilege System 188. | xi Contents Web Database Architecture .180 Architecture .180 Further Reading .182 Next .182 8 Creating Your Web Database 183 A Note on Using the MySQL Monitor .185 How to Log In to MySQL .185 Creating Databases and Users .187 Creating the Users and Privileges .187 Introduction to MySQL s Privilege Principle of Least Privilege .188 Setting Up Users The GRANT Command .188 Types and Levels of Privilege .190 The REVOKE Command .192 Examples Using GRANT and Setting Up a User for the Logging Out As Using the Right Database .193 Creating Database What the Other Keywords Mean .196 Understanding the Column Types .196 Looking at the Database with SHOW and MySQL Identifiers .199 Column Data Types .200 Numeric Types .201 Further Reading .206 Next .206 9 Working with Your MySQL Database 207 What Is SQL .208 Inserting Data into the Database .209 Retrieving Data from the Database .211 Retrieving Data with Specific Criteria .212 Retrieving Data from Multiple Tables .214 Retrieving Data in a Particular Grouping and Aggregating Data .220 Choosing Which Rows to Return .222 Updating Records in the Database .223 Altering Tables After Deleting Records from the Database .225 Dropping Tables .226 xii PHP AND MySQL Web Development Dropping a Whole Database .226 Further Reading .226 Next .226 10 Accessing Your MySQL Database from the Web with PHp 227 How Web Database Architectures Work .228 The Basic Steps in Querying a Database from the Web .232 Checking and Filtering Input Data .232 Setting Up a Connection .234 Choosing a Database to Use .235 Querying the Retrieving the Query Disconnecting from the Database .238 Putting New Information in the Database .238 Other Useful PHP-MySQL Functions .241 Freeing Up Resources .241 Creating and Deleting Databases .242 Other PHP-Database Interfaces .242 Further Reading .242 Next .243 11 Advanced MySQL 245 Understanding the .