You can use the explode<\/strong> syntax, as in the following exapmple:<\/p>\n\n\n\n In the example we have a mysql field (keywords) with many items comma separated (such as : “truth, soul, body, mind” and so on). <\/p>\n\n\n\n And we obtain to have as many links from each item toward a specific target, as they are (that is: 3 links if you have 3 items, 7 links fi you have 7 ones).<\/p>\n\n\n\n In this way you can get a system of hashtags for your database keywords.<\/p>\n\n\n\n You need another file, let we call them hashtag.php.<\/p>\n\n\n\n The content of hashtag.php could be something like:<\/p>\n\n\n\n Afterwards obviously you could adjust the css according to your needs.<\/p>\n\n\n\n Of course you can have as many other php files as you want, where you usually store you database content, in which you can add the kewwords as hashtags, with a code like the following:<\/p>\n\n\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" php separate all items in a mysql field You can use the explode syntax, as in the following exapmple: In the example we have a mysql field (keywords) with many items comma separated (such as : “truth, soul, body, mind” and so on). And we obtain to have as many links from each item toward … <\/p>\n$keywords = $row['keywords'];\nforeach (explode(',', $keywords) as $key) {\n echo \"<span><a href=\"\\hashtag.php?tag=$key\\\">{$key}<\/a><\/span>\";\n}<\/code><\/pre>\n\n\n\nother steps<\/h3>\n\n\n\n
<?php \n \/\/hashtag.php \n if(isset($_GET[\"tag\"])) \n { \n $tag = preg_replace('\/(?<!\\S)#([0-9a-zA-Z]+)\/', '', $_GET[\"tag\"]);\n\n\/\/to beautify and stylize, but not necessary BEGIN\n $title=$tag;\n include \"$root\/intell\/header-intell.inc\"; \n\/\/to beautify and stylize, but not necessary END \n\n $connect = mysqli_connect(\"localhost\", \"[mysql user]\", \"[mysql password]\", \"[mysql database]\"); \n \n mysqli_set_charset($connect, 'utf8mb4'); \/\/ procedural style\n \n $query = \"SELECT * FROM [your table] WHERE [your fields with tags] LIKE '%\".$tag.\"%'; \n $result = mysqli_query($connect, $query); \n if(mysqli_num_rows($result) > 0) \n { \n while($row = mysqli_fetch_array($result)) \n { \n echo \"<h2>$row[title]<\/h2>\n <blockquote><p>$row[text]<\/p><\/blockquote>\n <p><i>$row[author]<\/i><br \/>\";\n $keywords = $row['keywords'];\n foreach (explode(',', $keywords) as $key) {\n if(trim($row[\"keywords\"])==''){echo \"\";} else{echo \"<span><a href=\\\"hashtag.php?tag=$key\\\">{$key}<\/a><\/span>\";}\n }\n echo \"<\/p>\";\n } \n } \n else \n { \n echo '<p>No Data Found<\/p>'; \n } \n } \n ?> <\/code><\/pre>\n\n\n\necho \"<\/p><p class=\\\"keywords\\\">\";\n$keywords = $row['keywords'];\nforeach (explode(',', $keywords) as $key) {\n if(trim($row[\"keywords\"])==''){echo \"\";} else{echo \"<span><a href=\\\"hashtag.php?tag=$key\\\">{$key}<\/a><\/span>\";}\n}\necho \"<\/p>\";}<\/code><\/pre>\n\n\n\n