Adding a new page

[crackafaza]

Hi all

I am creating my own personal CMS at the moment, but I am having difficulty at one of the tasks.

I want the CMS to be able to create a new page, how do I go about doing this? Any tutorials out there?

And what database fields are needed, if any?

Thanks
Cracka

[RohanShenoy]

1. Make a database tabe for "Pages".
2. Create fields such a Title, body, by, time, etc.
3. When you want to add a new page, just run a INSERT query!

[crackafaza]

Hi

Thanks for the quick reply.

What are the exact fields in my database then? or does all this depend on what you are doing with the website?

What are the properties I need for each fields, such as varchar? etc!
Any help would be greatly received

Thanks

Cracka

[RohanShenoy]

What field of what type is your choice. But remember the auto-incrementing field should be INT(integer) type, else it returns an error!

[crackafaza]

Sorry for not understanding!
But could you please rephrase, because I don't understand!

Sorry!

[RohanShenoy]

In general, you would need following fields:
1. id - integer
2. title- varchar
3. date and time- varchar
4. by -varchar
5-body- text
and so on!

[alexgeek]

Okay this should help, run this SQL query to create a table.

Code: Select all

create table pages (
id INT(50) not null auto_increment,
title VARCHAR(50) not null,
date int(13) not null,
user varchar(35) not null,
pagetext TEXT not null
)

[JustinStudios]

Of course.. you can do this without using a database as well... Personally I steer clear of databases as much as possible because I'd rather it be there permanently.

You can do this by using PHP's file system. HERE is some good stuff on it.