Affected Row ID

[chrislentz]

I was just wondering how I might be able to adjust this class so when I INSERT something, the class returns something like the affected_row_id. In other words is it possible to add mysql_insert_id() functionality into the class?

It would be incredibly handy to know the generated row ID when inserting new data.

[ThingEngineer]

Sorry I let this go for so long, been busy on other projects. Plus I use CodeIgniter so I rarely use standalone db libraries like this except for in small projects. In answer to your question yes. This is actually what I'm doing now with the following code located on line 170 of the insert method.

($stmt->affected_rows) ? $result = $stmt->insert_id : $result = false;
return $result;

So IF there are affected rows then return the inserted id, IF not then return false. The included index file shows an example of inserting a record then prints out the inserted ID.