php PDO last insert id

[Sky_Sailor]

hey developers,

 

i have problem to get last insert id. btw.. i try to put that code on my mvc creation.

 

on register_model page i write like this:

 public function numbering(){
        $sth = $this->db->prepare('SELECT * FROM member_data');
        $result = $this->db->lastInsertId();
        return $result;
    }
 

and for the controllers page, i write the code like this:

 

$c = $this->model->numbering();
        

foreach ($c as $key => $value) {
$data = $result('id');             
}          
        
$abc['member_id'] = $data;

 

 

but i didn't get the results,.. can you help me?

[Jacques1]

Hi,

 

no offense, but this makes absolutely no sense whatsoever.

• You're asking for the ID of the last inserted row, but there's no INSERT query in your code.
• You prepare a SELECT query, but you never execute it.
• If the method worked, it would return a single number, but then you try to loop over this number as if it was some kind of collection.
• If the loop worked, it would just overwrite the same variable over and over again.
• What is $result('id') supposed to be?

Pretty much every line is a mystery. Are you sure you've thought this through?

 

Maybe what you actually want is the biggest member ID? That's one line of code:

$last_member_id = $this->db->query('SELECT MAX(id) FROM member_data')->fetchColumn();

Edited May 19, 2014 by Jacques1

[IanA]

If you're new to PDO, the best place to start is the PHP manual...

http://www.php.net/manual/en/book.pdo.php

[Sky_Sailor]

 

Hi,

 

no offense, but this makes absolutely no sense whatsoever.

• You're asking for the ID of the last inserted row, but there's no INSERT query in your code.
• You prepare a SELECT query, but you never execute it.
• If the method worked, it would return a single number, but then you try to loop over this number as if it was some kind of collection.
• If the loop worked, it would just overwrite the same variable over and over again.
• What is $result('id') supposed to be?

Pretty much every line is a mystery. Are you sure you've thought this through?

 

Maybe what you actually want is the biggest member ID? That's one line of code:

$last_member_id = $this->db->query('SELECT MAX(id) FROM member_data')->fetchColumn();

ok, i wil try your code. thx very much.

[Sky_Sailor]

If you're new to PDO, the best place to start is the PHP manual...

 

http://www.php.net/manual/en/book.pdo.php

yes, i have read all of that, but i still can't understand. i need people to teach me. is that why i'm joining here.. i hope you can help me to learn php here.. thx a lot

[Sky_Sailor]

hey anybody.. anyone can help me?

[Jacques1]

Help you with what? What's your question?

 

Or did you expect us to write you a personal PDO tutorial? I don't think that's how this forum works. If you have a concrete question, just ask. But you won't get private PHP lessons for free or something.

[Sky_Sailor]

on model page :

public function create($abc){
        $insert = $this->db->prepare('INSERT INTO member_data (`member_id`,`username`,`name`,
        `password`,`address`,`phone`,`nik_numb`,`gender`,`role`)
        VALUES(:member_id, :username, :name, :password, :address, :phone, :nik_numb, :gender, :role)
        ');
        
        $insert->execute(array(

        $id = $this->db->lastInsertId();
        ':member_id' => $abc['member_id'],
        ':username' => $abc['username'],
        ':name' => $abc['name'],        
        ':password' => $abc['password'],
        ':address' => $abc['address'],
        ':phone' => $abc['phone'],
        ':nik_numb' => $abc['nik_numb'],
        ':gender' => $abc['gender'],
        ':role' => $abc['role']
        ));
      ........

and controllers page :

 $abc['member_id'] = 0 . date('ymdN') . '00' . $id;

but i still don't get last insert id... please correct what is wrong..
      

[Jacques1]

Please use code tags (the “< >” in the toolbar above the textarea).

 

What is the $id = $this->db->lastInsertId(); line doing in the middle of the array expression? Is this actually how your code looks like?

[IanA]

Shouldn't you be calling lastInsertId() following the execution of a query? And as Jacques1 said, it doesn't seem clear as to why you've placed that line of code within the array expression? 

[Sky_Sailor]

Shouldn't you be calling lastInsertId() following the execution of a query? And as Jacques1 said, it doesn't seem clear as to why you've placed that line of code within the array expression? 

 

i really didn't know what to do. i'm very confuse right now..

 

[IanA]

What I am referring to is the execution of this line of code $id = $this->db->lastInsertId();

 

It should be ran following the execution of:

 

$insert->execute(array(

        $id = $this->db->lastInsertId();  //REMOVE THIS LINE
        ':member_id' => $abc['member_id'],
        ':username' => $abc['username'],
        ':name' => $abc['name'],        
        ':password' => $abc['password'],
        ':address' => $abc['address'],
        ':phone' => $abc['phone'],
        ':nik_numb' => $abc['nik_numb'],
        ':gender' => $abc['gender'],
        ':role' => $abc['role']
        ));

 

//AND PLACE IT HERE

[Sky_Sailor]

What I am referring to is the execution of this line of code $id = $this->db->lastInsertId();

 

It should be ran following the execution of:

 

$insert->execute(array(

        $id = $this->db->lastInsertId();  //REMOVE THIS LINE

        ':member_id' => $abc['member_id'],

        ':username' => $abc['username'],

        ':name' => $abc['name'],        

        ':password' => $abc['password'],

        ':address' => $abc['address'],

        ':phone' => $abc['phone'],

        ':nik_numb' => $abc['nik_numb'],

        ':gender' => $abc['gender'],

        ':role' => $abc['role']

        ));

 

//AND PLACE IT HERE

 

i have try that, but still didn't work.. ;'(

[Jacques1]

So what are we supposed to do now? We can't see your screen from here.

 

If you want us to help you, then you need to post the code and describe the problem. No, “doesn't work” is not a valid problem description. In fact, we knew that already, because otherwise you probably wouldn't be here.

 

So what's the problem? Does the INSERT query succeed at all? What's the return value of lastInsertId()?

 

And why do you even want the last insertion ID? Don't you set it manually with $abc['member_id']?

[Sky_Sailor]

honestly, i really want to explain here.. but my english not really good. how if i post all files project here??