php/mysql tags

[herghost]

Hi Guys

 

Whats the easiest way to store tags in a database from a php form?

 

If I have a text field called tags, and each tag is comma seperated how do I process the data?

 

I have a table called tags, with 3 fields, tag_id, post_id and tag

 

Basically how would I basically turn this input:

 

a tag, b tag, c tag from a form field to

tag_id

cat_id

tag

1

dont worry about me, i can work this out!

tag a

2

dont worry about me, i can work this out!

tag b

3

dont worry about me, i can work this out!

tag c

 

Many Thanks

 

[fugix]

mysql_query("insert into tags values('tag_id', 'post_id', 'tag')");

[wildteen88]

If I have a text field called tags, and each tag is comma seperated how do I process the data?

Use explode. Example

$tags = explode(',', $_POST['your_tag_field'];
print_r($tags);

 

To insert the tags into your tags table I'd do something like this

$cat_id = (int) $cat_id;

$query = 'INSERT INTO tags (cat_id, tag) VALUES (';
// dynamically build the query
foreach($tags as $tag)
{
    $tag = mysql_real_escape_string($tag);
    $query .= "($cat_id, '$tag'), ";
}

// clean the query up, remove the comma and space at the end of the query string
$query = substr($query, 0, -2);

mysql_query($query);

 

 

 

[herghost]

Thanks,

 

I now have this:

$post_id = '1';

$tags = explode(',', $_POST['tags']);
print_r($tags);
$query = 'INSERT INTO blog_tags (post_id, tag) VALUES
(';
// dynamically build the query
foreach($tags as $tag)
	{
    		$tag = mysql_real_escape_string($tag);
    		$query .= "('$post_id', '$tag'), ";
	}

// clean the query up, remove the comma and space at the end of the query string
	$query = substr($query, 0, -2);


mysql_query($query);
if(!$query)
{
echo mysql_error();
}

else
{
echo "ok";
}

 

However nothing is entered into the db, the query prints the OK echo, and if I remove the else the printf works as well?

 

Cheers

 

[fugix]

if you have 3 fields in your database then you will need to insert 3 pieces of data..his code only inserts 2 so it wont work

[herghost]

fujix:

 

tag_id is ai, so not needed

[fugix]

You still Need empty quotes fir the field

[herghost]

fugix:

 

Added, no difference

[Pikachu2000]

Have you echoed the query string, along with mysql_error() to help debug it?

[wildteen88]

Small typo remove the ( from the end of this line

$query = 'INSERT INTO blog_tags (post_id, tag) VALUES
(';

[fugix]

If you didn't have the parenthesis it wouldn't be a valid query

[herghost]

If you didn't have the parenthesis it wouldn't be a valid query

 

Please stop answering if you dont know what you are going on about

 

WildTeen & Pikachu:

 

Thanks, its now working using:

 

$post_id = '1';

$tags = explode(',', $_POST['tags']);
print_r($tags);
$query = 'INSERT INTO blog_tags (post_id, tags) VALUES
';
// dynamically build the query
foreach($tags as $tag)
	{
    		$tag = mysql_real_escape_string($tag);
    		$query .= "('$post_id', '$tag'), ";
	}

// clean the query up, remove the comma and space at the end of the query string
	$query = substr($query, 0, -2);

$go=mysql_query($query);
if(!$go)
{
echo mysql_error();

}

else
{
echo "ok";
echo '<br>';
echo $go;
}