Originally Said By: Jason Byrnes
on your page where you wish to output the content you create a recordset to return the content for that page.you can filter the recordset using the page column. When you store the content in the database, the page column is used to determine what page the content will be displayed on.
say you have content for the home.php page. In the page column you should have entered "home".
To output the home page content, create a recordset on home.php:
SELECT * FROM tblContent WHERE page = "home"
this will return all of the contnet areas for the home page, you can then use the recordset bindings to place the content where you wish,
Again, if you examine how the PowerCMS solution pack works, you can get a good idea of how to create your own CMS solution.
Thanks Jason. My database, albeit a rather simplistic one at the moment, is as so at the moment:
CREATE TABLE IF NOT EXISTS `content` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`content` mediumtext NOT NULL,
PRIMARY KEY (`id`)
)
What sequel do I have to add for the Page column? Would it be `page` varchar(100) NOT NULL, ???
If the PowerCMS had the option to save content to whatever page you like I would buy it and see how it works. The fact that it doesn't means that at $99 it's not a great investment unless I was also to actually use it on a web site for myself or a customer. Maybe if it came up as a special offer I would buy it.
