Đang chuẩn bị liên kết để tải về tài liệu:
Giải pháp thiết kế web động với PHP - p 2

When both lights are green again, click Open start page in the MAMP Control Panel. This reloads the MAMP welcome page into your browser. This time, the URL is likely to have :80 after localhost. Because port 80 is the default, the addition of :80 is unnecessary, so it doesn't matter if it's missing. The only time you need the colon followed by a number is if you use nonstandard ports. If you were expecting to have to do more, that s all there is to it | CONTENTS Breaking down information into small chunks.283 Checkpoints for good database design.284 Using MySQL with a graphical interface.284 Launching phpMyAdmin.286 Setting up the phpsols database.287 MySQL naming rules.287 Using phpMyAdmin to create a new database.288 Creating database-specific user accounts.288 Creating a database table.291 Inserting records into a table.293 Creating a SQL file for backup and data transfer.297 Choosing the right data type in MySQL.299 Storing text.299 Storing numbers.300 Storing dates and times.300 Storing predefined lists.301 Storing binary data.301 Chapter review.301 Chapter 11 Connecting to MySQL with PHP and SQL.303 Checking your remote server setup.304 How PHP communicates with MySQL.305 Connecting with the MySQL Improved extension.305 Connecting with PDO.305 PHP Solution 11-1 Making a reusable database connector.306 Finding the number of results from a query.307 Displaying the results of a query.310 MySQL connection crib sheet.313 Using SQL to interact with a database.314 Writing SQL queries.314 Refining the data retrieved by a SELECT query.315 Understanding the danger of SQL injection.319 Chapter review.334 ix CONTENTS Download from Wow eBook www.wowebook.com Chapter 12 Creating a Dynamic Online Gallery.335 Why not store images in a database .336 Planning the gallery.336 Converting the gallery elements to PHP.339 Building the dynamic elements.341 Passing information through a query string.341 Creating a multicolumn table.344 Paging through a long set of records.347 Chapter review.353 Chapter 13 Managing Content.355 Setting up a content management system.355 Creating the blog database table.356 Creating the basic insert and update form.357 Inserting new records.359 Linking to the update and delete pages.363 Updating records.366 Deleting records.375 Reviewing the four essential SQL commands.376 SELECT.377 INSERT.379 UPDATE.380 DELETE.380 Security and error messages.380 Chapter review.381 Chapter 14 Formatting Text and .