Creates dynamic web pages using PHP and MySQL

0
534

Competency Level 10.7:

Creates dynamic web pages using PHP and MySQL

Time: 06 periods

Learning Outcomes:

 Defines dynamic web pages
 Creates data source and enters data
 Creates PHP code to save/retrieve data to and from MySQL
 Develop simple web based information systems

Contents:

 Introduction to dynamic web pages
 Embedding PHP code into web page
o Variables
o Arrays
o Control structures
o Functions
o Database connectivity
o Working with databases
 Forms
o Input element
 Type attribute
 Name attribute
 Value attribute
o Text input (Password)
o Radio buttons
o Check box
o Selection
o Submit buttons
o Reset button
o Action attribute
o Method attribute
 Get
 Post
o Grouping form data using <field set> tag
o Saving form data into database
 Creating data source and entering data
 Creating PHP code to retrieve data from MySQL database Set form values using retrieved data

Concepts and terms to be highlighted:

 Characteristics of a dynamic web page
 Difference between the server based scripting and desktop applications
 Need for the use of a server side scripting language to access a database
 Embedding PHP code into a web page
 Concept of web based information systems
 Appreciate how data source (MySQL) is accessed using a server side scripting language (PHP) via a web page 95
 Web browser
 Scripting language (Example: PHP)
 Server (Example: Apache)
 Database software (Example: MySQL)
 WAMP, XWAMP

Guidance for lesson plans:

 Divide the students into groups
 Demonstrate few static web pages and dynamic web pages
 Ask students to identify the features of static web pages and dynamic web pages (Example: data source available in dynamic etc.)
 Introduce PHP (commands, syntax etc.)
 Demonstrate how to create a data source (MySQL) and populate the database with some data using MySQL commands
 Demonstrate how to embed an appropriate PHP code in to the source web page to retrieve data from the MySQL database
 Demonstrate how to embed an appropriate PHP code in the source web page to enter and save data in the MySQL database and view the data
 Ask student groups to develop a simple web based information system Guidance for assessments and evaluations:
 Create a data source (MySQL) and populate the database with some data using MySQL commands
 Create a web page and embed an appropriate PHP code into it to retrieve data from the MySQL database
 Embed an appropriate PHP code in the source web page to enter and save data in the SQL database and view the data
 Demonstrate the system to the class

Quality inputs:

 Computers with Server software (ex:- XAMP/WAMP/LAMP)
 Internet and Internet resources (ex:- YouTube)
 A list of required PHP and MySQL commands
 Presentations

2019 AL Southern Province ICT Paper II- B Question 06

Presentation

Download

PDF 

Download

Resources (.html/.php files) zip

Download

LEAVE A REPLY

Please enter your comment!
Please enter your name here