Making an array output to input?
Now I found a code that I modified and it is doing what I want (almost). The code is generating the music genre from a table of songs (with a lot of info) called table_genre with the fields genre_id and genre_name.
These are included in a form as checkboxes. The user can check one or more boxes of the genres that suit the song.
Then I want to input this into my table called songs_genre, but right now I only have it on my screen separated with comma.
I picked code from something I found when I googled it. But I want my output to be inserted into my db called songs_genre. Here I like to insert the song_genre from the form and also one called $song_id so the genres selected are connected to the song that is used on the actual form.
$song_genre = count($_POST['song_genre']) ? $_POST['song_genre'] : array();
//echo out the choices separated by a comma
echo count($song_genre) ? implode(', ',$song_genre) : 'Nothing!';
Can anyone tell me how to change the code above, so it is inserted as separated lines together with the song_id into my table called song_genre
If the song is $song_id=32. The genre is rock (song_genre 5), instrumental (song_genre 12).
Then I would like them inserted into my table (songs_genre) as :
song_id | song_genre
32 | 5
32 | 12