php-код для создания нескольких строк с настраиваемым кодом

Каждый раз, когда вы используете цикл, он возвращается к введенному значению (например, coupon_no)

Вы должны использовать значения для bookno , couponno и receiptno как отправные точки и значения для totalbook , totalcoup и totalrec как критерии цикла. Увеличивайте число, когда вы идете:

 <?php $bookno= $_POST['bookcode']; $totalbook= $_POST['book_no2']; $receiptno = $_POST['receiptcode']; $totalrec= $_POST['receipt_no']; $couponno= $_POST['couponcode']; $totalcoup= $_POST['coupon']; for ($book_counter=1; $book_counter<=$totalbook; $book_counter++) { for($rec_counter=1; $rec_counter<=$totalrec; $rec_counter++) { for($coup_counter=1; $coup_counter<=$totalcoup; $coup_counter++) { $insertrow = $database->insertRow( "INSERT INTO scheme_master (book_no2,receipt_no,coupon) VALUES (:book_no2,:receipt_no,:coupon)", array(':receipt_no'=>$receiptno,':book_no2'=>$bookno,':coupon'=>$couponno)); $couponno++; } $receiptno++; } $bookno++; } ?> 

NB Это не было протестировано, но оно должно установить вас на правильном пути

Отредактированный код (с комментариями относительно неиспользуемых переменных)

 <?php if (isset($_POST['save'])) { /* * No checking for validity of values */ $bookcode = $_POST['bookcode']; $book_no2 = $_POST['book_no2']; $receiptcode = $_POST['receiptcode']; $receipt_no = $_POST['receipt_no']; $couponcode = $_POST['couponcode']; $coupon = $_POST['coupon']; $Temp_receipt = $receiptcode + $receipt_no; $Temp_coupon = $couponcode + $coupon; for ($row1 = $bookcode + 1; $row1 <= $bookcode + $book_no2; $row1++) // what happens if $bookcode or $book_no2 are negative? Why start at +1 instead of what user entered? { for ($row = $receiptcode + 1; $row <= $Temp_receipt; $row++) // what happens if $receiptcode or $receipt_no are negative? Why start at +1 instead of what user entered? { /* * Each run of this query will slow down this whole code */ $query1 = $database -> getRow("SELECT if (receipt_no is null, 1,MAX(receipt_no)+1) AS max1 FROM scheme_master;"); $top = $query1['max1']; /* * Initialised but $Pric is never used apart from an assignment */ $Pric = ""; $loopCount = 0; // initialised and updated but not used anywhere in this code for ($row2 = $couponcode + 1; $row2 <= $Temp_coupon; $row2++) // what happens if $couponcode or $coupon are negative? Why start at +1 instead of what user entered { /* * Each run of this query will slow down this whole code */ $query2 = $database -> getRow("SELECT if (coupon is null, 1, MAX(coupon)+1) AS max2 FROM scheme_master;"); $coup = $query2['max2']; /* * $value is never used */ $value = $loopCount+=2; // the same as $value=$loopCount++ +1; No idea why it's here as it is not used at all in this code /* * These values are never used */ $code = '- mths'; //unused. As it never changes, should be initialised earlier $Pric = $value.$code; //unused $insertrow = $database -> insertRow("INSERT INTO scheme_master (book_no2,receipt_no,coupon) VALUES (:book_no2,:receipt_no,:coupon)", array(':receipt_no' => $top, ':book_no2' => $row1, ':coupon' => $coup)); } } } $_SESSION['message'] = "Books Created Successfully"; } ?> не <?php if (isset($_POST['save'])) { /* * No checking for validity of values */ $bookcode = $_POST['bookcode']; $book_no2 = $_POST['book_no2']; $receiptcode = $_POST['receiptcode']; $receipt_no = $_POST['receipt_no']; $couponcode = $_POST['couponcode']; $coupon = $_POST['coupon']; $Temp_receipt = $receiptcode + $receipt_no; $Temp_coupon = $couponcode + $coupon; for ($row1 = $bookcode + 1; $row1 <= $bookcode + $book_no2; $row1++) // what happens if $bookcode or $book_no2 are negative? Why start at +1 instead of what user entered? { for ($row = $receiptcode + 1; $row <= $Temp_receipt; $row++) // what happens if $receiptcode or $receipt_no are negative? Why start at +1 instead of what user entered? { /* * Each run of this query will slow down this whole code */ $query1 = $database -> getRow("SELECT if (receipt_no is null, 1,MAX(receipt_no)+1) AS max1 FROM scheme_master;"); $top = $query1['max1']; /* * Initialised but $Pric is never used apart from an assignment */ $Pric = ""; $loopCount = 0; // initialised and updated but not used anywhere in this code for ($row2 = $couponcode + 1; $row2 <= $Temp_coupon; $row2++) // what happens if $couponcode or $coupon are negative? Why start at +1 instead of what user entered { /* * Each run of this query will slow down this whole code */ $query2 = $database -> getRow("SELECT if (coupon is null, 1, MAX(coupon)+1) AS max2 FROM scheme_master;"); $coup = $query2['max2']; /* * $value is never used */ $value = $loopCount+=2; // the same as $value=$loopCount++ +1; No idea why it's here as it is not used at all in this code /* * These values are never used */ $code = '- mths'; //unused. As it never changes, should be initialised earlier $Pric = $value.$code; //unused $insertrow = $database -> insertRow("INSERT INTO scheme_master (book_no2,receipt_no,coupon) VALUES (:book_no2,:receipt_no,:coupon)", array(':receipt_no' => $top, ':book_no2' => $row1, ':coupon' => $coup)); } } } $_SESSION['message'] = "Books Created Successfully"; } ?> не <?php if (isset($_POST['save'])) { /* * No checking for validity of values */ $bookcode = $_POST['bookcode']; $book_no2 = $_POST['book_no2']; $receiptcode = $_POST['receiptcode']; $receipt_no = $_POST['receipt_no']; $couponcode = $_POST['couponcode']; $coupon = $_POST['coupon']; $Temp_receipt = $receiptcode + $receipt_no; $Temp_coupon = $couponcode + $coupon; for ($row1 = $bookcode + 1; $row1 <= $bookcode + $book_no2; $row1++) // what happens if $bookcode or $book_no2 are negative? Why start at +1 instead of what user entered? { for ($row = $receiptcode + 1; $row <= $Temp_receipt; $row++) // what happens if $receiptcode or $receipt_no are negative? Why start at +1 instead of what user entered? { /* * Each run of this query will slow down this whole code */ $query1 = $database -> getRow("SELECT if (receipt_no is null, 1,MAX(receipt_no)+1) AS max1 FROM scheme_master;"); $top = $query1['max1']; /* * Initialised but $Pric is never used apart from an assignment */ $Pric = ""; $loopCount = 0; // initialised and updated but not used anywhere in this code for ($row2 = $couponcode + 1; $row2 <= $Temp_coupon; $row2++) // what happens if $couponcode or $coupon are negative? Why start at +1 instead of what user entered { /* * Each run of this query will slow down this whole code */ $query2 = $database -> getRow("SELECT if (coupon is null, 1, MAX(coupon)+1) AS max2 FROM scheme_master;"); $coup = $query2['max2']; /* * $value is never used */ $value = $loopCount+=2; // the same as $value=$loopCount++ +1; No idea why it's here as it is not used at all in this code /* * These values are never used */ $code = '- mths'; //unused. As it never changes, should be initialised earlier $Pric = $value.$code; //unused $insertrow = $database -> insertRow("INSERT INTO scheme_master (book_no2,receipt_no,coupon) VALUES (:book_no2,:receipt_no,:coupon)", array(':receipt_no' => $top, ':book_no2' => $row1, ':coupon' => $coup)); } } } $_SESSION['message'] = "Books Created Successfully"; } ?>