FrancescoITA
-
Posts
1 -
Joined
-
Last visited
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
How to create a set of data from string to insert in MySQL
in PHP Coding Help
Posted
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