Dr Clèm's Blog

MySQLiToRSS

a PHP file that generate a RSS 2.0 feed based on content stored in a MySQL database.

Copyright (C) 2017 Clément Février

License

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

About

MySQLiToRSS is a PHP file that generate a RSS 2.0 feed based on content stored in a MySQL database. It is licensed under GPLv3. It handles sorting by date, the use of HTML in the description of an item, which allow to render the article as it appears in the feed reader, excepted for the CSS sheets, and multitag articles. It is based on Version 2.0.11 of the RSS 2.0 specification, the most up to date at the time of writing this software. Some optional items are missing because I do not use them. I might add them later (some or all). I will be pleased to add optional items if requested.

Install

1/ Clone the git repository.
You first need git.

% sudo apt install git
Then, you need to clone the git repository
% git clone https://clementfevrier.fr/git/MySQLiToRSS.git
% cd MySQLiToRSS

2/ Copy or move the file rss/index.php.dist to rss/index.php.

% cp rss/index.php.dist rss/index.php

3/ Edit the file rss/index.php and adjust the variables according to your blog's informations and database structure. This is the only required step.

% vi rss/index.php

4/ Copy, move or link the folder to the root of your website for a better looking feed URL, for example to have yourdomain.tld/rss/

% cd /var/www/html
% ln -s MySQLiToRSS/rss .

5/ Advertise your RSS feed in the webpages of your website to let web browsers know about its existence. In the header of your webpages, add the following line

<link rel="alternate" type="application/rss+xml" href="/rss/" title="RSS">
And you can also add a visible link inside your webpages by adding the line
<a type="application/rss+xml" href="/rss/">
 <img src="/images/Feed-icon.svg" alt="RSS" title="RSS">
</a>
Do not forget to adjust the href and img variables according to your case.

Dr Clément Février

I am Dr Clément Février, French, living in Grenoble. I defended my PhD on July 4th, 2016. After my defense I run as deputy deputy (not a typo) for the national parliamentary elections in the 1st circonscription of Isère for the political movement La France Insoumise.


Bonjour,
J'ai changé d'opérateur pour Red-by-SFR la semaine dernière. Après 20min, plus de paquet n'entre ou ne sorte via la "box". Après une semaine sans internet et un service technique dépassé, j’ai compris que SFR bloque ma connexion à partir du moment où il y a un relais (middle et entry guard) hébergé sur le réseau local. Il me semble que ça va à l’encontre de la neutralité du net. Quelqu’un a-t-il eu le même problème ? Que puis-je faire ?

CC @LaQuadrature @torproject

so, mastodon users, how does a computer work? heres a helpful analogy i came up with a while ago:

the CPU (the BRAIN of the computer) takes data from the RAM (kinda like the computer's BRAIN) and stores it on the hard disk (which can be thought of as the BRAIN of the computer)