大家好，插入記錄后我想記錄寄存器的最后一個 ID，我正在使用 PDO lastInsertId () 并寫入 $_SESSION，但我沒有得到我的代碼中缺少的內(nèi)容我有一條錯誤消息<?php session_start();define("SERVER", "localhost");define("BASES", "databases");define("USER", "userbases");define("PASS", "******");class Sql extends PDO { private $conn; public function __construct(){ try { $this->conn = new PDO("mysql:dbname=".BASES.";host=".SERVER, USER, PASS); }catch (Exception $e) { echo "Database Error: ".$e->getMessage(); } catch(Exception $e){ echo "Generic error: ".$e->getMessage(); } } public function query($rawQuery, $params = array()){ $stmt = $this->conn->prepare($rawQuery); $this->setParams($stmt, $params); $stmt->execute(); return $stmt; } public function query($rawQuery, $params = array()){ $stmt = $this->conn->prepare($rawQuery); $this->setParams($stmt, $params); $stmt->execute(); return $this->conn->lastInsertId(); //agreement by @dennisgon }}/* INSERT */$query = "INSERT INTO User(Name,Email) VALUES ('Cledson Stefanato','teste@gmal.com');";$txt = new Sql();$txt->query($query);$_SESSION["RECORD"] = $txt->lastInsertId();echo "Recorded: ".$_SESSION["RECORD"];?>致命錯誤：未捕獲的錯誤：在 /home/xxxx/index.php:24 中的 null 上調(diào)用成員函數(shù) lastInsertId() 堆棧跟蹤：在第 24 行的 /home/xxxx/index.php 中拋出 #0 {main}
1 回答
汪汪一只貓
Email
TA貢獻(xiàn)1898條經(jīng)驗 獲得超8個贊
最后一個 lastInsertId() 是 PDO 類上的一個函數(shù)，問題是在你的類中你返回準(zhǔn)備函數(shù)，認(rèn)為最好的方法是你必須像這樣在函數(shù)查詢中返回 lastInsertId()
//---------------Conseld 正如我所建議的那樣，我通過使用兩個不同的類和函數(shù)來補(bǔ)充。
<?php
/*CONNECTION WITH DATABASES*/
define("SERVER", "localhost");
define("BASES", "databases");
define("USER", "userbases");
define("PASS", "******");
/*DATABASE AND FUNCTION CONNECTION CLASS*/
class QueryPDO extends PDO{
private $conn;
public function __construct(){
$this->conn = new PDO("mysql:dbname=".BASES.";host=".SERVER, USER, PASS);
}
/*INSERT, UPDATE AND DELETE FUNCTION*/
public function query($rawQuery, $params = array()){
$stmt = $this->conn->prepare($rawQuery);
$stmt->execute();
return $this->conn->lastInsertId();
}
}
/*DATABASE AND FUNCTION CONNECTION CLASS*/
class SelectPDO extends PDO{
private $conn;
public function __construct(){
$this->conn = new PDO("mysql:dbname=".BASES.";host=".SERVER, USER, PASS);
}
/*LISTAR DADOS*/
public function query($rawQuery, $params = array()){
$stmt = $this->conn->prepare($rawQuery);
$stmt->execute();
return $stmt;
}
public function select($rawQuery, $params = array()):array{
$stmt = $this->query($rawQuery, $params);
$stmt->execute();
return $stmt->fetchAll(PDO::FETCH_ASSOC);
}
}
/*INSERT - MAY ALSO USE WITH UPDATE AND DELETE*/
$query = "INSERT INTO User(
Nome,
) VALUES (
'Cledson A Stefanato',
'txt@gmail.com'
);";
$txt = new QueryPDO();
/*SESSION RECORD, LAST REGISTRATION*/
$_SESSION["RECORD"] = $txt->query($query);
echo "Recorded: ".$_SESSION["RECORD"];
/*LIST*/
$query = "SELECT * FROM Cadastro";
$txt = new SelectPDO();
$result = $txt->select($query);
//echo json_encode($result);
//echo var_dump($result);
foreach ($result as $dados){
?>
<div style="color: red; font-size: 15px">
<?php
echo $dados["Nome"]. "<br />";
echo $dados["Email"]. "<br />";
?>
</div>
<?php } ?>
- 1 回答
- 0 關(guān)注
- 126 瀏覽
添加回答
舉報
0/150
提交
取消