Minor Project Report for Online Music Streaming Website, Lab Reports of Web Design and Development

Download Minor Project Report for Online Music Streaming Website and more Lab Reports Web Design and Development in PDF only on Docsity! MUSIQUE A Minor Project Report Submitted in Partial Fulfillment of the requirement for the award of the degree Of BACHELOR OF COMPUTER APPLICATIONS (B.C.A) By Durgesh Nandini Jangid 171015049 Under the Guidance of Dr Kuntal Gaur School of Basic Science MANIPAL UNIVERSITY JAIPUR JAIPUR-303007 RAJASTHAN, INDIA June/2020 CERTIFICATE 28/05/2020 This is to certify that the project titled ​MUSIQUE is a record of the bonafide work done by ​DURGESH NANDINI JANGID (171015049) submitted in partial fulfilment of the requirements for the award of the Degree of Bachelor of Computer Applications (B.C.A)​ ​of Manipal University Jaipur, during the academic year 2019-20. Dr Kuntal Gaur Project Guide, Dept of Computer Applications Manipal University Jaipur Dr Devershi Pallavi Bhatt HOD, Dept of Computer Applications Manipal University Jaipur Page No Abstract i List Of Figures List Of Tables Chapter 1 INTRODUCTION 1 1.1 Introduction to work done/ Motivation (​Overview, Applications & Advantages​) 1 1.2 Project Statement / Objectives of the Project 1 1.3 Organization of Report 1 Chapter 2 BACKGROUND OVERVIEW 2 2.1 Conceptual Overview (​Concepts/ Theory used​) 2 2.2 Technologies Involved 2 … Chapter 3 METHODOLOGY 3 3.1 Detailed methodology that will be adopted 3 3.2 Circuit Layouts / block diagrams 3 … Chapter 4 IMPLEMENTATION AND RESULTS 4 4.1 Modules 4 4.2 Prototype 10 ​… Chapter 5 FUTURE WORK AND CONCLUSION 15 5.1 ​Progress Chart/Timeline Chart 15 5.2​ ​Future Work and Conclusion 15 REFERENCES 16 ANNEXURES (OPTIONAL) 1. INTRODUCTION 1.1. Introduction of work done/ Motivation Several solutions already use intelligent playlists embedded in music players installed on computers. There are also online solutions, the most popular of which is last.fm, which acts as a personalized radio station that plays preferred music. On the other hand, it does not allow playback of a certain track. There are also other solutions which use the users’ music collection to generate playlists. The biggest disadvantage of the latter solution is that the users can only have tracks that they already have on their PCs to generate playlists. Of course, this limits the power or the algorithm very much. Now the suggested scenario - one opens a website, types in a track that reflects one’s current mood and hits ‘play’. That’s it! One can go with one’s work and in order to stop the music, one only has to hit the pause or space button, or close the browser, if they prefer. The simplicity of the solution speaks for itself. 1.2. Objectives of the project ● Create a fully functional, but feature-limited, version of an online music player ● Imitate a common music player UI such that the users don’t have to get used to something completely new ● Play music on the go without the need of download or consuming much of users’ bandwidth ● Should be responsive to work well with devices of all screen sizes, whether it’s a widescreen desktop or a handheld device ● Passwords are also secured with salted hash ids and md5 checksum combinations, so it can’t be decrypted easily ● Normalize database such that there is no redundancy 1.3. Organization of report First chapter of my report introduces what my website is about and why it was needed. And how the website is working on the surface. The second chapter of this report tells us about the concept used in this project and also tells us about the technologies used in the project. The third chapter of this report describes the methodologies used in the application; this section consists of the design and outline part of the project. It helps us understand the project much better with the help of diagrams and flowchart involved in the methodologies. The fourth chapter consists of the modules which means it tells us about the sub division of our project into smaller parts and it’s implementation as a whole. The fifth chapter gives us information about the timeline of our project and the future improvement or features to be included in our project in further development. 1 3. METHODOLOGY 3.1. Detailed methodology that will be adapted ● Setup of login/signup form - A login and registration form will be presented to the user upon the first visit of the website. ● Now Playing Bar - After this, there is a Now Playing page where the user can play, shuffle, skip and repeat songs. Users will also be able to seek the progress bar of the song and change the volume. ● Navigation Menu - Then there is a side navigation bar where the user can browse other pages, create their own playlists, discover new music, have a look at the artists etc. ● Creating and inserting data into the database - On the database part, there will be separate tables for songs, artists, genres, albums, playlist and playlist songs. ● Design of Artist page, Album page and the Music Player - The Album page will contain a list of available albums in the database. Now comes the interesting part - The Music Player page. It will have fetched music. The Artists page will contain info about the artist; his songs, albums etc. ● Sorting music based on artist, genre or album - And of course, there is a search page where users can search for a particular song, album or genre. 3.2. Circuit layouts / block diagrams Figure 3.2.1: Entity Relationship Diagram 4 Figure 3.2.2: Zero level Data Flow Diagram 4. IMPLEMENTATION AND RESULTS 4.1. Modules Figure 4.1.1: List of all the tables in the database 5 Figure 4.1.2: Users Table |- SSRs eee eee (Browse | Structure [j SQL Search i Insert 3 Export (i) Import = Privileges J Operations © Tracking = Triggers SELECT * FR “veers D Profiing [Ecit inline} [ Edit] Explain SOL] Cres © Showa | Number ofrows: [25 ~] itr rows: [Search wistanle _] + Options eames) ~ id username fullName email password signupDate dob profilePic CO PEAK $5 Copy @ Delos 13 erj2t —[email protected] cbbdebdbeS4Ss0d4t4a2184b"EetEe0 2020-0224 00 00:00 2020.01.00 aeelsimagesrotie-ps/durgesh JPG tL Ci Checkal Withsslectod: gf Edit 3éCopy @ Delete i} Export Figure 4.1.3: Songs Table (Sener 1270013 Database musque sl lable Songs (Gl Browse [4 Structure [j SQL 4 Search 3 Insert 5} Export [) Import = Privileges” Operations © Tra 28 Triggers 1D) Profiling (Edit inline) [ Edit } [ Explain SQL] << 2) > >> | © Showall | Numberofrows: | 25 v Fitter rows: | Search this table ‘Sort by key | None v + Options Te. vy id title artistid albumid genreld duration path albumOrder plays O @ Edit # Copy @ Delete 26 Sunny 5 2 4 220 assetsimusicibensound-sunny.mp3 4 2 CO PEdit $ Copy @ Delete 27 Sweet 5 a 5 507 asseisimusicibensound-sweet mp3 5 oH OC @PFdit }E Copy @ Delete 28 Tenderness: 3 3 7 203 assets/music/bensound-tendemess.mp3. 4 8 C) P Edt 32 Copy @ Delete 29° The Lounge 3 3 8 446 asseisimusicibensound thelounge mp3 3 10 OC Edit JE Copy @ Delete 30 Ukulele 3 3 9 226 assets/music/bensound-ukulele mp3 2 24 CO) PEdit 32 Copy @ Delete 31 Tomorrow 3 3 1 454 —_asseisimusiobbensound tomorrow mp3 448 O PEdit HE Copy @ Delete 32 8 Parche 2 a 9 3:30 assetsimusic’8- Parche mp3 1 0 CP Edit $8 Copy © Delete 33 Coka 2 a 9 222 assets/music/Coka mp3 2 o Cl @Edit $8 Copy @ Delete 34 Crazy Habibi Vs Decent Munda 32. a 9 3:03 assets/music/Crazy-Habibi-vs-decent-munda mp3 3 0 O bat Copy @ Delete 35 Kalla Sonna Nai 24 7 9 262 assets/music/KALLA-SOHNA-NAI mp3. 4 5 CO @Edit #4 Copy @ Delete 36 Lehanga 12 a 9 3:30 assets/music/Lehanga.mp3 5 0 OC) WP Edit #8 Copy @ Delele 37 Love You Oye 31 ar 9 335 assets/music/Love-You-Oye.mp3 6 0 OC Edit Be Copy @ Delete 38 Mere Wala Sardar 23 7 9 5:16 assets/music/Mere-Wala-Sardar.mp3 , o PEdit 3 Copy @ Delete 39 Perfect 23 % 5 423° asseisimusioPerfect mp3 1 0 QP Edit } Copy @ Delete 40 Despacito a 6 5 441 assets!music/Despacito mp3 2 0 CO) Edit 32 Copy @ Delete 41 1 Don't Care a 6 5 337 assetsimusicll Dont Care.mp3 a) OQ PFA} Copy @ Delete 42 Faded 32 36 5 3:32 asselsimusicFaded mp3 40 (| PEdit #i Copy @ Delete 43 Better 34 6 5 410 asselsimusic/better mp3 5 0 Figure 4.1.6: Artists Table pea (1) Server: 127.0.0.1 » §§ Database: musique » ff Table: artists |) Browse Structure {} SQL 4 Search « Insert =} Export SELECT * FROM “artists” << < 2+) | (© Showall | Numberofrows: | 25 v) Filter rows: [{ + Options ali, v id name £ Edit #2 Copy @ Delete 26 Shaan wu Edit #¢ Copy @ Delete 27 Sunidhi Chauhan & Edit #2 Copy @ Delete 28 Maroon5 wf Edit #2 Copy @ Delete 29 Ash King & Edit #¢ Copy @ Delete 30 Marshmello w Edit #¢ Copy @ Delete 31 Selena Gomez Edit #2 Copy © Delete 32 Justin Beiber uw’ Edit #¢ Copy @ Delete 33 Amaal Malik & Edit #2 Copy @ Delete 34 Pritam wy? Edit %¢ Copy © Delete 35 ShirleySetia & Edit #é Copy @ Delete 36 Sonu Nigam w Edit %¢ Copy @ Delete 37 Shankar Ehsaan Loy & Edit %¢ Copy @ Delete 38 Udit Narayan Ooo0oo000000 000 0 Figure 4.1.7: Playlist Table Figure 4.1.8: Playlist Songs Table 10 4.2. Prototype Figure 4.2.1: Login Page Figure 4.2.2: Registration Page 11 Figure 4.2.7: Your Music Page Figure 4.2.8: Playlist Page 14 Figure 4.2.9: User Profile Page Figure 4.2.10: Update Settings Page 15 5. FUTURE WORK AND CONCLUSION 5.1. Progress chart / timeline chart Figure 5.1.1: Timeline Chart 5.2. Future Work and Conclusion ● Create a dashboard where users could upload their own songs, albums, genres and artists ● Add uncountable songs, albums and artists from all around the globe ● Fetch songs, albums and artists from a properly designed REST API instead of Relational Database ● Populate a user’s previously played songs playlist when the user comes again to the website instead of a randomized playlist every time ● Add more options to the song options menu The goal of building a simple skeleton application for providing an online music player has been achieved. The idea was to create a simple application to be used as a playground for future ideas of providing valuable music content to the users. Also, a simple algorithm was developed that delivers good playlists with minimal input from the user side. The UI has an area used to display track specific information like title, artist and other. Basically, the client implements the whole music player UI, with play, pause, mute, shuffle and repeat functions as well as playlist generation and modification. The application is a good playground for further developments or innovations. 16