Assalamu'alaikum wr wb,
kali ini saya akan share bagaimana Cara menyimpan file foto / gambar ke dalam database di php mysql.
Berikut ini syntaxnya :
----------------------------------------------
buat file index.php dengan syntax dibawah ini
----------------------------------------------
<html>
<head>
<title>Cara menyimpan file foto / gambar ke dalam database di php mysql by Syawaluddin Amin, S.Kom</title>
</head>
<body>
<h1>Upload Image</h1>
<form action="simpan.php" method="post" enctype="multipart/form-data">
Pilih File : <input type="file" name="foto"> <input type="submit" value="Upload">
</form>
<?php
mysql_connect("localhost", "root", "");
mysql_select_db("db_gambar");
$tampil=mysql_query("SELECT foto FROM foto");
if($tampil === FALSE)
{
die(mysql_error());
}
$no=1;
while ($r=mysql_fetch_array($tampil))
{
echo $no.".";
echo '<img src="data:image/jpeg;base64,' . base64_encode( $r['foto'] ) . '" width="120"/>';
echo '<br>';
$no++;
}
?>
</body>
</html>
----------------------------------------------
buat file simpan.php dengan syntax dibawah ini
----------------------------------------------
<?php
mysql_connect("localhost", "root", "");
mysql_select_db("db_gambar");
if(empty($_FILES['foto']))
{
echo 'Pilih file gambar';
}
else
{
$image = addslashes(file_get_contents($_FILES['foto']['tmp_name']));
mysql_query("INSERT INTO foto (foto)VALUES('$image')");
echo "<script>document.location='index.php'</script>";
}
?>
----------------------------------------------
File source code bisa di download disini :
index.php
simpan.php
db_gambar.sql
----------------------------------------------
Semoga bermanfaat.
http://pangeran-it.blogspot.co.id/
----------------------------------------------
Cara menyimpan file foto / gambar ke dalam database di php mysql
Reviewed by Syawaluddin Amin, S.Kom
on
Maret 07, 2017
Rating:
Reviewed by Syawaluddin Amin, S.Kom
on
Maret 07, 2017
Rating:
![Cara mengatasi error microsoft excel style 'comma [0]' not found](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOFi0vZX0Si_GfPTRMx9sV-xbrBAfxPv3hwRBnI_wXXHpVWuLXE-OEbztMvyCJDcn1Lt9iCfluqm2_q_cviCxFKjHMj6DgyTzYgzF5pFB_McNqh-vQuKZAVenkPpYa23kOvNlivVY7LjgU/s72-w618-c-h323/Screenshot_0.png "Cara mengatasi error microsoft excel style 'comma [0]' not found")
Tidak ada komentar: