图片mysql服务器_我可以将图片加载到mySQL服务器端吗？

这是BLOB存储的基本示例：

CREATE TABLE IF NOT EXISTS `files` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`filename` varchar(255) DEFAULT NULL,

`ext` varchar(5) DEFAULT NULL,

`filedata` blob,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

$db = mysql_connect('localhost', 'user', 'pass') or die('Could not connect:' . mysql_error());

mysql_select_db('the_database',$db);

if(isset($_FILES['upload'])){

if (is_uploaded_file($_FILES['upload']['tmp_name'])) {

$file_parts = pathinfo($_FILES['upload']['name']);

$file['name'] =$file_parts['filename'];

$file['ext'] =$file_parts['extension'];

$file['data'] =addslashes(file_get_contents($_FILES['upload']['tmp_name']));

mysql_query('INSERT into files (id,filename,ext,filedata) values ("","'.$file['name'].'","'.$file['ext'].'","'.$file['data'].'")',$db) or die(mysql_error());

$notice="File Uploaded successfully";

}

}

?>

BLOB Upload

BLOB Upload

<?php if(isset($notice)){echo '

'.$notice.'

';}?>