在这段代码中，在向db.i插入值之后，我正在执行select查询来选择invoiceno（$sql1=“select invoiceno from invoices order by invoiceid desc limit 1”；）。而不是从数据库中选择如何获取invoiceno？
例如：假设有两个用户。两个用户同时插入invoiceid。在执行“select invoiceno from invoices order by invoiceid desc limit 1”时；这将获取最后一个发票ID。我需要获取特定的发票ID（针对特定用户）。如何获取它？

$query          = "select * from invoices order by invoiceID desc limit 1";
$result         = $link->query($query);
$row            = $result->fetch_assoc();
$invoiceNo      = $row["invoiceNo"];
$getinvoiceNo   = str_pad($invoiceNo + 1, 4, 0, STR_PAD_LEFT); //inserting like 0000
$sql            = "INSERT INTO invoices (invoiceNo)
                   VALUES ('$getinvoiceNo')";
if ($link->query($sql) === TRUE) {
   //echo "1";
   $sql1    = "select invoiceNo from invoices order by invoiceID desc limit 1";
   $last_id = mysqli_insert_id($link, $sql1);
   $result1 = mysqli_query($link, $sql1);
   $row1    = mysqli_fetch_array($result1);
   echo json_encode($row1);
} else {
    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
mysql_close($link);