Catálogo de publicaciones - libros

This chapter introduced stored routines, one of MySQL’s newest and longest-awaited features. You learned about the advantages and disadvantages to consider when determining whether this feature should be incorporated into your development strategy, and all about MySQL’s specific implementation and syntax. Finally, you learned how easy it is to incorporate both stored functions and stored procedures into your PHP applications.

The next chapter introduces another feature new to MySQL 5.0: triggers.

This chapter introduced triggers, a feature new to MySQL 5.0. Triggers can greatly reduce the amount of code you need to write solely for ensuring the referential integrity and business rules of your database. You learned about the different trigger types and the conditions under which they will execute. An introduction to MySQL’s trigger implementation was offered, followed by coverage of how to integrate these triggers into your PHP applications.

The next chapter introduces , yet another feature new to MySQL 5.

This chapter introduced views, a new feature introduced in MySQL 5.0. Views can greatly cut down on otherwise repetitive queries in your applications, and enhance security and maintainability. In this chapter you learned how to create, execute, modify, and delete MySQL views, and incorporate them into your PHP-driven applications.

The next chapter delves into the topic of queries, covering numerous concepts that you’re bound to encounter repeatedly when building data-driven Web sites.

This chapter introduced many common general tasks that you’ll encounter when developing data-driven applications. The chapter started by providing a MySQL data class, and offering some basic usage examples involving this class. Next, you were presented with a convenient and easy methodology for outputting data results in tabular format, and then learned how to add actionable options for each output data row. This strategy was further expanded by showing you how to sort output based on a given table field. Finally, you learned how to spread query results across several pages by creating linked page listings, enabling the user to navigate the results in a nonlinear fashion.

The next chapter introduces MySQL’s database indexing and full-text search capabilities, and shows you how to execute Web-based database searches using PHP.

Table indexing is a sure-fire way to optimize queries. This chapter introduced table indexing and showed you how to create primary, unique, normal, and full-text indexes. You then learned just how easy it is to create PHP-enabled search interfaces for querying your MySQL tables.

The next chapter introduces MySQL’s transaction-handling feature and shows you how to incorporate transactions into your Web applications.

Database transactions are of immense use when modeling your business processes, because they help to ensure the integrity of your organization’s most valuable asset: its information. If you use database transactions prudently, they are a great asset when building databasedriven applications.

In the next and final chapter, you’ll learn how to use MySQL’s default utilities to both import and export large amounts of data. Additionally, you’ll see how to use a PHP script to format forms-based information for viewing via a spreadsheet application, such as Microsoft Excel.

MySQL’s data import and export utilities offer powerful solutions for migrating data to and from your MySQL database. Using them effectively can mean the difference between a maintenance nightmare and a triviality.

This concludes the book. Best of luck!