- or download this
@array1 = [ 1 ,2 , 3];
@array2 = [4, 5, 6];
- or download this
foreach $user(@array1){
$sth -> $dbh ->perpare("INSERT INTO `trial` (User) VALUES ('$user')");
...
foreach $time(@array2){
$sth -> $dbh ->perpare("INSERT INTO `trial` (Time) VALUES ('$time')");
$sth->execute();
- or download this
User Time
1 NULL
...
NULL 4
NULL 5
NULL 6
- or download this
User Time
1 4
2 5
3 6