• PHP将二进制文件存入数据库以及从数据库中读取二进制文件


    <?php
    $file = 'abcd.sqlite';
    
    mysql_connect('localhost','root','123456');
    mysql_select_db('zblog');
    mysql_query('set names utf8');
    
    /*
    $backup_stream = file_get_contents($file);
    // var_dump($backup_stream);exit;
    // $PSize = filesize($file); 
    // $backup_stream = addslashes(fread(fopen($file, "r"), $PSize)); 
    // var_dump($backup_stream);exit;
    
    $sql = 'insert into t_user(backup) values("'. addslashes($backup_stream) .'")';
    mysql_query($sql) ;
    echo mysql_error();
    
    
    exit;
    */
    
    
    $sql = 'select id,backup from t_user limit 1';
    $result = mysql_query($sql);
    $row = mysql_fetch_assoc($result);
    
    header('Content-Description: File Transfer');
    header('Content-Type: application/octet-stream');
    header('Content-Disposition: attachment; filename=db_backup.sqlite');
    header('Content-Transfer-Encoding: binary');
    header('Expires: 0');
    header('Cache-Control: must-revalidate');
    header('Pragma: public');
    header('Content-Length: ' . strlen($row['backup']));
    // ob_clean();
    // flush();
    // readfile($file);
    echo $row['backup'];
    exit;
    
    
    
    /*
    if (file_exists($file)) {
        header('Content-Description: File Transfer');
        header('Content-Type: application/octet-stream');
        header('Content-Disposition: attachment; filename='.basename($file));
        header('Content-Transfer-Encoding: binary');
        header('Expires: 0');
        header('Cache-Control: must-revalidate');
        header('Pragma: public');
        header('Content-Length: ' . filesize($file));
        ob_clean();
        flush();
        readfile($file);
        exit;
    }
    */
    

      

  • 相关阅读:
    WinForm简单的打包和部署
    C#实现获取枚举的描述
    C#实现序列化对象到XML文档与反序列化
    cookie与session的区别与联系
    windows环境下创建多个Redis实例
    struts2中的constant配置详解
    PowerDesigner使用教程
    配置JAVA环境变量
    CAS实现SSO单点登录原理
    OVER(PARTITION BY)函数用法
  • 原文地址:https://www.cnblogs.com/adtuu/p/4723451.html
Copyright © 2020-2023  润新知