Loop And Insert Monthly Schedule By Php

I'm working on loan monthly schedule right now and I met a problem with generate monthly schedule with php and mysql. My problem is: Example: loan date = 2/12/2015, duration = 5

Solution 1:

In this query add next month from your timestamp value you can adjust this based on your duration try this

INSERT INTO `tbl_book`(`book_date`) VALUES (now( ) + INTERVAL 1 MONTH)