http://www.mp3load.ws/mp3-php-mysql/
Install mp3 files on host monster mysql datebase so php retrieves it, sends it to flash?
I just joined host monster and i am trying to figure out how i am going to put mp3 files in the mysql database that host monster provides. After doing that i want to write a php code that retrieves the mp3 or music files and send it to flash. Can someone help out please.
Hi,
the easiest solution would be to read the mp3 binary and then store it in a longtext/blob column in a database. I recommend having two tables where you store your information: first being just blobs with blob_id, blob_data, blob_timestamp and blob_active, second containg all the mp3 info such as artist, blob_id (important), file_size, if you’re only dealing with with mp3s you shouldn’t need file_size nor file_type (all can be retrieved by PHP when reading the file), timestamp never did any harm…
To retrieve it you perform a simple SELECT from both tables based on blob_id (such as ‘SELECT b.blob_data, m.mp3_name, m.mp3_size FROM blobs as b, mp3s as m WHERE m.mp3_id = ‘HOWEVER YOU PASS THE MP3_ID here (GET I SUPPOSE)’ AND m.blob_id = b.blob_id) and using headers output the mp3 to browser either to download or play (attachment/inline).
This should give you enough information to be able to browse the internet for the rest, this simple is an outline of the approach I have been taking so far (and I store all sorts: office documents, images… actually I run a DMS (Document Management System))…
Give me a shout if you need more help,
good luck,
hoopyfrood
————————————–…
Love your documents!
DocuView (http://docuview.co.uk/) – The best Web 2.0 document management system (DMS) – utilising the latest technology to help your company achieve ISO 9001 certification.
How to Build a Community Web Site Part 7 – Create Logout in Flash AS3 & PHP Destroy Session
|
|
PHP and MySQL Web Development (3rd Edition) $39.99 This is the eBook version of the printed book.A new edition of this title is available, ISBN-10: 0672329166 ISBN-13: 9780672329166 We’ve taken the best and made it even better. The third edition of the best-selling PHP and MySQL Web Development has been updated to include material and code on MySQL 5, PHP 5 and on PHPs object model and validation. Through a clear, practical approach, you wi… |
|
|
Expert PHP and MySQL (Wrox Programmer to Programmer) $44.99 Best practices and expert techniques for even the most demanding MySQL-driven PHP applicationsPHP is the world’s most popular, general-purpose, open-source scripting language and MySQL is the world’s most popular open-source database. This expert-level book begins with a brief overview of the two technologies and quickly moves on to coverage of advanced programming techniques, as well as the excit… |
|
|
Mastering phpMyAdmin 3.3.x for Effective MySQL Management $31.99 This is a step-by-step instructional guide to get you started easily with phpMyAdmin and teach you to manage and perform database functions on your database. You will first be introduced to the interface and then build basic tables and perform both simple and advanced functions on the created database. The book progresses gradually and you will follow it best by reading it sequentially. If you are… |
