日本欧洲视频一区_国模极品一区二区三区_国产熟女一区二区三区五月婷_亚洲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

              欧美日韩第一区日日骚| 欧美在线看片a免费观看| 国产视频一区二区在线观看 | 久久精品人人做人人爽| 日韩视频免费观看| 伊人蜜桃色噜噜激情综合| 欧美日韩亚洲另类| 欧美成人有码| 久久久国产精品一区二区中文| 亚洲三级影片| 亚洲第一区在线观看| 国产欧美日韩精品专区| 欧美日韩一区二区国产| 免费看亚洲片| 老牛嫩草一区二区三区日本| 亚洲欧美一区二区视频| 99视频超级精品| 亚洲人成7777| 亚洲国产精品美女| 尤妮丝一区二区裸体视频| 国产日韩亚洲| 国产欧美日韩在线视频| 国产精品视频成人| 国产伦精品一区二区三区免费迷 | 一本一本久久a久久精品牛牛影视| 国产有码在线一区二区视频| 国产欧美日韩亚洲| 国产有码一区二区| 激情视频一区二区| 精品成人国产在线观看男人呻吟| 国内精品久久久| 精品福利电影| 亚洲电影欧美电影有声小说| 在线看片一区| 亚洲国产天堂久久综合网| 在线观看一区视频| 亚洲黄色在线看| 99在线观看免费视频精品观看| 亚洲毛片网站| 亚洲一区中文字幕在线观看| 午夜精品亚洲一区二区三区嫩草| 性色av一区二区三区红粉影视| 性欧美18~19sex高清播放| 欧美伊人久久久久久午夜久久久久| 欧美一区二区三区另类| 久久久国产91| 欧美久久一区| 国产人妖伪娘一区91| 在线成人av| 洋洋av久久久久久久一区| 亚洲综合精品| 久久久人人人| 欧美日韩成人一区| 国产亚洲成av人片在线观看桃| 曰本成人黄色| 亚洲一区二区三区777| 欧美一区二区在线看| 欧美成人官网二区| 国产精品久久久久久久久久久久久久 | 亚洲黄一区二区| 99精品欧美一区二区蜜桃免费| 亚洲综合二区| 欧美激情精品久久久久久久变态| 国产精品女主播在线观看| 国产亚洲欧美另类中文| 一本色道久久综合亚洲精品不| 欧美在线二区| 国产精品国产三级国产| 在线播放一区| 午夜精品免费视频| 欧美日韩国产成人在线免费| 国产专区欧美专区| 宅男66日本亚洲欧美视频| 老司机精品视频一区二区三区| 欧美三区在线视频| 影音先锋亚洲一区| 午夜久久99| 欧美日韩不卡一区| 亚洲国产欧美不卡在线观看| 亚洲欧美日韩精品久久亚洲区 | 91久久精品国产91性色tv| 欧美一级二区| 欧美性视频网站| 亚洲乱码一区二区| 欧美成年人视频网站欧美| 国产亚洲欧美一级| 性色av一区二区三区红粉影视| 欧美日产在线观看| 亚洲精品裸体| 美女精品一区| 亚洲国产精品日韩| 蜜臀99久久精品久久久久久软件| 国产日韩欧美视频| 羞羞色国产精品| 国产精品毛片一区二区三区| 一本色道精品久久一区二区三区| 欧美激情视频给我| 99国产精品国产精品久久| 欧美日韩免费观看一区二区三区| 亚洲精品乱码久久久久久蜜桃91 | 亚洲精品国产精品久久清纯直播 | 欧美黄污视频| 日韩香蕉视频| 欧美日韩精品免费观看视频| 中文欧美在线视频| 国产精品日韩欧美| 久久国产88| 亚洲国产mv| 欧美日韩国产麻豆| 亚洲在线播放| 国产一区二区三区自拍| 久久综合伊人77777蜜臀| 亚洲欧洲在线免费| 欧美亚洲成人免费| 午夜精品剧场| 在线 亚洲欧美在线综合一区| 久久伊人免费视频| 日韩一级免费| 国产毛片精品视频| 久久亚洲电影| 最新成人在线| 国产精品视频免费在线观看| 久久成人人人人精品欧| 亚洲国产影院| 国产精品男女猛烈高潮激情 | 久久色在线观看| 亚洲乱码精品一二三四区日韩在线 | 久久国产综合精品| 亚洲免费成人| 国产亚洲精品v| 欧美精品一区二区三区蜜桃| 亚洲图片你懂的| 又紧又大又爽精品一区二区| 欧美午夜宅男影院| 久久久久久久激情视频| 99精品国产在热久久婷婷| 国产欧美一区二区三区国产幕精品 | 欧美精品一区二| 欧美专区福利在线| 亚洲最新在线| 怡红院av一区二区三区| 国产精品美女久久久免费| 久久久一区二区三区| 亚洲伊人伊色伊影伊综合网| 亚洲国产精品久久| 国产婷婷色综合av蜜臀av| 欧美久久视频| 久久―日本道色综合久久| 午夜久久黄色| 亚洲图片在线| 亚洲精品国产拍免费91在线| 国产亚洲欧洲997久久综合| 国产精品九九| 国产精品www.| 欧美三级日本三级少妇99| 免费不卡中文字幕视频| 久久精品视频在线看| 亚洲男人的天堂在线观看| 一区二区三区三区在线| 日韩一二三区视频| 亚洲国产天堂网精品网站| 亚洲成在人线av| 伊人久久亚洲热| 国内伊人久久久久久网站视频| 国产精品视频999| 国产免费观看久久黄| 国产精品一区二区久激情瑜伽| 国产精品久久久久久久app| 欧美日韩美女| 欧美日韩在线三区| 欧美午夜精品理论片a级大开眼界 欧美午夜精品理论片a级按摩 | 激情久久久久久久| 国模私拍视频一区| 悠悠资源网亚洲青| 亚洲国产精品悠悠久久琪琪| 亚洲国产一区二区在线| 亚洲成人在线观看视频| 亚洲第一毛片| 亚洲免费av电影| 这里只有精品视频在线| 亚洲一区二区欧美| 先锋影音国产一区| 久久人人97超碰精品888| 欧美va亚洲va香蕉在线| 欧美精品一区三区在线观看| 国产精品wwwwww| 国产在线不卡精品| 亚洲黄色av| 亚洲永久精品大片| 久久亚洲精品一区二区| 欧美成人一区二区三区| 欧美三级特黄| 韩国精品主播一区二区在线观看| 亚洲成人资源网| 99成人免费视频| 欧美在线视频全部完| 麻豆av一区二区三区| 欧美日韩一区二区免费在线观看 | 国产精品乱码妇女bbbb| 狠狠色伊人亚洲综合成人|