how can i add primary key value which is auto incremented to another column in php?

Question

I have a tree and I want to I have a table which has an id also, I want to use this id by adding to another column.

clearly, I want to add id column'value to parent_root column.

   sql = "INSERT INTO agac_menu (id,isim,aciklama,parent_id,parent_root,yetki,sira,tip,created)
        VALUES (NULL,'".$isim."','".$aciklama."','".$parent_id."','".$parent_root."','".$yetki."','".$sira."','".$tip."','".date('Y-m-d H:i:s')."')";

score 1 · Accepted Answer · edited May 23 '17 at 10:25

1

If it was MySQL (yes, I know it was more generic) you could use a trigger: MySQL Triggers last_insert_id()

edited May 23 '17 at 10:25

Community

1
1

answered Nov 01 '12 at 14:21

ethrbunny

10,379
9
69
131

score 0 · Answer 2 · answered Nov 01 '12 at 14:16

0

You can't do this in the same query--the auto incremented id doesn't exist until the record is inserted. After your query runs in php, grab the last insert id and run an update query.

answered Nov 01 '12 at 14:16

Ray

40,256
21
101
138

how can i add primary key value which is auto incremented to another column in php?

2 Answers2