note 102614 added to pdo.lastinsertid
[email protected] Thu, 24 Feb 2011 07:48:54 -0800
| Newsgroups | php.notes |
|---|---|
| Message-ID | <[email protected]> |
I think I get a nice solution in Postgres to get the ID using the RETURNING that comes with Postgress since version 8.2. In the example below, I add to my insert clause the "returning" along with the primary key of my table, then after the execute, I do a fetch getting an array with the value of the last inserted id.
<?
public function insert($employee){
$sqlQuery = "INSERT INTO employee(user_id,name,address,city) VALUES(:user_id,:name,:address,:city) RETURNING employee_id";
$statement = $this->prepare($sqlQuery);
$a ="2002-03-11 12:01AM" ;
$statement->bindParam(":user_id", $employee->getUserId(), PDO::PARAM_INT);
$statement->bindParam(":name", $employee->getName(), PDO::PARAM_STR);
$statement->bindParam(":address", $employee->getAddress(), PDO::PARAM_STR);
$statement->bindParam(":city", $employee->getCity(), PDO::PARAM_STR);
$statement->execute();
$result = $statement->fetch(PDO::FETCH_ASSOC);
return $result["employee_id"];
}
?>
----
Server IP: 69.147.83.197
Probable Submitter: 213.84.116.84
----
Manual Page -- http://www.php.net/manual/en/pdo.lastinsertid.php
Edit -- https://master.php.net/note/edit/102614
Del: integrated -- https://master.php.net/note/delete/102614/integrated
Del: useless -- https://master.php.net/note/delete/102614/useless
Del: bad code -- https://master.php.net/note/delete/102614/bad+code
Del: spam -- https://master.php.net/note/delete/102614/spam
Del: non-english -- https://master.php.net/note/delete/102614/non-english
Del: in docs -- https://master.php.net/note/delete/102614/in+docs
Del: other reasons-- https://master.php.net/note/delete/102614
Reject -- https://master.php.net/note/reject/102614
Search -- https://master.php.net/manage/user-notes.php