Hii,
I have managed to get some code working using the PHP Manual. It uploads multiple images to my server, however i am having problems inserting each file path to my database…?
This is my FORM code with 4 images input :
<form method="POST" action='' enctype='multipart/form-data'>
<table>
<tr>
<td width='200'>NSS </td><td> <input type='text' style='padding:5px;width:250px;' name="nss" placeholder='nomor statistik sekolah' required='required' /></td></tr>
<tr>
<td>NPSN </td><td> <input type='text' style='padding:5px;width:250px;' name="npsn" placeholder='npsn' /></td></tr>
<tr>
<td>Nama Sekolah </td><td> <input type='text' style='padding:5px;width:250px;' name="nama_sekolah" placeholder='Nama Sekolah' required='required' /></td></tr>
<tr>
<td>Jenis Sekolah </td><td><select name="jenis_sekolah" required='required'>
<option value=''>--Negeri/Swasta--</option>
<option value='Negeri'>Negeri</option>
<option value='Swasta'>Swasta</option>
</select></td></tr>
<tr>
<td>Akreditasi</td><td><select name="akreditasi" required='required'>
<option value=''>--PILIH AKREDITASI--</option>
<option value='A'>A</option>
<option value='B'>B</option>
<option value='C'>C</option>
<option value='D'>D</option>
<option value='E'>E</option>
<option value='TT'>Belum Terakreditasi</option>
</select></td></tr>
<tr>
<td>Alamat </td><td> <input type='text' style='padding:5px;width:250px;' name="alamat" placeholder='Alamat Lengkap' required='required' /></td></tr>
<tr>
<td>Telepon </td><td> <input type='text' style='padding:5px;width:250px;' name="tlp" placeholder='(0291)-xxx/085xxx' /></td></tr>
<tr>
<td>Websites </td><td> <input type='text' style='padding:5px;width:250px;' name="web" placeholder='Alamat website / blog' /></td></tr>
<tr>
<td>Jumlah Guru </td><td> <input type='text' style='padding:5px;width:250px;' name="jmlguru" placeholder='jumlah guru' required='required' /></td></tr>
<tr>
<td>Jumlah Siswa </td><td> <input type='text' style='padding:5px;width:250px;' name="jmlsiswa" placeholder='jumlah siswa' required='required' /></td></tr>
<tr>
<td>Kecamatan</td><td><select name="kecamatan" required='required'>
<option value=''>--PILIH KECAMATAN--</option>
<option value='BAE'>BAE</option>
<option value='DAWE'>DAWE</option>
<option value='GEBOG'>GEBOG</option>
<option value='KALIWUNGU'>KALIWUNGU</option>
<option value='KOTA'>KOTA</option>
<option value='JATI'>JATI</option>
<option value='JEKULO'>JEKULO</option>
<option value='MEJOBO'>MEJOBO</option>
<option value='UNDAAN'>UNDAAN</option>
</select></td></tr>
<tr>
<td colspan='2'><center>Koordinat Geografis Sekolah</center></td></tr>
<tr>
<td>Lintang</td><td> <input type='text' style='padding:5px;width:250px;' name="lat" placeholder='-6.xxxxx' required='required'/></td></tr>
<tr>
<td>Bujur </td><td> <input type='text' style='padding:5px;width:250px;' name="lon" placeholder='110.xxxxx' required='required' /></td></tr>
<tr>
<td>Images </td><td> <input type='file' style='padding:5px;width:250px;background:#f0f0f0;' name="file1" id='f1' /><br /></td></tr>
<tr><td> <input type='file' style='padding:5px;width:250px;background:#f0f0f0;' name="file2" id='f2' /><br /></td></tr>
<tr><td> <input type='file' style='padding:5px;width:250px;background:#f0f0f0;' name="file3" id='f3' /><br /></td></tr>
<tr><td> <input type='file' style='padding:5px;width:250px;background:#f0f0f0;' name="file4" id='f4' /><br /></td></tr>
<tr>
<td> </td><td><br /> <input type='submit' class='submit' name='submit' value='Simpan' />
<input type='reset' class='submit' value='Reset' /></td></tr>
</table>
<a class="more" href="data.php">Kembali</a>
</form>
this is my code to save image and insert data to database : (*but this code bellow is not work)
<?php
if (isset($_POST['submit']))
{
$tipe_file1 = $_FILES['file1']['type'];
$tipe_file2 = $_FILES['file2']['type'];
$tipe_file3 = $_FILES['file3']['type'];
$tipe_file4 = $_FILES['file4']['type'];
if ($tipe_file1 == "image/jpeg" || $tipe_file1 == "image/jpg"){
$aMyUploads = array();
foreach ($_FILES as $aFile) {
if(0 === $aFile['error']){
$newLocation = 'foto/'.$aFile['name'];
if(0 === $aFile['error'] && (false !== move_uploaded_file($aFile['tmp_name'], $newLocation))){
$aMyUploads[] = $newLocation;
} else {
$aMyUploads[] = '';
}
}
}
print_r($aMyUploads);
mysql_query("INSERT INTO smamakudus (nss, npsn, nama_sekolah, jenis_sekolah, akreditasi, alamat, tlp, web, jmlguru, jmlsiswa, kecamatan, lat, lon, image1, image2, image3, image4,) VALUES
(
'".$_POST['nss']."',
'".$_POST['npsn']."',
'".$_POST['nama_sekolah']."',
'".$_POST['jenis_sekolah']."',
'".$_POST['akreditasi']."',
'".$_POST['alamat']."',
'".$_POST['tlp']."',
'".$_POST['web']."',
'".$_POST['jmlguru']."',
'".$_POST['jmlsiswa']."',
'".$_POST['kecamatan']."',
'".$_POST['lat']."',
'".$_POST['lon']."',
'".$_POST['alamat']."',
'".$aMyUploads[0]."',
'".$aMyUploads[1]."',
'".$aMyUploads[2]."',
'".$aMyUploads[3]."',
'".$aMyUploads[4]."',)") or die(mysql_error());;
echo "<script>alert('Successfully added')</script>";
}else{
echo "<script>alert('Failed to add data! Images must be inputed at last one and filetype JPG/JPEG')</script>
<script>setTimeout(\"self.history.back();\",0000);</script>";
}
}
echo "</div>
</div>";
?>
and my problem is the images all upload to the server fine, but insert data that does not work…
Are something error in my $_POST code…?
