上传任意文件类型到mysql的PHP代码，同时也可以下载。使用了SAE的服务。

<?php
// filename :getdown.php

function getdownfile($id) {
    $mysql = new SaeMysql();
    $sql = "SELECT *
FROM `adg_files` where filename='$id'
";
    $dataa = $mysql->getData($sql);
    $fn = $dataa[0]["filename"];

    if ($mysql->errno() != 0) {
        die("Error:" . $mysql->errmsg());
    }

    $mysql->closeDb();
    header("Content-Disposition:attachment;filename=" . $fn);
    echo $dataa[0]["data"];
}

$upload_file = $_FILES['upload_file']['tmp_name'];
$upload_file_name = $_FILES['upload_file']['name'];
if ($upload_file) {
    header("Content-Type: text/html; charset=utf-8");
    $file_size_max = 1000000; // 1M限制文件上传最大容量(bytes)

    $store_dir = "E:/"; // 上传文件的储存位置

    $accept_overwrite = 1; //是否允许覆盖相同文件

// 检查文件大小

    if ($upload_file_size > $file_size_max) {
        echo "对不起，你的文件容量大于规定";
        exit;
    }

    echo '前页';
    $mysql = new SaeMysql();

    $sql = "
CREATE TABLE IF NOT EXISTS `adg_files` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `filename` char(128) NOT NULL,
  `data` longblob NOT NULL,
  `time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `filename` (`filename`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ";

    $mysql->runSql($sql);
    if ($mysql->errno() != 0) {
        die("Error:" . $mysql->errmsg());
    }


    $sql = "DELETE FROM `adg_files` WHERE `filename` ='$upload_file_name'";
    $mysql->runSql($sql);

    if ($mysql->errno() != 0) {
        die("Error:" . $mysql->errmsg());
    }

    $date = addslashes(file_get_contents($upload_file));
    //echo $date;

    $sql = "INSERT INTO `adg_files` ( `filename` , `data` , `time` ) VALUES ( '" . $upload_file_name . "' , '" . $date . "' , NOW() ) ";


    $mysql->runSql($sql);
    if ($mysql->errno() != 0) {
        die("Error:" . $mysql->errmsg());
    }
    echo 'over';
    $mysql->closeDb();

    Echo "你上传了文件:";
    echo $_FILES['upload_file']['name'];
    echo "";
//客户端机器文件的原名称。

    Echo "文件的 MIME 类型为:";
    echo $_FILES['upload_file']['type'];
//文件的 MIME 类型，需要浏览器提供该信息的支持，例如“image/gif”。

    echo "";
    Echo "上传文件大小:";
    echo $_FILES['upload_file']['size'];
//已上传文件的大小，单位为字节。

    echo "";
    Echo "文件上传后被临时储存为:";
    echo $_FILES['upload_file']['tmp_name'];
//文件被上传后在服务端储存的临时文件名。

    echo "";
    $Erroe = $_FILES['upload_file']['error'];
    switch ($Erroe) {
        case 0:
            Echo "上传成功";
            break;
        case 1:
            Echo "上传的文件超过了 php.ini 中 upload_max_filesize 选项限制的值.";
            break;
        case 2:
            Echo "上传文件的大小超过了 HTML 表单中 MAX_FILE_SIZE 选项指定的值。";
            break;
        case 3:
            Echo "文件只有部分被上传";
            break;
        case 4:
            Echo "没有文件被上传";
            break;
    }
    echo "下载$upload_file_name";
}

if ($_GET['name']) {
    getdownfile($_GET['name']);
} else {
    if (!header)
        header("Content-Type: text/html; charset=utf-8");
    echo '

php上传文件实例


请选择文件：




';
}

function sae_write($file, $content) {
    file_put_contents(SAE_TMP_PATH . "/" . $file, $content);
}

function sae_read($file) {
    return file_get_contents(SAE_TMP_PATH . "/" . $file);
}

function temp() {
    sae_write("1.txt", "周春");
    $rs = sae_read("1.txt");
    print_r($rs);

    $s = new SaeStorage();
    $s->write('wjcroom', 'thebookhe', 'bookcontent!');

    echo $s->read('wjcroom', 'thebook');


// will echo 'bookcontent!';


    echo $s->getUrl('wjcroom', 'thebook');
// will echo '';

    $f = new SaeFetchurl();
    echo $content = $f->fetch('');
}

?>