mysql_insert_id always returns 0

Question

  $userName = $this->getParam('userName', self::TYPE_STRING); 

  $db = Frapi_Database::getInstance();
  $sql = "INSERT INTO user (userName)
            values ('".$userName."')";

  $stmt = $db->prepare($sql);        

  $stmt->execute();

  $this->data['userId'] = mysql_insert_id();

always getting 0 in userId.

i tried to search this, but couldn't find any solution for it.

With prepare and execute calls, I think it should rather return **Fatal Error**. — hjpotter92, Mar 26 '13 at 12:34

score 2 · Answer 1 · answered Mar 26 '13 at 12:35

2

Have you read the documentation?

The ID generated for an AUTO_INCREMENT column by the previous query on success, 0 if the previous query does not generate an AUTO_INCREMENT value, or FALSE if no MySQL connection was established.

Also, these calls are deprecated.

This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used.

Read about choosing a new API here

answered Mar 26 '13 at 12:35

Rawkode

21,990
5
38
45

as MAMP pro has PHP version 5.4.10, i wanted to test on the older version. – keen Mar 26 '13 at 12:53
and the previous insert statement makes entry in database. so connection is established. – keen Mar 26 '13 at 12:55
Can you post your table's schema? – Rawkode Mar 26 '13 at 13:08

score 0 · Accepted Answer · answered Mar 28 '13 at 06:44

0

thanks for your help guyz.
this worked for me.
$this->data['userId'] = $db->lastInsertId();

answered Mar 28 '13 at 06:44

keen

3,001
4
34
59

mysql_insert_id always returns 0

2 Answers2