不能上传图片到mysql数据库

can't upload image to mysql database

本文关键字：mysql 数据库 不能      更新时间：2023-09-26

这是我第一次尝试将图像上传到数据库。我有以下一段代码来上传图像到mysql数据库。但没有图片被上传到数据库。没有错误或警告。不知道是什么问题。如有任何帮助，不胜感激。

php: 

if(isset($_FILES['files'])){
    $name=$_FILES['files']['name'];
    if(!empty($name)){

        if(!file_exists($name)){
            $temp=$_FILES['files']['tmp_name'];
            //move_uploaded_file($temp,getcwd().'/uploads/'.$name);
            try{
                 $servername='localhost';
                 $username='root';
                 $password='';
                 $dbname='login';
                 $fp = fopen($temp, 'r');
                 $conn=new PDO('mysql:host=localhost;dbname=login',$username,$password);
                 $stmt = $conn->prepare("INSERT INTO images (image_name, image) VALUES (?, ?)");
                 $stmt->bindParam(1, $_FILES['file']['name']);
                 $stmt->bindParam(2, $fp, PDO::PARAM_LOB);
                 if($stmt->execute()){
                     echo 'its uploaded to database';
                 }
            }catch(PDOException $e){
                    echo $e->getMessage();
            }
        }else{
            echo 'file already exists';
        }
    }
    }else{
        echo 'select a file';
    }

HTML和js:

<html>
    <head>
        <meta charset="utf-8">
        <title>A Simple Page with CKEditor</title>
        <!-- Make sure the path to CKEditor is correct. -->
        <style>
            #mydiv{
                position: relative;
                overflow: hidden;
                width:80px;
                height:30px;
                background:crimson;
                color:white;
                text-align:center;
                padding:auto;
                border-radius:4px ;
                border:1px solid black;
                font-size:22px;
            }
            #files{
                   position: absolute;
                   top: 0;
                   right: 0;
                   margin: 0;
                   padding: 0;
                   font-size: 20px;
                   cursor: pointer;
                   opacity: 0;
                   filter: alpha(opacity=0);
            }
        </style>
    </head>
    <body>
    <form action='file.php' method='POST' enctype='multipart/form-data'>
      <div id='mydiv'>upload
        <input type="file" id="files" name="files" multiple />
      </div>
      <input type='submit' value='submit' name='submit'>
    </form>
<output id="list"></output>
<script>
  function handleFileSelect(evt) {
    var files = evt.target.files; // FileList object
    // Loop through the FileList and render image files as thumbnails.
    for (var i = 0, f; f = files[i]; i++) {
      // Only process image files.
      if (!f.type.match('image.*')) {
        continue;
      }
      var reader = new FileReader();
      // Closure to capture the file information.
      reader.onload = (function(theFile) {
        return function(e) {
          // Render thumbnail.
          console.log(theFile.type);
          var div = document.createElement('div');
          div.setAttribute('style','width:300px;height:300px;border:1px solid black;position:relative;');
          div.innerHTML = ['<img style="width:300px;height:300px;" class="thumb" src="',e.target.result,
                            '" title="',escape(theFile.name), '"/>'].join('');
          document.getElementById('list').insertBefore(div, null);
        };
      })(f);
      // Read in the image file as a data URL.
      reader.readAsDataURL(f);
    }
  }
  document.getElementById('files').addEventListener('change', handleFileSelect, false);
</script>
    </body>
</html>

检查您的PHP代码，很可能是$stmt->execute()执行失败。

从PHP文档(http://php.net/manual/en/pdo.lobs.php)中，您需要以'rb'模式打开您的图像:

$fp = fopen($_FILES['file']['tmp_name'], 'rb');

，以便将其插入数据库

相关文章：