Question

This question already has answers here:

Why does this PDO statement silently fail? (2 answers)

Closed 4 years ago.

This problem is driving me crazy, i tried everything. Is does not give me any error, but it does not insert anything to the database either. Database connection is good, and there should be no typos. Please take a look, and see if you can find the problem:

$err = array();

if (isset($_POST[ submit ])) {

    $ip = gethostbyname($_SERVER[ REMOTE_ADDR ]);
    $date = "2012-02-02 02:02:02"; //Example
    $uploader_name = $_POST[ uploader_name ];

    // Validation happens here...


    if (empty($err)) {

        $host = "host";
        $dbname = "db";
        $user = "user";
        $pass = "pass";

        try {
            $dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);  

            $sql = "INSERT INTO `table` (`ip`, `date`, `uploader_name`) 
                    VALUES (:ip, :date, :uploader_name)";
            $stmt = $dbh->prepare($sql);

            # the data we want to insert  
            $params = array(
                 :ip  => $ip,
                 :date  => $date,
                 :uploader_name  => $uploader_name
            );


            $stmt->execute($params);

            $dbh = null;

        } catch(PDOException $pe) {
            die( SQL Error );
        }


        if (empty($err)) {
            $err[] = "Success!";
        }   
    }

}

而且,相信它会得到插入部分内容,因为获得成功的信息。

Answer 1

利用该守则执行你的发言。如果存在非致命错误,它将显示。

$stmt->execute($params) or die(print_r($stmt->errorInfo(), true));

几乎你们的 d客当然没有获准执行你再次要求你再次试图对你进行处决的发言。

Answer 2

是否使用汽车? 如果没有,你可能需要在交易中总结你的询问。

try
{
    $dbh->beginTransaction();
    // your code.
    $dbh->commit();
}
catch(PDOException $pe)
{
    $dbh->rollback();
    die($pe->getMessage());
}

http://php.net/manual/en/pdo.transactions.php

友情链接