+91 9717203377

Monthly Archives: August 2014
Uncategorized

DDL (Data Definition Language) in mysql

Data Definition Language normally known as DDL are the mysql statements or query which are used to define and modify the structure of database schema or tables. DDL have these commands: CREATE, ALTER, TRUNCATE, DROP, COMMENT, RENAME. CREATE query is to create a new table in database. Syntax of create statement is given below. CREATE […]

Read More...
Web

Common mistakes in PHP development

No doubt now a days PHP is most popular open source scripting language. PHP can run on various plateform lke Windows, Linux, Unix, Mac OS X, etc and it is compatible to all servers Apache, IIS, etc. Biggest blogging system WORDPRESS is in PHP, largest social network FACEBOOK is in PHP and it is easy […]

Read More...
Uncategorized

Canonical url

In content management application or online shopping systems, the most common thing is the same content to be accessed through multiple URLs. It can be some kind of duplicate content issues. For example www.mysite.com/search.html would be considered by search engines to be an entirely different page from www.mysite.com/search.html?country=us. It is possible that both URLs will […]

Read More...
Uncategorized

MySql Optimization

MySql database is most widely used database now a days, few tricks can be use to speed up data retrieval. For specific type of data which is frequently accessing, we can create an index to speed up. If table has no indexes, MySQL scans full table to retrieve the data, one after another, until it […]

Read More...
Uncategorized

Social Sign On Extension available

Social Sign On is an extension for opencart which provide single sign in from social networking services to your opencart store. This extension is now available at opencart store PHP 5.4 or greater version is required for Latest Facebook v4 compatibility. If your server is running with old version of PHP you can contact to […]

Read More...
Web

meta title and title tag

Metadata is data or information about data. In the HTML document tag provides metadata about the HTML document. It doesn’t display on the page, but necessary for SEO point of view and give information about page to search engine. Meta elements are typically used to specify page description, keywords, author of the document, last modified, […]

Read More...
Uncategorized

Custom post type and taxonomy

WordPress has power to display various types of content and it works based on post. Posts have post type, By default it comes with 5 types of post types i.e post, page, attachment, Revision, Navigation menu. So we can say that a single item of a content is generally called a post, and post is […]

Read More...