RSS (XML) through php + mysql?

reason
A completely unknown problem occurred due to the first call to RSS,.
currently there is a blog in the web site, but it is not a WP or other third-party suite, but a blog written by yourself, which can post, view a list of all articles, and rewrite the network address rules with htaccess.

climb
I checked the operation mode of RSS
http://raymondchou.pixnet.net.
. His practice is to build a table of numbers and import all the contents that need to be made into RSS. Finally, use php while to print out the key data of this data table, and add the tag on the RSS, such as < title > , and so on. Is this a way that I have seen so far that seems to have been made by RSS? Is this the standard method of operation?

XML Format?
because I currently connect with others, I mainly want to update my article to his post. I was given a XML Format format, and there are really a lot of tags on it.

this is one of the paragraphs:

 <startYmdtUnix>1457280000000</startYmdtUnix> //Mandatory
        <endYmdtUnix>1457480000000</endYmdtUnix>  //Mandatory
        <title>String // article title</title>  //Mandatory
        <category>String</category>  //Mandatory
        <subCategory>String</subCategory>  //Optional
        <publishTimeUnix>1457480000000</publishTimeUnix>  //Mandatory
        <updateTimeUnix>1457480000000</updateTimeUnix>  //Optional
        //Optional
        // 0 stands for general article with plain text, images and short video
        // 1 stands for long video news. Warning!!! if the article is long video news, this tag is necessary and must be 1.
        // 2 stands for the comic book.
        // 5 is for video content, only allow one video and text in contents.
        // 6 stand for trailer for a specific movie, only allow one video and text in contents.
        <contentType>0, 1, 2, 5, 6</contentType>
        <thumbnail>String // relative file of thumbnail file</thumbnail>  //Optional
        <contents> //Contain at least one of image, video, text. Can be multiple.
            <image>
                <title>String // image title</title>  //Optional
                <description>String // image caption</description>  //Optional
                <url>String // relative file path of image file</url>  //Mandatory
                <thumbnail>String // relative file of thumbnail file</thumbnail>  //Optional
            </image>
            <video>
                <title>String // video title</title>  //Optional
                <description>String // video caption</description>  //Optional
                <url>String // relative file path of video file</url>  //Mandatory
                <thumbnail>String // relative file path of thumbnail file</thumbnail>  //Optional
                <restrictedCountries>  //Optional
                    <country>String // ISO 31661 alpha2</country>
                    <country>String // ISO 31661 alpha2</country>
                    <country>... // others</country>
                </restrictedCountries>
                <width>449</width> //Optional
                <height>101</height> //Optional
            </video>
            <text>
                <content>  //Mandatory
                         <![CDATA html tag or pure text ]]>
                </content>
            </text>
        </contents>

problems arise

    Is the XML Format provided by the
  1. counterpart the same as RSS?
  2. XML Format is the way each tag RSS with me in the right direction?
  3. that is to say, when I add a new blog post, in addition to sending a copy to the number table that I originally want to display on my web site, I also send the blog content that needs to be called RSS to another RSS special data table, and then print it out to the counterpart to get it?
  4. is this method a standard practice?
  5. Does the
  6. phrase "when I add an article, the opposite party can catch it", does it refer to this RSS? Can I just send the content of the blog to the number of RSS databases, and then use php to print the articles in this database and add the tag XML Format above it?

Sorry for having a lot of questions, but it really bothers me for days

Jul.07,2021

your question is essentially one. What is RSS?
RSS is an information transmission protocol, or a format, that is agreed upon by all parties.
intuitively, RSS is a xml document generated according to the standard format . Anyone who gets this xml, can recognize those tags indicating the list of articles, which tags indicate the title, which tags represent the content of the file and the URL of this article.

all you have to do is to publish an article, regenerate the xml file in rss format corresponding to the new article list, and hang it on the external network and access it.


Rss is just a mechanism for subscribers to know if they are interested in publishing content, which is used to subscribe

.

the theory should be read by parsing the specific address through rss

.

RSS uses certain standards and formats to display articles in the form of XML. If you need to convert the original blog article into rss, you can refer to the open source RSS library
https://github.com/miniflux/p.
for parsing RSS, and generating RSS documents.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e7ac06-465e4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e7ac06-465e4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?