<code> $data = [ 'field1' => isset($params['field1']) ? $params['field1'] : 0, 'field2' => isset($params['field2']) ? $params['field2'] : 0,, 'field3' => isset($params['field3']) ? $params['field3'] : 0, 'field4' => isset($params['field4']) ? $params['field4'] : 0, 'field5' => isset($params['field5']) ? $params['field5'] : 0, 'field6' => isset($params['field6']) ? $params['field6'] : 0, 'field7' => isset($params['field7']) ? $params['field7'] : 1, ]; 在往数据库中插入的时候,这种代码该如何优化</code>
<code> $data = [ 'field1' => isset($params['field1']) ? $params['field1'] : 0, 'field2' => isset($params['field2']) ? $params['field2'] : 0,, 'field3' => isset($params['field3']) ? $params['field3'] : 0, 'field4' => isset($params['field4']) ? $params['field4'] : 0, 'field5' => isset($params['field5']) ? $params['field5'] : 0, 'field6' => isset($params['field6']) ? $params['field6'] : 0, 'field7' => isset($params['field7']) ? $params['field7'] : 1, ]; 在往数据库中插入的时候,这种代码该如何优化</code>
<code> $data=array_map(function($v,$k){ $default=0; if($k=='field7') $default=1; #return $v??$default; //php7 return isset($v) ? $v : $default; },$data,array_keys($data)); </code>
<code class="php">$fields = array('field1'=>0, 'field2'=>'default_value'); $data = array(); foreach ($fields as $k=>$v) { $data[$k] = isset($params[$k]) ? $params[$k] : $v; }</code>