Question

我有这一法典:

    $this->db->beginTransaction();
    $query =  INSERT INTO `table1` VALUES (NULL,:a,:b,NULL,NOW()) ;
    $sth = $this->db->prepare($query);
    foreach ($values as $k => $v) {
      $sth->bindParam( :  . $k, $v, PDO::PARAM_INT);
    }

    $this->executeQueryRollbackOnException($sth,  Message_1 );
    $resetId = $this->db->lastInsertId();

    $query =  UPDATE `table2` SET c=:c,d=:d WHERE reset_id IS NULL ;
    $sth = $this->db->prepare($query);
    foreach ($values2 as $k => $v) {
      $sth->bindParam( :  . $k, $v, PDO::PARAM_INT);
    }


    $this->executeQueryRollbackOnException($sth,  Message_2 );

    Zend_Debug::dump($sth->rowCount(),  Affected ); // This is 0

    // Commit
    $this->db->commit();

......

  private function executeQueryRollbackOnException($sth, $message) {
    try {
      $sth->execute();
    } catch (Exception $e) {
      $this->logSQLError($e);
      $this->db->rollBack();
      throw new Exception($message);
    }
  }

第一个问题已经执行,但第二个没有执行。没有产生我的错误。任何想法?

Answer 1

我找到了解决办法。

foreach ($values as $k => $v) {
   $sth->bindParam( :  . $k, $v, PDO::PARAM_INT);
}

应

foreach ($values as $k => $v) {
   $sth->bindParam( :  . $k, $values[$k], PDO::PARAM_INT);
}

索赖斯·伊登首次张贴了正确的法典,但我排除了简化法典的征兆。

Answer 2

The fact that $sth->rowCount() is 0 does not mean the query was not run. If you have no error reported in your PHP error log, then the query ran just fine. If the row count is 0, that means that no rows were updated. This is very likely due to your condition not matching any rows.

回答如下:如果你收到0份,那么你知道问题是<条码>。 UPDATE conditions:

SELECT COUNT(*) FROM `table2` WHERE reset_id IS NULL

友情链接