日本欧洲视频一区_国模极品一区二区三区_国产熟女一区二区三区五月婷_亚洲AV成人精品日韩一区18p

代寫COMPX222、代做Java/SQL編程語言

時間:2024-06-08  來源:  作者: 我要糾錯



COMPX222 – Assignment 3: 
Database Driven CRUD Application (30%) 
 
Deadline: Friday 21st June by 23:59 (at the latest) 
 
Task 
 
In this assignment, you will build a web application for storing and retrieving people’s 
contact information. This will be a database driven CRUD application, allowing users to 
Create, Read, Update and Delete contacts from the database. 
 
The application will have: 
• A page for displaying all the contacts stored in the database 
• A page for displaying detailed information about individual contacts. 
• A form enabling users to input new contacts, including details such as name, phone, 
email and address. 
• An additional form allowing users to modify the details of existing contacts. 
• Functionality that enables users to delete a contact from the database. 
 
To achieve this, you will use PHP to dynamically generate page content, validate the form 
data, and interact with the database. 
 
You are free to create any design you want for your application; however, ensure that it 
meets all of the requirements specified below. 
 
Goal 
 
The goal of this assignment is to demonstrate your ability to use server-side PHP scripts to 
dynamically generate content, process and validate HTML form data, and interact with a 
MySQL database. You are also expected to demonstrate your ability to build a responsive 
web application with a design that is both user-friendly and consistent across all pages. 
 
Requirements 
 
 1. Your application must consist of the following pages: index.php, details.php, 
add.php, update.php. 
2. The index.php page serves as the homepage and should display all contacts in 
alphabetical order. You do not need to show all of the contact information for each 
contact; you may choose to show the name, email and phone number, but not the 
address. Clicking on a contact should redirect the user to the details page for that 
contact. 
3. The details.php page displays a single contact and should display all of the 
information for that contact. This page also includes a delete button and a link to the 
update page, where that contact can be edited. 4. The add.php page contains a form where users can add a new contact. This form 
should be a POST request and it should contain at least the following inputs: Name, 
Phone, Email, Address. After the form has been submitted and the contact 
successfully added, the page should redirect to user to either the homepage or the 
details page for that contact. 
5. The update.php page contains a form where users can update the details of an 
existing contact. This form should also be a POST request and it should be possible to 
update any of the fields, e.g. Name, Phone, Email, Address. When the user visits this 
page, the inputs should be pre-populated with the data for that particular contact. 
For example, the Name input should already contain the name of the contact. To 
achieve this, you will first need to retrieve the contact from the database using its ID. 
After the form has been submitted and the contact successfully added, the page 
should redirect the user to either the homepage or the details page for that contact. 
6. Form data must be validated with PHP. Invalid data should be reported with 
appropriate error messages, styled to be recognizable as errors. This validation 
should only occur when the user submits the form, not when moving between 
inputs. 
7. The following validation should be applied to both the add and the update form: 
a. The Name field cannot be empty. 
b. Either the Phone, Email, or both must be provided; leaving both empty 
should trigger a validation error. 
8. Users must be able to delete a contact from the database. This can be achieved via a 
Delete button on the details page. After a contact has been successfully deleted, the 
user should be redirected to the homepage. 
9. All pages of your web application must be responsive. This means they should 
usable on different screen sizes and devices. You can use CSS grid, flexbox and media 
queries to achieve this. 
10. All pages should have a common header and footer. You should implement this by 
creating a single header.php and footer.php file and using PHP includes to include 
them on every page. 
11. The user must be able to navigate to each of the pages via the UI. In other words, 
you must provide links to the add form, details page, update page, and a link to 
return to the index page. 
12. You must add comments to describe the main parts of your PHP, HTML and CSS 
code. 
 
Setup (Getting Started) 
 
You have been provided with the skeleton code for the application on Blackboard: 
Assignment3-Skeleton.zip. This code provides you with the files for starting the project as 
well as the code for connecting to the database. You should download and extend this code 
rather starting from scratch. 
 
You have also been provided with an SQL file to create the database and the table: 
assignment3.sql. You should use this file in phpMyAdmin to get the database running on 
your computer. Note that one example contact has been provided in the SQL file.  
Setup Instructions 
 
 1. Download Assignment3-Skeleton.zip and unzip it. 
