<body><!--
ปรับปรุง : 2549-06-01
ประกอบด้วย uploadpage.htm, uploadprocess.php และ download.php
Source from http://php.dreamwerx.net/forums/viewtopic.php?t=6
-->
<table width=100%>
<td valign=top bgcolor=#dddddd><b>Image Upload in MySQL<br>so MySQL : required</b></td><td>
<form method="post" action="uploadprocess.php" enctype="multipart/form-data">
ส่งภาพ .jpg .gif .png เข้า Server<br>
<input type="file" name="file1" size="20">
<input type="submit" name="submit" value="submit">
</form>
<hr color=red>
<form method="get" action="download.php">
Image ID : <input name="id" size="20" value=1>
<input type="submit" name="submit" value="download.php">
<br>มีข้อมูลแล้ว ระหว่าง 1 ถึง 3
</form>
<hr color=red>
<img src=download.php?id=1>
<br><img src=download.php?id=1>
</td></table>
<pre><font size=4><b>SQL for 2 Table Creating in TEST Database</b><ul>
CREATE TABLE file (
id mediumint(8) unsigned NOT NULL auto_increment,
datatype varchar(60) NOT NULL default 'application/octet-stream',
name varchar(120) NOT NULL default '',
size bigint(20) unsigned NOT NULL default '1024',
filedate datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (id) ) TYPE=MyISAM;
CREATE TABLE filedata (
id mediumint(8) unsigned NOT NULL auto_increment,
masterid mediumint(8) unsigned NOT NULL default '0',
filedata blob NOT NULL,
PRIMARY KEY (id),
KEY master_idx (masterid) ) TYPE=MyISAM ;
</ul></pre>
