mysql - 如何为数据数组sql创建短代码

Question

我已经可以使用以下查询将数据插入数据库。但我想缩短一些列名称的代码，因为它就像一个连续的数字。我已经通过 m1=A、m2=B、m3=C、m4=A 爆炸标记并继续..

下面是我的 Controller :

$mark = 'ABCADDBBAACBCDDABBCA';
$totalquestion = '10';

for($i=0; $i<$totalquestion; $i++):
  $no = $i+1;
  $m = substr($mark, 0, $no);
endfor;

$data[] = array(
        'TotalQuestion'   => $totalquestion,
        'Mark'   => $mark,
        'm1'    => $m[0],
        'm2'    => $m[1],
        'm3'    => $m[2],
        'm4'    => $m[3],
        'm5'    => $m[4],
        'm6'    => $m[5],
        'm7'    => $m[6],
        'm8'    => $m[7],
        'm9'    => $m[8],
        'm10'    => $m[9],
        'm11'    => $m[10],
        'm12'    => $m[11],
        'm13'    => $m[12],
        'm14'    => $m[13],
        'm15'    => $m[14],
        'm16'    => $m[15],
        'm17'    => $m[16],
        'm18'    => $m[17],
        'm19'    => $m[18],
        'm20'    => $m[19]
        );

$this->excel_import_model->insert($data);

这是我的结果:

我的问题是如何重新编码我的 data[] 数组，这样我就不需要手动输入 m1、m2、m3 直到 m20。抱歉我的英语不好

Answer 1

    $mark = 'ABCADDBBAACBCDDABBCA';
    $totalquestion = '20';

    $data = array();
    $data = array(
        'TotalQuestion'   => $totalquestion,
        'Mark'   => $mark,
     );

    //Split String into array
    $list = str_split($mark);
    $mlist = array();

    //Loop through splited string
    for($i=0; $i<$totalquestion; $i++):
      $mlist['m'.$i] = $list[$i];
    endfor;

    //Merge here or you an even use push array in for loop itslef
    $data = array_merge($data,$mlist);