Jump to content


Photo

Need help completing tagging input


  • Please log in to reply
No replies to this topic

#1 devinkray

devinkray
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 15 September 2006 - 07:13 PM

I am a bit confused but here is what ive done:

Users insert tags VIA a textarea IE:

| rap, hip-hop, jungle |

Then I explode the ones into an array, then I did a foreach statement to insert each into separate rows in the "tags_relations" table

Then I went ahead further and brought the tags back together to display in the textarea box on submit, so after a user submits those tags above it will show:

| rap, hip-hop, jungle |

in the textarea, so what I want to do now is make it easyer to delete the tag by just removing it from the textarea like(so the user deletes ", jungle" from the list:

| rap, hip-hop |

The problem is that I have no idea on how to remove the tag "jungle" from the tags_relations table, ive asked around and people told me to use array_diff, but ive try multiple times trying to get it to work but nothing

<?php
require_once('include/bittorrent.php');
dbconn();
loggedinorreturn();

$act = $_GET[action];
  $torrentid = (int) $_GET['id'];
        if (!isset($torrentid) || !$torrentid)
          die();

if($act == "taketag") {
       $before = $_POST['tags'];
       //If nothing is in the box delete all the tags
       if(!$before)
        mysql_query("DELETE FROM tags_relations WHERE tagger_id=$CURUSER[id] AND torrent_id=$torrentid");
       //Make it lowercase
       $lower = strtolower($before);
       //Remove a comma if its the last char.
       $text = trim($lower);
       $last = $text{strlen($text)-1};
       if (!strcmp($last,",")){
         $text = rtrim($text, 'a..z');
         $text = rtrim($text, ',');
       }
              //Explode all tags into an array
       $tags = explode(',',$text);
              //Split each and do w/e to each one
       foreach($tags as $tag) {
                $tag = trim($tag);


         $tagsql = mysql_query("SELECT tag_id FROM tags WHERE tag_name='".mysql_escape_string($tag)."'") or die(mysql_error());
           $result = mysql_fetch_assoc($tagsql);

             if (!$result) {
               @mysql_query ("INSERT INTO tags (tag_name, tag_owner) VALUES ('".mysql_escape_string($tag)."', '".$CURUSER['id']."')") or die(mysql_error());
               $tagId = mysql_insert_id();
             } else {
               $tagId = $result['tag_id'];
             }
              @mysql_query ("INSERT INTO tags_relations (torrent_id, tag_id, tagger_id, tag_name) VALUES ('".$torrentid."', '".$tagId."', '".$CURUSER['id']."', '".mysql_escape_string($tag)."') ON DUPLICATE KEY UPDATE tag_id='".$tagId."',torrent_id='".$torrentid."', tagger_id='".$CURUSER['id']."'") or die(mysql_error());
            }
}

if($act == "reset") {
        mysql_query("DELETE FROM tags_relations WHERE torrent_id=$torrentid AND tagger_id = $CURUSER[id]");
        }

stdhead('Add Request Page');

$torrentid = (int) $_GET['id'];
if (!isset($torrentid) || !$torrentid)
  die();

$rre = mysql_query("SELECT * FROM tags LEFT JOIN tags_relations tr ON tr.tagger_id = $CURUSER[id] AND tr.torrent_id = $torrentid WHERE tr.tag_id = tags.tag_id ORDER BY tags.tag_name ASC");
while($arr = mysql_fetch_array($rre)){
      if ($tagsw)
      $tagsw .= ", ";
      $tagsw .= $arr['tag_name'];
        }


$res = mysql_query("SELECT name FROM torrents WHERE id=$torrentid");
$rawr = mysql_fetch_assoc($res);

?>
<form method="post" action="tag.php?id=<?=$torrentid?>&action=taketag">
<table width=750 cellspacing=0 cellpadding=5>
<tr><td colspan=2 class=tabletitle align=left><b>Tag <?=$rawr[name]?>.</b></td></tr>
<tr><td colspan=2 class=tableb align=left>Separate tags by a comma.  Ex.: punk, hardcore, ska<br>
<textarea value="<?=$tagsw?>" name="tags" rows="6" cols="80"><?=$tagsw?></textarea>
<tr><td colspan=2 class=tableb align=left>Click <a class=altlink href="tag.php?action=reset&id=<?=$torrentid?>">here</a> to remove all tags you have put on this torrent.</td></tr>
<tr><td colspan=2 class=tableb align=left><input type=submit value=Submit style='height: 20px'></td></tr>
</table>
</form>
<?
stdfoot();
die;
?>





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users