将自动递增的值添加到另一个表

Question

I have 2 tables:

1)'table'
    'id' - int autoincremented
    'name' - string

2) 'table2'
     'id' - int
     'info' - string

Lets, say the last row in table has id=20

After I insert 5 empty rows to table, last row has id=25

INSERT INTO `table` (`name`)
VALUES ((""),(""),(""),(""),(""))

1) First thing I need is to add 5 rows with same id-s and empty info-s to table2, right after they were added to table. Something like that:

INSERT INTO `table2` (`id`,`info`)
VALUES ((21,""),(22,""),(23,""),(24,""),(25,""))

Can I do it using one statement?

2) Second thing I need is to extract these values to a PHP variable, like array or string (21,22,23,24,25), so that it could be used for further actions. Is it possible at all?

Answer 1

1- you cant insert in two tables with one statment. you need two statments.

2- and if you using Mysqli or pdo you already have the option to bind parameters to variables.

edit>

    $stmt->store_result();
    $stmt->bind_result($id); ---------> here you will get $id as variable of those ids