15 Questions about Magento Ecommerce System

15 Questions about Magento Ecommerce System

I am enlisting 15 questions related to Magento ecommerce system. If you can answer these questions, you can consider yourself as a good beginner in Magento.

To understand Magento you should cover at least following areas :

  • Store Management
  • Product Management
  • Category Management
  • Inventory Management
  • Understanding of product variables
  • Layout and themes
  • Cache Management
  • Backup and Restoration of Backup
  • Extension Overview

1. What is Magento and how it is different from other e-commerce solutions available in the market?
2. How to create new Magento extensions?…

44 questions about Database Programming in PHP

44 questions about Database Programming in PHP

1. What is Sqlite?
2. Why sqlite is being called inbuilt database in PHP?
3. How mysql can be installed?
4. How mysql can be configured?
5. What are best features of MYsql?
6. How many types of storage engine mysql supports?
7. What is different between mysql_fetch_row and mysql_fetch_array functions?
8. How mysql databases can be optimized or repaired?
9. Can we used stored procedure and triggers in mysql? Give details.
10. How transactions can be done in mysql?
11.…

13 questions about PHP configuration options

13 questions about PHP configuration options

1. How PHP configurations can be changed?
2. What are major configuration values which we usually may want to change?
3. Mention the types of values which we can set in configuration values?
4. Can we use the ini_set function anywhere in our script?
5. Can we change and restore the configuration value to its original form from a script?
6. What are error reporting settings? How they affect the script?
7. What are session related settings in PHP?
8. What are database related settings?…

28 questions about PHP programming in general

28 questions about PHP programming in general

1. How PHP is different from other programming language?
2. What are basic and main features of PHP?
3. A brief history of PHP?
4. Can we use the PHP for desktop application development?
5. What are PHP data types?
6. How we can install the PHP on windows?
7. How we can install the PHP on Linux?
8. How we can install the PHP on Mac?
9. How PHP is platform independent?
10. How we can customize the PHP behaviour in our installation?…

16 questions about File uploading and Form handling in PHP programming

16 questions about File uploading and Form handling in PHP programming

1. Do we need to do something specific to do form handling in PHP?
2. How file uploading has to be enabled in a HTML form?
3. How PHP handles file uploading process?
4. What are configuration variables available in PHP for forms?
5. What configuration variables available in PHP for file uploading?
6. What are register_globals in PHP and how these are related to forms?
7. How form data can be accessed in a PHP script?
8. How form data can be secure from bad user inputs?…

How to optimize all databases and tabels on mysql server?

How to optimize all databases and tabels on mysql server?

Optimization of database tables in mysql is a process which has to be carried out regularly to make your database in good health.

According to mysql manual,

OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows (tables that have VARCHAR, VARBINARY, BLOB, or TEXT columns). Deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. You can use OPTIMIZE TABLE to reclaim the unused space and to defragment the data file.

Integrating Zend Framework with Drupal and WordPress

Integrating Zend Framework with Drupal and WordPress

Zend Framework is not only a framework but a robust library for many kind of operations and services. While working with Drupal or WordPress sometime we found that a good library for one particular operation is already available in Zend Framework.

You can easily use Zend Framework library in your projects with bothering about its app framework and MVC structure. Drupal and WordPress both have mechanism to use Zend framework in them without doing any major work.

Drupa module for Zend Framework

Its very easy to setup and use.…