[I need to display an image from my FTP using a database entry result (php & mysql)]

Hi Muddy_

 

I have mysql, php, apache all setup and running on a localhost enviroment.

 

All the images will be stored on my server (in the htdocs folder) therefore a fixed location.

 

The database stores the filename of each picture but nothing else.

 

thanks...

 

Justin.

[I need to display an image from my FTP using a database entry result (php & mysql)]

I am looking for some guidance before i attampt to code the following.

 

 

The Brief:

I have a MySQL database of music, one of the columns is called "albumart", within this entry is a file name i.e. "picture.jpg".

 

This entry is not a link... just a file name.

 

I would like to display picture.jpg onto my website.

 

The picture is stored in a specific location on the server.

 

This is what i think i need to do:

 

Call the "albumart" columns most recent entry into a variable (i think) , then ask PHP to go and find the "file name" from a specific location (on the server) add it to another variable (i think) and then display it on screen.

I hope this makes sense...

 

although i understand the basic concept i am unsure where to start when it comes to linking the two bits of code together

 

much respect...

 

justin..

 

[A question to the Wise...]

And after reading the rules ... i have just broken every one of them... Sorry..

[A question to the Wise...]

Dear knowledgeable people...

 

I am a complete novice when it comes to coding so to begin with I would like your help in answering a question that relates to the structure of which my project needs to proceed..

 

 

The basics are:

 

I have a piece of audio broadcasting software.

The software plays music to whoever wants to listen across the net.

When a song is played the software updates a MYSQL database.

The information that is sent to the database consists of data such as “song name” “artist” etc.. etc..

 

What I would like to do:

 

I would like this information to be sent to my web page (yet to be designed) and it be updated when a change is made to the database (I.e. upon a song change) or updated at logical times (maybe every 15 seconds).. either way it is important that the user viewing the web page does not have to refresh the page to see the new results from the database.

 

My understanding:

 

The way I understand it is that …

MYSQL stores the information created by the broadcasting program.

Then I need a PHP script to take this information and store it in a logical way on my server.

Next I need some form of JAVA to take this information and place it onto the web page for the user to view. (I also believe that I need Java as it enables real-time updates without the need to refresh the page manually)

That is about as far as I have got..

 

What I would really like is for someone to explain if this process is correct so I can go about learning the programming languages in a structured way..

 

What do I already know...

 

I have a server set-up

It has, MYSQL+PHP+APACHE all running and I can access these programs/services.

I have managed to copy/destroy and paste other peoples PHP work and I am able to get information from the MYSQL database.. i.e. “the most recently played song” and “the last 6 played songs” and display them on screen.

 

Where do I go from here?. Am I right in thinking that this structure is correct... How big is this can of worms..

 

I hope you can find the time to help me head in the right direction..

 

 

regards

 

Justin..