TAILIEUCHUNG - PHP 5/MySQL Programming- P72

PHP 5/MySQL Programming- P72: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 | 333 INSERT INTO adventure values 13 replace Enigma and wait You put the Enigma back in place and wait patiently but you never get another chance. You are discovered when the sub pulls in to harbor. 19 0 0 0 INSERT INTO adventure values 14 Win Congratulations You have captured the device and shortened the war 1 0 0 0 INSERT INTO adventure values 15 Water You are in the water. The sub moves away. It looks bad. 19 0 0 0 INSERT INTO adventure values 16 0 0 0 0 INSERT INTO adventure values 17 0 0 0 0 INSERT INTO adventure values 18 0 0 0 0 INSERT INTO adventure values 19 Game Over The game is over. You lose. 1 0 0 0 SELECT id name north east south west FROM adventure SELECT id description FROM adventure I wrote this code by hand but I could have designed it with phpMyAdmin just as easily. Note that I created the table inserted values and wrote a couple of SELECT statements to check the values. I like to have a script for creating a database even if I built it in a tool like phpMyAdmin because I managed to mess up this database several times as I was writing the code for this chapter. It is very handy to have a script that instantly rebuilds the database without any tears. Chapter 9 Using MySQL to Create Databases 334 Summary PHP 5 MySQL Programming for the Absolute Beginner Although you didn t write any PHP in this chapter you did learn how to create a basic data structure using the SQL language. You learned how to work with the MySQL console to create and use databases and how to return data from your database using the SELECT statement. You know how to modify the SELECT statement to get more-specific results. You know how phpMyAdmin can simplify the creation and manipulation of MySQL databases. You built a data structure for an adventure game. CHALLENGES 1. Design a database. Start with something simple like a phone list. 2. Create your database in SQL. 3. Write a batch program to create and populate your database. 4. Use phpMyAdmin to manipulate your database and .

• 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