Expert Coder

Friday, 14 November 2014

How to use multiple databases dynamically in CakePHP

This is my final solution.

<?php
class AppModel extends Model
{
/**
   * Connects to specified database
   *
   * @param String name of different database to connect with.
   * @param String name of existing datasource
   * @return boolean true on success, false on failure
   * @access public
   */
    public function setDatabase($database, $datasource = 'default')
    {
      $nds = $datasource . '_' . $database;
      $db = &ConnectionManager::getDataSource($datasource);

      $db->setConfig(array(
        'name'       => $nds,
        'database'   => $database,
        'persistent' => false
      ));

      if ( $ds = ConnectionManager::create($nds, $db->config) ) {
        $this->useDbConfig = $nds;
        $this->cacheQueries = false;
        return true;
      }

      return false;
    }
}
?>

And here is how I used it in my app/Controller/CarsController.php

<?php
class CarsController extends AppController
{
public function index()
{
    $this->Car->setDatabase('cake_sandbox_client3');

    $cars = $this->Car->find('all');

    $this->set('cars', $cars);
}

}
?>

Friday, 7 November 2014

How to call a layout in Controller in Zendframework2

Zend Framework 2

-:: Step 1 ::-
Create layout file
========================================================================
First Create a directory in your module,
Suppose we have User module, and I would like to add login page layout
then, create module/User/view/layout/login.phtml file into this directory
========================================================================

-:: Step 2 ::-
Call layout into your Controller Action
========================================================================
Simply Call the layout this way into
your controller

$this->layout('layout/login');

========================================================================

View Helper - InlineScript : Use InlineScript for HTML Body Scripts

How To Use InlineScript for HTML Body Scripts

he HTML <script> element is used to either provide inline client-side scripting elements or link to a remote resource containing client-side scripting code.
The InlineScript helper allows you to manage both. It is derived from HeadScript, and any method of that helper is available;
however, use the inlineScript() method in place of headScript();

===============================================
Note::Use InlineScript for HTML Body Scripts
InlineScript, should be used when you wish to include scripts inline in the HTML body.
Placing scripts at the end of your document is a good practice for speeding up delivery of your page,
particularly when using 3rd party analytics scripts.
Some JS libraries need to be included in the HTML head; use HeadScript for those scripts.
===============================================

-:: Basic Usage ::-
Add to the layout script:
===============================================<body>

    <?php
    echo $this->inlineScript()->prependFile($this->basePath('js/vendor/foundation.min.js'))
                              ->prependFile($this->basePath('js/vendor/jquery.js'));
    ?>
</body>

===============================================
-:: Output ::-
===============================================

<body>
    

    <script type="text/javascript" src="/js/vendor/jquery.js"></script>
    <script type="text/javascript" src="/js/vendor/foundation.min.js"></script>
</body>

===============================================
-:: Capturing Scripts ::-
Add in your view scripts:
===============================================

$this->inlineScript()->captureStart();
echo <<<JS
    $('select').change(function(){
        location.href = $(this).val();
    });
JS;
$this->inlineScript()->captureEnd();

===============================================
-:: Output ::-
===============================================<body>

<script type="text/javascript" src="/js/vendor/jquery.js"></script>
    <script type="text/javascript" src="/js/vendor/foundation.min.js"></script>
    <script type="text/javascript">
        //
    </script>
</body>

-:: More Details On ::-
===============================================| Source:: http://framework.zend.com/manual/2.2/en/modules/zend.view.helpers.inline-script.html |===============================================

Thursday, 6 November 2014

Flash Message on view File in Zend2

FlashMessenger Documentation
Going by the documentation a simple use case for the flashMessenger would look like the following:
http://zf2.readthedocs.org/en/latest/modules/zend.mvc.plugins.html#the-flashmessenger

Step 1.
======================================================
Add Plugin on your Controller
======================================================
------------------
------------------
Use Zend\Mvc\Controller\Plugin\FlashMessenger <- Add this Plugin on your controller
------------------
------------------

Step 2.

In Controller, Your Code may be like this

public function commentAction()
{
    // ... display Form
    // ... validate the Form
    if ($form->isValid()) {
        // try-catch passing data to database
    --------------------------------------------------------------------------
    |    $this->flashMessenger()->addMessage('Thank you for your comment!'); |
    --------------------------------------------------------------------------
        return $this->redirect()->toRoute('blog-details'); //id, blabla
    }
}

public function detailsAction()
{
    // Grab the Blog with given ID
    // Grab all Comments for this blog
    // Assign the view Variables

    return array(
        'blog' => $blog,
        'comments' => $comments,
        -------------------------------------------------------------
        | 'flashMessages' => $this->flashMessenger()->getMessages() |
        -------------------------------------------------------------
    );
}

In Short, For Set the message Simply Call
$this->flashMessenger()->addMessage('Your Message Goes Here');

For Get the Message and set for view file, simply Call
$flashMessages = $this->flashMessenger()->getMessages();

Here $flashMessages is ready for to set the value for showing the message

How to create helper in zend 2 for View file

As you can see by its name this is a class that you can call or access it in your view file.
So when you need a class in your view file like a function to calculate total or anything else.
You need to create “view helper” it’s difference with "action helper" because "Action helper" is intended to just call from action controller.

Step 1:
-----------------------------------------------------------------------
1. create a new directory and new file.
-----------------------------------------------------------------------

your_module_name/src/your_module_name/view/Helper/Foohelper.php
e.g Suppose you want to create a helper for User Module, file path should be like this

module/User/src/User/view/Helper/Foohelper.php

Step 2:
-----------------------------------------------------------------------
Add new file in it :

-----------------------------------------------------------------------

<?php
namespace User\View\Helper;
use Zend\View\Helper\AbstractHelper;

class Foohelper extends AbstractHelper
{
    public function __invoke()
    {
        return $this;
    }

    public function fooMethod( $test ){
        echo $test;
    }

    public function barMethod(){
        echo 'hai';
    }

}

Step 3:
-----------------------------------------------------------------------
Edit your Module.php Of User Module
-----------------------------------------------------------------------

    public function getViewHelperConfig()
    {
        return array(
            'factories' => array(
                'foo_helper' => function($sm) {
                    $helper = new View\Helper\Foohelper ;
                    return $helper;
                }
            )
        );
   }

Step 4:
-----------------------------------------------------------------------
How to use it in your view file :
-----------------------------------------------------------------------

<?php echo $this->foo_helper()->fooMethod('hello'); ?>

Framework