{"id":234167,"date":"2023-02-04T13:32:00","date_gmt":"2023-02-04T10:32:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=234167"},"modified":"2023-02-04T13:34:32","modified_gmt":"2023-02-04T10:34:32","slug":"comment-publier-automatiquement-un-article-de-blog-sur-les-reseaux-sociaux-la-solution-universelle-avec-ifttt-et-crontab","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/fr\/comment-publier-automatiquement-un-article-de-blog-sur-les-reseaux-sociaux-la-solution-universelle-avec-ifttt-et-crontab\/","title":{"rendered":"Comment publier automatiquement un article de blog sur les r\u00e9seaux sociaux\u00a0? La solution universelle avec IFTTT et Crontab"},"content":{"rendered":"\n

Publier r\u00e9guli\u00e8rement les messages sur les r\u00e9seaux sociaux aide \u00e0 augmenter efficacement le trafic du site, par exemple Facebook<\/a>, Twitter<\/a>, Tumblr<\/a>. C’est certainement bien si nous pouvons automatiser ce processus. Avec l’utilisation d’ IFTTT<\/a> et de crontab, cela devient facile.<\/p>\n

Cha\u00eene IFTTT Maker<\/h2>\n

Le canal Maker dans IFTTT peut \u00eatre d\u00e9clench\u00e9 par la "r\u00e9ception d’une requ\u00eate Web", et il prend en charge jusqu’\u00e0 3 param\u00e8tres, c’est-\u00e0-dire value1, value2 et value3 au format JSON<\/a>. Par exemple, vous pouvez invoquer l’\u00e9v\u00e9nement SayHi avec deux param\u00e8tres {\u00ab\u00a0value1\u2033:"Hello",\u00a0\u00bbvalue2\u2033:\u00a0\u00bbComputing\u00a0\u00bb}.<\/p>\n

curl -X POST -H \"Content-Type: application\/json\" -d '{\"value1\":\"Hello\",\"value2\":\"Computing\"}' <a class=\"vglnk\" target=\"_blank\" href=\"https:\/\/maker.ifttt.com\/trigger\/{SayHi}\/with\/key\/REPLACE_KEY\" rel=\"nofollow\"><span>https<\/span><span>:\/\/<\/span><span>maker<\/span><span>.<\/span><span>ifttt<\/span><span>.<\/span><span>com<\/span><span>\/<\/span><span>trigger<\/span><span>\/{<\/span><span>SayHi<\/span><span>}\/<\/span><span>with<\/span><span>\/<\/span><span>key<\/span><span>\/<\/span><span>REPLACE<\/span><span>_<\/span><span>KEY<\/span><\/a><\/code><\/pre>\n
Publication sur les r\u00e9seaux sociaux via IFTTT<\/h2>\n
Il est simple de cr\u00e9er une nouvelle applet (r\u00e8gle IFTTT<\/a>) avec Maker et le r\u00e9seau social de votre choix par exemple Facebook<\/a>. En outre, vous devez sp\u00e9cifier le nom de l’\u00e9v\u00e9nement pour que le Maker fonctionne (qui est la partie "ceci" de l’IFTTT).<\/p>\n
maker-recevoir-une-requ\u00eate-web<\/p>\n
Ensuite, vous devez sp\u00e9cifier l’action (qui est la partie ‘cette’ de IFTTT<\/a> ).<\/p>\n
\"Comment<\/a><\/p>\n
maker-configuration des param\u00e8tres value1, value2 et value3<\/p>\n
Script PHP automatique<\/h2>\n
Maintenant, nous pouvons \u00e9crire un script PHP pour automatiser cela\u00a0: choisissez une publication (par exemple al\u00e9atoire ou par ID) qui n’a pas \u00e9t\u00e9 publi\u00e9e au cours des 90\u00a0derniers jours, par exemple, placez le lien dans la base de donn\u00e9es et invoquez le canal Maker qui d\u00e9clenche la r\u00e8gle. pour publier sur le r\u00e9seau social de votre choix.<\/p>\n
Pour WordPress, si nous choisissons un article au hasard, le script PHP<\/a> ressemblera \u00e0 ceci :<\/p>\n
<?php\n\u00a0 \/\/ <a class=\"vglnk\" target=\"_blank\" href=\"https:\/\/helloacm.com\/how-to-prevent-script-running-from-browsers\/\" rel=\"nofollow\"><span>https<\/span><span>:\/\/<\/span><span>helloacm<\/span><span>.<\/span><span>com<\/span><span>\/<\/span><span>how<\/span><span>-<\/span><span>to<\/span><span>-<\/span><span>prevent<\/span><span>-<\/span><span>script<\/span><span>-<\/span><span>running<\/span><span>-<\/span><span>from<\/span><span>-<\/span><span>browsers<\/span><span>\/<\/span><\/a>\n\u00a0 require('deny-from-web.php'); \/\/ avoid calling from the web URL, \n\u00a0 require('db.php'); \u00a0\n\u00a0 $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, \"blog_database\");\n\u00a0 $today = date(\"Y-m-d h:i:s\");\n\u00a0 $query = \"select \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` = 'post') and \n \u00a0 \u00a0 \u00a0 \u00a0(`post_status` = 'publish')\n \u00a0\";\n\u00a0 $result = mysqli_query($connection, $query);\n\u00a0 $row = mysqli_fetch_row($result);\n\u00a0 $total = $row[0];\n\u00a0 $cnt = 0;\n\u00a0 if ($total > 0) {\n\u00a0 \u00a0 while (1) {\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`, `ID`, `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` = '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 = mysqli_query($connection, $query);\n\u00a0 \u00a0 \u00a0 $row = mysqli_fetch_array($result);\n\u00a0 \u00a0 \u00a0 $url = \"<a class=\"vglnk\" target=\"_blank\" href=\"https:\/\/helloacm.com\/\".$row['post_name\" rel=\"nofollow\"><span>https<\/span><span>:\/\/<\/span><span>helloacm<\/span><span>.<\/span><span>com<\/span><span>\/\".$<\/span><span>row<\/span><span>['<\/span><span>post<\/span><span>_<\/span><span>name<\/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 = mysqli_query($connection, $query2);\n\u00a0 \u00a0 \u00a0 if (mysqli_num_rows($result2) > 0) {\n\u00a0 \u00a0 \u00a0 \u00a0 $lastrow = mysqli_fetch_row($result2);\n\u00a0 \u00a0 \u00a0 \u00a0 $last = $lastrow[0];\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) {\/\/ 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;\n\u00a0 \u00a0 \u00a0 \u00a0 }\n\u00a0 \u00a0 \u00a0 }\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 mysqli_query($connection, $query);\n\u00a0 \u00a0 \u00a0 $msg = $title; \u00a0 \u00a0 \u00a0\n\u00a0 \u00a0 \u00a0 $value1 = $url;\n\u00a0 \u00a0 \u00a0 $value2 = $title;\n\u00a0 \u00a0 \u00a0 echo \"value2 = \". $value2. \" n\";\n\u00a0 \u00a0 \u00a0 echo \"value1 = \". $value1. \" n\"; \u00a0 \u00a0 \u00a0 \u00a0 \n\u00a0 \u00a0 \u00a0 \/\/ invoke the IFTTT Maker Channel \u00a0 \u00a0\n\u00a0 \u00a0 \u00a0 shell_exec(\"curl -s -X POST -H \"Content-Type: application\/json\" -d '{\"value1\":\"$value1\",\"value2\":\"$value2\"}' <a class=\"vglnk\" target=\"_blank\" href=\"https:\/\/maker.ifttt.com\/trigger\/{justyy}\/with\/key\/YOUR_KEY\" rel=\"nofollow\"><span>https<\/span><span>:\/\/<\/span><span>maker<\/span><span>.<\/span><span>ifttt<\/span><span>.<\/span><span>com<\/span><span>\/<\/span><span>trigger<\/span><span>\/{<\/span><span>justyy<\/span><span>}\/<\/span><span>with<\/span><span>\/<\/span><span>key<\/span><span>\/<\/span><span>YOUR<\/span><span>_<\/span><span>KEY<\/span><\/a>\");\n\u00a0 \u00a0 \u00a0 break;\n\u00a0 \u00a0 }\n\u00a0 }\n\u00a0 echo \"Done!n\";<\/code><\/pre>\n
Pour que ce qui pr\u00e9c\u00e8de fonctionne, vous devez cr\u00e9er une table pour stocker les articles publi\u00e9s (via MySQL<\/a> ):<\/p>\n
--\n-- Table structure for table `twitter`\n--\n\nCREATE TABLE `twitter` (`id` bigint(32) NOT NULL,\n  `url` varchar(255) NOT NULL,\n  `posttime` date NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;\n\n--\n-- Indexes for dumped tables\n--\n\n--\n-- Indexes for table `twitter`\n--\nALTER TABLE `twitter`\n  ADD PRIMARY KEY (`id`),\n  ADD KEY `urla` (`url`),\n  ADD KEY `dd` (`posttime`);\n\n--\n-- AUTO_INCREMENT for dumped tables\n--\n\n--\n-- AUTO_INCREMENT for table `twitter`\n--\nALTER TABLE `twitter`\n  MODIFY `id` bigint(32) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;<\/code><\/pre>\n
Configuration Crontab pour la publication automatique de blogs<\/h2>\n
La derni\u00e8re \u00e9tape apr\u00e8s avoir test\u00e9 le script ci-dessus consiste \u00e0 ajouter la commande PHP<\/a> aux t\u00e2ches crontab .<\/a> Vous pouvez configurer la fr\u00e9quence, par exemple @quotidien ou @hebdomadaire, @mensuel, etc.<\/p>\n
@daily php \/path-to-your-script\/ifftt-post-blog.php<\/code><\/pre>\n
Source d’enregistrement:  helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
Comment publier automatiquement un article de blog sur les r\u00e9seaux sociaux\u00a0? La solution universelle avec IFTTT et Crontab<\/p>\n","protected":false},"author":1,"featured_media":224083,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[893,717,832,780,748,811,1016,841,862],"tags":[1167],"class_list":["post-234167","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-code-2","category-developpeur","category-guide-pour-les-debutants","category-logiciels-open-source","category-open-source-projektmanagement-2","category-plugins-2","category-sites-utiles","category-tutoriels","category-wordpress-3","tag-affiai-fr"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/posts\/234167","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=234167"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/posts\/234167\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/media\/224083"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/media?parent=234167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/categories?post=234167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/fr\/wp-json\/wp\/v2\/tags?post=234167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}