时间戳

首页 > 解决方案 > 如何将图像文件名内爆到mysql数据库中

php - 如何将图像文件名内爆到mysql数据库中

问题描述

我正在将多个图像上传到我的 sql 数据库，但我的 implode 方法不起作用......

if(isset($_POST['submit'])) {
    $id     = $_POST['id'];
    for($i = 0; $i < count($_FILES['file_upload']['name']); $i++){
      $filetmp  = $_FILES['file_upload']['tmp_name'][$i];
      $filename = basename($_FILES['file_upload']['name'][$i]);
      $filetype = $_FILES['file_upload']['type'][$i];
      $filepath = "../images/".$filename;
      move_uploaded_file($filetmp,$filepath);
    }
      $mainfiles = implode(", ", $filename);

      $sql  = "INSERT INTO pictures2 (";
      $sql .= "image, photograph_id";
      $sql .= ") VALUES ('";
      $sql .= $database->escape_character($mainfiles) ."', '";  
      $sql .= $id ."')";
      $result = $database->query($sql);
        if($result){
        $session->message('<div class="success-msg">Pictures uploaded sucessfully.</div>');
        }

}

标签： phpmysql

解决方案

做出这样的改变，我正在考虑$id是你的photograph_id

if (isset($_POST['submit'])) {
    $id = $_POST['id'];
    for ($i = 0; $i < count($_FILES['file_upload']['name']); $i++) {
        $filetmp    = $_FILES['file_upload']['tmp_name'][$i];
        $filename[] = [$id, basename($_FILES['file_upload']['name'][$i])]; // here changes
        $filetype   = $_FILES['file_upload']['type'][$i];
        $filepath   = "../images/" . $filename;
        move_uploaded_file($filetmp, $filepath);
    }
    // I made changes at below code
    $valueStr = array_map(function ($item) {
        return "('" . implode("','", $item) . "'),"; // to convert into `,` separated values
    }, $filename);
    $mainfiles = rtrim(implode("", $valueStr), ','); // removing right training `,`

    $sql = "INSERT INTO pictures2 (";
    $sql .= "image, photograph_id";
    $sql .= ") VALUES ('";
    $sql .= $database->escape_character($mainfiles) . "', '";
    $sql .= $id . "')";
    $result = $database->query($sql);
    if ($result) {
        $session->message('<div class="success-msg">Pictures uploaded sucessfully.</div>');
    }

}

推荐阅读