/** * 插入数据 * @param string $datalist 数据集合 */ public function Insert_Form_Data($datalist) { $db_form = new DbformModel(); $dbcell = new DbcellModel(); if ($datalist) { $tables = $db_form->GetDBFormVid($datalist[0]['vid']); //获取s_dbcell内容 $sdbcolumn_list = $dbcell->GetListForTid($tables['tid']); $sql = "INSERT INTO " . $tables['form_table'] . "(column) VALUES (key)"; foreach ($datalist as $key => $value) { $column .= ',' . $value['name']; //判断是否是密码 $type = GetPWDByName($value['name'], $sdbcolumn_list); if ($type['flx'] == 'password') { $dtvalue .= ',\'' . md5($value['value']) . '\''; } else { $dtvalue .= ',\'' . $value['value'] . '\''; } } $sql = str_replace('column', substr($column, 1), $sql); $sql = str_replace('key', substr($dtvalue, 1), $sql); return $this->execute($sql); } }
/** * 通过$tid获取列名 */ public function GetColumnFortid($tid) { $dbcell = new DbcellModel(); return $dbcell->GetListForTid($tid); //通过vid获取视图信息 }