duanjian9148 2018-11-26 20:47
浏览 38

PDO lastInsertId()不会打印任何值

I've done create method which should add new User object into database and on success it should assign id from the auto_increment field in the database.

Everything works except the fact that PDO lastInsertId() does not output any value.

Here is my code:

public function create() {
    $stmt = $this->connect()->prepare(
                'INSERT INTO users 
                (username, password, first_name, last_name) 
                VALUES (?, ?, ?, ?)');
    $stmt->execute(
            [$this->username, $this->password, $this->first_name, $this->last_name]);

    if ($stmt) {
        echo $this->connect()->lastInsertId(); 
    }
}

Method connects() refers to method in Database class which returns PDO class object.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 目详情-五一模拟赛详情页
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
    • ¥15 关于#Java#的问题,如何解决?
    • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算
    • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
    • ¥15 cmd cl 0x000007b
    • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line