With php and mySQL create a database to hold 120 songs and 3 playlists.
Each playlist contains 40 songs.
With php allow a user to register, login, logout and reset password. Reset password should require email temporary reset link.
Create a separate table that stores user email and password hash + salt for login. Use a random, non-repeating alphanumeric id to identify each user. Do not store the actual password.
When logged in present in XML, the next song to be played from the playlist selected based on URL.
Present the songs from the playlist in order from the selected playlist table.
Use the following url structure:
[login to view URL]
Example: this would output the next song in playlist 2 to the user.
The XML output should contain:
songID
songTitle
songArtist
songAlbum
songArtworkURL
songMP3URL
I'll use the xml to build a simple music player for my band website.
In the xml output to a user the songMP3URL should be a temporary URL. (To prevent direct download of my music.) Serve the MP3 from a directory that is not public, use php to generate a temporary url to access that expires after 15 minutes. (Don't make it a one-time use url, make it expire after 15 minutes.)
Do not allow a song to be repeated for 8 hours by the same user. Usage data can be deleted after 8 hours for each user to make sure the database doesn't fill up with data.
Do not allow access to anything unless user is logged in.
Also, please allow the user to like a song when logged in with the following url structure:
[login to view URL]
and dislike like this:
[login to view URL]
If a user dislikes a song do not allow that user to play the song again, use the next song for xml output. Make sure songs identified as dislikes are not presented to the user in xml again.
About 120 people will register so keep track of each users likes and dislikes so I can run a report.
Please add protections to prevent common vulnerabilities in the code (avoid sql injection, XSS, CRSF, invalid POSTs, other common protections).
Also, prevent login credential sharing by creating a separate table to track.
I will replace the dummy data you use to create the database with actual data when delivered. Keep it simple with basic styling. I'll customize things later.
Use your own server for testing. Upon delivery please deliver the following:
- 1 database for user data, songs/playlist data
- All the needed PHP files for user
registration, login, logout, password reset, php page to output next song data in XML from selected playlist.
Should be a simple project for the right person.
Hello,
With 99% completion rate, 700 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wrong choosing me :)
I look forward to your reply.
Thanks.
Kind Regards,
Rajesh Soni
I have read your project details, and I am interested in offering my services.
I provide 100% satisfaction guaranteed on all my work.
Milestone is required to begin; to be released when the job has been satisfactorily completed.
I estimate a 4-5 day turnaround (including weekends) on this project.
ftp and cpanel details to your site will be required.
Contact me at your soonest convenience so we may get your solution delivered quickly.
Thanks,
coderXO
Yes you are right its a simple project and i need 24 to 48 hours to finish this project its my guaranty if u see my reviews than u willl be sured that you are along with right guy
Hi,
Hope you are doing well. Thanks for the requirement. There, Greetings from WSK Technologies Pvt. Ltd. Thank you for offering this job, We have gone through your description and we are confident to deliver you best solution. Your Goal of the project and your requirement is very clear to us. Please share your website url.
Looking forward to hear back from you and maintain a long term relationship.
Cheers!
Subrata
Dear hiring manager,
I have read your job description very attentively. I have fully understood what you need to done..
We have a team of professionals.. I can work full time and have the ability to finish the project within the deadlines .
I am interested in this job. I can give you 100% assurance of my work.
Have a nice day..
Dear Sir, I am really interested to work on this project, I can start the work now , and can provide the best services from my end. Please come on chat to discuss more about the project. Regards, Bhagwan