My Publishing Profile
Write a Tutorial
Creating A Php-sql Rss Feed
Views: 3736
Comments: 0
Posted: 1-26-2007
based on 4 votes.
Faves: 6 | + Faves
PHP Coding » RSS Feeds
Add to My Categories
 		 
 
Page(s): 1 2 3 4 5 Next Page
In this tutorial you will learn how to create a table in phpMyAdmin and create an RSS feed that goes along with it!
Requirements: Know basics of PHP, phpMyAdmin, notepad, mouse and keyboard.

Now let’s start with our SQL Table.
1

2

3

4

5

6

7


CREATE TABLE `news` (

  `id` tinyint(11) NOT NULL auto_increment,

  `title` text NOT NULL,

  `author` text NOT NULL,

  `content` text NOT NULL,

  PRIMARY KEY  (`id`)

);
That simply created a table called news. The table news contains 4 rows. Each row stands for something different. So in this case, we have 4 rows.


Click to enlarge

Now lets fill the table with some random text so we can see how this RSS works.
1

2

3


INSERT INTO `news` VALUES (1, ‘test1', 'BigDog', ' This is Test 1');

INSERT INTO `news` VALUES (2, ‘test2', 'BigDog', ' This is Test 2');

INSERT INTO `news` VALUES (3, ‘test3', 'BigDog', ' This is Test 3');
If you don’t understand what I did above, I just simply used INSERT TO and inserted values into each row.

Page(s): 1 2 3 4 5 Next Page
More tutorials from this author:

» No tutorials by this user.

View All Tutorials
BigDog - http://fragpegs.com
My name is Nick aka BigDog. I help run a gaming website called "FPSBANANA" or "FPSB". Its a FPS (first person shooter) website.

I love to code and try my best to learn new and useful languages. I am currently learning Java in school and hoping to get
Close