对于每个查询结果，将其添加到一个表中，并给出一个ID php

Question

我需要帮助将查询结果插入另一个表中，并为每个结果提供一个id号。

$GroupSize = $_POST['groupsize'];
//Connect to the Server+Select DB
$con = mysqli_connect($host, $user, $password, $dbName) or die("Nope");
if (isset($_POST['create'])) {
//assign group id to groups created
//insert groupinformation to table from userInformation group Id must increment by every group created
//$query ="Select RegistrationId from userInformation order by RAND() LIMIT ".$GroupSize;
$query = "INSERT INTO groupInformation SELECT RegistrationId FROM (SELECT RegistrationId FROM userInformation ORDER BY RAND() LIMIT ".$GroupSize.")";
$result = mysqli_query($con, $query) or die ("query failed " . mysqli_error($con));
while (($row = mysqli_fetch_row($result)) == true) {
echo $row[0].'<br>';
}

我的表userInformation在RegistrationId上有一个主键，在groupInformation中在Registration Id上有个外键。groupInformation中的组Id将自动递增地生成每个结果的Id。

我知道我需要一个while循环或foreach，但我不知道怎么做。

Answer 1

开始选择您想要的

$ stmt = $con->prepare("SELECT //Select what you want to select\)
$ stmt->execute()
$ array = $stmt->fetch()

在你可以像一样插入到一个新表之后

$ stmt = $con->prepare(INSERT INTO groupinformation)
$ stmt->execute

U不能在同一行中进行插入和选择