TAILIEUCHUNG - PHP 5/MySQL Programming- P84

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 shows a more detailed state diagram. figure 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 . 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

• Cơ sở dữ liệu
• cơ sở dữ liệu MySQL
• database SQL
• Kiến trúc hệ quản trị cơ sở dữ liệu
• đặc tính cơ sở dữ liệu
• bảo mật cơ sở dữ liệu
• Cơ sở dữ liệu
• Hệ quản trị cơ sở dữ liệu MySQL
• Quản trị cơ sở dữ liệu
• Làm việc với MySQL
• Giới thiệu về MySQL
• Bài giảng Phần mềm nguồn mở
• Phần mềm nguồn mở
• Hệ quản trị cơ sở dữ liệu
• Lịch sử phát triển MySQL
• Kiến trúc MySQL
• MySQL Command Line
• MySQL Query Browser
• giáo trình cơ sở dữ liệu
• lý thuyết cơ sở dữ liệu
• bái giảng cơ sở dữ liệu
• tài liệu cơ sở dữ liệu
• Kết nối với MySQL
• Truy xuất cơ sở dữ liệu
• Quản lý dữ liệu
• Kết nối cơ sở dữ liệu
• Cập nhật dữ liệu
• Kích hoạt dữ liệu
• cơ sở dữ liệu sql server
• MySQL cơ bản