Find Jobs
Hire Freelancers

mySQL, PHP, XML Project

$30-250 USD

Terminado
Publicado hace más de 9 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 6491799

Información sobre el proyecto

17 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hello, I am expert MYSQL & PHP and i am very interesting this project! Let i do it for you! Best regards, LEO
$111 USD en 3 días
5,0 (10 comentarios)
3,7
3,7
17 freelancers están ofertando un promedio de $377 USD por este trabajo
Avatar del usuario
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
$1.473 USD en 7 días
5,0 (997 comentarios)
8,7
8,7
Avatar del usuario
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
$285 USD en 5 días
4,9 (784 comentarios)
8,3
8,3
Avatar del usuario
A proposal has not yet been provided
$1.000 USD en 10 días
5,0 (382 comentarios)
7,8
7,8
Avatar del usuario
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
$180 USD en 3 días
5,0 (281 comentarios)
7,2
7,2
Avatar del usuario
let expert do this...................................................................................................
$611 USD en 14 días
4,9 (209 comentarios)
6,7
6,7
Avatar del usuario
Do you have PSD for this task ?........................................................................................................
$263 USD en 10 días
4,8 (48 comentarios)
6,6
6,6
Avatar del usuario
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
$150 USD en 6 días
5,0 (49 comentarios)
5,8
5,8
Avatar del usuario
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
$197 USD en 8 días
5,0 (26 comentarios)
4,9
4,9
Avatar del usuario
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.
$222 USD en 10 días
5,0 (18 comentarios)
4,2
4,2
Avatar del usuario
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..
$178 USD en 3 días
5,0 (11 comentarios)
3,8
3,8
Avatar del usuario
A proposal has not yet been provided
$210 USD en 10 días
4,4 (4 comentarios)
2,2
2,2
Avatar del usuario
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
$200 USD en 5 días
5,0 (1 comentario)
0,6
0,6

Sobre este cliente

Bandera de UNITED STATES
Los Angeles, United States
5,0
1
Forma de pago verificada
Miembro desde sept 22, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.