2023年11月25日

PHP代写 | COS20019 Assignment 1 – Part B Photo Album web site

本次PHP代写的内容主要是使用MySQL、PHP代码、AWS完成一个web的开发工作

To complete this assignment, you will need to…

  • Successfully passed Assignment 1A.
  • Make sure you have completed Lab activities 1 to 4.
  • Know how to set up and manage a MYSQL database.
  • Understand how to write PHP code that interacts with MYSQL database.
  • Know how to set up and manage a Web accessible S3 bucket.

Objectives

This assignment has the following objectives:

  1. Create a secure Virtual Private Cloud (VPC) with subnets, routing tables and security groups.
  2. Control access to and from your VPC via an Internet Gateway.
  3. Create a web site in PHP that stores meta-data information about photos uploaded to S3 in a

    MariaDB database managed by Amazon RDS. The website should enable the user to search

    for and display photos using meta-data.

  4. Deploy and test your PHP web site on an Apache web server running on an EC2 virtual

    machine instance.

Virtual Machine

  • –  Amazon Machine Image: Amazon Linux 2 AMI (HVM), SSD Volume Type
  • –  Instance type: t2.micro
  • User data: install Apache Web server and PHP (as in Assignment 1A)

RDS Database instance

  • –  DB engine version: mariadb10.2
  • –  DB instance class: db.t2.micro
  • –  Public accessibility: No
  • –  Backup retention period: 0 days

RDS Hint #1:

When creating RDS, there are two options, one to enable Multi AZ or choose not to enable it. The second option deploys RDS in one Availability Zone (AZ) only. In the real world, it is desirable to deploy RDS in more than one Availability Zone. Multi AZ, RDS is not part of free tier account as it is a costly feature. Your Educate account also does not support it. Therefore, do not check Multi-AZ checkbox when you set up your RDS. (The RDS wizard has a Free-tier only checkbox on the first page that limits selections to Free-tier options.). In addition, while creating your RDS you might want to uncheck the detail monitoring option as it cost you and we are not using this feature in this assignment.

RDS Hint #2:

In production you need your RDS to be in a private subnet with the only the Web tier security group being able to access it. However, your need to be able to access your database over the internet so that you can set it up and maintain it. There are several ways you can do this. It is up to you to choose.

    1. Install phpMyAdmin on your EC2 Webserver instance and create and maintain the database through its UI. Instructions on how to do this are on the Assignment Resources section on Canvas.
    2. Create a ‘Photo Admin’ interface in PHP that allows a user with the correct credentials to create, insert and delete SQL operations so the database, tables and records can be managed.
    3. Create a ‘Bastion Host’ (NAT server) in a public subnet and enable SSH forwarding to the RDS EC2 instance (most secure method).