php code to create dynamic rows and insert in database

Question

I need to generate no in serial order starts from custom code. If user want to print two book with 3 receipt in each book and 2 coupon in each receipt.

user enter book code and total book
user enter receipt code and total receipt
user enter coupon code and total coupon

User input in textbox like:

bookno   - 101
totalbook    -  2

receiptno  - 500
totalrec      -  2

coupon     -  700
totalcoup     -   2

then output comes like below table.

In this table, coupon no are always unique.and receipt no comes twice because each receipt has two coupon alloted.

Please suggest me how generate below output using for loop and insert every row in database.

book   receipt     coupon

101     500        -   700

101     500        -   701

101  -   501       -    702

101  -   501        -   703

102   -  502        -   704

102  -   502         -  705

102   -  503        -   706

102   -  503        -   707

i try below code but not working properly.

         $bookno= $_POST['bookcode'];               
                $totalbook= $_POST['book_no2']; 

                $receiptno = $_POST['receiptcode'];
                $totalrec= $_POST['receipt_no'];                        
                $couponno= $_POST['couponcode'];                            
                $totalcoup= $_POST['coupon'];   


for($row1=$bookno;$row1<=$bookno+$totalbook;$row1++)
                    {   

                    for($row=$receiptno;$row<=$receiptno+$totalrec;$row++)
                        {

                                for($row2=$couponno;$row2<=$couponno+$totalcoup;$row2++)
                                {   

$insertrow = $database->insertRow("INSERT INTO scheme_master (book_no2,receipt_no,coupon)
VALUES (:book_no2,:receipt_no,:coupon)", 
array(':receipt_no'=>$row,':book_no2'=>$row1,':coupon'=>$row2));

                            }

                    }
                }

possible duplicate of php code to generate multiple rows with custom code — DaveyBoy
– DaveyBoy, Commented Feb 24, 2015 at 16:54

Community · Accepted Answer · 2017-05-23 12:29:57Z

Your question is EXACTLY the same as this one from Ashok Awachat. You both seem to be submitting questions to StackOverflow pretty regularly to get someone else to do your (I assume) college work.

As I said before in an earlier answer, go back to first principles:

If you're having problems running SQL queries through PHP, try the query on the database directly with hard-coded values
If the SQL works correctly on the database, try it from PHP with hard-coded values again
Don't re-invent the wheel. You're using methods which take a query and a set of parameters. If you typed out the full PHP for this, the overhead is negligible but readability of your code will increase.
Progressively add debugging code to your app so that you can check what is happening at each stage. Once you're happy that one part is working, add debugging to the next part. (Debugging in this instance is logging of values and errors)
Work slowly and methodically. Don't try to get everything done in one go. Start small and go from there.

With regards to StackOverflow, you need to consider the following:

The questions you are submitting are pretty rudimentary and relate to basic things like not understanding variable scope. Therefore, buy some books on PHP, SQL and HTML which you can refer to. Bookmark the documentation pages for the systems you are using. Search the web for tutorials etc
Submit as much information with your questions as possible. By this, I mean give the code you have tried, what errors you are getting ("it doesn't work" is not acceptable) etc. if someone asks for output from something, supply it.
Don't treat StackOverflow members as a vast repository of people willing to do your project for you. Everyone here are answering questions out of the goodness of their heart. They don't have to be here. I would guess that the vast majority of people answering questions have jobs which pay good money.
Once a question is answered, don't then go back and change the question to ask another one (Ashok did this). Also, don't delete comments if you do this as it removes context from the question. Start a new question off. If you're unable to do this as you've hit a limit for questions per day (I don't know if this is possible), then this should be a warning signal to yourselves that you are taking the easy way out

If you're going to be a developer then you need to know how to bug-hunt. Asking a question on StackOverflow every time you have a problem is not teaching you anything

Collectives™ on Stack Overflow

php code to create dynamic rows and insert in database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related