Web Apps
Contents
Web Apps
Web apps are cross platform apps which are used via a browser. This allows you to create a single app to cover platforms such has Windows, Linux, iOS, Android, and so on. These essentially have a server program, which when you start it will allow you to access your app via http://localhost:8000 or http://127.0.0.1:8000. The exact port number may vary, but the server will output the correct link to use.
Flask
Setup
Connecting MySQL to Flask Web App
Connecting sqlite to Flask Web App
Login System
Login and Logout in a Flask App
Register and Edit profile in a Flask App
Database / Models
Models aren't used in Flask, so you will need to use the normal SQLITE queries. Remember the previous tutorials create a class to handle the database, so you will need to write the SQL only. The execute command can be used for Create, Update, Insert, and Delete queries. The select command can be used to run a select query.
Skills
Flashing messages in Flask App
Passing an integer via URL in Flask App
ASP.Net Web App
Setup MySql
Connect MySQL to ASP.Net Web App
Setup Session
Setup Session for ASP.Net Web App
Custom Login System
Create login for ASP.Net Web App
Create logout for ASP.Net Web App
Create register for ASP.Net Web App
Hide logout button if user not logged in for ASP.Net Web App
Django
Students should avoid using this for their projects, use ASP.Net Core or Flask instead. Both can be set up to use MySQL and you can therefore easier to get the technical skills marks.
Setup
Creating the Home page in Django
Login System
Create a sign up page in Django
Create account edit page in Django
Enforce login required for page
Models in django
Display data from a model in django
Add data into a model in Django
Editing data into a model in Django
Delete data from a model in Django
Relating models in Django, ie Primary key to Foreign Key
Enforcing unique model entries
Other skills
Passing an integer through the url to make a product page
Returning a 404 error if the value is not in the model data