{"id":232699,"date":"2023-01-27T12:15:00","date_gmt":"2023-01-27T09:15:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232699"},"modified":"2022-11-10T17:23:27","modified_gmt":"2022-11-10T14:23:27","slug":"hur-visar-jag-tweetsarkiv-i-wordpress-med-php-och-mysql-med-crontab-support","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/sv\/hur-visar-jag-tweetsarkiv-i-wordpress-med-php-och-mysql-med-crontab-support\/","title":{"rendered":"Hur visar jag tweetsarkiv i WordPress med PHP och MySQL med Crontab Support?"},"content":{"rendered":"\n

Diskanth\u00f6gtalaren \u00e4r inte bra p\u00e5 att visa alla tweets. Jag har mer \u00e4n 600 tweets hittills (de flesta av dem skickas med PHP-skript<\/a> p\u00e5 VPS<\/a> ). Om du vill spara en kopia av alla dina historiska tweets till din egen databas lokalt kan du sj\u00e4lvklart beg\u00e4ra ett arkiv p\u00e5 ditt twitterkonto [Inst\u00e4llningar \u2013 Konto \u2013 Beg\u00e4r arkiv].<\/p>\n

\"Hur<\/a><\/p>\n

beg\u00e4ran-twitter-arkiv<\/p>\n

Vad s\u00e4gs om att du kan spara alla tweets och visa dem i din blogg (WordPress-sida)? Id\u00e9n \u00e4r bra eftersom tweets kan ses som artiklar f\u00f6r SEO-\u00e4ndam\u00e5l. S\u00e5 du skulle beh\u00f6va skapa en tabell i wordpress-databasen, l\u00e5t oss till exempel namnge den tweets<\/code>.<\/p>\n

\"Hur<\/a><\/p>\n

tweet-historik-tabell<\/p>\n

Vi har fyra kolumner, dessa \u00e4r: tweet-ID<\/strong>, text<\/strong>, datum\/tid<\/strong>, antal retweet<\/strong>. Naturligtvis kan du f\u00e5 mer information fr\u00e5n twitter API statuses\/user_timeline<\/strong> men vi \u00e4r bara intresserade av dessa fyra.<\/p>\n

Lagra lokalt<\/h3>\n

Det finns alltid en hastighetsgr\u00e4ns f\u00f6r att anv\u00e4nda Twitter API:er s\u00e5 att du inte kan anv\u00e4nda dem s\u00e4rskilt ofta. Men tanken h\u00e4r \u00e4r att ha ett PHP-skript som k\u00f6rs p\u00e5 crontab<\/a> (med n\u00e5gra timmars mellanrum) och h\u00e4mtar tweetarna och lagrar dem lokalt i databasen.<\/p>\n

Vi kan anv\u00e4nda TwitterOAuth<\/strong> php-bibliotek f\u00f6r att interagera med Twitter API:er:<\/p>\n

\/\/ <a class=\"vglnk\" target=\"_blank\" href=\"http:\/\/helloacm.com\" rel=\"nofollow\"><span>helloacm<\/span><span>.<\/span><span>com<\/span><\/a>\n\/\/ How to Show Tweets Archive in WordPress using PHP and MySQL with Crontab Support\nrequire('TwitterOAuth-1\/TwitterOAuth\/TwitterOAuth.php');\nrequire('TwitterOAuth-1\/TwitterOAuth\/Exception\/TwitterException.php');\nrequire('TwitterOAuth-1\/config.php'); \u00a0\nuse TwitterOAuthTwitterOAuth;\ndate_default_timezone_set('UTC');\n\u00a0\n$config = array(\n\u00a0 \u00a0 'consumer_key' \u00a0 \u00a0 \u00a0 => $twitter_apikey, \/\/ API key\n\u00a0 \u00a0 'consumer_secret' \u00a0 \u00a0=> $twitter_apisecret, \/\/ API secret\n\u00a0 \u00a0 'oauth_token' \u00a0 \u00a0 \u00a0 \u00a0=> $twitter_accesstoken, \/\/ not needed for app only\n\u00a0 \u00a0 'oauth_token_secret' => $twitter_accesstokensecret,\n\u00a0 \u00a0 'output_format' \u00a0 \u00a0 \u00a0=> 'object'\n);\n$tw = new TwitterOAuth($config);<\/code><\/pre>\n
Spara ovan som twitter.php<\/strong> s\u00e5 att vi kan inkludera dem varje g\u00e5ng om vi vill komma \u00e5t Twitter API:er.<\/p>\n
\/\/ <a class=\"vglnk\" target=\"_blank\" href=\"http:\/\/helloacm.com\" rel=\"nofollow\"><span>helloacm<\/span><span>.<\/span><span>com<\/span><\/a>\n\/\/ How to Show Tweets Archive in WordPress using PHP and MySQL with Crontab Support\n\u00a0 require(\"twitter.php\"); \n\u00a0\n\u00a0 $params = array(\n\u00a0 \u00a0 \u00a0 'screen_name' => $twitter_screenname,\n\u00a0 \u00a0 \u00a0 'user_id' => $twitter_ownerid,\n\u00a0 \u00a0 \u00a0 'count' => 300,\n\u00a0 \u00a0 \u00a0 'include_rts' => 1,\n\u00a0 \u00a0 \u00a0 'exclude_replies' => false\n\u00a0 );\n\u00a0 $tweets = $tw->get('statuses\/user_timeline', $params);\n\u00a0\n\u00a0 mysql_query(\"SET NAMES utf8\");\n\u00a0 if(!empty($tweets)) {\n\u00a0 \u00a0 \u00a0 foreach($tweets as $tweet) {\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $id = $tweet->id;\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $retweet_count = (integer)$tweet->retweet_count;\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $created_at = $tweet->created_at;\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $text = $tweet->text;\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $text = mysql_real_escape_string($text);\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $query = \"select count(1) from `tweets` where `id` = '$id'\";\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $result = mysql_query($query);\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $cnt = mysql_result($result, 0, 0);\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 if ($cnt == 0) {\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $query = \"insert into `tweets` set `id`='$id', `text`='$text', `created_at`='$created_at',`retweet_count`='$retweet_count'\"; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 } else {\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $query = \"update `tweets` set `id`='$id', `text`='$text', `created_at`='$created_at',`retweet_count`='$retweet_count' where `id`='$id'\"; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 mysql_query($query);\n\u00a0 \u00a0 \u00a0 }\n\u00a0 }<\/code><\/pre>\n
Mysql_query (”SET NAMES utf8")<\/strong> ser till att tweetarna infogas korrekt i databasen. mb_detect_encoding<\/strong> kommer att verifiera att tweetarna som returneras fr\u00e5n API:er verkligen \u00e4r UTF-8-kodade. PHP-skriptet ovan kommer att s\u00f6ka efter dubbletter (baserat p\u00e5 Twitter ID) s\u00e5 f\u00f6rsta g\u00e5ngen kommer en ny tweet att infogas men andra g\u00e5ngen kommer den bara att uppdateras.<\/p>\n
Det finns ett maximalt antal tweets du kan f\u00e5 av ett API-anrop, t.ex. 300. Om du har fler tweets kan du alltid ringa flera g\u00e5nger skriptet f\u00f6r att ladda ner alla tweets. Vi m\u00e5ste dock ange parametern max_id<\/strong>, som kommer att returnera tweets som \u00e4r \u00e4ldre \u00e4n det ID:n (mindre ID:n). S\u00e5 vi kan:<\/p>\n
\/\/ <a class=\"vglnk\" target=\"_blank\" href=\"http:\/\/helloacm.com\" rel=\"nofollow\"><span>helloacm<\/span><span>.<\/span><span>com<\/span><\/a>\n\/\/ How to Show Tweets Archive in WordPress using PHP and MySQL with Crontab Support\n\u00a0 $query = \"select min(`id`) from `tweets`\";\n\u00a0 $result = mysql_query($query) or die(mysql_error());\n\u00a0 $cnt = mysql_result($result, 0, 0); \u00a0 \u00a0\n\u00a0\n\u00a0 $params = array(\n\u00a0 \u00a0 \u00a0 'screen_name' => $twitter_screenname,\n\u00a0 \u00a0 \u00a0 'user_id' => $twitter_ownerid,\n\u00a0 \u00a0 \u00a0 'count' => 1000,\n\u00a0 \u00a0 \u00a0 'max_id' => $cnt,\n\u00a0 \u00a0 \u00a0 'include_rts' => 1,\n\u00a0 \u00a0 \u00a0 'exclude_replies' => false\n\u00a0 );<\/code><\/pre>\n
Tanken \u00e4r att leta efter den \u00e4ldsta tweeten (med min id) och bara returnera tweets som \u00e4r \u00e4ldre \u00e4n s\u00e5, s\u00e5 om du k\u00f6r skripten flera g\u00e5nger kommer du att importera alla tweets.<\/p>\n
Nu har vi data redo och vi kan k\u00f6ra detta skript p\u00e5 VPS-servern<\/a> med n\u00e5gra timmars mellanrum (frekvens upp till dig) genom att anv\u00e4nda crontab -e-<\/strong> kommandot.<\/p>\n
Visa Tweets p\u00e5 WordPress-sidor<\/h3>\n
Nu visar den h\u00e4r sidan helloacm.com\/tweets-history\/<\/a> alla tr\u00e4den fr\u00e5n databasen. Du skulle beh\u00f6va ett plugin f\u00f6r att k\u00f6ra PHP\/HTML p\u00e5 en wordpress-sida. Du kan enkelt hitta s\u00e5dana wordpress-plugins.<\/p>\n
Skapa en wordpress-sida och l\u00e4gg in f\u00f6ljande:<\/p>\n
[ include ]tweets.php[ \/ include ]<\/code><\/pre>\n
Sedan m\u00e5ste vi l\u00e4gga in PHP-skriptet i denna tweets.php som<\/strong> anges ovan.<\/p>\n
<php\n\/\/ <a class=\"vglnk\" target=\"_blank\" href=\"http:\/\/helloacm.com\" rel=\"nofollow\"><span>helloacm<\/span><span>.<\/span><span>com<\/span><\/a>\n\/\/ How to Show Tweets Archive in WordPress using PHP and MySQL with Crontab Support\n\u00a0 global $wpdb;\n\u00a0 \n\u00a0 $query = \"select count(1) from `tweets`\";\n\u00a0 $total = $wpdb->get_var($query);\n\u00a0 \n\u00a0 $per = 50;\n\u00a0 $page = get_query_var('page');\n\u00a0 if (!$page) {\n\u00a0 \u00a0 $page = 1;\n\u00a0 }\n\u00a0 \n\u00a0 \/\/ pagination\n\u00a0 $totalpages = ceil($total \/ $per);\n\u00a0 if ($page > $totalpages) {\n\u00a0 \u00a0 $page = 1;\n\u00a0 }\n\u00a0 \n\u00a0 $lowerbound = ($page - 1) * $per;\n\u00a0 $upperbound = $lowerbound + $per;\n\u00a0 $lmt=\" limit \". $lowerbound. \",\". $per;\n\u00a0 \n\u00a0 $query = \"select * from `tweets` order by `id` desc $lmt\";\n\u00a0 \n\u00a0 $result = $wpdb->get_results($query);\n\u00a0 \n\u00a0 if ($result) {\n\u00a0 \u00a0 foreach ($result as $tweet) {\n\u00a0 \u00a0 \u00a0 $created_at = $tweet->created_at;\n\u00a0 \u00a0 \u00a0 $text = $tweet->text;\n\u00a0 \u00a0 \u00a0 $retweet_count = $tweet->retweet_count;\n\u00a0 \u00a0 \u00a0 \/\/ display tweets\n\u00a0 \u00a0 \u00a0 echo \"$text - $created_at\";\n\u00a0 \u00a0 \u00a0 if ($retweet_count > 0) {\n\u00a0 \u00a0 \u00a0 \u00a0 echo \"($retweet_count Retweeted)\";\n\u00a0 \u00a0 \u00a0 }\n\u00a0 \u00a0 }\n\u00a0 } \u00a0\n\u00a0 \n\u00a0 \/\/ show prev\/next page links\n\u00a0 if ($page > 1) {\n\u00a0 \u00a0 echo \"<a href='?page=\".($page-1).\"'>Newer Tweets<\/a> - \";\n\u00a0 }\n\u00a0 if ($page < $totalpages) {\n\u00a0 \u00a0 echo \"<a href='?page=\".($page+1).\"'>Older Tweets<\/a>\";\n\u00a0 }<\/code><\/pre>\n
Vi anv\u00e4nder get_query_var(’page’)<\/strong> f\u00f6r att f\u00e5 fr\u00e5gestr\u00e4ngen s\u00e5 att vi vet p\u00e5 vilken sida vi tittar.<\/p>\n
Inspelningsk\u00e4lla:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Hur visar jag tweetsarkiv i WordPress med PHP och MySQL med Crontab Support?<\/p>\n","protected":false},"author":1,"featured_media":224614,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[838,848,999,901,922,724,868],"tags":[1173],"class_list":["post-232699","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-guide-foer-nyboerjare","category-handledningar","category-innehallsmarknadsforing","category-koda","category-oevrig","category-utvecklaren","category-wordpress-9","tag-affiai-sv"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/232699","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/comments?post=232699"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/232699\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/media\/224614"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/media?parent=232699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/categories?post=232699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/tags?post=232699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}