Book Image

Magento 1.8 Development Cookbook

By : Bart Delvaux, Nurul Ferdous
Book Image

Magento 1.8 Development Cookbook

By: Bart Delvaux, Nurul Ferdous

Overview of this book

<p>Magento is an open source e-commerce platform which has all the functionality to function from small to large online stores. Its architecture makes it possible to extend the functionalities with plugins where a lot of them are shared by the community. This is the reason why the platform is liked by developers and retailers.</p> <p>A practical developer guide packed with recipes that cover all the parts of Magento development. The recipes will start with the simple development exercises and get the more advanced as the book progresses. A good reference for every Magento developer!</p> <p>This book starts with the basics. The first thing is to create a test environment. Next, the architecture, tools, files and other basics are described to make you ready for the real work.</p> <p>The real work starts with the simple things like theming and catalog configuration. When you are familiar with this, we will move on to more complex features such as module and database development. When you have survived this, we will move on to the last part of making a shop ready for launch: performance optimization and testing. This book will guide you through all the development phases of Magento, covering the most common pitfalls through its recipes.</p>
Table of Contents (19 chapters)
Magento 1.8 Development Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Creating a database connection in Magento


Magento uses resources to connect to a database. By default, Magento uses one connection to interact with the database. In this connection, there are resources declared in the config.xml files of the modules to link the models with the right table.

In this recipe, we will use a Magento connection to read some tables and we will learn how to configure a second connection to another database, such as a third-party system.

Getting ready

Navigate to IndexController of the Packt_Helloworld module that we created in Chapter 4, Creating a Module. We will test some connections in the indexController.

How to do it...

In the following steps, we will explain how to work with multiple database connections in your script:

  1. Paste the following code in the indexAction method:

    $resource = Mage::getSingleton('core/resource');
    $connection = $resource->getConnection('core_read');
    
    $results = $connection->query('SELECT * FROM core_store')->fetchAll();
    
    Zend_Debug...