In my database I have a table called topics, in the table there is the tags column where the tags are stored in a comma-separated order (for example $row['tags'] = "tag1,tag2,tag3,...". What I'm trying to do is display related topics depending on the tags that each has. The code below identifies only the single "tag" it finds (for example $row['tags'] ="tag1"). Do you have something to suggest? Thanks in advance.
<?php
$result_topic = $conn -> prepare("SELECT * FROM topics WHERE topics.topic_id = :id");
$result_topic->bindValue(':id',$topic_id, PDO::PARAM_INT);
$result_topic -> execute();
while($row = $result_topic->fetch(PDO::FETCH_ASSOC))
{
$tag = explode(",",$row['tags']);
for($i = 0; $i < count($tag); $i++){
$current_tag = $tag[$i];
$relative_topics = $conn -> prepare("SELECT topic_subject FROM topics WHERE tags LIKE ?");
$relative_topics -> bindParam(1,$current_tag);
$relative_topics -> execute();
$get_relative_topics = $relative_topics -> fetch(PDO::FETCH_ASSOC);
echo $get_relative_topics['topic_subject'].'<br>';
}
}
?>
With LIKE you can use the following two wildcard characters in the pattern:
% matches any number of characters, even zero characters.
_ matches exactly one character.
so, you need to use the % wildcard in your query:
$current_tag = "%" . $tag[$i] . "%";
$relative_topics = $conn -> prepare("SELECT topic_subject FROM topics WHERE tags LIKE ?");
You could try using following SQL query -
$relative_topics = $conn -> prepare("SELECT topic_subject FROM topics WHERE tags LIKE %?%");