mysql添加标签_PHP / MySQL - 如何添加多个标签

我有这个脚本，只允许用户输入单个标签，但我想让用户输入多个用逗号分隔的标签，例如shoe, shirt, hat, glasses，并将每个标签存储在数据库中。

有人可以给我一些我需要在脚本中更改的示例，以便执行此操作。

这是我下面的MySQL表。

CREATE TABLE questions_tags (

id INT UNSIGNED NOT NULL AUTO_INCREMENT,

tag_id INT UNSIGNED NOT NULL,

users_questions_id INT UNSIGNED NOT NULL,

PRIMARY KEY (id)

);

CREATE TABLE tags (

id INT UNSIGNED NOT NULL AUTO_INCREMENT,

tag VARCHAR(255) NOT NULL,

PRIMARY KEY (id)

);

这是下面的脚本。

require_once ('./mysqli_connect.php');

if (isset($_POST['submitted'])) {

$mysqli = new mysqli("localhost", "root", "", "sitename");

$dbc = mysqli_query($mysqli,"SELECT questions_tags.*, tags.* FROM questions_tags, tags");

if (!$dbc) {

print mysqli_error($mysqli);

}

$page = '3';

$tag = mysqli_real_escape_string($mysqli, $_POST['tag']);

$mysqli = new mysqli("localhost", "root", "", "sitename");

$dbc = mysqli_query($mysqli,"SELECT questions_tags.*, tags.* FROM questions_tags INNER JOIN tags ON tags.id = questions_tags.tag_id WHERE questions_tags.users_questions_id='$page'");

if(mysqli_num_rows($dbc) >= 0){

$mysqli = new mysqli("localhost", "root", "", "sitename");

$clean_url = mysqli_real_escape_string($mysqli, $page);

$query1 = "INSERT INTO tags (tag) VALUES ('$tag')";

if (!mysqli_query($mysqli, $query1)) {

print mysqli_error($mysqli);

return;

}

$mysqli = new mysqli("localhost", "root", "", "sitename");

$dbc = mysqli_query($mysqli,"SELECT id FROM tags WHERE tag='$tag'");

if (!$dbc) {

print mysqli_error($mysqli);

} else {

while($row = mysqli_fetch_array($dbc)){

$id = $row["id"];

}

}

$query2 = "INSERT INTO questions_tags (tag_id, users_questions_id) VALUES ('$id', '$page')";

if (!mysqli_query($mysqli, $query2)) {

print mysqli_error($mysqli);

return;

}

echo "$tag has been entered";

if (!$dbc) {

print mysqli_error($mysqli);

}

}

mysqli_close($mysqli);

}

?>