Jump to content
The Uniform Server Community

Recommended Posts

Posted

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 :(

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...
×
×
  • Create New...