Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
Kelas Premium!
Belajar bikin website dari nol sekarang
Gunakan kupon "lebihcepat" untuk diskon 25%!
(ASK)input content & image ke database - PHP
saya punya masalah dengan input content ke database dengan content gambar juga. sebelumnya sudah bisa, tapi ntah kenapa sekarang error blank.
input formnya spt ini.
<form class='form-horizontal' method='POST' action='save_input_problem.php' enctype='multipart/form-data'>
<fieldset>
<?php
$barkode = date('dmhis');
$date=date('Y-m-d');
?>
<div class='form-group'>
<label class='col-lg-2 control-label' for='id_problem'>ID problem</label>
<div class='col-lg-10'>
<input class='form-control' id='id_pelanggan' name='id_masalah' type='text' value='<?php echo $barkode ?>' readonly required='required' >
<span class='help-block'>ID Problem</span>
</div>
</div>
<div class='form-inline' style="padding-bottom:50px">
<label class='col-lg-2 control-label' >Date / Time</label>
<div class='col-lg-10'>
<input class='form-control' readonly="" name='tgl' type='text' required='required' value=" <?php echo $date ?> ">
<input class='form-control' name='waktu' type='text' required='required'value="<?php echo date("h:i:s")?>" >
</div>
</div>
<!--departemen-->
<div class='form-group'>
<label class='col-lg-2 control-label' >To Departemen</label>
<div class='col-lg-10'>
<select name='id_departemen' class='selectize-select form-control' required='required'>
<?php
$sql = mysql_query("SELECT * FROM departemen ORDER by id_departemen ");
while($x=mysql_fetch_array($sql))
{
echo "<option value='$x[id_departemen]'>$x[nama_departemen]</option>";
}
?>
</select>
</div>
</div>
<!--memanggil tipe-->
<div class='form-group'>
<label class='col-lg-2 control-label' >Problem Type</label>
<div class='col-lg-10'>
<select name='id_kategori' class='selectize-select form-control' required='required'>
<?php
$sql = mysql_query("SELECT * FROM kategori_masalah ORDER by id_kategori ");
while($x=mysql_fetch_array($sql))
{
echo "<option value='$x[id_kategori]'>$x[nama_kategori]</option>";
}
?>
</select>
</div>
</div>
<div class='form-group'>
<label class='col-lg-2 control-label' >Probelm</label>
<div class='col-lg-10'>
<textarea class="form-control" placeholder="what's the problem ?" name="masalah" required='required'></textarea>
</div>
</div>
<div class='form-group' >
<label class='col-lg-2 control-label' >Location</label>
<div class='col-lg-10'>
<input class='form-control' name='lokasi' type='text' placeholder='Room/Place/PC' required='required' >
</div>
</div>
<div class='form-group'>
<label class='col-lg-2 control-label' >User</label>
<div class='col-lg-10'>
<input class='form-control' name='id_staff' type='text' value="<?php echo "$_SESSION[id_staff]"; ?> " readonly>
</div>
</div>
<div class='form-group'>
<div class='col-lg-10'>
<div class="radio radio-info radio-inline">
<input type="radio" id="inlineRadio1" value="1" name="status" checked="" >
</div>
<div class="radio radio-inline radio-danger">
<input type="radio" name="status" id="radio4" value="2" >
</div>
</div>
</div>
<div class='form-group'>
<label class='col-lg-2 control-label' >Image</label>
<div class='col-lg-10'>
<input class='form-control' name='file' type='file' id="fotom">
</div>
</div>
<div class='form-group'>
<label class='col-lg-2 control-label' for='focusedInput'></label>
<div class='col-lg-10'>
<button type='submit' class='btn btn-primary'>Save</button>
<button type='file' class='btn btn-danger'>Reset</button>
</div>
</div>
</fieldset>
</form>
nah file actionnya spt ini.
<?php
include "koneksi.php";
$dir="fotom/";
$extension=$_FILES["fotom"]['type'];
$filename=$_FILES["fotom"]["name"];
$filesize=$_FILES["fotom"]["size"];
$tmpname=$_FILES["fotom"]["tmp_name"];
if($extension=="gambar/jpeg" or $extension=="gif")
{
if(move_uploaded_file($tmpname,$dir,$filename))
{
$save=mysql_query("INSERT INTO masalah VALUES (
'$_POST[id_masalah]',
'$_POST[id_departemen]',
'$_POST[id_kategori]',
'$_POST[masalah]',
'$_POST[lokasi]',
'$_POST[tgl]',
'$_POST[waktu]',
'$_POST[id_staff]',
$filename,
'$_POST[status]'
)");
if($save)
{
echo"<script>
alert('TERSIMPAN');location.href='input_problem.php';
</script>";
}
}
else
{
echo"<script>
alert('GAGAL');location.href='homr.php';
</script>";
}
}
?>
sekarang blank di url save_input_problemnya,mungkin ada yg bisa bantu.
mohon bantuannya.
1 Jawaban:
$extentions=="gambar/jpeg" bukannya "image/jpeg" gan? $_FILES["fotom"]["type"] digunakan untuk mengecek tipe mime file gan tuk mengecek file extention pke pathinfo
<?php
$dir="fotom/";
$target_file = $target_dir . basename($_FILES["fotom"]["name"]);
$extention = pathinfo($target_file, PATHINFO_EXTENSION);
?>