. Integrating Database.
Database integration in code igniter we just need to install the codeigniter and manually create the database table for project according to requirement. Code igniter allow us to extend predefine library for reducing the extra coding .This database table define previously are manually created according to project requirement.
2. Database connectivity.
- Connecting PHP shopping Cart to MySQL Database.
Database connectivity in codeigniter is done by setting a parameter in the database.php for connecting a particular database to required project. To connect manually to a desired database you can pass an array of values:
In the database.php:
$config['hostname'] = "localhost";
$config['username'] = "root";
$config['password'] = "mypassword";
$config['database'] = "mydatabase";
$config['dbdriver'] = "mysql";
$config['dbprefix'] = "";
$config['pconnect'] = FALSE;
$config['db_debug'] = TRUE;
$config['cache_on'] = FALSE;
$config['cachedir'] = "";
$config['char_set'] = "utf8";
$config['dbcollat'] = "utf8_general_ci";
$this->load->database($config);
Web based system programming
A) Server Side Processing:
Server side processing is undoubtedly a strong tool in website designing, giving a site with a high level of intelligence which can be quite stunning. It can be elaborated as a process of code that happens on the server when one sends a request for a specific webpage. In alternative words, once a user queries up their browser, and tries to view the webpage, the server reads through the code to ascertain if there are any changes or calculations variations required to apply and so it produces the webpage to send to the visitor who has send the query.
a) .htacess:
It is configuration file which include d...
... middle of paper ...
...amless development. The factor that makes CodeIgniter completely different over many such similar tools is rich set of libraries that deliver the wonderful assortment of code events and choices.
PHP frameworks:
PHP functions on the Model View Controller (MVC) fundamentals. MVC is an architectural pattern whose concepts are used in various popular programming languages that distinguishes the domain logic and the user interface. The domain logic can be elaborated as the entity that handles processed data interchange among database and user interface.
The following figure clearly illustrates the flow of a MVC:
Fig11: MVC function.
b) MySQL :
The system consists of the MySQL database, it is the most widely used open source database in the World.
Open source software development is taking place all over the world where part of the community develops individual modules, becoming necessary to establish standards and common definitions for open source software. These standards are established to define interaction between modules to insure interoperability of software. Software components which follow specific open standards can be replaced with other standard-compliant product, which allows the user more freedom to choose the component best suited to his needs and is not bound to a particular product, as with commercial software (Chauhan)
The first database systems were based on the network and hierarchical models. A database can be defined as a collection of non-redundant data which can be shared by different application systems. A database implies separation of physical storage from use of the data by an application program to achieve program/data independence. Using a database system, the user or programmer or application specialist need not know the details of how the data are stored and such details are usually "transparent" to the user. .
Technologies advance so quickly that it seems no sooner has one technology become widely accepted than it is replaced by something newer and superior. Technologies in the field of web design are no exception. As web-related hardware and software components became faster, more reliable, and easier to use, the web exploded with new websites which led to a dramatic increase in web usage around the world.
In an SQL database like MySQL, or Oracle, it executes queries, retrieves or updates data, and even deletes or creates new records. SQL is a lightweight language that is declarative and does a lot of heavy lifting for the relational database, thus it may act like a server side script but only database version of it.
Microsoft Access is a database engine and development environment in one package. It is typically workstation-based, and designed to be easy to use, even for users with no experience. However, it also provides advanced functionality for experienced users. MySQL is the largest open-source RDMBS, and it is server-based, as well as the rest of the DBMS that will be discussed. According to the mysql.com website, it offers high reliability and performance, easy use and deployment, freedom from platform lock-in by providing ready access to source code, and cross-platform support. SQL Server is an enterprise class RDBMS from Microsoft. It is part of the Back Office Suite of products. Although it is always server-based in production, it can be client-based in development. DB2 is also an enterprise-class DBMS, produced by IBM. It offers some object-oriented functionality, as well as cross-platform compatibility, and is server-based. Finally, Oracle offers much of the same functionality as DB2, with cross-platform capability, and some object-oriented features. It, as well, is server-based.
The database application design can be improved in a number of ways as described below:
A database is a collection of data which is organized and easy for users to find data. Database can record massive amount of data, it can be use for business and organization’s purpose. Every organization should have database security to secure the information of the organization.
A database management system, or DBMS, gives the user access to their data and helps them transform the data into information. Such database management systems include dBase, Paradox, IMS, and Oracle. These systems allow users to create, update, and extract information from their databases. Compared to a manual filing system, the biggest advantages to a computerized database system are speed, accuracy, and accessibility.
Satzinger, Jackson & Burd (2010, pp. 488) further states that DBMS “provide designers, programmers and end users with sophisticated capabilities to store, retrieve and manage data”. Sharing and managing the vast amount of data needed by a modern organisation simply would not be possible without a database management system.
Databases are becoming as common in the workplace as the stapler. Businesses use databases to keep track of payroll, vacations, inventory, and a multitude of other taske of which are to vast to mention here. Basically businesses use databases anytime a large amount of data must be stored in such a manor that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user. Databases are used extensively where I work. In fact, since Hyperion Solutions is a database and financial intelligence software developing company we produce one. To keep the material within scope I shall narrow the use of databases down to what we use just in the Orlando office of Hyperion Solutions alone.
Database management system (DBMS) is a collection of interrelated data and a set of programs to access the data. The collection of data, usually referred to as a database, contains the information related to the Company, the company's system at workplace, detailed information as an example employee personal information stored in the data. The goal of a database management system is to provide a way how to store and retrieve data information more efficiently. For examples, of the data, consider the name, telephone number and address are known, the recorded data is indexed address book, can be stored on a floppy disk, using a personal computer and software such as dBase IV or V, Microsoft Access or Excel
PHP is suitable used in web development and also can be embedded into HTML. Besides, PHP scripts are usually used in three main areas which are server-side scripting, command line scripting and writing desktop applications. Usually, PHP used to read data and information from databases, and to add or update the databases content. A single PHP template can be written to retrieve and display the databases records. PHP is a language developed by Rasmas Lerdorf which originally an abbreviation of “Personal Home Page (tools)” (Motive Glossary, 2004). PHP is a recursive programming where the command can be used over and over again to gain data. Before this, this language has been said that has been widely used in server-side scripting (Motive Glossary, 2004), which is can do anything that are related to any other computer graphic image (CGI) program likes collect data, generate dynamic page content or send and receive cookies. This language can be used in any operating systems, including Linux, Microsoft Windows, Mac OS X, and RISC OS. Each of the programming language has its function and same goes with PHP language which are can output images, form a server-side cache for content and easily output any text such as XHTML and XML file. Example code of PHP language that used in developing program can be seen in Table 1. PHP code can be inserted into the HTML webpage
These approaches also have some limitations, in part due to differences between web applications and systems developed and operated under more traditional paradigms. Among these differences, we consider three in particular.
The Database Management System (DBMS) is software that enables the users to define, create, maintain and control the access to the database. It is a software that interact with the user’s applications programs and it database. Meanwhile, information retrieval system is a system that involved the activity that the systems obtain the information. The obtaining information action need the information from it resources.