尝试将图像存储到数据库时发生sql错误(已更新)

icomxhvb 于 2021-07-24 发布在 Java

关注(0)|答案(1)|浏览(446)

UPDATED: 正如在评论部分所建议的，我已经更新了我的代码并使用了pdo。我还是有同样的错误。我正在尝试将多个图像存储到数据库（phpmyadmin）。当我试图上传它给了一个错误 Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'file.png' in 'field list' 我的数据库：
我有一个名为image\u upload的数据库，里面有一个名为car\u details的表，其中有一个id（int11）、car\u name（varchar 255）和imageofcar（longblob）。
这是我的图像细节：

Array
(
    [0] => Array
        (
            [name] => file.png
            [type] => image/png
            [tmp_name] => /opt/lampp/temp/phpJYyrQn
            [error] => 0
            [size] => 77776
        )
    [1] => Array
        (
            [name] => files.png
            [type] => image/png
            [tmp_name] => /opt/lampp/temp/phpXOLvzL
            [error] => 0
            [size] => 84710
        )
)

正如评论部分所建议的，我现在正在使用pdo，这是我的代码：（更新）

<!doctype html>
<html>
    <head>
        <title>Test</title>
    </head>
    <body>
    <form   method="post" enctype="multipart/form-data">
           <input type="file" name="userfile[]" multiple="" /> 
           <input type="submit" name="submit" value="upload" />
    </form>
    <?php
      $servername="localhost";
      $username="root";
      $password = "";
      $dbname="image_upload";
      try {
      $conn = new PDO("mysql:host=$servername;dbname=$dbname",$username, $password);
      $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
      // begin the transaction
      $conn->beginTransaction();
$phpFileUploadErrors = array(
    0 => "There is no error, the file uploaded with success",
    1 => "The uploaded file exceeds the upload_max_filesize directive in php.ini",
    2 => "The upload file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form",
    3 => "The upload file was only partially uploaded",
    4 => "No file was uploaded",
    6 => "Missing a temporary folder",
    7 => "Failed to write file to disk.",
    8 => "A php extension stopped the file upload"
);
    if(isset($_FILES['userfile'])) {
       $file_array = reArrayFiles($_FILES['userfile']);
       pre_r($file_array);
        for($i=0;$i<count($file_array);$i++) {
    $carname = $file_array[$i]["tmp_name"];
    $tablename = "car_detailss";
            $imagename = $file_array[$i]["name"];
            pre_r($carname);
            pre_r($imagename);
            $conn->exec("INSERT INTO `car_detailss`(`car_name`, `imageOfcar`) VALUES ( $carname,$imagename)");
            }
        }
        $conn->commit();
        echo "new records created succesfully";
    } catch(PDOException $e) {
        // roll back the transaction if something failed
        $conn->rollback();
        echo "Error: " . $e->getMessage();
      }
      $conn = null;
 function reArrayFiles($file_post) {
     $file_ary = array();
     $file_count = count($file_post['name']);
     $file_keys = array_keys($file_post);
     for ($i = 0; $i < $file_count; $i++){
     foreach($file_keys as $key) {
         $file_ary[$i][$key] = $file_post[$key][$i];
     }
 }
 return $file_ary;
}
    function pre_r($array) {
        echo '<pre>';
        print_r($array);
        echo '</pre>';
    }
    ?>
    </body>
</html>

如何修复我提到的显示在顶部的错误？

sql php Database upload

来源：https://stackoverflow.com/questions/62987218/sql-error-while-trying-to-store-the-image-to-databaseupdated

1条答案

按热度按时间

jm2pwxwz1#

正如评论部分所建议的。我首先将代码更改为pdo，并没有在没有任何反勾号或“”的情况下插入数据库，而是按照注解部分的建议，在将图像插入数据库时添加了反勾号和“”。 $conn->exec( "INSERT INTO 车辆详细信息 ( 车辆名称 , 汽车影像 ) VALUES ('$carname', '$imagename')"); 现在我可以将图像插入数据库。我也更新了我的代码。
我的代码：

<!doctype html>
<html>
    <head>
        <title>Test</title>
    </head>
    <body>
    <form   method="post" enctype="multipart/form-data">
           <input type="file" name="userfile[]" multiple="" /> 
           <input type="submit" name="submit" value="upload" />
    </form>
    <?php
      $servername="localhost";
      $username="root";
      $password = "";
      $dbname="image_upload";
      try {
      $conn = new PDO("mysql:host=$servername;dbname=$dbname",$username, $password);
      $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
      // begin the transaction
      $conn->beginTransaction();
$phpFileUploadErrors = array(
    0 => "There is no error, the file uploaded with success",
    1 => "The uploaded file exceeds the upload_max_filesize directive in php.ini",
    2 => "The upload file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form",
    3 => "The upload file was only partially uploaded",
    4 => "No file was uploaded",
    6 => "Missing a temporary folder",
    7 => "Failed to write file to disk.",
    8 => "A php extension stopped the file upload"
);
    if(isset($_FILES['userfile'])) {
       $file_array = reArrayFiles($_FILES['userfile']);
       pre_r($file_array);
        for($i=0;$i<count($file_array);$i++) {
    $carname = $file_array[$i]["size"];
    $tablename = "car_detailss";
            $imagename = $file_array[$i]["name"];
            $conn->exec( "INSERT INTO `car_detailss` (`car_name`, `imageOfcar`) VALUES ('$carname', '$imagename')");
            }
        }
        $conn->commit();
        echo "new records created succesfully";
    } catch(PDOException $e) {
        // roll back the transaction if something failed
        $conn->rollback();
        echo "Error: " . $e->getMessage();
      }
      $conn = null;
 function reArrayFiles($file_post) {
     $file_ary = array();
     $file_count = count($file_post['name']);
     $file_keys = array_keys($file_post);
     for ($i = 0; $i < $file_count; $i++){
     foreach($file_keys as $key) {
         $file_ary[$i][$key] = $file_post[$key][$i];
     }
 }
 return $file_ary;
}
    function pre_r($array) {
        echo '<pre>';
        print_r($array);
        echo '</pre>';
    }
    ?>
    </body>
</html>

展开查看全部

赞(0）回复(0）举报 2021-07-24

我来回答

尝试将图像存储到数据库时发生sql错误(已更新)

1条答案

相关问题

热门标签

最新问答