插入一个查询后获取数据库行

Question

At the moment I have a script where I add data to the database.

Once the data is entered I would like to get the get the row straight away.

For example if I have a query like this where I have two seperate:

    $sql = "INSERT INTO  table SET columnA '".$this->db->escape($columnA)."'";
    $query = $this->db->query($sql);
    $sql = "SELECT * FROM table";
    $query = $this->db->query($sql);
    return $query->db->row;

I want to be able to make get that database row instantly after inserting it. Will I have to make a whole new query or is there a quicker way? I am using OpenCarts API if that helps.

Thanks Peter

Answer 1

INSERT INTO table (a,b,c) VALUES ('a','b','c');
SELECT * FROM table WHERE your_table_primary_key = LAST_INSERT_ID();

PHP:

$sql  = "INSERT INTO  table SET columnA '".$this->db->escape($columnA)."';";
$sql .= "SELECT * FROM table WHERE your_table_primary_key = LAST_INSERT_ID();"
$query = $this->db->query($sql);
return $query->db->row;