LastInserID from other table insert to table

Asked Aug 18 '16 at 08:44

Active Aug 18 '16 at 08:59

Viewed 34 times

how i can select lastinserid from table player and insert into to test_table?

 $stmt = $pdo->prepare("INSERT INTO baza.test_table (`player`) VALUES (?)");

   $a = mt_rand(1, 100);
   $stmt->bindParam(1, $a, PDO::PARAM_INT);
   $stmt->execute();
   print $pdo->lastInsertId().'<br/>';
   $pdo = null;

when i create account id is (autoincromentet) i want insert this id to another table

edited Aug 18 '16 at 08:59

asked Aug 18 '16 at 08:44

Raven

What is your problem? Why you're printing lastInsertId() instead of assigning it to a variable and using in another query? – Your Common Sense Aug 18 '16 at 08:47
@YourCommonSense do you mean $stmt = $pdo->prepare("SELECT FROM baza.player (`id`)"); – Raven Aug 18 '16 at 08:53
I mean you are ALREADY using the proper function - $pdo->lastInsertId(). Why don't you assign its result to a variable, `$id=$pdo->lastInsertId();` and than use this variable in another query? – Your Common Sense Aug 18 '16 at 09:23
@YourCommonSense i arleady try it but dont work i get id from insert i want id from other table – Raven Aug 18 '16 at 10:34
Sorry, I don't understand – Your Common Sense Aug 18 '16 at 10:45
@YourCommonSense create account = autoincromented id table=account i want insert this id to table=test – Raven Aug 18 '16 at 11:51

LastInserID from other table insert to table

0 Answers0