TAILIEUCHUNG - ICT 5 Web Development - Chapter 6.1: Using MySQL with PHP

ICT 5 Web Development - Chapter : Using MySQL with PHP To learn how to prepare a MySQL database for use with PHP; To learn how to store, retrieve, and update data in a MySQL database in a MySQL data. | Vietnam and Japan Joint ICT HRD Program Objectives To understand the advantages of using d t b i databases to store Web data t t W bd t To learn how to prepare a MySQL database for use with PHP To learn how to store, retrieve, and update data in a MySQL database ICT 5 Web Development Chapter . Using MySQL with PHP Nguyen Thi Thu Trang trangntttrangntt-fit@ 2 Content What is a database? 1. Database and MySQL Overview 2. Basic SQL commands 3. Creating a table 4. Inserting data to a table 5. Retrieving data from a table 6. Updating data for a table A set of data organized into one or more computer files. t fil Using files for product inventory is a type of database Generally the term is reserved for more formal database systems like access, Oracle or MySQL. 3 4 1 Advantages of Databases Over Files Relational Database? Faster access Better concurrent access Easier changes to data and scripts Increased security A database is a collection of tables with defined relationships between them Columns define attributes of the data – All data in a column must have the same data type A record is stored in a row table name row First Name Nadia Madhu Ajuma Wade Helen column 5 Which Database System Employees Last Name Phone Li 2687 Charu 7856 Kinsaka 4489 Randal 5257 Clark 2147 6 Using A Query Language PHP works with a variety of databases that include: d t b th t i l d When using a database, use a separate query language to work t l t k with database Within MySQL, use Structured Query Language (SQL), to access database – Oracle – Access – Ingres – SQL Server – MySQL PHP Script Will use MySQL since simple to use, free and very popular. 7 Send SQL Query Query Results MySQL Database 8 2 2. Basic SQL commands Content - Connecting to MySQL from the Command Line mysql -uusername -p 1. Database and MySQL Overview 2. Basic SQL commands 3. Creating a table 4. Inserting data to a table 5. Retrieving data from a table 6. Updating data .

• Quản trị Web
• ICT 5 Web Development
• Using MySQL with PHP
• MySQL Overview
• Basic SQL commands
• Creating a table
• Updating data for a table
• Introduction to Web Programming
• The Internet
• Uniform Resource Identifier
• World Wide Web
• Web site or Website
• Web Techniques
• Web Security
• Environment variables
• Setting Response Header
• Global arrays
• Maintaining state through multiple forms
• Multiple Form Web Sessions
• The state through multiform
• PHP Script
• Receiving Hidden Fields in Web Sessions
• OOP in PHP
• Creating an Object
• Accessing attributes
• Building a classing
• Syntax to declare a Class
• Introduction to HTML
• Structured Document
• Document Object Model
• Common HTML Elements
• Nested Elements
• Introduction to PHP
• Publish PHP scripts
• PHP proper syntax
• PHP comments
• Alternative Comment Syntax
• PHP Variables
• HTML Input Forms PHP Variables
• Working with PHP String Variables
• HTML Input Forms
• Conditional Statements
• Using Conditional Test Statements
• Using Loops to Repeat Statements
• Conditional Test Statements
• Using the elseif Clause
• Functions Basic PHP Functions
• Write your own functions
• Using External Script Files
• The abs Functionabs
• The sqrt Function
• Working with Arrays Benefits of arrays
• Sequential arrays
• Multidimensional lists
• Creating Associative Arrays
• PHP Advanced
• CardSystems Attack
• Normal Query
• Getting private info
• Different database engines
• PHP Frameworks
• Overview of Design Patterns
• MVC architecture
• Structure of a design pattern
• XHTML Overview
• XML Components
• XML Schema
• XML Validation
• XML Applications
• Using CSS
• Introduction to CSS
• Applying style rules Style class
• CSS box mode
• Useful properties
• Regular Expressions
• String functions
• Regular Expressio
• A Full Script
• Using grouping characters
• JavaScript Overview Window Controls
• Event Handlers
• AJAX Overview
• AJAX Implementation
• JS syntax basic