{"id":95,"date":"2006-07-29T10:22:06","date_gmt":"2006-07-29T09:22:06","guid":{"rendered":"http:\/\/jerome.harckmans.be\/?p=95"},"modified":"2006-07-29T10:22:06","modified_gmt":"2006-07-29T09:22:06","slug":"re-test","status":"publish","type":"post","link":"https:\/\/jerome.harckmans.be\/?p=95","title":{"rendered":"Automatic Keywords Generation"},"content":{"rendered":"

I just wrote a small php function that automatically generate HTML meta keywords from the custom “tags” field of the displayed posts:<\/p>\n

#########################
\n# KEYWORDS GENERATOR\t#
\n#########################\/*
\nThis function generate HTML Keywords based on
\nthe tags filled in for the displayed posts.
\nRequirements: WordPress 2.0, and you have to manually enter
\nthe tags separated by a comma in the ‘custom fields’ (named tags)
\npart of the post.
\nTODO: actually, it’s only applicable to the first page (5 posts).
\nIt will be updated soon to all post pages.
\nAuthor: harck (jerome.harckmans.be)
\n*\/
\nfunction keywordGen() {<\/p>\n

\/\/ Global Settings
\n$num_posts = 5; \/\/ Number of posts per page
\n$db_name = “WordPress Database Name”;
\n$db_user = “WordPress Database User”;
\n$db_pwd = “User Password”;
\n$db_host = “WordPress Database Host”;
\n\/\/ connecting to DB
\nmysql_connect($db_host, $db_user, $db_pwd) or die (“Unable to connect to Database Server!”);
\nmysql_select_db($db_name) or die (“Unable to select Database!”);
\n\/\/ Get all tags for the $num_posts last posts
\n\/\/ (the $num_posts displayed in the home page)
\n$tags = mysql_query(“SELECT meta_value FROM wp_postmeta, wp_posts WHERE post_id = ID AND meta_key = ‘tags’ ORDER by post_date DESC LIMIT $num_posts “);
\n\/\/ Get the number of tags lines (may be different from $num_posts)
\n$num_tags = mysql_numrows($tags);
\n\/\/ Loop for each tag line
\nfor ( $i = 0; $i < $num_tags; $i++ ) {\n\n\n

\/\/ Get current tag line
\n$cur_tags = mysql_result($tags, $i);
\n\/\/ First time, $keywords = tags
\nif ( $i == 0 ) {<\/p><\/blockquote>\n

$keywords = $cur_tags;<\/p><\/blockquote>\n

}
\n\/\/ then append tags to $keywords
\nelse {<\/p>\n

$keywords = $keywords.”,”.$cur_tags;<\/p><\/blockquote>\n

}
\n}
\n\/\/ Print HTML Keywords Meta
\nprint(”<\/p>\n

<meta name=\\”Keywords\\” content=\\”{$keywords}\\” \/>
\n“);
\n\/\/ THE END
\n}\n<\/p><\/div>\n

Simply call that function from the header part of your index page, and this should make web robots’ life easier \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"

I just wrote a small php function that automatically generate HTML meta keywords from the custom “tags” field of the displayed posts: ######################### # KEYWORDS GENERATOR # #########################\/* This function<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,6],"tags":[],"_links":{"self":[{"href":"https:\/\/jerome.harckmans.be\/index.php?rest_route=\/wp\/v2\/posts\/95"}],"collection":[{"href":"https:\/\/jerome.harckmans.be\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jerome.harckmans.be\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jerome.harckmans.be\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/jerome.harckmans.be\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=95"}],"version-history":[{"count":0,"href":"https:\/\/jerome.harckmans.be\/index.php?rest_route=\/wp\/v2\/posts\/95\/revisions"}],"wp:attachment":[{"href":"https:\/\/jerome.harckmans.be\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jerome.harckmans.be\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jerome.harckmans.be\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}