$value) $fields[$key]=str_replace($escape.$enclosure,$enclosure,$value); return($fields); } function array2csv($input,$delimiter=',',$enclosure='"',$escape='\\'){ foreach ($input as $key=>$value) $input[$key]=str_replace($enclosure,$escape.$enclosure,$value); return $enclosure.implode($enclosure.$delimiter.$enclosure,$input).$enclosure; } function loadEmptyFields($table){ // returns variables corresponding to table fields, all set to blank '' -- used to init add-forms $sql = "SHOW COLUMNS FROM $table"; $CI =& get_instance(); $res = $CI->db->query($sql); $r = $res->result_array(); foreach($r as $v){ $var = $v["Field"]; $r[$var]=''; } return $r; } function getTableFieldNames($table, $exclude = ''){ $CI =& get_instance(); if(!$CI->db->table_exists($table)){ echo "WARNING ! Table: $table does not exist // getTableFieldNames"; return array(); } $ret = array(); $sql = "SHOW COLUMNS FROM $table"; $res = $CI->db->query($sql); $r = $res->result_array(); foreach($r as $v){ $var = $v["Field"]; if($exclude != $var){ $ret[$var]= $var; } } return $ret; } function getTableFieldsArray($table){ $sql = "SHOW COLUMNS FROM $table"; $CI =& get_instance(); $res = $CI->db->query($sql); $r = $res->result_array(); return $r; } function getSetfieldOptionsDropdown($table,$field, $current = '', $name =''){ // return dropdownlist with options for field "$field" (which is of type "SET" ) if(!$name){ $name = $field; } $sql = "SHOW COLUMNS FROM $table"; $CI =& get_instance(); $res = $CI->db->query($sql); $r = $res->result_array(); foreach($r as $v){ if ($v["Field"]==$field){ $sets = substr($v["Type"],4,-1); // => eg ('120x600-left','120x600-right','468x6') } } $ret = ""; if($sets){ $r = explode(",",$sets); foreach($r as $v){ $v = str_replace("'",'',$v); $ret .= "db->where('PERSON_ID', $userID); $this->db->where('BAND_ID', $bandID); $this->db->select('COUNT(ID) as C'); $r = $this->db->get('BAND_2_PERSON')->result_array(); return $r[0]['C']; } function BandOwnsSongsuggestion($rID, $bandID){ return $this->bandOwns($rID,$bandID,'SONGSUGGESTION'); } function BandOwnsImage($rID, $bandID){ return $this->bandOwns($rID,$bandID,'IMAGE'); } function BandOwnsHtml_page($rID, $bandID){ return $this->bandOwns($rID,$bandID,'HTML_PAGE'); } function BandOwnsBooklet($rID, $bandID){ return $this->bandOwns($rID,$bandID,'BOOKLET'); } function BandOwnsVideo($rID, $bandID){ return $this->bandOwns($rID,$bandID,'VIDEO'); } function BandOwnsSonglist($rID, $bandID){ return $this->bandOwns($rID,$bandID,'SONGLIST'); } function BandOwnsGig($rID, $bandID){ return $this->bandOwns($rID,$bandID,'GIG'); } function BandOwnsProduction($rID, $bandID){ return $this->bandOwns($rID,$bandID,'PRODUCTION'); } function BandOwnsLedger($rID, $bandID){ return $this->bandOwns($rID,$bandID,'LEDGER'); } function BandOwnsSong($rID, $bandID){ return $this->bandOwns($rID,$bandID,'SONG'); } function BandOwnsRelease($rID, $bandID) { return $this->bandOwns($rID,$bandID,'RELEASE'); } function BandOwnsRehearsal($rID, $bandID) { return $this->bandOwns($rID,$bandID,'REHEARSAL'); } function BandOwnsComposer($rID, $bandID) { return $this->bandOwns($rID,$bandID,'COMPOSER'); } function PersonOwnsVideo($rID, $personID) { return $this->personOwns($rID,$personID,'VIDEO'); } function PersonOwnsSongsuggestion($rID, $personID) { return $this->personOwns($rID,$personID,'SONGSUGGESTION'); } private function personOwns($rID, $personID, $table){ $this->db->where( 'ID', $rID ); $this->db->where( 'OWNER_ID', $personID ); $res = $this->db->get( $table )->num_rows(); return $res; } private function bandOwns($rID, $bandID, $table){ $this->db->where( 'ID', $rID ); $this->db->where( 'BAND_ID', $bandID ); $res = $this->db->get( $table )->num_rows(); return $res; } } ?>