Jump to content
The Uniform Server Community

Database table refrencing Site HTML?


Heinz Stapff
 Share

Recommended Posts

Building My first MySQL database for wholesale products site using myphpAdmin. I'm guessing that as I am trying to work from the server to create the site I should have a list of the html elements in the HTML pages in the order of the HTML set in a table. Something like this;

 

SITE_TABLE

 

FIELDS:|Id---------|HTML_Id|HTML_NAME|Description|Classes|Onchange|Image--------|Function_name

--------------------------------------------------------------------------------------------------------------------

TYPE:--|PRIMARY+|INDEX---|UNIQUE-----|Text( )-----|ENUM---|INT+-----|VARCHAR( )---|VARCHAR( )

---------------------------------------------------------------------------------------------------------------------

EXPL:--|List of------|#logo--|logo---------|Site Head--|.logo----|counter--|logo.jpg-------|logoOnchange

---------|HTML-------|or-------|or------------|Company--|.Article--|eg. How-|in images-----|in scripts

---------|elements--|id=" "?-|name=" "?-|Logo--------|.Prod----|many-----|sunglasses--|Index.js

---------|in order on|syntax?|syntax?----|as is--------|Drop-----|times-----|syntax?-------|syntax?

---------|page-------|question|question--|Shown-----|down----|occur-----|question------|question

 

The syntax? questions are there to ask what form I should use to use php to manipulate the site best like activating '../scripts/index.js/logoOnchange or loading ../images/sources/logo.jpg. sql Escape characters might be applied to the fields like ../%images/%sources/%logo.jpg to overide sql statement for field input values as long as the images and scripts can be loaded using that value.

Again, I don't know what is best for php use.

Almost imposable to type.

Any advice greatly appreciated :(

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...