{"id":232856,"date":"2023-01-29T17:57:00","date_gmt":"2023-01-29T14:57:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232856"},"modified":"2023-02-10T16:20:26","modified_gmt":"2023-02-10T13:20:26","slug":"comment-faire-revivre-les-anciens-messages-en-utilisant-php-et-crontab-wordpress","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/fr\/comment-faire-revivre-les-anciens-messages-en-utilisant-php-et-crontab-wordpress\/","title":{"rendered":"Comment faire revivre les anciens messages en utilisant PHP et Crontab (WordPress)"},"content":{"rendered":"\n

Supposons que vous ayez un certain nombre de messages d\u00e9cents sur votre blog et que vous vous demandiez s’il existe un moyen de publier sur Twitter\/Facebook (ou d’autres r\u00e9seaux sociaux) automatiquement et r\u00e9guli\u00e8rement.<\/p>\n

Ce n’est pas difficile. Bien que ce post vous guidera pour poster sur twitter mais le principe est similaire pour les autres r\u00e9seaux sociaux. Cet article<\/a> pr\u00e9sente la fonction PHP pour publier sur Twitter.<\/p>\n

Nous ne voulons pas publier le m\u00eame contenu\/articles encore et encore dans un court laps de temps. Par cons\u00e9quent, nous devons cr\u00e9er une table SQL qui stocke l’historique des articles republi\u00e9s.<\/p>\n

--\n-- Table structure for table `twitter`\n--\n\nCREATE TABLE IF NOT EXISTS `twitter` (`id` bigint(32) unsigned NOT NULL,\n  `url` varchar(255) NOT NULL,\n  `posttime` datetime NOT NULL) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;<\/code><\/pre>\n
La table comporte trois champs, l’un est la cl\u00e9 primaire (incr\u00e9mentation automatique), le deuxi\u00e8me champ est l’emplacement de l’URL qui a \u00e9t\u00e9 republi\u00e9e et le troisi\u00e8me est la date et l’heure.<\/p>\n
Tous les champs doivent \u00eatre correctement index\u00e9s.<\/p>\n
ALTER TABLE `twitter`\n ADD PRIMARY KEY (`id`), ADD KEY `url` (`url`,`posttime`), ADD KEY `posttime` (`posttime`);<\/code><\/pre>\n
Maintenant, si vous avez un wordpress, vous devez interroger les messages valides et en choisir un au hasard.<\/p>\n
\u00a0 \/\/ database constants\n\u00a0 require('db.php');\n\u00a0 \/\/ twitter function\n\u00a0 require('twitter.php');\n\u00a0 mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die(mysql_error());\n\u00a0 mysql_select_db(DB_NAME);\n\u00a0 $today = date(\"Y-m-d h:i:s\");\n\u00a0 \/\/ get total number of valid posts\n\u00a0 $query = \"\n \u00a0 \u00a0 \u00a0select \n \u00a0 \u00a0 \u00a0 \u00a0count(1)\n \u00a0 \u00a0 \u00a0from \n \u00a0 \u00a0 \u00a0 \u00a0`wp_posts`\n \u00a0 \u00a0 \u00a0where \n \u00a0 \u00a0 \u00a0 \u00a0(`post_type` = 'page' or `post_type` = 'post') and \n \u00a0 \u00a0 \u00a0 \u00a0(`post_status` = 'publish')\n \u00a0\";\n\u00a0 $result = mysql_query($query) or die(mysql_error());\n\u00a0 $total = mysql_result($result, 0, 0);\n\u00a0 $cnt = 0;\n\u00a0 if ($total > 0) {\n\u00a0 \u00a0 while (1) {\n\u00a0 \u00a0 \u00a0 \/\/ pick a random npost\n\u00a0 \u00a0 \u00a0 $idx = mt_rand(0, $total - 1);\n\u00a0 \u00a0 \u00a0 $query = \"\n \u00a0 \u00a0 \u00a0 \u00a0select \n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0`post_name`, `post_title` \n \u00a0 \u00a0 \u00a0 \u00a0from \n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0`wp_posts`\n \u00a0 \u00a0 \u00a0 \u00a0where \n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0(`post_type` = 'page' or `post_type` = 'post') and \n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0(`post_status` = 'publish')\n \u00a0 \u00a0 \u00a0 \u00a0limit $idx, 1\n \u00a0 \u00a0 \u00a0\";\n\u00a0 \u00a0 \u00a0 $result = mysql_query($query) or die(mysql_error());\n\u00a0 \u00a0 \u00a0 $row = mysql_fetch_array($result);\n\u00a0 \u00a0 \u00a0 \/\/ post URL\n\u00a0 \u00a0 \u00a0 $url = \"<a class=\"vglnk\" target=\"_blank\" href=\"http:\/\/www.codingforspeed.com\/\".$row['post_name'].\"\/\" rel=\"nofollow\"><span>http<\/span><span>:\/\/<\/span><span>www<\/span><span>.<\/span><span>codingforspeed<\/span><span>.<\/span><span>com<\/span><span>\/\".$<\/span><span>row<\/span><span>['<\/span><span>post<\/span><span>_<\/span><span>name<\/span><span>'].\"\/<\/span><\/a>\";\n\u00a0 \u00a0 \u00a0 $title = $row['post_title'];\n\u00a0 \u00a0 \u00a0 $query2 = \"select date(`posttime`) from `twitter` where `url` = '$url' order by `posttime` desc limit 1\";\n\u00a0 \u00a0 \u00a0 $result2 = mysql_query($query2) or die(mysql_error());\n\u00a0 \u00a0 \u00a0 if (mysql_num_rows($result2) > 0) {\n\u00a0 \u00a0 \u00a0 \u00a0 $last = mysql_result($result2, 0, 0);\n\u00a0 \u00a0 \u00a0 \u00a0 \/\/ last reposted date\/time\n\u00a0 \u00a0 \u00a0 \u00a0 $diff = abs((strtotime($today) - strtotime($last)) \/ 24 \/ 3600);\n\u00a0 \u00a0 \u00a0 \u00a0 if ($diff <= 90) {\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 $cnt ++;\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 if ($cnt > 16) { \/\/ max retry time to avoid endless loop\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 break;\u00a0 \n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 }\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 continue; \/\/ try next random post\n\u00a0 \u00a0 \u00a0 \u00a0 }\n\u00a0 \u00a0 \u00a0 }\n\u00a0 \u00a0 \u00a0 \/\/ record the post in the table\n\u00a0 \u00a0 \u00a0 $query = \"\n \u00a0 \u00a0 \u00a0 \u00a0insert into `twitter`\n \u00a0 \u00a0 \u00a0 \u00a0set \n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0`url` = '$url',\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0`posttime` = '$today'\n \u00a0 \u00a0 \u00a0\";\n\u00a0 \u00a0 \u00a0 mysql_query($query) or die(mysql_error());\n\u00a0 \u00a0 \u00a0 $msg = \"#Repost \".$title;\n\u00a0 \u00a0 \u00a0 echo \"$msg $url\";\n\u00a0 \u00a0 \u00a0 postTwitter($msg, $url);\n\u00a0 \u00a0 \u00a0 break;\n\u00a0 \u00a0 }\n\u00a0 }<\/code><\/pre>\n
L’id\u00e9e ici est d’obtenir un message al\u00e9atoire et de v\u00e9rifier s’il a \u00e9t\u00e9 republi\u00e9 au cours des 90 derniers jours (modifiez si n\u00e9cessaire), sinon, postez-le et enregistrez-le dans la base de donn\u00e9es. Sinon, essayez les prochains messages al\u00e9atoires jusqu’\u00e0 ce qu’un certain nombre de fois aient \u00e9t\u00e9 essay\u00e9s. S’il n’y a pas de messages "valides" trouv\u00e9s (par exemple, pas de nouveaux articles pendant une longue p\u00e9riode), il le d\u00e9tectera et abandonnera la boucle.<\/p>\n
V\u00e9rifiez \u00e9galement cet article<\/a> pour obtenir une ligne al\u00e9atoire \u00e0 l’aide de SQL.<\/p>\n
La prochaine chose est de le tester correctement et de le mettre dans le crontab<\/a><\/strong>, par exemple une fois par jour.<\/p>\n
0 8 * * * php \/home\/justyy.lai\/auto.php > \/dev\/null 2>&1<\/code><\/pre>\n
La publication du message sur Twitter est personnalisable et j’ai ajout\u00e9 une balise de hachage "#Repost" pour me distinguer des autres publications normales. J’ai \u00e9galement li\u00e9 mon compte Twitter \u00e0 une page Facebook, de sorte que chaque fois que les twits sont publi\u00e9s sur Twitter, la page Facebook statut est \u00e9galement synchronis\u00e9, ce qui est beaucoup plus facile pour moi.<\/p>\n
Source d’enregistrement:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Comment faire revivre les anciens messages en utilisant PHP et Crontab<\/p>\n","protected":false},"author":1,"featured_media":220869,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[675,893,832,993,801,841,862],"tags":[1167],"class_list":["post-232856","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bloguer","category-code-2","category-guide-pour-les-debutants","category-marketing-de-contenu","category-php-3","category-tutoriels","category-wordpress-3","tag-affiai-fr"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/posts\/232856","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/comments?post=232856"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/posts\/232856\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/media\/220869"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/media?parent=232856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/categories?post=232856"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/tags?post=232856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}