Storing Images in a Database

[Anon]

Anyone have links or source code on storing images via php into a mysql database? Or does anyone know of a web tool to upload images into a db. Also how would I retrieve the image from the database?

Any help is highly helpful.

Thank You,

Ephren Taylor

[Anon]

make a form like this, watch at "form enctype" area.

<h2>Form Lelang Otomotif dan lain-lain</h2>
<form enctype="multipart/form-data" action="responlelang.php3" method="post">
<pre>
Jenis : <input type=radio name=otto value="mobil" checked>Mobil <input type=radio name=otto value="motor" checked>Motor <input type=radio name=otto value="Lain-lain" checked>Lain-lain
Merk : <input type=text name=mobil>
Ket. Masukkan merk mobil, motor, aksesoris lainnya ( misalnya :
merk helm, sapu tangan, tape mobil)
Tipe : <input type=text name=tipe>
Ket. Masukkan tipe barang mis : sedan,minibus,racing dll.
Tahun : <input type=text size=4 name=tahun>
Warna : <input type=text size=15 name=warna>
Kondisi : <input name = "kondisi" type=radio value=Baru checked> Baru <input name="kondisi" type=radio value=Bekas checked> Bekas
Alamat Hubung : <input type=text size=40 name=alamat>
<input type=text size=40 name=alamatjuga>
Harga Barang : <input type=text name=harga> Rupiah
Masukkan angka saja, ex: 10000 untuk sepuluh ribu, bukan 10.000
Deskripsi :
<textarea cols=40 rows=5 name="deskripsi"></textarea>
Lama Penawaran : <select name=lama>
<option>1
<option>2
<option>3
<option>7
<option>14
</select> hari
Browse : <input type=file name="filefoto">
</pre>
<hr>
<input type=submit value=" Kirim "> <input type=reset value=Perbaiki>

</form>

just browse the file either .gif, .jpeg or anything.
and the response file should be like this (i use windows version of mysql, or you can contact me personally by email if anything i can fix your problem -- Linux ?)

You submitted this file : <br>
<br>Name file : <? echo($filefoto_name); ?>
<br>Type file : <? echo($filefoto_type); ?>
<br>Size file : <? echo($filefoto_size); ?>
<?
//copy the file to c:\upload.txt remember to escape backslash !
if (copy("C:\WINDOWS\TEMP\php2",$filefoto_name)){
print "File successfully copied !";
} else {
print "<b>Error: failed to copy file.... </b>";
}
//destroy the file now we've copied it
unlink("C:\WINDOWS\TEMP\php2");
?>

<pre>
<? echo "Jenis : $otto"; ?> <br>
<? echo "Merk mobil : $mobil"; ?><br>
<? echo "Tipe mobil : $tipe"; ?><br>
<? echo "Tahun : $tahun"; ?><br>
<? echo "Warna : $warna"; ?><br>
<? echo "Kondisi : $kondisi"; ?><br>
<? echo "Alamat : $alamat-$alamatjuga"; ?><br>
<? echo "Harga : $harga"; ?><br>
<? echo "Deskripsi : $deskripsi"; ?><br>
<? echo "Lama Penawaran : $lama";?>
</pre>

<?
$query = "INSERT INTO lelangbabe ";
$query .= "(jenis,merk, tipe, tahun, warna, ";
$query .= "kondisi, alamat, harga, deskripsi, waktu, foto, pass_id) ";
$query .="values('$otto','$mobil','$tipe','$tahun','$warna','$kondisi','$alamat-$alamatjuga', '$harga','$deskripsi','$lama','$filefoto_name','$pass_id')";
mysql_connect("localhost","root","") or die("Unable to connect to SQL server");
mysql_select_db("mobilbabe") or die("Unable to select database");
mysql_query($query) or die("Insert Failed!");

//masukkan data tersebut ke garasiku
$query = "INSERT INTO garasiku (user_id,data_trans,keterangan,kettgl) values('$pass_id2','Ikutan lelang','Anda telah ikutan lelang Jenis : $otto - Merk : $mobil - Tipe : $tipe - Tahun :$tahun - Warna : $warna - Harga :Rp.$harga', now())";
mysql_connect("localhost","root","") or die("Unable to connect");
mysql_select_db("mobilbabe") or die("Unable to select database");
mysql_query($query) or die("Insert Failed!");
?>

Please let me know if this stuff can help.

[e-mail]