当我没有在上传输入中附加任何文件时，PHP INSERT 错误

Question

当我未附加任何文件时，在 Postgresql 数据库中插入某些内容时出现错误。我有一个表单，其中包含一些输入，我将其插入到一个表中，还有一个输入用于将多个文件和一些信息上传到其他表。

空上传输入的错误：

致命错误：在第 60 行对 C:\wamp\www\arn\upload.php 中的非对象调用成员函数prepare()

LINE 60: $sth = $dbh->prepare("INSERT INTO arn_info (arn , modelos , familias , Problema , solucao) VALUES ( ? , ? , ? , ? , ? )");

我的表单：

<?php
$sth = $dbh->query("SELECT * FROM arn_info");

    $sth->setFetchMode(PDO::FETCH_ASSOC);

    if($sth){
        $row = $sth->fetch();

        echo '<form method="post" action="upload.php" enctype="multipart/form-data" >';
        echo '<input type="hidden" name="id" />';
        echo 'ARN: <input type="text" name="arn" /><br />';
        echo 'Familias: <input type="text" name="familias" /> <br />';
        echo 'Problema: <textarea class="tinymce" name="problema" cols="30" rows="10">';
        echo '</textarea>';
        echo 'Solução: <textarea class="tinymce" name="solucao" cols="30" rows="10">';
        echo '</textarea>';

        echo '<input type="hidden" name="MAX_FILE_SIZE" value="2000000">';
        echo 'Anexos: <input name="userfile[]" type="file" class="multi" id="userfile">';

        echo '<input name="upload" type="submit" class="box" id="upload" value="ADD ARN">';
        echo '</form>';

     }
?>

我的上传和插入 PHP：

<?php

if(isset($_POST['upload']))
{
    $uploadDir = 'uploads/';

    $fileArn = $_POST['arn'];
    $id = $_POST['id'];
    $arn = $_POST['arn'];
    $modelos = $_POST['modelos'];
    $familias = $_POST['familias'];
    $problema = $_POST['problema'];
    $solucao = $_POST['solucao'];

    foreach ($_FILES["userfile"]["error"] as $key => $error)
    {      
        if ($error == UPLOAD_ERR_OK)
        {           
            $fileName = $_FILES['userfile']['name'][$key];
            $tmpName = $_FILES['userfile']['tmp_name'][$key];
            $fileSize = $_FILES['userfile']['size'][$key];
            $fileType = $_FILES['userfile']['type'][$key];

            $folderName = $_POST['arn'] . "/";

            if (!file_exists ( $uploadDir . $folderName )) {
            $arnFolder = mkdir($uploadDir . $folderName, 0777);
            }

            $filePath = $uploadDir . $folderName  . basename($fileName);

            $result = move_uploaded_file($tmpName, $filePath);

            if (!$result) {
            echo "Error adding Files";
            exit;
            }

            include 'includes/connection.php';

            $fileName = addslashes($fileName);
            $filePath = addslashes($filePath);

            if (!file_exists ($fileName)) {

            $info = array ($fileName , $fileSize , $fileType , $filePath , $fileArn );

            $sth = $dbh->prepare("INSERT INTO upload2 (name, size, type, path , id_arn ) VALUES ( ? , ? , ? , ? , ? )");
            $sth->execute($info);
            }
        }

        } //END OF LOOP

        $parametros = array($arn,$modelos,$familias,$problema,$solucao);

        $sth = $dbh->prepare("INSERT INTO arn_info (arn , modelos , familias , problema , solucao) VALUES ( ? , ? , ? , ? , ? )");

        $sth->execute($parametros); 

        if($sth){
            header("location: admin.php?inserted=1");
        }
}
?>

如果我附加一个或多个文件一切正常！

谢谢

Answer 1

不好的是，以上是很好的一般建议，但不是您问题的原因。该问题是由于您将连接包含在循环内而引起的，如果没有文件上传，则该连接将永远不会执行。这是修复方法：

<?php

include 'includes/connection.php';

if(isset($_POST['upload']))
{
    $uploadDir = 'uploads/';

    $fileArn = $_POST['arn'];
    $id = $_POST['id'];
    $arn = $_POST['arn'];
    $modelos = $_POST['modelos'];
    $familias = $_POST['familias'];
    $problema = $_POST['problema'];
    $solucao = $_POST['solucao'];

    foreach ($_FILES["userfile"]["error"] as $key => $error)
    {      
        if ($error == UPLOAD_ERR_OK)
        {           
            $fileName = $_FILES['userfile']['name'][$key];
            $tmpName = $_FILES['userfile']['tmp_name'][$key];
            $fileSize = $_FILES['userfile']['size'][$key];
            $fileType = $_FILES['userfile']['type'][$key];

            $folderName = $_POST['arn'] . "/";

            if (!file_exists ( $uploadDir . $folderName )) {
            $arnFolder = mkdir($uploadDir . $folderName, 0777);
            }

            $filePath = $uploadDir . $folderName  . basename($fileName);

            $result = move_uploaded_file($tmpName, $filePath);

            if (!$result) {
            echo "Error adding Files";
            exit;
            }

            $fileName = addslashes($fileName);
            $filePath = addslashes($filePath);

            if (!file_exists ($fileName)) {

            $info = array ($fileName , $fileSize , $fileType , $filePath , $fileArn );

            $sth = $dbh->prepare("INSERT INTO upload2 (name, size, type, path , id_arn ) VALUES ( ? , ? , ? , ? , ? )");
            $sth->execute($info);
            }
        }

        } //END OF LOOP

        $parametros = array($arn,$modelos,$familias,$problema,$solucao);

        $sth = $dbh->prepare("INSERT INTO arn_info (arn , modelos , familias , problema , solucao) VALUES ( ? , ? , ? , ? , ? )");

        $sth->execute($parametros); 

        if($sth){
            header("location: admin.php?inserted=1");
        }
}
?>

Answer 2

致命错误：在 C:\wamp\www\arn 中的非对象上调用成员函数prepare()
\upload.php 第 60 行

看来你的 $sth 不是一个对象。如果您想查看更具描述性的消息，则必须告诉 PDO 您确实想查看错误。尝试以下操作（可能在“connection.php”中）：

<?php
$dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );

这将确保 PDO 输出一条消息。

Answer 3

在您的文件中找不到 $dbh 的定义。因此该变量不存在，您无法对其调用 prepare() 方法。