Re: Date increment in INSERT loop

[Peter Brawley]

One way ...

$conn = mysqli_connect( ... );
$userid = '...'
$d = "2021-05-03';
$n = 28;
for( $i=0; $i<$n; $i++ ) {
  $q = "insert into roomsav set userid='$userid', sdate=adddate('$d' interval $i day)";
  if( !mysqli_query($conn,$q) )
    exit( $conn->error );
}