2. Rename the extracted Assignment3-Skeleton folder to 320XXXX-Assignment3 (where 
320XXXX is your student ID). 
3. Move the 320XXXX-Assignment3 folder to your XAMPP htdocs folder. 
4. Download the assignment3.sql file. 
5. Open phpMyAdmin in your browser: http://localhost/phpmyadmin. 
6. Navigate to the SQL tab. 
7. Copy the entire content of assignment3.sql and paste it into the main query window. 
8. Click the Go button in the bottom right of the query window. 
9. Refresh phpMyAdmin by clicking the circular arrow underneath the phpMyAdmin 
logo. You should now see the compx222-assignment3-2024 database in the 
database list. 
10. Open your browser and visit: http://localhost/320XXXX-Assignment3/index.php 
(replace 320XXXX with your student ID). 
11. If everything has worked, you should see a message saying: "You are now ready to 
get started!" 
12. Open the 320XXXX-Assignment3 folder in your preferred code editor and start 
extending the code to build your application. 
 
When building your application, try to implement it one function at a time. Start by 
displaying all the contacts on the homepage. Once this is working, move on to displaying an 
individual contact on the details page, then adding a contact, then updating a contact, and 
finally deleting a contact. Make sure each function works before moving on to the next. If 
any errors occur, try to understand the cause, and fix them. 
 
Restrictions 
 
The purpose of this assignment is to demonstrate your ability to use PHP, MySQL, HTML and 
CSS. Therefore, the following restrictions apply: 
 
• DO NOT copy and paste large blocks of PHP, SQL, HTML or CSS from other sources. 
• DO NOT use visual design tools (such as Dreamweaver) that generate the HTML/CSS 
code. 
• DO NOT use third-party frameworks or libraries (for PHP, HTML or CSS). This includes 
frameworks such as Laravel and Bootstrap. 
• DO NOT use the HTML required attribute as this could prevent some of your PHP 
validation being triggered. 
• DO NOT use any JavaScript for this assignment. 
Guidelines 
 
Project Organisation 
 
Organize your project appropriately. In the root folder, include PHP files for your 
application's pages (add.php, details.php, index.php, update.php), a 'css' folder for CSS files, 
an 'img' folder for images, a 'config' folder for PHP code connecting to your database 
(db_connect.php), and a 'templates' folder for header and footer PHP files. The 
db_connect.php, header.php and footer.php files should be included in the PHP files for 
each of your pages. Most of this structure has been provided for you in the starter project 
code: Assignment3-Skeleton. 
 
Your folder structure should look like this: 
 
/root 
 /config 
 db_connection.php 
 /css 
 style.css 
 /img 
 image1.jpg 
 … 
 /templates 
 footer.php 
 header.php 
 add.php 
 details.php 
 index.php 
 update.php 
 
Filenames (including images) should only contain ASCII characters, so you should avoid 
using Chinese characters. This is to prevent problems when zipping/unzipping. 
 
Images 
 
Do not use absolute filenames for image and videos because if you do, they will only work 
on your computer. All links to images and videos should use relative filenames. 
 
Correct (relative): 
 
src="img/image1.jpg" 
 
Incorrect (absolute): 
 
src=“/Users/alex/Documents/your-website/img/image1.jpg" 
src=“C:your-websiteimgimage1.jpg" 
 All images should be appropriately sized for the web and be no larger than they need to 
be. Large image files can significantly impact page load times, leading to a poor browsing 
experience for users. 
 
CSS 
 
You must use an external CSS file (style.css) for all of your CSS code then include it in your 
HTML file using a <link> tag inside the <head>. Do not include any CSS code in the HTML file 
(either inline in the HTML elements or in style tags at the top of the HTML page). 
 
Correct: 
 
<head> 
 <link rel="stylesheet" href="css/style.css"> 
</head> 
 
Incorrect: 
 
<p style="color: green"> 
 
<style> ... </style> 
 
HTML 
 
ALL text must be enclosed in the correct HTML tags. Do not leave any un-tagged text in the 
HTML file. All HTML must be valid HTML5 and you should use semantic HTML5 elements 
where appropriate. 
 
PHP 
 
Use meaningful variable and function names. This will make it easier to read your code and 
keep track of what each part does. 
 
Each page will contain some content that needs to be generated dynamically on the server 
via PHP. Each page should, therefore, be a .php file rather than an .html file. Most of the 
page will be HTML markup, but PHP code segments will occur at appropriate points and be 
placed between <?php and ?> tags. 
 
PHP scripts can redirect the browser to other pages by setting the HTTP Location header 
using the header function. For example, header('Location: index.php'); redirects to the 
index.php page. 
 
MySQL 
 
You can test your queries in phpMyAdmin (using real values) to make sure they are correct. 
 
All interactions with the database will be done via PHP. Make sure you use the correct PHP 
MySQLi functions to achieve this. 
  
 
What to Submit 
 
All your material for this assignment must be submitted using Blackboard. 
 
 1. Create a folder with a name of “320XXXX-Assignment3,” where 320XXXX is your 
