
Need a php developer to help with web project
- or -
Post a project like this3060
$$
- Posted:
- Proposals: 13
- Remote
- #1362577
- Completed
Full Stack Web Developer | PHP | Laravel | CodeIgniter | JavaScript | jQuery | Ajax |MySQL
♛ Most Trusted #1 Team |19+ years of expertise in Website, Mobile Apps, Desktop & Console Games. Wordpress, ReactJS, Shopify, Laravel, Python, React Native, Flutter, Unity, Unreal Engine and AR/VR




1416099501260455855129217179254213277109288101180221128342700805429882213267





Description
Experience Level: Intermediate
Assignment Case Study Scenario
You are a consultant working for a web development company who have been awarded the contract to design a fresh, dynamic and interactive web site for a retro music club and fanzine.
The owner understands that the popularity of the club is due to his focus on the music rather than purely business factors. As such, he wishes to replicate the community experience of the paper magazine by including social networking concepts such as allowing customers to share each other’s music reviews, and by structuring the site using the latest web design ideas. Since this club stores valuable data, a secure system is both legally required and expected by club members.
This phase of the project requires you to develop a prototype database web system, which will implement only part of the functionality that the final system will require. The design team that you work with has already identified that given the facilities provided by the clubs (Internet Service Provider) this project will need to be capable of connecting to a MySQL database management system (DBMS) and will be developed using PHP as server-side scripting language.
The web site should be compatible with the software configuration as it will be moved to another portal and as such needs to be portable. YOU MUST ensure your application is installed and working a folder called LD7013 under public_html. This avoid disagreements over whether some feature works for you but not for others. That is, you should not assume that your assignment will start in the root folder of the web server. It is essential that clear indications are given as to which source code file principally implements the required elements. This will be done by including a page ‘features.txt’ that lists the element, and the web page on which it is implemented. All data should be appropriately validated and protected against SQL Injection
and stored cross-site scripting attacks.
Practical Solution
Design and create appropriate HTML5/PHP web pages (connecting to the underlying MySQL database) to provide the following functionality:
• Create a home page (called index.html) located in the root of your web site (i.e. in
which contains the appropriate links to the other sections of your web site, including the page containing your critical discussion. Note: depending on your design, this
page may purely act as a redirect to a PHP script.
• Pages giving information about TipTop Music should be accessible to nonmembers without login (for example, the home page and contact pages). You
should make up reasonable English text so the site looks realistic.
• The public should be able to see a list of music categories that are dynamically
retrieved from the database. When one of the music categories is selected, an
appropriately formatted list of albums in that category should be shown.
• Provide one logon form that will allow club members and system administrators
to log onto and use certain parts of the web site. If a user logons on as a member,
then display page(s) relevant to either the member or administrator functionality.
• Club Member Functionality: If a user is logged on as a member they should be
able to:
o View a list of their own reviews and dates created.
o Delete a review which they wrote.
o Add or Edit a review that they contributed. (The changes must be
recorded in the database, using an UPDATE SQL query.)
• Administrator Functionality: A user logged on as a system administrator, should
be able to view a page that lists all of the members, in alphabetical order of
surname. It will also display a summary of their reviews:
• The Administrator may create and delete club members. The form used to create
a new member should ensure that data are valid. For example, that a member's
password has at least six characters, with one or more; and that house numbers
are actually numeric. Data validity should be checked on the client and indicated
without needing to refresh the screen.
You are a consultant working for a web development company who have been awarded the contract to design a fresh, dynamic and interactive web site for a retro music club and fanzine.
The owner understands that the popularity of the club is due to his focus on the music rather than purely business factors. As such, he wishes to replicate the community experience of the paper magazine by including social networking concepts such as allowing customers to share each other’s music reviews, and by structuring the site using the latest web design ideas. Since this club stores valuable data, a secure system is both legally required and expected by club members.
This phase of the project requires you to develop a prototype database web system, which will implement only part of the functionality that the final system will require. The design team that you work with has already identified that given the facilities provided by the clubs (Internet Service Provider) this project will need to be capable of connecting to a MySQL database management system (DBMS) and will be developed using PHP as server-side scripting language.
The web site should be compatible with the software configuration as it will be moved to another portal and as such needs to be portable. YOU MUST ensure your application is installed and working a folder called LD7013 under public_html. This avoid disagreements over whether some feature works for you but not for others. That is, you should not assume that your assignment will start in the root folder of the web server. It is essential that clear indications are given as to which source code file principally implements the required elements. This will be done by including a page ‘features.txt’ that lists the element, and the web page on which it is implemented. All data should be appropriately validated and protected against SQL Injection
and stored cross-site scripting attacks.
Practical Solution
Design and create appropriate HTML5/PHP web pages (connecting to the underlying MySQL database) to provide the following functionality:
• Create a home page (called index.html) located in the root of your web site (i.e. in
which contains the appropriate links to the other sections of your web site, including the page containing your critical discussion. Note: depending on your design, this
page may purely act as a redirect to a PHP script.
• Pages giving information about TipTop Music should be accessible to nonmembers without login (for example, the home page and contact pages). You
should make up reasonable English text so the site looks realistic.
• The public should be able to see a list of music categories that are dynamically
retrieved from the database. When one of the music categories is selected, an
appropriately formatted list of albums in that category should be shown.
• Provide one logon form that will allow club members and system administrators
to log onto and use certain parts of the web site. If a user logons on as a member,
then display page(s) relevant to either the member or administrator functionality.
• Club Member Functionality: If a user is logged on as a member they should be
able to:
o View a list of their own reviews and dates created.
o Delete a review which they wrote.
o Add or Edit a review that they contributed. (The changes must be
recorded in the database, using an UPDATE SQL query.)
• Administrator Functionality: A user logged on as a system administrator, should
be able to view a page that lists all of the members, in alphabetical order of
surname. It will also display a summary of their reviews:
• The Administrator may create and delete club members. The form used to create
a new member should ensure that data are valid. For example, that a member's
password has at least six characters, with one or more; and that house numbers
are actually numeric. Data validity should be checked on the client and indicated
without needing to refresh the screen.

Enos J.
100% (4)Projects Completed
4
Freelancers worked with
4
Projects awarded
24%
Last project
10 Oct 2017
Uganda
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello,
I have done similar task for one of our clients.Please give me a chance so that I can prove my assets to you.
Query
What your's budget and deadline.?
Thanx & Regards
AmanEnos J.21 Nov 2016budget is about 400£ and need it in 3-4 weeks.
-
Whats you total budget?
Enos J.21 Nov 2016max £400 or thereabouts.
-
How early you need this completed?
Enos J.21 Nov 2016like in 2 to 3 weeks as i ned to write a report thereafter
233105232926232879
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies