Semester 1, 2024: ITECH3108 Dynamic Web Programming Project

Desklib provides solved assignments and past papers to help students succeed.

ITECH3108 Dynamic Web
Programming
Assignment 1

Table of Contents
SQL Query.....................................................................................................................................................3
Task Completed:............................................................................................................................................3
Screenshots....................................................................................................................................................3
Database:....................................................................................................................................................3
Website......................................................................................................................................................4
Table of Figures
Figure 1: Table structure of desert table........................................................................................................2
Figure 2: Table structure of likes table..........................................................................................................3
Figure 3: table structure of message table......................................................................................................3
Figure 4: table structure of user table............................................................................................................3
Figure 5: update profile page.........................................................................................................................4
Figure 6: Contact page...................................................................................................................................5
Figure 7: Login Page......................................................................................................................................6
Figure 8: About page.....................................................................................................................................7
Figure 9: home page.......................................................................................................................................8
Figure 10: Message Page...............................................................................................................................9
1

SQL Query
1. To verify registered user:
select * from user where email='$em' and password='$pass';
2. To register user:
insert into user (name, email, password, profile, photo_url) values
('$name','$em','$pass','$profile','$target_file');
3. To view profile:
select * from user where email='$email';
4. To update profile:
insert into user (name, email, password, profile, photo_url) values
('$name','$em','$pass','$profile','$target_file')
5. To send message:
insert into message (from_user_id,to_user_id,message) values ($from,$to,'$mess');
6. To view message:
select * from message where from_user_id=to_user_id AND to_user_id=from_user_id AND
to_user_id=$to AND from_user_id=$from);
7. Setting likes:
insert into likes(user_id,desert_id) values($u_id,$des)
Task Completed:
Task Name Status
Database Structure Completed
User Accounts Completed
Setting Interest Completed
Message Completed
Finding Matches Completed
Screenshots
Database:
1. Desert table:
Figure 1: Table structure of desert table
2. Likes table:
2

Figure 2: Table structure of likes table
3. Message table:
Figure 3: table structure of message table
4. User table:
Figure 4: table structure of user table
Website
1. Update profile:
3

Figure 5: update profile page
2. Contact:
4

Figure 6: Contact page
3. Login
5

Figure 7: Login Page
4. About
6

Figure 8: About page
7

5. Home:
Figure 9: home page
6. Message page
8

Figure 10: Message Page
9