mysql - 无法从表单 zend 2 插入数据

Question

我有以下代码将数据从 zend 表单插入到数据库表中，我在这里给出了模型的代码。

 public function Savemedic( $medicaldata,$id)
 {
   $medicadapter = $this->tableGateway->adapter;    
   $data = array(
            'cardno' => $medicaldata->cardno,
            'disabilityGroup' => $medicaldata->disabilityGroup,
            'childhooddis' => $medicaldata->childhooddis,
            'reason' => $medicaldata->reason,
            'ilnessCrypt' => $medicaldata->ilnessCrypt,
            'hearing' => $medicaldata->hearing,
            'vision' => $medicaldata->vision,
            'movement' => $medicaldata->movement,
            'dcp' => $medicaldata->dcp,
            'autism' => $medicaldata->autism,
            'psychology' => $medicaldata->psychology,
            'sensor' => $medicaldata->sensor,
            'statodinamic' => $medicaldata->statodinamic,
            'bloodflow' => $medicaldata->bloodflow,
            'brithing' => $medicaldata->brithing,
            'stomack' => $medicaldata->stomack,
            'escression' => $medicaldata->escression,
            'metabolism' => $medicaldata->metabolism,
            'secression' => $medicaldata->secression,
            'imunitet' => $medicaldata->imunitet,
            'speach' => $medicaldata->speach,
            'distortion' => $medicaldata->distortion,
            ' canser' => $medicaldata-> canser,
            'other' => $medicaldata->other,           
        );       
 $resultstd=$this->tableGateway->insert($data);

 $med_id=$this->tableGateway->lastInsertValue;
 //$education_id=$this->tableGateway->lastInsertValue;
 $dbAdapter = $this->tableGateway->adapter;

 $medadapter=$this->tableGateway->getAdapter();
 $medicaldataToStudent=new TableGateway('medicaldata_to_student', $medadapter);
 $data_arr = array(
    'student_id'  =>$id,
    'medical_id' => $med_id,      
 );
 $medicaldataToStudent->insert($data_arr);
}

这会生成以下查询:

 object(PDOStatement)#553 (1) { ["queryString"]=> string(598) "INSERT INTO `medicaldata` (`cardno`, `disabilityGroup`, `childhooddis`, `reason`, `ilnessCrypt`, `hearing`, `vision`, `movement`, `dcp`, `autism`, `psychology`, `sensor`, `statodinamic`, `bloodflow`, `brithing`, `stomack`, `escression`, `metabolism`, `secression`, `imunitet`, `speach`, `distortion`, ` canser`, `other`) VALUES (:cardno, :disabilityGroup, :childhooddis, :reason, :ilnessCrypt, :hearing, :vision, :movement, :dcp, :autism, :psychology, :sensor, :statodinamic, :bloodflow, :brithing, :stomack, :escression, :metabolism, :secression, :imunitet, :speach, :distortion, : canser, :other)" }

但我收到此错误消息:

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

我错过了什么？

Answer 1

字段名称中有一个空格:

' canser' => $medicaldata-> canser,