PHP PDO代码，用于从用户输入动态插入行

我的问题是——

列名 - 总计

文本框名称 - 总循环

我需要的是当用户在总循环文本框中输入 5 时。然后在数据库中插入 5 行。

总列内的值为 1,2,3,4,5 ......还行。

当用户在总循环文本框中输入 3 时再次。然后在数据库中插入 3 行。

总列内的值来自 6,7,8 ......还行。

每个想法都从我的代码中工作正常....

请建议将我的查询和变量放在哪里，以便每次从数据库列内的循环中插入最大值。

   if(isset($_POST['save']))
    {       
                    $book_no = $_POST['book_no'];                   
                    $created = date("Y-m-d H:i:s");                     
                    $query = $database->getRow("SELECT MAX(book_no) AS max1 FROM scheme_master;");
                        $largestNumber = $query['max1'];
                        $top = $largestNumber + 1;  
                    for($row=1;$row<=$book_no;$row++)
                    {   
                        $insertrow = $database->insertRow("INSERT INTO scheme_master (book_no,created) VALUES (:book_no,:created)", 
                        array(':book_no'=>$top,':created'=>$created));
                    }
                    $_SESSION['message'] = "Books Created Successfully";                        
    }   

if(isset($_POST['save']))
    {       
                    $book_no = $_POST['book_no'];                   
                    $created = date("Y-m-d H:i:s");                         
                    for($row=1;$row<=$book_no;$row++)
                    {   
                        $query = $database->getRow("SELECT MAX(book_no) AS max1 FROM scheme_master;");
                        $largestNumber = $query['max1'];
                        $top = $largestNumber + 1;
                        $insertrow = $database->insertRow("INSERT INTO scheme_master (book_no,created) VALUES (:book_no,:created)", 
                        array(':book_no'=>$top,':created'=>$created));
                    }
                    $_SESSION['message'] = "Books Created Successfully";                        
    }