使用explode（php）将多个（不知道多少）单词添加到数据库中

Question

A user can add multiple tags to describe the picture, separate them with commas. I don't know how to split tags and add them into the database, because I can't tell how many words he would write. I know I should use functions count and foreach, but I don't know how.

$tag_title=mysql_real_escape_string($con, $_POST['tag_title']);
$array_title=explode(',', $tag_title);

Any help would be much appreciated ...

Answer 1

You can try this simple approach.

$s = 'a, b, c, d, e, f, g';
$e = explode(',', $s);
$sum = count($e);
for($i = 0; $i < $sum; $i++)
{
    echo $e[$i];
}

Output: a b c d e f g

So now you have separated string, this will be your sql query values. And insert its as much as the tags. $sum already covering how many insert will be processed.

And of course a note:

Warning This function has been DEPRECATED as of PHP 5.3.0. Relying on this feature is highly discouraged.