student ID. You should end up with a single ZIP file called 320XXXX-Assignment3.zip 
containing your website files inside (see the Project Organisation section for details). 
Use only ASCII characters for filenames (no Chinese characters). 
2. Submit the ZIP archive via Blackboard. On the course page you will find a section 
‘Assignments’ with a link entitled ‘Assignment 3 Submission’ (or similar). Follow the 
link and upload your ZIP file. 
 
No other mechanism for submission will be accepted. 
 
NOTE: your site should work 'as is' when unzipped from your ZIP archive into the Apache 
htdocs folder, without any modification or changes to the database credentials. You should 
check that this is the case by unzipping your archive and testing the site yourself. 
 
Assessment 
 
Your mark for this assignment contributes to 30% of your overall grade. Zip your website up 
into a single file and submit it on Blackboard before the due date. The marking will be as 
follows: 
 
HTML Markup 
Including structure of the HTML document, appropriate form elements, attributes 
and input types 
15% 
CSS Styling 
Including overall style and consistency, usability, responsiveness, and use of 
selectors 
15% 
PHP 
Including validation, displaying or error messages, use of functions and appropriate 
techniques, absence of errors and warnings, all required pages included 
40% 
MySQL and PHP interaction 
Including support for each CRUD operation, properly structured queries, correct use 
of PHP MySQLi functions 
20% 
Project Structure 
Including file and folder organisation, file naming and external CSS 
10% 
Total 100% 
 
You will lose marks if you break any of the restrictions or guidelines. 
 
The assignment is INDIVIDUAL work. You are not allowed to work with other students or 
copy code from other sources and you must not share your code with any other student. If 
any assignment description is not clear to you, please ask your teachers. 

請加QQ:99515681  郵箱:99515681@qq.com   WX:codinghelp




















 

標簽:

