CODE (htmlphp):
скопировать код в буфер обмена
скопировать код в буфер обмена
- <form method="post" action="">
- <input name="add" type="submit" value="Записать файл" class="button" />
- </form>
- $link = mysql_connect("localhost", "root", "")
- or die("Ошибка подключения : " . mysql_error());
- mysql_select_db("ivan") or die("Could not select database");
- $sqlrss = mysql_query("SELECT id, guid, post_content, post_title, post_date
- FROM wp_posts WHERE post_status = 'publish' AND post_type = 'post' ORDER BY post_date DESC LIMIT 3");
- while ($rss = mysql_fetch_array($sqlrss, MYSQL_BOTH)) {
- $rsstitle = $rss["post_title"];
- $rsslink = $rss["guid"];
- $rssid = $rss["id"];
- $filersscenter ='
- <item>
- <title>'.$rsstitle.'</title>
- <link>'.$rsslink.'</link>
- </item>';
- }
- mysql_free_result($sqlrss);
- if ($_POST['add']){
- $fp = fopen ('rss.xml', "w");
- fwrite($fp, $filersscenter);
- fclose($fp);
- }