Rate this script:  I Love it  /   I Hate it

Flat-tag updater


Code


function updateTags($tags,$table,$db) {//category handling stuff
   include("recordExists.php");//see http://bigbold.com/snippets/posts/show/464
   $cats = explode(";",$tags);//parse tags into array cats
   foreach($cats as $cat) {//loop through cats
      $tmp = array($cat);//dummy array with cat in it
      $tmp = array_diff($cats,$tmp);//get everything in cats that is not cat
      if(!recordExists("tagname",$cat,$table,$db)) {//if there is no category by this name yet
         $tmp = implode(";",$tmp);//make tmp into semicolon-separated string
         $result = mysql_query("INSERT INTO ".$table." (tagname,relatedtags) VALUES ('$cat','$tmp')", $db) or die(mysql_error());//insert category into database
      } else {
         $result = mysql_query("SELECT relatedtags FROM ".$table." WHERE tagname='$cat'", $db) or die(mysql_error());//select already related tags
         $result = mysql_fetch_array($result);//get the result row as an array
         $result = explode(";",$result['relatedtags']);//parse relatedtags into result
         $result = array_merge($tmp,$result);//merge the cats in this $tags (without cat, hence tmp) with the ones that were in there already
         $result = array_unique($result);//strip duplicates
         $result = implode(";",$result);//make result into semicolon-separated string
         $result = mysql_query("UPDATE ".$table." SET relatedtags='$result' WHERE tagname='$cat'", $db) or die(mysql_error());//update category
      }//end if-else !recordExists
   }//end foreach cats
}//end function updateTags
 

 

 
Flat-tag updater scripts | Flat-tag updater snippet | Flat-tag updater example | Flat-tag updater tutorial | Flat-tag updater code