Difference between revisions of "Web Apps"

From TRCCompSci - AQA Computer Science
Jump to: navigation, search
(ASP.Net Web App)
(ASP.Net Web App)
 
(7 intermediate revisions by the same user not shown)
Line 24: Line 24:
  
 
[[Uploading files in Flask]]
 
[[Uploading files in Flask]]
 
[[Fully OOP views in Flask]]
 
  
 
==ASP.Net Web App==
 
==ASP.Net Web App==
===MySql===
+
====Setup MySql====
 
[[Connect MySQL to ASP.Net Web App]]
 
[[Connect MySQL to ASP.Net Web App]]
  
 +
====Setup Session====
 
[[Setup Session for ASP.Net Web App]]
 
[[Setup Session for ASP.Net Web App]]
  
 +
====Custom Login System====
 
[[Create login for ASP.Net Web App]]
 
[[Create login for ASP.Net Web App]]
  
Line 38: Line 38:
  
 
[[Create register 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====
 +
[[Django in PythonAnywhere]]
 +
 +
[[Creating the Home page in Django]]
 +
 +
[[Creating a Django Web App]]
 +
 +
[[Django management program]]
 +
 +
====Login System====
 +
[[Set up Login System in Django]]
 +
 +
[[Create a sign up page in Django]]
 +
 +
[[Create account edit page in Django]]
 +
 +
[[Enforce login required for page]]
 +
====Models in django====
 +
[[Creating a Model 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]]
 +
 +
[[Images in models and uploading images]]
 +
 +
[[Change password function]]
 +
 +
[[Reset password function]]

Latest revision as of 10:26, 19 November 2024

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

Creating a Flask Web App

Parts of a Flask Web App

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

Uploading files in Flask

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

Django in PythonAnywhere

Creating the Home page in Django

Creating a Django Web App

Django management program

Login System

Set up Login System in Django

Create a sign up page in Django

Create account edit page in Django

Enforce login required for page

Models in django

Creating a Model 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

Images in models and uploading images

Change password function

Reset password function