Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Database system to hold html templates

Author  Topic 

acknowledged74
Starting Member

7 Posts

Posted - 2008-12-16 : 11:37:54
Hi

A company has a system setup where 50 websites are structured via a database.

I mean all 50 websites look the same but have slightly different html content, but exactly the same content.

To change the templates and therefore the layout, visual appearance of the website, is it a case of adapting the html template in my favourite editor and then just uploading to the database?

The therefore changing all 50 websites at once.

or is there likely to be some level of SQL coding involved to make the alterations?

Also how would you change the textual content of the individual website?

Sorry I have never physically used a database only via other systems, WP, Drupal etc.

thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-16 : 11:52:55
If the html templates are stored in the database, then yes you must run some SQL code to modify the data.


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

acknowledged74
Starting Member

7 Posts

Posted - 2008-12-16 : 11:56:36
Hi

I have been told that I need to change the html, actually I need to update the websites to Css rather than tables and so on, then just upload to their database ? I pressume this is done via ftp, but when I look in my existing ftp folders that have databses I can't locate the database folders.

Sorry this is I'm sure very basic stuff but I can't find adequate tutorials on Google etc.

Thanks for your patience.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-16 : 12:11:18
You can't just drop off some files into a folder and expect the database to receive them. That's just not how it works.

Have you designed the database yet?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

acknowledged74
Starting Member

7 Posts

Posted - 2008-12-16 : 12:25:26
Ok I will try and set something similar up myself. Yes I have created a database using My SQL. It seems that you nee to setup connect.php ?

But what I was really asking is that the system and the 50 websites already existing, if I am provided with the html template files how would I get them to the websites ?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-16 : 12:41:03
If you are asking about MySql, then you should post in a MySql forum. This site is for Microsoft SQL Server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

acknowledged74
Starting Member

7 Posts

Posted - 2008-12-16 : 12:57:10
No the existing 50 website database template set up is MS SQL, I use Unix at home and can't use that. Besides isn't SQL the language and MS SQL and My SQL the server.

Ok literally how are they updating the Html templates in the database that are used to build 50 websites. and therefore If I was to change the html file how would I then get it uploaded to the database and therefore all the websites ???

I was only suggesting setting something similar at home, its basically that I don't under stand uploading or whateve to a dtatbase, please forget the rest.

Thx

Ash
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-16 : 13:02:07
Well each database platform using a variation of SQL. Microsoft SQL Server uses T-SQL. Oracle uses PL/SQL. I'm not sure what the MySql one is called.

What technologies do you have? Are you able to write a programming interface to perform INSERT/UPDATE statements to get the templates into the database? Can you use SSIS?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

acknowledged74
Starting Member

7 Posts

Posted - 2008-12-16 : 13:33:45
I have been told that I need to change the html, actually I need to update the websites to Css rather than tables and so on, then just upload to their database ?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-16 : 13:38:42
We don't have enough information to help you. Is there anyone who could help you work on this and perhaps be able to ask more database specific questions to us?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

acknowledged74
Starting Member

7 Posts

Posted - 2008-12-16 : 15:41:42
I had this suggestion through Yahoo Ask

"ANOTHER possible but high crap way, if you don't move up to ASP or PHP, is to create your own template HTML website with special text place holders.
You then run your magic string replacement program (which you would neeed to write) which would then make your 50 websites for you. Pulling the content from files somehow.
Even this sounds a bit backwards, but if you need to make a change to all 50 websites then this will atleast be able to cope with that."

I have a feeling thats kind of whats being used.

expressfreightgermany.co.uk is used just with html templates and a database, I know that for sure.

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-16 : 15:57:09
I don't think we can help you with that information. It seems you are asking about non-database stuff. We specialize in SQL Server here.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

acknowledged74
Starting Member

7 Posts

Posted - 2008-12-16 : 20:50:56
Well that is what I am asking, anyway nevermind.

Maybe its just a bit of a hard one to answer, no problem I'll ask elsewhere Tara.

thanks for trying.

Go to Top of Page

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2008-12-18 : 06:36:05
If you use ASP you can use masterpages to set the style etc of the entire website.
Go to Top of Page
   

- Advertisement -