mySQL, PHP, XML Project

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:

[url removed, login to view]

Example: this would output the next song in playlist 2 to the user.

The XML output should contain:







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:

[url removed, login to view]

and dislike like this:

[url removed, login to view]

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.

Beceriler: MySQL, PHP, XML

Daha fazlasını görün: things needed for creating a website, structure stores, reset link, please reset your password, php code to create report, make up styling, hash table in data structure, hash table data structure, hash in data structure, hash data structure, creating php table, public domain database, xml to my sql, sql server random, invalid project id, build a website public database, add playlist player, build mp3 website, website sql injection, project php download songs, report mysql php database, database music store, use php, simple mp3 player project, php mysql sql example

İşveren Hakkında:
( 1 değerlendirme ) Los Angeles, United States

Proje NO: #6491799



Hello, I am expert MYSQL & PHP and i am very interesting this project! Let i do it for you! Best regards, LEO

3 gün içinde 111$ USD
(0 Değerlendirme)

18 freelancers are bidding on average $370 for this job


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 satisfactor Daha fazlası

in 5 gün içinde285$ USD
(641 Değerlendirme)

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 wron Daha fazlası

in 7 gün içinde1473$ USD
(512 Değerlendirme)

Do you have PSD for this task ?........................................................................................................

in 10 gün içinde263$ USD
(44 Değerlendirme)

I m expert in this. I have +5years experience. Following are my recently completed project: Wordpress [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] Daha fazlası

in 7 gün içinde250$ USD
(124 Değerlendirme)

let expert do this...................................................................................................

in 14 gün içinde611$ USD
(137 Değerlendirme)

A proposal has not yet been provided

in 10 gün içinde1000$ USD
(73 Değerlendirme)

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

in 3 gün içinde180$ USD
(65 Değerlendirme)

Hello. I am a web developer with 11+-year experience . I work remotely on DigitalRay company - [url removed, login to view] - LA (USA). Technical knowledges: 1PHP JavaScript Ruby RoR ASP.Net C#, Java, Python, Zend, CakePHP, Symph Daha fazlası

in 3 gün içinde377$ USD
(24 Değerlendirme)

A proposal has not yet been provided

in 10 gün içinde210$ USD
(9 Değerlendirme)

Is the xml output for an rss feed? Its not exactly clear why you want the output to be xml. Also, what time frame and budget are you considering.

in 10 gün içinde222$ USD
(12 Değerlendirme)

Hello dear sir i am having few questions if you would like to answer please, i will be waiting for your PM and hope you will contact soon thanks

in 6 gün içinde150$ USD
(10 Değerlendirme)

Hi, I got a fair comprehension about your project. I have few questions, so please come on chat for further discussion. Benefits you get: 1. 2 Months Free Technical Support and Warranty 2. W3C Compliant Code, So Daha fazlası

in 3 gün içinde147$ USD
(13 Değerlendirme)

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 pr Daha fazlası

in 3 gün içinde178$ USD
(4 Değerlendirme)

A proposal has not yet been provided

in 3 gün içinde250$ USD
(3 Değerlendirme)

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 be Daha fazlası

in 8 gün içinde197$ USD
(3 Değerlendirme)

Hello Mate We are a young team that is focused on growth through doing things differently. Since inception we have focused on delivering projects which are benchmarked by its quality. We say what we can deliver and d Daha fazlası

in 10 gün içinde555$ USD
(0 Değerlendirme)

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

in 5 gün içinde200$ USD
(0 Değerlendirme)