php - How to upload multiple music files simultaneously to a single column in mysql database -

php - How to upload multiple music files simultaneously to a single column in mysql database -

i beginner in php creating project of music download website using php , mysql. want upload multiple songs in single column below code not working.

i have 3 tables: album, artist, , music.

album table +================================ | album_id | album_name | poster| +================================ | | | | | | | | +===============================+ arist table +========================== | artist_id | artist_name | +========================== | | | | | | +=========================+ music tabel +=====================================+ | artist_name | album_name | song_name| +=====================================+ | | | | | | | | +=====================================+

i want insert info @ 1 time in above tables. code below:

<?php $album_name1=$_request['txtmovie1']; $album_name2=$_request['txtmovie2']; $album_name3=$_request['txtmovie3']; $album_name4=$_request['txtmovie4']; $album_name5=$_request['txtmovie5']; $artist1=$_request['txtartist1']; $artist2=$_request['txtartist2']; $artist3=$_request['txtartist3']; $artist4=$_request['txtartist4']; $artist5=$_request['txtartist5']; if(isset($_request['cmdsubmit'])) { $con = mysql_connect("localhost","root") or die(""); $db=mysql_select_db("omg",$con); //movie poster upload //poster1 $target_file="upload/".$_files['upsongs1']['name']; $source_file=$_files['upsongs1']['tmp_name']; if(move_uploaded_file($source_file, $target_file)) { $poster1=$_files['upsongs1']['name']; } echo $poster1; //poster2 $target_file="upload/".$_files['upsongs2']['name']; $source_file=$_files['upsongs2']['tmp_name']; if(move_uploaded_file($source_file, $target_file)) { $poster2=$_files['upsongs2']['name']; } echo $poster2; //poster3 $target_file="upload/".$_files['upsongs3']['name']; $source_file=$_files['upsongs3']['tmp_name']; if(move_uploaded_file($source_file, $target_file)) { $poster3=$_files['upsongs3']['name']; } echo $poster3; //poster4 $target_file="upload/".$_files['upsongs4']['name']; $source_file=$_files['upsongs4']['tmp_name']; if(move_uploaded_file($source_file, $target_file)) { $poster4=$_files['upsongs4']['name']; } echo $poster4; //poster5 $target_file="upload/".$_files['upsongs5']['name']; $source_file=$_files['upsongs5']['tmp_name']; if(move_uploaded_file($source_file, $target_file)) { $poster5=$_files['upsongs5']['name']; } echo $poster5; //song upload //song1 upload $targets1_file="song/".$_files['txts1']['name']; $sources1_file=$_files['txts1']['tmp_name']; if(move_uploaded_file($sources1_file, $targets1_file)) { $s1=$_files['txts1']['name']; } //song2 upload $targets2_file="song/".$_files['txts2']['name']; $sources2_file=$_files['txts2']['tmp_name']; if(move_uploaded_file($sources2_file, $targets2_file)) { $s2=$_files['txts2']['name']; } //song3 upload $targets3_file="song/".$_files['txts3']['name']; $sources3_file=$_files['txts3']['tmp_name']; if(move_uploaded_file($sources3_file, $targets3_file)) { $s3=$_files['txts3']['name']; } //song4 upload $targets4_file="song/".$_files['txts4']['name']; $sources4_file=$_files['txts4']['tmp_name']; if(move_uploaded_file($sources4_file, $targets4_file)) { $s4=$_files['txts4']['name']; } //song5 upload $targets5_file="song/".$_files['txts5']['name']; $sources5_file=$_files['txts5']['tmp_name']; if(move_uploaded_file($sources5_file, $targets5_file)) { $s5=$_files['txts5']['name']; } $qry1=("insert music(artist_name, album_name, song_name ) values('$artist1','$album_name1', '$s1'), values('$artist1','$album_name2', '$s2'),('$artist1','$album_name3', '$s3'), ('$artist1','$album_name4', '$s4'),('$artist1','$album_name5', '$s5')"); $qry2=("insert album(album_name, poster) values('$album_name1','$poster1'), ('$album_name2','$poster2'), ('$album_name3','$poster3'), ('$album_name4','$poster4'), ('$album_name5','$poster5')"); ?> <form name="form1" method="post" action="admin_new2.php" enctype="multipart/form-data" id="main" onsubmit="return check();"> <table> <thead><tr> <th>song</th> <th>movie/album</th> <th>artist</th> <th>poster</th> </tr></thead><tbody> <tr > <td> <input type="file" name="txts1"> <input type="file" name="txts2"> <input type="file" name="txts3"> <input type="file" name="txts4"> <input type="file" name="txts5"> </td> <td> <input type="text" name="txtmovie1"> <input type="text" name="txtmovie2"> <input type="text" name="txtmovie3"> <input type="text" name="txtmovie4"> <input type="text" name="txtmovie5"> </td> <td id="artist-clm"> <input type="text" name="txtartist1"> <input type="text" name="txtartist2"> <input type="text" name="txtartist3"> <input type="text" name="txtartist4"> <input type="text" name="txtartist5"> </td> <td id="poster"> <input type="file" name="upsongs1"> <input type="file" name="upsongs2"> <input type="file" name="upsongs3"> <input type="file" name="upsongs4"> <input type="file" name="upsongs5"> </td></tr> </tbody></table> <center><input type="submit" name="cmdsubmit" value="submit"></center> </form>

basically, because must not repeat values keyword when insert many records 1 query.

insert music(artist_name, album_name, song_name ) values('$artist1','$album_name1', '$s1'), ('$artist1','$album_name2', '$s2'), ('$artist1','$album_name3', '$s3'), ('$artist1','$album_name4', '$s4'), ('$artist1','$album_name5', '$s5')

then, next step, know beginner code not optimized. instead repeat 4 times, see loop or store info array :)

this decrease code size , maintaining easier.

php html mysql