Auto-increment value from mysql Insert query

Question

if(!class_exists('MySql'))
{ include('MySql.php'); }
  $sql=new MySql();
  $sql->connect();
  $sqlCommand="insert into `freecomputermarket`.`members`
 (`UserName`,`Password`,`Email`,`BirthDate`,`RegisterationDate`,`ActivationCode`,
 `ActivationLink`,`IsActive`,`Gender`)
 values('$this->_userName','$this->_password','$this->_email','$this->_birthDate',
 '$this->_registerationDate','$this->_activationCode','$this->_activationLink',
 '$this->_isActive','$this->_gender')";
  $sql->query($sqlCommand);

how i can get the Auto-increment ID inserted?

JvdBerg · Accepted Answer · 2012-10-03 10:58:01Z

2

You have hidden the implementation details of your MySql class very well.

In case you are using PDO, you will want to have a look at LastInsertId()
In case you are using mysqli, look at mysql_insert_id();
In case you are using mysql: switch to PDO or mysqli

answered Oct 3, 2012 at 10:58

JvdBerg

21.8k8 gold badges40 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

martinwnet · Accepted Answer · 2012-10-03 10:58:43Z

0

$sql->query($sqlCommand);
$id = lastInsertId();

Documentation here: http://php.net/manual/en/pdo.lastinsertid.php

answered Oct 3, 2012 at 10:58

martinwnet

5812 gold badges4 silver badges10 bronze badges

2 Comments

Alaa Joumaa Over a year ago

is this function raise an error if the command is select for example? or return null?

martinwnet Over a year ago

You would have to try/catch any exceptions, see examples in my previous link (in the comments).

Collectives™ on Stack Overflow

Auto-increment value from mysql Insert query

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related