Online ordering and inventory system

5.2.3 Macromedia Dreamweaver

Is the best tool (software) to create professional websites and is now the easiest tool to build attractive website. For the first time we can work in single environment to quickly create, build an internet application. The back-and of the system which is the database was designed using MY SQL.

5.2.4 My SQL

MySQL, pronounced either "My S-Q-L" or "My Sequel," is an open source relational database management system. It is based on the structure query language , which is used for adding, removing, and modifying information in the database. Standard SQL commands, such as add, drop, insert, and update can be used with MySQL.

MySQL can be used for a variety of applications, but is most commonly found on Web servers. A website that uses MySQL may include Web pages that access information from a database. These pages are often referred to as "dynamic," meaning the content of each page is generated from a database as the page loads. Websites that use dynamic Web pages are often referred to as database-driven websites.

Many database-driven websites that use MySQL also use a Web scripting language like PHP to access information from the database. MySQL commands can be incorporated into the PHP code, allowing part or all of a Web page to be generated from database information. Because both MySQL and PHP are both open source (meaning they are free to download and use), the PHP/MySQL combination has become a popular choice for database-driven websites.

5.2.5 Apache

Apache is primarily used to serve both static content and dynamic Web pages on the World Wide Web. Many web applications are designed expecting the environment and features that Apache provides. Apache is the web server component of the popular LAMP web server application stack, alongside My SQL, and the PHP /Perl /Python programming languages. Apache is used for many other tasks where content needs to be made available in a secure and reliable way.

One example is sharing files from a personal computer over the Internet. A user who has Apache installed on their desktop can put arbitrary files in the Apache's document root which can then be shared Programmers developing web applications often use a locally installed version of Apache in order to preview and test code as it is being developed.

5.2.6 Php MyAdmin

Php MyAdmin is a well known and popular open-source tool written in PHP intended to handle the administration of My SQL over the Internet. Currently it can create and drop databases, create/drop/alter tables, and delete/edit/add fields, execute any SQL statement, and manage keys on fields. My SQL is the most popular open-source database, used by millions of developers and supporting numerous large dynamic websites and applications. My SQL acquired this wide popularity by virtue of its open-source nature, performance, reliability, robustness, and support for various platforms.

This popularity has also been helped by the existence of php My Admin, the industry-standard administration tool that makes database management easy for both the experienced developer and the novice. The powerful graphical interface that it provides to My SQL has made php My Admin an indispensable tool for My SQL and web developers. Every php My Admin user can benefit from unlocking the full potential of this powerful application. Whether you are an experienced developer, system administrator, web designer, or new to My SQL and php My Admin, this book will show you how to increase your productivity and control when working with your databases.

My SQL is a very popular Open Source relational database. Database is a data structure used to store organized information. A database is typically made up of many linked tables of rows and columns. For example, a company might use a database to store information about their products, their employees, and financial information. Databases are now also used in nearly all e-commerce sites to store product inventory and customer information. Database software, such as Microsoft Access, FileMaker Pro, and My SQL is designed to help companies and individuals organize large amounts of information in a way where the data can be easily searched, sorted, and updated.