Questions | Login

Top / PHP / MySQL

How would MYSQL be used in a website?

demo 18 Dec 2008 10:40am
What sort of websites would use MYSQL and what would they use it for? Is it possible to find an example of an online use of MYSQL, or do users never have any contact with it?

Answers

demo 18 Dec 2008 10:53am
Users typically don't have direct contact with the MySQL server. They typically use online forms to fill out (i.e. mailing lists, contact lists, etc.).

MySQL can store anything, including an entire website.
After all, don't forget that information is just data. And data can be stored in an SQL database.

There are many uses for MySQL for various websites. CMS, Session Data, user information, phone numbers, pictures, etc.

Keep in mind that just because you can store all of this information in the database, isn't the same as saying it's the best use of a database. For instance, if you're storing the footer information for a website in a database, that's OK, but if it is in a website template, that can save the need to open a database connection, query the database for the footer, format the footer if necessary, return the information to the web browser.
demo 18 Dec 2008 10:54am
according to my experience MYSQL could be integrated with some programming languages to produce systems. Some websites that involve keeping track of users in a database combine the use of mysql and web programming language.
demo 18 Dec 2008 10:55am
Content Management and Online Forums are just a couple examples of using MYSQL database
demo 18 Dec 2008 10:58am
MySql is a Relational Database. It can store just about any piece of data, including pages for an entire website or just small pieces of data like login info.

Most interactive website use a database to store data. Users never actually see its use directly. It is hidden in various layers of the website programming.

Various web systems like Wordpress, postNuke, phpNUKE, Wikipedia, phpBB, Gallery can use it. Each of these can be installed on a website with php.

Related

Submit Answer

You must be logged in to post an answer. Please Login or Register.

Powered by phpMyAnswers.