Hi to everybody
I need ur help because I’m trying to make a script in php to write the same data but with different date in MySQL depending on the splitting ($data06).... like a schedule...
For example if $data06 = annual and $data03 = “2019/01/01”
programm must create in MySQL :
2019/01/01
2020/01/01
2021/01/01
2022/01/01
2023/01/01
if $data06=“half year” will create 10 date , increasing 6 moths ...
But I have a problem at finish of code
switch ($data06) {
case 'annual': $numrate = 5; $aumdata = "+12 months";
break;
case 'half year': $numrate = 10; $aumdata = "+6 month"; break;
default: echo "error";
break;
}
$sql = "INSERT into $nometb ( name, scadenza ) values ( '$data01', '$data03' )";
if ($conna->query($sql) === TRUE) {} else {die('ERROR'. $conna->error); }
//IMPORT NEXT AND NEW DATE
$newDate = date_create($data03);
for ($mul = 2; $mul <= $numrate; ++$mul) {
$datanuova = date_create($data03); $datanuova->modify($aumdata); $datanuova->format('yy/m/d'); $newDate = $datanuova->format('yy/m/d');
$sql = "INSERT into $nometb ( name, scadenza ) values ( '$data01', '$newDate' )";
if ($conna->query($sql) === TRUE) {} else {die('ERROR'. $conna->error); }
//HERE THERE IS ERROR $data03 = $newDate;
if ($conna->query($sql) === TRUE) {} else {die('ERRORE NELL\'IMPORTAZIONE'. $conna->error); }
}
}
}
}
$data03 need to be a string but I have problem at the end to convert a date in string
How I can resolve ?
many thanks
Francesco