如何在php和sql中插入标签到3表系统 - How to insert tags into 3 table system in php and sql

How to insert tags into 3 table system in php and sql

本文关键字：标签系统插入 php sql | 更新日期: 2023-09-27

我正试图使3表标签系统。我有3个表在mysql:

#Articles# id article content

#Tags# tag_id tag (unique)

#tagmap# id tag-id articleid

在我的提交php中，我有:

$tags= explode(',', strtolower($_POST['insert_tags']));
for ($x = 0; $x < count($tags); $x++) {
    //Add new tag if not exist
    $queryt = "INSERT INTO `tags` (`tag_id`, `tag`) VALUES ('', '$tags[x]')";
    $maket = mysql_query($queryt);
    //Add the relational Link, now this is not working, beacasue this is only draft
    $querytm = "INSERT INTO `tagmap` (`id`, `tagid`, `articleid`) VALUES ('',  (SELECT `tag_id` FROM `tags` WHERE tag_id  = "$tags[x]"), '$articleid')";
    $maketm = mysql_query($querytm);
    }

当我向文章提交新标签时，这不起作用。Mysql不能在我的标签表中创建新的标签

p。对不起，我的英语不好。

变量'x'缺少$符号。在这两行中尝试这样做。

'" . $tags[$x] . "'

我也建议这样做，不需要使你的SQL查询复杂化。

$tags= explode(',', strtolower($_POST['insert_tags']));
for ($x = 0; $x < count($tags); $x++) {
    //Add new tag if not exist
    $queryt = "INSERT INTO `tags` (`tag_id`, `tag`) VALUES ('', '" . $tags[$x] . "')";
    $maket = mysql_query($queryt);
    //Get tag id
    $tag_id = mysql_insert_id();
    //Add the relational Link, now this is not working, beacasue this is only draft
    $querytm = "INSERT INTO `tagmap` (`id`, `tagid`, `articleid`) VALUES ('',  '$tag_id', '$articleid')";
    $maketm = mysql_query($querytm);
}