Modelling System Solutions

Image courtesy of lekkyjustdoit

 

View the recording
Modelling System Solutions 42:46 min

In this session on Modelling System Solutions OTEN teacher, Barry Collier looks at developing a Use Case Diagram.

This session covers the following points: Why Model Unified Modelling Language Use Case Diagram Use Case Diagram Components Documentating

Students will find the content of this Adobe Connect session most helpful for units ICTNWK514 Model perferred system solutions, ICTSAD501 Model data objects & ICTSAD502 Model data processes in the Diploma of Information Technology & Diploma of Website Development courses.

Responsive Spreadsheets

Image courtesy of Howtogeek

 

View the recording
Responsive Spreadsheets 57:14 min

In this session on Responsive Spreadsheets OTEN teacher, Barry Collier looks at setting up a spreadsheet to respond to What If scenarios.

This session covers the following points: What If scenarios Working Figures Absolute Referencing Named References

Students will find the content of this Adobe Connect session most helpful for units ICTSAD506 Produce a feasibility report & ICTICT510 Determine appropriate ICT strategies and solutions in the Diploma of Information Technology & Diploma of Website Development courses.

Using Session Management 2 via a Form

Image Authentication-and-Session-Management-Process courtesy of ResearchGate at ResearchGate

 

View the recording
Using Session Management via a Form 45:11 min

In this session on Using Session Management via a Form OTEN teacher, Barry Collier continues from the previous tutorial and covers using PHP to authorise the session via form.

This session covers the following points: Using a form to authorise the user Confirming the user via a database Checking the isset() function Clearing using the unset() function

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.

Using Session Management 1

Image courtesy of hackernoon at Hackernoon

 

View the recording
Using Session Management 41:03 min

In this session on Using Session Management OTEN teacher, Barry Collier covers using PHP to establish a session, checking the session variable and clearing it.

This session covers the following points: Establishing a session Setting the session variable Checking the isset() function Clearing using the unset() function

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.

Updating a Database via Form

Image curtesy of 365datascience at Cloudways

 

View the recording
Updating a Database via a Form 45:54 min

In this session on Updating a Database OTEN teacher, Barry Collier covers updating a MySQL database via a Form using $_POST.

This session covers the following points: Passing Login details Validating the Login Displaying the record associated with the login

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.

Updating a Database Using PHP

Image courtesy of Formget at Cloudways

 

View the recording
Updating a Database Using PHP 1 hr 15:06 min

In this session on Updating a Database OTEN teacher, Barry Collier covers updating a MySQL database using PHP.

This session covers the following points: Updating usng mysqli_query() Inserting records Inserting records with auto_increment Retrieving the last record added Deleting a record

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.

Querying a Database Using PHP

Image courtesy of Cloudways at Cloudways

 

View the recording
Querying a Database Using PHP 49:10 min

In this session on Querying a Database OTEN teacher, Barry Collier covers querying aMySQL databse using PHP.

This session covers the following points: Querying usng mysqli_query() Query arguments Returning the number or rows Returning the row values

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.