Date increment in INSERT loop

[Pete Ace]

I have the code below in a php file and it works successfully. The roomsav mysql table gets the inserts and here is that table:


userid | sdate
TL2-0001 2021-05-03
TL2-0001 2021-05-03
TL2-0001 2021-05-03

All I want to do is increment the date by one day in the loop so the roomsav table looks like this:


userid | sdate
TL2-0001 2021-05-03
TL2-0001 2021-05-04
TL2-0001 2021-05-05

I have tried everything including throwing computer out of window. Would appreciate any help. Thanks

$conn = mysqli_connect($HOST_STRING, $USER_NAME, $USER_PASSWORD, $DATABASE_NAME);

$userid = $_POST["userid"];
$sdate = $_POST["sdate"];
$qty = 3;


for($i=0; $i< $qty; $i++)
{
$sql = "INSERT INTO roomsav (userid, sdate) VALUES('".$userid."','".$sdate."')";
$result = mysqli_query($conn, $sql);
}