Connect to a MySL Database Using PHP

Image courtesy of Cloudways at Cloudways

 

View the recording
Connecting to a Database Using PHP 40:09 min

In this session on Connecting to a Database OTEN teacher, Barry Collier covers connecting to a MySQL databse using PHP.

This session covers the following points: Connecting usng mysqli_connect() Connection arguments Determining a Successful Connection Closing the Connection

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page, ICTWEB503 Create web-based programs & ICTDBS504 Integrate a database in the Diploma of Website Development course.

Defining a Website 2

Image courtesy of iStock by Getty Images.

 

View the recording
Defining a Website 2 56:19 min

In this second session on Defining a Website OTEN teacher, Barry Collier covers the steps in exporting a website using Expression Web. He also looks at up the PATH in Window's Environment Variable and Parsing files at the command line.

This session covers the following points: Revising Editing Files Exporting a website as a package Editing the Path in Windows Parsing a file

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page, ICTWEB503 Create web-based programs & ICTDBS504 Integrate a database in the Diploma of Website Development course.

Defining a Website 1

Image courtesy of iStock by Getty Images.

View the recording
Defining a Website 1 55:25 min

In this session on Defining a Website OTEN teacher, Barry Collier covers the steps in creating a website using Expression Web.

This session covers the following points: Creating an empty site Importing existing file / folders Enabling hidden meta files option Editing files

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page & ICTWEB503 Create web-based programs in the Diploma of Website Development course.

PHP Include files

Image courtesy of iStock by Getty Images.

View the recording
PHP Include Files 66:29 min

In this session on Using PHP Include Files OTEN teacher, Barry Collier covers aspects of Incorporating PHP Include files using a local web server.

This session covers the following points: PHP tags Running PHP in the browser Using incudes Relativity of links

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page & ICTWEB503 Create web-based programs in the Diploma of Website Development course.

Using a Local Web Server

Image courtesy of iStock by Getty Images.

View the recording
Using a local web server 48:42 min

In this session on Using a Local Web Server OTEN teacher, Barry Collier covers aspects of running a web server on your own computer.

This session covers the following points: different web servers locating the root folder enabling the server localhost security considerations

Students will find the content of this Adobe Connect session most helpful for units ICTWEB501 Build a dynamic web page, ICTWEB502 Create a dynamic web page & ICTWEB503 Create web-based programs in the Diploma of Website Development course.

Developing Complex SQL Statements

"Confused Character Means Bewildered Puzzled Or Purplexed" by Stuart Miles Image courtesy of Freedigitalphotos.net

View the recording
Developing Complex SQL Statements 49:02 min

In this session on Developing Complex Select Statements OTEN teacher, Barry Collier continues on from the previous session.

This session covers the following points: joins inner join left join right join full join self join union nested queries

Students will find the content of this Adobe Connect session most helpful for unit ICTPRG425 Use SQL in the Diploma of Information Technology course.

Developing Select Statements

Image courtesy of study.com

View the recording
Using MySQL Workbench 2 60:03 min

In this session on Developing Select Statements OTEN teacher, Barry Collier continues on from the previous session.

This session covers the following points: Select Statement from Absolute Tables and Databases Alias Where Clause Where Clause Operators Group By Having Clause

Students will find the content of this Adobe Connect session most helpful for unit ICTPRG425 Use SQL in the Diploma of Information Technology course.