[advice] how to put pages in a database?

[Theancientone]

Hi all,

A note in advance: I'm fairly new to PHP and just looking for some advice about how to create a easy way pages for my website and manage them. Thank you.


I would like some advice about creating "a sort of" content management system. I'm running an web application at home on a local server. From this application I'm working at home. From this application I would like to manage my website on the internet.

As an simple example I take a news article system in which you can add, edit, archive and delete article. Now I would like to be able to do the same thing with my webpages. So the following questions are comming to mind:

- Does this work the same way?
- If so, do I add the page markup? (html/php)
- If not, how do i start?

Thanks in advance!

Kind regards,

The ancient one

[rocknbil]

Welcome aboard Theancientone,

- Does this work the same way?

Yes.

- If so, do I add the page markup? (html/php)

PHP no, HTML "maybe". The idea is you have a templating system in place and your interface only edits important changeable areas: titles, content, meta info, etc. Your programming slurps up the content for that page and outputs it in a template like a "page." You can't do PHP because it requires execution of PHP (You can' it's just requires evaluating the content for PHP tags and executing it.)
So you might have markup in your content, but the idea is to have as little markup as possible, limiting the editing to content only.

[abushahin]

Hello, if you are going to create a cms then it most likely needs to be db driven unless there are other ways which im not familiar with. In the case of db driven then you would need to create an actual db schema which conforms to what you are trying to achieve i.e. categories to articles will be a 1:n relationship etc.
Are you familiar with er diagrams?

[Theancientone]

@Rocknbil: Thanks for your answer. I have some idea now on how to do this. As I understand it, I need to create a sort of "framework" in which i place my content (with database connection). Like a template as you said?

@Abushahin: It's not really an cms. Maybe cms like because I want to manage content (articles, blog, etc) and (if needed, I stress the if) add new pages. The main purpose is to correct language error or if something changes, I can change the content. Like Rocknbil said, it looks like I need to create an template in which I can display my content.

I guess I forgot to say that I'm not "actively" use the cms like system.

Thank you for your answers! :-)

[rocknbil]

Genius one-liner template system [webmasterworld.com]

(not database driven, and cool beans)

recent template discussion [webmasterworld.com]