Đang chuẩn bị liên kết để tải về tài liệu:
PHP 5/MySQL Programming- P84

Không đóng trình duyệt đến khi xuất hiện nút TẢI XUỐNG Tải xuống

PHP 5/MySQL Programming- P84:computer programming has often been seen as a difficult and arcane skill. Programming languages are difficult and complicated, out of the typical person’s reach. However, the advent of the World Wide Web has changed that to some extent. It’s reasonably easy to build and post a Web page for the entire world to see. The language of the Web is reasonably simple, and numerous applications are available to assist in the preparation of static pages | 393 If I want to improve a module I do it once in the library rather than in several places. It is extremely simple to modify the code library so it works with another database. The details of each particular module are hidden in a separate library so I can focus on the bigger picture when writing each PHP page. The routines can be reused to work with any table in the database. The routines can automatically adjust to changes in the data structure. The library can be readily reused for another project. Figure 12.11 shows a more detailed state diagram. figure 12.11 This state diagram illustrates the relationship between PHP programs and functions in the spyLib code library. Chapter 12 Building a Three-Tiered Data Application When you begin looking at actual code you ll see most of the PHP programs are extremely simple. They usually just collect data for a library function send program control off to that function and then print any output produced by the function. Writing the Non-Library Code I begin here by describing all the parts of this project except the library. The library module is driven by the needs of the other PHP programs so it makes sense to look at the other programs first. 394 Preparing the Database PHP 5 MySQL Programming for the Absolute Beginner The database for this segment is almost the same as the one used in chapter 11 Data Normalization. I added one table to store queries. All other tables are the same as those in chapter 11. The SQL script that creates this new version of the spy database is available on the CD as buildSpy.sql. Note I have modified the database slightly from chapter 11 because the new version includes several queries as part of the data In order to make the program reasonably secure I don t want typical users to be able to make queries. I also don t want users to be limited to the few queries I thought of when building this system. One solution is to store a set of queries in the database and let appropriate users modify the