掃一掃在手機打開當前頁
  • 上一篇:program程序代做、代寫Python/C++編程設計
  • 下一篇:代做COMP 636、Java程序設計代寫
  • 無相關信息
    昆明生活資訊

    昆明圖文信息
    蝴蝶泉(4A)-大理旅游
    蝴蝶泉(4A)-大理旅游
    油炸竹蟲
    油炸竹蟲
    酸筍煮魚(雞)
    酸筍煮魚(雞)
    竹筒飯
    竹筒飯
    香茅草烤魚
    香茅草烤魚
    檸檬烤魚
    檸檬烤魚
    昆明西山國家級風景名勝區
    昆明西山國家級風景名勝區
    昆明旅游索道攻略
    昆明旅游索道攻略
  • NBA直播 短信驗證碼平臺 幣安官網下載 歐冠直播 WPS下載

    關于我們 | 打賞支持 | 廣告服務 | 聯系我們 | 網站地圖 | 免責聲明 | 幫助中心 | 友情鏈接 |

    Copyright © 2025 kmw.cc Inc. All Rights Reserved. 昆明網 版權所有
    ICP備06013414號-3 公安備 42010502001045

    日本欧洲视频一区_国模极品一区二区三区_国产熟女一区二区三区五月婷_亚洲AV成人精品日韩一区18p

              午夜一区不卡| 国产精品久久77777| 亚洲精品在线视频观看| 国产精品尤物| 欧美日韩一区三区四区| 久久久另类综合| 翔田千里一区二区| av成人免费在线观看| 亚洲国产专区| 国产综合香蕉五月婷在线| 欧美日韩你懂的| 欧美电影电视剧在线观看| 欧美一区二区精品| 亚洲一卡二卡三卡四卡五卡| 亚洲精品日产精品乱码不卡| 一区在线影院| 国产一区二区三区久久悠悠色av | 欧美精品激情| 欧美1区2区| 欧美成人在线免费观看| 久久久久一区二区| 久久久久久久91| 久久久久久电影| 久久不见久久见免费视频1| 午夜精品影院| 欧美一区三区三区高中清蜜桃 | 欧美视频第二页| 欧美日韩精品不卡| 欧美日韩免费观看一区二区三区| 欧美xx69| 欧美日韩综合另类| 国产精品老牛| 国产永久精品大片wwwapp| 国产主播一区| 精品成人a区在线观看| 精品1区2区3区4区| 在线观看三级视频欧美| 亚洲福利专区| 一区二区三区欧美激情| 在线综合亚洲欧美在线视频| 亚洲女性裸体视频| 久久精品亚洲精品国产欧美kt∨| 久久久久国色av免费观看性色| 久久久久国产精品www| 欧美高清在线一区二区| 欧美午夜免费影院| 国产亚洲精品aa| 亚洲成人原创| 亚洲午夜小视频| 久久精品国产一区二区三| 久久在线精品| 国产精品国产三级国产| 国产午夜一区二区三区| 亚洲国产日韩在线| 亚洲欧美另类在线| 榴莲视频成人在线观看| 欧美三级在线| 亚洲成色999久久网站| 亚洲一区视频| 欧美成人精品一区二区| 国产精品啊v在线| 亚洲第一区在线| 亚洲欧美日韩综合国产aⅴ| 欧美ab在线视频| 国产区精品在线观看| 99www免费人成精品| 久久国产加勒比精品无码| 欧美日韩免费视频| 亚洲国产精品一区在线观看不卡 | 国内精品久久久久影院色| 亚洲人成网站影音先锋播放| 亚洲欧美在线免费| 欧美日韩免费高清| 91久久嫩草影院一区二区| 欧美一区二区在线视频| 国产精品a级| 亚洲精品专区| 欧美二区在线| 亚洲国产人成综合网站| 久久国产精品久久久久久电车| 欧美亚男人的天堂| 99在线|亚洲一区二区| 欧美成人r级一区二区三区| 国产一区二区在线观看免费播放 | 亚洲一区二区不卡免费| 欧美福利视频| 亚洲精品1区2区| 模特精品在线| 亚洲国产精品www| 久久综合一区二区| 精品成人国产| 免费成人小视频| 在线免费高清一区二区三区| 久久美女艺术照精彩视频福利播放| 国产日本欧美一区二区三区在线| 亚洲无毛电影| 国产精品一级二级三级| 亚洲欧美日韩精品在线| 国产伦精品一区| 欧美影视一区| 国内精品**久久毛片app| 久久精品99无色码中文字幕| 狠狠综合久久av一区二区老牛| 久久久久成人精品| 亚洲国产美女久久久久| 欧美韩日一区二区| 亚洲精品极品| 国产精品v欧美精品∨日韩| 亚洲免费在线播放| 国产亚洲一区二区精品| 久久精品国产亚洲精品| 亚洲第一中文字幕在线观看| 欧美大片在线看| 一区二区三区精品在线| 国产日韩欧美一区二区三区在线观看 | 日韩视频免费观看高清在线视频| 欧美日韩一区二区在线观看视频| 中文国产成人精品久久一| 国产欧美日韩视频| 久久人人看视频| 妖精成人www高清在线观看| 国产精品亚洲激情| 麻豆国产精品va在线观看不卡| 9色国产精品| 国产一区久久| 欧美日韩三级在线| 欧美一区免费| 亚洲精品一区二区三区蜜桃久| 国产精品久久久久久久久搜平片| 久久天天狠狠| 亚洲一区国产精品| 亚洲第一精品电影| 国产精品一区三区| 欧美成人中文字幕| 欧美在线观看视频一区二区| 亚洲国产黄色片| 国产日韩精品一区二区| 欧美日韩mp4| 久久午夜色播影院免费高清| 亚洲视频精品| 亚洲精品麻豆| 在线观看亚洲| 国产毛片一区二区| 欧美视频一区二区三区| 久久综合综合久久综合| 亚洲欧美日韩高清| 亚洲精品自在在线观看| 激情综合色综合久久| 国产精品视频自拍| 欧美精品一区在线观看| 久久夜色撩人精品| 亚洲午夜三级在线| 亚洲高清成人| 黑丝一区二区| 国产三级欧美三级| 国产伦精品一区二区三区高清版 | 亚洲电影有码| 伊人久久久大香线蕉综合直播 | 久久精品视频网| 香蕉精品999视频一区二区| 亚洲天堂av综合网| 在线综合+亚洲+欧美中文字幕| 亚洲乱码精品一二三四区日韩在线 | 99精品国产一区二区青青牛奶 | 欧美精品激情| 欧美韩日一区二区| 欧美激情二区三区| 欧美大片免费观看| 欧美福利视频在线观看| 欧美成人久久| 欧美精品久久久久久久久久| 欧美精品一区二区三区视频| 欧美成人自拍| 欧美日韩1区2区| 欧美日韩一区二区三区在线 | 亚洲嫩草精品久久| 亚洲欧美日韩系列| 久久久精品动漫| 欧美高清视频一区| 欧美日韩福利视频| 欧美视频在线观看免费网址| 国产精品久久久久久久久久三级| 国产精品无码永久免费888| 国产精品一区二区欧美| 国产亚洲精品福利| 91久久夜色精品国产九色| 99re成人精品视频| 亚洲综合欧美日韩| 久久亚洲欧美| 欧美日韩视频| 国产一区二区精品久久91| 亚洲福利专区| 亚洲欧美激情一区| 久久深夜福利免费观看| 欧美精品二区| 国产目拍亚洲精品99久久精品| 国产在线视频欧美一区二区三区| 亚洲片国产一区一级在线观看| 亚洲一区二区视频| 美国成人直播|