foreach/array problem with tagging

[adastra]

I need some help with foreach/arrays - I want to add a small tagging function to a news script, but so far it's not working.

I either get the error "Warning: Invalid argument supplied for foreach() on line 54"
or it enters the data as "charts, tags, testing" into the database in only one row, instead of creating a new row for each of those tags.

I have defined a $tags = array(); at the top if my file, and I have a simple text input field for typing the tags.

This is the part of the script which posts the tags:

$tags = $_POST['tags'];
				foreach($tags as $tag) {
					$tag = strtolower($tag);
					$tag = strip_tags($tag);
					$tag = str_replace('ä', "ae", $tag);
					$tag = str_replace('ö', "oe", $tag);
					$tag = str_replace('ü', "ue", $tag);
					$tag = str_replace('ß', "ss", $tag);
					$tag = mysql_real_escape_string($tag);
					$query_tag = "INSERT INTO news_tags VALUES ('','$newsID','$tag')";
					$result_tag = mysql_query($query_tag);
					if ($result_tag != false) {
							echo "<br />Tag '".$tag."' hinzugefügt.";
					}
				}

Can anyone help out and explain how I get a new entry for each comma seperated tag in my input field?

[Rodney_H_]

If the tags are separated by commas, you will have to "separate" them.

The best choice for this is the EDIT: explode() function.

So, maybe you could try something like:

<?php
// if value is set and not empty:
if(isset($_POST['tags']) && trim($_POST['tags']) != '')
{
	// split each tag at the comma, and store in the "$tags" array:
	$tags = explode(',', $_POST['tags']);

$added = array();

foreach($tags as $tag) 
{
	if(trim($tag) != '')
	{
		$tag = trim($tag);
		$tag = strtolower($tag);
		$tag = strip_tags($tag);

		$locate = array('ä', 'ö', 'ü','ß' );
		$replace = array('ae', 'oe', 'ue', 'ss');
		$tag = str_replace($locate, $replace, $tag);

		$query = "INSERT INTO `news_tags` 
				  VALUES ('',
				  '" . $newsID . "',
				  '" . mysql_real_escape_string($tag) . "')";

		$result = mysql_query($query) or die('Could not execute query');

		$added[] = $tag;
	}
}

if(count($added) > 0)
{
	echo '<br />Tags added: ' . implode(', ', $added);
}
else
{
	echo '<br />Sorry. Nothing added.';
}
}
?>

[adastra]

That's exactly what I needed, thank you very much! 🙂

[adastra]

Edit: Nevermind 😉

[Rodney_H_]

Sure thing.

if that is all, please mark this thread as RESOLVED.

Thanks.