database driven stylesheet

tbobker

am designing a website that has a database driven stylesheet which will enable me to change the style of the site through admin forms and so on.

Im not sure how i can design the database, any tips that people may have in designing such a database would be useful.

So far i have decided to use the class as my PK, and then rows which include;

background
border
font_color
font_face
font_size
width
height

If anyone has done this before please give me some tips.

it was in coding forum sorry.

thorpe

Id'e probably be inclined to create to tables, one for the name of your defintion, and one to store all the key - value attributes. eg;

CREATE TABLE style (
  id INT PRIMARY KEY,
  def VARCHAR(80)
)
CREATE TABLE attributes (
  id INT PRIMARY KEY,
  style_d INT,
  att VARCHAR(80),
  val VARCHAR(80)
)

Then... to define a style such as...

html {
  margin: 0px;
  padding: 0px;
}

You would simply insert data like...

INSERT INTO style (def) VALUES ('html');
INSERT INTO attributes (style_id,att,val) VALUES (1,'margin','0px');
INSERT INTO attributes (style_id,att,val) VALUES (1,'padding','0px');

This assumes that the definition for html has an id of 1.

tbobker

Not sure what you mean by the definition. Is it a PK, unique identifier. But how does it link in with the other table? Would i have to use a join to query it and extract the information? Im confused!