http://snippets.dzone.com/posts Thu, 21 Aug 2008 00:52:34 GMT DZone Snippets: php code http://snippets.dzone.com/posts/show/465 Pass new tags followed by a table name and database handle and this function updates the table so that each tag becomes properly associated/its record created, eg: <br /> <br />table state: <br />tagname | relatedtags <br />----------------------- <br />blog | rss;personal <br />rss | blog <br />personal | blog <br /> <br />call (table is named tags): <br />updateTags("blog personal friends","tags",$db); <br /> <br />table state: <br />tagname | relatedtags <br />----------------------- <br />blog | rss;personal;friends <br />rss | blog <br />personal | blog;friends <br />friends | blog;personal <br /> <br /> <br /><code> <br />function updateTags($tags,$table,$db) {//category handling stuff <br /> include("recordExists.php");//see http://bigbold.com/snippets/posts/show/464 <br /> $cats = explode(";",$tags);//parse tags into array cats <br /> foreach($cats as $cat) {//loop through cats <br /> $tmp = array($cat);//dummy array with cat in it <br /> $tmp = array_diff($cats,$tmp);//get everything in cats that is not cat <br /> if(!recordExists("tagname",$cat,$table,$db)) {//if there is no category by this name yet <br /> $tmp = implode(";",$tmp);//make tmp into semicolon-separated string <br /> $result = mysql_query("INSERT INTO ".$table." (tagname,relatedtags) VALUES ('$cat','$tmp')", $db) or die(mysql_error());//insert category into database <br /> } else { <br /> $result = mysql_query("SELECT relatedtags FROM ".$table." WHERE tagname='$cat'", $db) or die(mysql_error());//select already related tags <br /> $result = mysql_fetch_array($result);//get the result row as an array <br /> $result = explode(";",$result['relatedtags']);//parse relatedtags into result <br /> $result = array_merge($tmp,$result);//merge the cats in this $tags (without cat, hence tmp) with the ones that were in there already <br /> $result = array_unique($result);//strip duplicates <br /> $result = implode(";",$result);//make result into semicolon-separated string <br /> $result = mysql_query("UPDATE ".$table." SET relatedtags='$result' WHERE tagname='$cat'", $db) or die(mysql_error());//update category <br /> }//end if-else !recordExists <br /> }//end foreach cats <br />}//end function updateTags <br /></code> Fri, 08 Jul 2005 01:50:07 GMT http://snippets.dzone.com/posts/show/465 singpolyma () http://snippets.dzone.com/posts/show/464 In mySQL (from PHP), checks for the existance of a record based on id, passing the name of the id field followed by the id to check for, the table name, and the database resource, in that order. <br /><code> <br />function recordExists($id,$idval,$table,$db) {//check for id=idval in table and return TRUE or FALSE <br /> $result = mysql_query("SELECT * FROM ".$table." WHERE ".$id."='".$idval."'", $db) or die(mysql_error()); <br /> if($row = mysql_fetch_array($result)) {//if we did return a record <br /> return 1; <br /> }//end if row <br /> return 0; <br />}//end fuction recordExists <br /></code> Fri, 08 Jul 2005 01:27:38 GMT http://snippets.dzone.com/posts/show/464 singpolyma ()