sebelumnya saya juga sudah buat unduh image ke dalam myswl, dan ada yang commend kalau file juga bisa masuk, pas d coba eh ternya ta bener bisa.
pertama buat tabelnya dulu,
CREATE TABLE `transaksi`
(`id_file` int(4) NOT NULL auto_increment,
`id_dosen` varchar(30) NOT NULL,
`nm_file` varchar(30) NOT NULL,
`ext` varchar(5) NOT NULL,
`type_file` varchar(30) default NULL,
`size_file` int(11) default NULL,
`isi_file` longblob,
`des_file` varchar(50) NOT NULL,
`tgl_krm` date default NULL,
`jam_krm` time default NULL,
PRIMARY KEY (`id_file`,`id_dosen`));
terus kita buat form.php
<html>
<title>Masukkan File</title>
<head></head>
<body>
<form name="iip" method="post" action="masuk.php?X=E" enctype='multipart/form-data'>
<table width="444" border="0" cellpadding="0" cellspacing="0" height="313" align="center">
<tr>
<td colspan='3' align="center"<font style="font-family: Arial,Verdana,Sans; font-size: 15pt; color: #000000"><b>ADD File</b></font></td>
</tr>
<tr>
<td>Judul File
<td>:</td>
</td>
<td>
<input name="judul"></td>
</tr>
<tr>
<td>File</td>
<td>:</td>
<td><input type="file" name="file" id="file" /></td>
</tr>
<tr>
<td>Deskripsi</td>
<td>:</td>
<td><textarea name="deskripsi" cols="25" rows="4"></textarea></td>
</tr>
<tr>
<td>Dosen</td>
<td>:</td>
<td><input name="dosen" size="33"></td>
</tr>
<tr>
<td><input type="submit" value="Save" name="simpan" style="font-family: Tahoma; font-size: 10pt; color: #000000"></td>
<td><input type="Reset" value="Reset" name="batal" style="font-family: Tahoma; font-size: 10pt; color: #000000"></td>
</tr>
</table>
<form>
</body>
</html>
dan terakhir baru deh masukin ke mysql ini masuk.php
<?php
$db_host = 'localhost'; // don't forget to change
$db_user = 'root';
$db_pwd = '';
$database = 'uts';
$table = 'transaksi';
if (!mysql_connect($db_host, $db_user, $db_pwd))
die("Can't connect to database");
if (!mysql_select_db($database))
die("Can't select database");
$strX=$_GET['X'];
$strJudul = '';
$strDeskripsi = '';
$strDosen = '';
if($strX==E)
{
if ($_FILES["file"]["error"] > 0)
{
echo "Error: " . $_FILES["file"]["error"] . "
";
}
else
{
$strJudul = $_POST['judul'];
$strType = $_FILES["file"]["type"];
$strSize = ($_FILES["file"]["size"] / 1024);
$strFile = $_FILES["file"]["tmp_name"];
$nsf = $_FILES["file"]["name"];
$strNama = strtolower(end(explode('.', $nsf)));
$strDeskripsi = $_POST['deskripsi'];
$strDosen = $_POST['dosen'];
$strTgl = date('Y-m-d');
$strJam = date('H:i:s');
$fp = fopen($strFile, 'r');
$content = fread($fp, filesize($strFile));
$content = addslashes($content);
fclose($fp);
mysql_query("INSERT INTO transaksi (id_dosen, nm_file, ext, type_file, size_file, isi_file, des_file, tgl_krm, jam_krm) value('".$strDosen."','".$strJudul."','".$strNama."','".$strType."','".$strSize."','".$content."','".$strDeskripsi."','".$strTgl."','".$strJam."')");
echo "alhamdulillah";
}
}
?>
<body onload="alert('Sukses dan Terima Kasih');window.location.assign('form.php');"></body>
ya, bisa juga buat file koneksi tersendiri, tapi biar cepet saya masukin d sini aja (kan cuma contoh) π