how can i get the insert_id using prepare statement in php?

Question

I tried but I can't get insert_id from the function. I have made a class call functions but I don't understand how can I get it. See below code.

class DatabaseConnection {
protected $pdo;
public function __construct() {
 try {
   $this->pdo = new PDO('mysql:host=localhost;dbname=xxx', 'root', '');
 } catch(PDOException $e) {
  exit('Database error');
  }
 }
}

class Invoice extends DatabaseConnection {
  public function order($rename, $location) {
  $query = $this->pdo->prepare("INSERT INTO orderlist (re_name, location) VALUES (?, ?)");
  $query -> execute(array($rename, $location));
}

$user = new Invoice();
if($_SERVER['REQUEST_METHOD'] == 'POST') {
   $rename = $_POST['re_name'];
   $location = $_POST['location'];
   $insertOrder  = $user->order($rename, $location); // call the function here
   $insertid = ____ // I want to get id using insert_id in here see blank space.
}

Data is inserted successfully but how can I get id which I insert data recently. help me.

call insert_id after execute $pstm->execute(); $pstm->insert_id; — Devsi Odedra, Dec 05 '17 at 11:46

score 2 · Accepted Answer · edited Dec 05 '17 at 11:57

2

Wouldn't it work if you tried :

$user->getPdo->lastInsertId();

Details

edited Dec 05 '17 at 11:57

urfusion

5,528
5
50
87

answered Dec 05 '17 at 11:53

Zyigh

425
4
16

It works. Thank you so much. – Ankit Parmar Dec 05 '17 at 11:56

how can i get the insert_id using prepare statement in php?

1 Answers1