why people put data into db

i notice alot of people put the data into db and then display it by using php but they don't have a cms like wordpress, joomla and some other free CMS. i want to know wht is the advantage to put data into db without running a CMS. (except no duplicate entry)

 

You will have much more power using the SQL queries rather than dealing with files .


read this for more info :

http://www.eng.mu.edu/corlissg/168Search.03F/n_files_vs_db.html

 

well if they r running a static web then by using db for displaying will this web know as dynamic web ( not fully dynamic)

but its like a static web

 

Well, it depends. Putting the contents in a database means that they just need to create one set of templates and use the database to populate the page using that template.

Also at the same time, if it is in the database, you can have online search for the site while if it is just static html pages, you cannot do keyword searches.

 

yes you can make a static site from a db , if the info is the same all the time , usualy what they will do is use the php cache function to minimize the sql queries .

 

can u elaborate it

 

is it like dynamic website? and 2nd question is womenxite.com an example of this kind of web which about jalpari is talking?

 

If you put your data into a database you cat manage it easily.
You will use the data dinamicaly, but dinamic pages can be transformed into static ones by using url rewrite rules.

 

Well, as for the searches. Static HTML pages cannot be searched on. Say if you have 1,000 pages and your visitor wants to search for a specific keywords through your entire website, it would not be possible if all are HTML files or static files. If they are in a database, the script can have a 'Select' SQL state to bring up all the pages which contains that keywords. It gives it sort of an element of dynamic contents.

As for the Templating. If you have a dynamic website with a database backup, you do not need to make 1,000 pages in that site, you just need to make 1 or 2 template files which will be the templates for your 1000 pages. So if you change the design, you just need to make changes to 1 page instead of 1,000 pages.

 

just analogy :

wordpress is database driven blog, every aspect of wordpress stored in database and powerfull enough for low and medium traffic site . On the other site blogspot is example of dynamic data input by end user translated into static .html content.

for heavy traffic site, using database driven blog/website isn't good since overhead to database server very high. Using cache is alternative way to overcome it.

Handling data in database is easier than using flat file or make static content via web editor like dreamweaver or ms-frontpage. Just input your data into db and engine(wordpress, joomla, drupal etc) take the rest

 

is www.womenxite.com an example of this kind of web about which jalpari is talking?

 

anyhelp about womenxite?

 

can it happens by using data binding feature in dreamweaver MX?

 

womenxite is using databases and PHP to manage the data, but is not very good optimised for the search engines

 

If there is enough content I think that it is definitely worth using a CMS rather than just a static site. Aside from the points already mentioned, it means that the entire site is much more expandable, so potentially comments could be written, etc. (Arguable you should just use a blog if this is your intention but still)

 

Putting data into DB
1] Gives you the freedom to make a single template & then use queries to retrieve the data
2] Its clean & easily understandable coding
3] Makes it easy to edit pages

- Parag

 

@zzzttt, regarding SEO, how do crawlers treat sites that store content in a DB? Is that content indexed at all ? Even if you can manage content more easily you still want to be ranked as high as possible.

 

Jalpari data is the most important resource of any website. Storing the data in to database instead of making a static page will much safer and easier to handle those data for further process.

Such process are

Suppose someday you want to change the layout of your page.Then you need to create a page design the template and then you need to copy the content and then add the content to new page. But if it is stored in database just you need to change the template and run a sql query to get the content.

For searching the content from database is easier where as it is not easy to search data from static page.

Use of data in different way. From static page it is not possible.

 

Even if you use databases and a PHP language to manage your data, the output is an html code. So it doesn't matter if you made a static site or a dinamic one.
So you must optimise the output, because the search engines can "see" this code. Another thing that is important wen you use dinamic content is the aspect of the URL.
For example, your url looks like
index.php?item=articles&id=23
You must rewrite the URL so that it will look like:
articles/23/ or articles/23.html or (even better) articles/the_title_of_the_article.html
If you have a lot of parameters in you url, rewriting your URL it's the right thing to do.
I'm new to this forum, but I think you can find here posts about how to rewrite url.

 

Well for now I use WordPress and I've customized my URL's to look like this: /cathegory/post_name.htm Which I think it's the best way to deal with it.

It's great that my data is indexed anyway, one more question though: In my native language (Romanian) we use characters like "ţ","ş" or "î". Are these indexed as "t","s" and "i" or "ţ","ş" or "î" ?

Hope this is also relevant to everyone else...