Uploading CD details to a mysql database advice

[herghost]

Hi all,

 

how would you upload track information into a database? Obvioulsy the amount of tracks will vary per album uploaded and I was wondering the best way to acheive this.

 

The end result being that I would like to echo out the information like:

 

1. Track 1 name
2. Track 2 name etc

 

The only uploading I have done has just been through a PHP form and then inserting it into a database.

 

How would you go about this?

 

Thanks

[Ken2k7]

So what other way do you want to upload?

[herghost]

I am happy with the insert, but i dont know how the best way to do this for tracks is. If I basically call each field say t1 for track one and then t2 for track two etc, it is going to cause problems with undefied fields if i have 20 boxes but there are only 12 tracks, i would in effect have undefied fields on t13 to t20 if you see what I mean

[Ken2k7]

I would have JavaScript operate the number of input boxes. But you can always check using PHP to see if the input box is empty or not.

 

This is how I would do it:

<form method="post" name="tracks">
<input id="1" type="hidden" name="tracks_count" value="0" />
</form>

<script type="text/javascript">
var trackcount = 1;
var trackform = document.forms.tracks;
function addTrackField () {
     trackform.innerHTML += '<input type="text" name="track' + trackcount + '" />';
     trackform.tracks_count.value = ((int) trackform.tracks_count.value) + 1;
     trackcount++;
}
<script>

<a href="javascript:addTrackField(); return false;">Add track</a>

 

Then for PHP, I can grab the tracks_count field and loop.

[fry2010]

you could store them as CSV's. In just one column.

So say CD TITLE, CD TRACKS. and thats it.

 

Then store them by appending a comma in between each track name. All you then have to do to find out the number of tracks is split them using explode().

[herghost]

Thanks to both of you,

 

Ken, how would I do this in the database? 1 x Long Text field?

[Ken2k7]

Do what in the database?

[herghost]

store the track information.

 

perhaps I have missed the point, I have only been dabbling in pphp for the last few weeks, there is a lot i dont understand!

[Ken2k7]

Well you set up the table and run an INSERT SQL. Google.

[herghost]

yeah I get that....

 

Basically the output of this javascript, does it give every track an variable? or will all the tracks be in one?

[Ken2k7]

Try it out. Put it on your page.

 

The JavaScript just adds a field. Of course, you would want to modify it a bit. The form keeps track of the total number of tracks you added in the form.