© 2016, IJARCSSE All Rights Reserved Page | 335 Volume 6, Issue 5, May 2016 ISSN: 2277 128X International Journal of Advanced Research in Computer Science and Software Engineering Research Paper Available online at: www.ijarcsse.com Webpage Generation from Enhanced Content Management System using PHP Data Objects Pardeep Kumar * , Anupama Kaur CSE Department, SUSCET Tangori Punjab, Punjab Technical University, Jalandhar, Punjab, India Abstract— Databases, what would web applications be without them, especially when we’re working with Hyper Text Pre Processor (PHP). For Modern Applications there is a wide variety of data sources that are available in market. For managing data or information there’s flat files, like Comma Separated Values (CSV) or text files. There’s databases, like My Structured Query Language (MySQL), PostgreSQL, Oracle, Firebase, Sybase, and MS SQLServer etc. Then there’s the newer NoSQL data sources, which include Hadoop, Redis, Cassandra, and MongoDb, amongst a range of other options. The safer way of sending the data to MySQL is using the prepared statements, as it prevent from getting hacked using SQL injection. This is the main reason why one should always prefer MySQLi or PDO method over MySQL. MySQLi is procedural as well as object oriented whereas PDO in Object Oriented Method. For programming object oriented programming, MySQLi and PDO and we know a lot has already been talked about how useful Object method is very much useful. MySQLi and PDO supports multiple Statements, Complex Transaction statements and has enhanced debugging capabilities and embedded server support. In this research, it is preferred to use PHP Data objects (PDO) over MySQLi as MySQLi method works on a single database which is MySQL whereas PDO method supports over 12 type of Databases. That means for shifting information from one database to another is quite easy. In research it is also found that the performance of using PDO method is far better as compared with MySQLi method. Keywords— HyperText Pre-Processor (PHP), PHP Data Objects (PDO), My Structured Query Language (MySQLi), MySQL, Database I. INTRODUCTION From the beginning when WWW - World Wide Web is invented i.e. in 1990 by a CERN – Conseil Européen pour la Recherche Nucléaire physicist named Tim Berners-Lee (Berners-Lee & Fischetti 1999), it has been playing an important role in people’s life and growing day by day. It started from a file sharing method i.e. on 2008, nowadays web services play multiple roles such Amazon defining service on online store, a place where to share different ideas (i.e. in forum), a place where anyone can upload his/ her own video and share it with worldwide (i.e. with the help of Youtube), a place like community centre (i.e. Facebook), and many more are exists. In the field of business i.e. for an organisation, a website helps in the promotion of its services and products, the company’s background, and news related to the organisations activity. As developing and maintaining a website is technically not done for many people working in that organisations and it is the major problem for same, the CMS - Content Management System comes in to help organisations to manage their website. Basically a Content Management System is a computer program that helps us or users to manage, publish, edit and modify the content as well as maintain it from a central interface (Boiko 2005; Rockley, Kostur, & Manning 2003; White 2005). One of the main features is a Web CMS which revolves around different contents of organisations that are deployed on the Web. Also this feature allows all non-technical users to control easily and manage website of an organisation with ease. Further CMS also has other features to its name, this thesis will focus on the Web part of this computer program. II. MY STRUCTURED QUERY LANGUAGE IMPROVED (MYSQLI) My Structured Query Language Improved (MySQLi) is an extension for PHP Language, and often it is referred to as MySQL improved. It was introduced in PHP 5.0, and till now it will be in every version of PHP following (until something better comes along). It also allows you to use all of the MySQL database (i.e. version 4.1.3 or newer) servers features. Some features of MySQLi are (from the PHP manual):  It’s object oriented interface, making it easier to use  Support for prepared statements, helping secure you code  Support for multiple statements, allowing you to run more than one query at a time MySQLi has procedural as well as object oriented interface. Making it even more widely usable.