PHP Tools_help::arraytofields示例

 /**
  * 单条查询
  *
  */
 public function select($params = array('where' => array()))
 {
     $query = "";
     if (isset($params['field']) && is_array($params['field']) && !empty($params['field'])) {
         $fieldstr = Tools_help::arraytofields($params['field']);
         $query .= 'select ' . $fieldstr . ' from ' . $this->_table;
     } else {
         $query .= 'select * from ' . $this->_table;
     }
     if (isset($params['where']) && is_array($params['where']) && !empty($params['where'])) {
         $query .= ' where 1=1 ';
         foreach ($params['where'] as $k => $v) {
             $islike = strstr($v, '%');
             if ($islike) {
                 $query .= ' and ' . $k . ' like ?';
             } else {
                 $query .= ' and ' . $k . '=?';
             }
         }
     }
     if (isset($params['order']) && !empty($params['order'])) {
         $query .= ' order by ' . $params['order'];
     }
     $query .= ' limit 1';
     $dbconn = $this->db->prepare($query);
     $dbconn->execute(array_values($params['where']));
     $result = $dbconn->fetch(PDO::FETCH_ASSOC);
     $dbconn->closeCursor();
     return isset($result) ? $result : false;
 }