Song Request Software?

[qball]

Hopefully I wont have to learn to write all that my self.

you done yet???

lol.

[ChoaticWhisper]

I have been trying to lean alittle bit of mysql and php but the syntax is really getting to me, So I just started to see what I could do with Mysql from commandline.
I dont have the database yet, Ill try to makeup a sample one or try to get a guy to send one to me, But I would still need to make it into a mysql database.
Rhino, Sounds like Access would make everything easy but I dont have it and cant afford it. Is there a demo that works for so long or something?
qball, Lol no Im not done. Not even close.

[qball]

ChoaticWhisper,

Iffin you wanna keep learning, then you'll get the most bang for your buck with PHP and mySQL. They are both free, wait, both are GPL.

I run mySQL on an XP server, PHP through IIS, me lucky (works well, btw), though I could use Apache, instead. Hey, maybe I should.

Anyway, what server are you running on your 'main computer'?

[ChoaticWhisper]

Hey qball, I will probably learn one day but I just cant get the syntax, Think maybe I should just learn PHP first?
Good to see you got mySQL and php working on IIS, I never could. I got apache and mysql and php running before and I recently tried PHPTriad. I dont have a server for this project up and running yet, Although I thought I would use Linux, I dont have much luck with windows and servers.

Do most people learn PHP and MySQL at the same time or one at a time?
Do you have anything besides PHP.com or MySQL.com to learn, Is PHPBuilder a good place?

[qball]

Think maybe I should just learn PHP first?

Learn HTML first.

Wait, learn client-server (GUI/DB), then HTML (GUI), then learn networking (or how PCs interact)...

What the p do I know?

Anyway:

phptriad is basically PHP and mySQL in a common install (there is another piece, thus triad name...) Iffin you have PHP and mySql already installed and working, no need.

PHP is an HTML preprocessor (server side scripting).

mySQL is a DBMS.

If this doesn't make much sense to you, you need to learn more.

BTW, this is how 'I' think you want this whole jobber work.

On any PC of original 3, open browser (your choice) and go to URL for your web server.

This brings up login page? HTML search page for music? The starting point (let's use PHP).

From here user chooses "artist", "alice in chains" (po alice), and clicks Submit button.

Now, onSubmit() will send form input to web server, which will recognize PHP requext and send to PHP processing.

PHP now processes form input and connects to a mySQL DB, that performs SQL query returning any matches to PHP, which returns to web server, which sends back to browser...

Got it? There is some processing and a lot to learn.

Without a PC acting as server (web and DB), then things are a little tougher...

[ChoaticWhisper]

I know HTML,I make all the webpages I do in notepad. I kinda know Networking(just enough to setup a network in windows and linux).
I tried PHPTraid but something was wrong so I download apache, mysql, and php and installed it on this computer for testing purposes.
Ive pretty much got it figured out on how I want to do things, just the things I want to do, I dont know how, Like php and mysql I dont know how to write.

I looked around and I know how to make a very simple counter in PHP, I guess thats a start in learning.

I guess what I need to do could be done pretty easily done with just html and cgi, but I dont want to have to add all the songs into pages the first time around.

[qball]

I guess what I need to do could be done pretty easily done with just html and cgi, but I dont want to have to add all the songs into pages the first time around.

Do you know CGI? And, no, I don't think so easy.

It seems you want a 'user' to open an html page that offers up whatever music you want to offer. Choose by style, search for artist, maybe song title? This may seem easy in concept, but you need to 'make it happen'.

Simply set up apache as web server, mySQL as DB server, configure apache to run php.

Now the fun stuff.

Set up mySQL DB to store relevant info on your mp3 collection. Or better yet store the mp3s. Non-trivial, but not that hard.

Get PHP to connect to mySQL DB, to access given info. But you gotsa write the HTML and PHP.

Why don't you set up network and let users browse your mp3s by directory?

[ChoaticWhisper]

Do you know CGI?
No, I dont but thought I might be able to find a script pretty easily to do that.

Simply set up apache as web server, mySQL as DB server, configure apache to run php.
I've done that on my own computer to check how far along things are and what I can do with stuff I download or try to write.

Set up mySQL DB to store relevant info on your mp3 collection.
Or better yet store the mp3s. Non-trivial, but not that hard.
Its not mp3s Im wanting to play its cds in a club, and the cds are labled by a ID number. I found a cgi scripts that read a csv database file and print the info into a html page, but I cant submit data to anywhere it just prints it.


Get PHP to connect to mySQL DB, to access given info. But you gotsa write the HTML and PHP.
Thats what I thought I would end having to do. Im having some problems right now trying to make a database, I have MySQL front but I dont know enough about making propties to give a table or what ever esle stuff to make it work.
Ill go read and search some more, Wouldnt all the data need to be in a VARCHAR?

Why don't you set up network and let users browse your mp3s by directory?
Like above not mp3s I want to play.

Thanks for the help and other ideas.

[qball]

good, your thinking.

Im wanting to play its cds in a club, and the cds are labled by a ID number.

ok, help me out here.

Do you want mix-mastering functionality, like DJ?

Do you want PC to control what CD tracks are playing? and what is next?

Do you want something that will return 'ID number' by song/artist/track choice, search results, whatever?

[ChoaticWhisper]

Do you want mix-mastering functionality, like DJ?
There is someone placing the cds in the cd changer and most of the time people request what is going to be played.
Do you want PC to control what CD tracks are playing? and what is next?
No it doesnt need to play anything.

Do you want something that will return 'ID number' by song/artist/track choice, search results, whatever?
Someone will be able to search and it will return the results of what was searched. Then the song/artist/ID number and the name that someone typed in will be sent back to the main computer somehow(Maybe email or something?).