Login

08-06-2010, 04:55 AM

[eluser]ruizpi[/eluser]
Hi, again!
It's a pleasure to know that somebody can help to one. i will explain a little my problem. I have used this component with the server side example in my database and works well. I test it with your model and my controller and my view but it doesn´t show datas from my table.
My view is like shows:

Code:
&lt;html &gt;

&lt;head&gt;

&lt;title&gt;&lt;?php $titulo_pagina?&gt;&lt;/title&gt;

&lt;link rel="stylesheet" href="../css/misclases.css" type="text/css" /&gt;

&lt;link rel="stylesheet" href="../../../css/demo_table.css" type="text/css" /&gt;

&lt;link rel="stylesheet" href="../../../css/demo_page.css" type="text/css" /&gt;

[removed][removed]

[removed][removed]

[removed]

 $(document).ready(function()

        {

          $('#test').dataTable

          ({

            'bProcessing'    : true,

            'bServerSide'    : true,

            'sPaginationType': 'full_numbers',

            'sAjaxSource'    : '&lt;?php echo base_url();?&gt;ethyria/listener',

            'fnServerData': function(sSource, aoData, fnCallback)

            {

              $.ajax

              ({

                'dataType': 'json',

                'type'    : 'POST',

                'url'     : sSource,

                'data'    : aoData,

                'success' : fnCallback

              });

            }

          });

        });

[removed]

&lt;/head&gt;

  &lt;body&gt;

    <div id="Contenedor">

     <div id="BarraIzq">

       <img src='/images/logopine.png' border='0' width='150' height='60' alt='logopine.png (1.095 bytes)'>

       &lt;?php echo br(3);?&gt;

       <table align="center" class="MiTablaMenu">

          <tr>

            <td class="TDMenu"><font class="MiFuenteTituloMenu">MENU</font></td>

          </tr>

          <tr>

          <td class="CeldaTransparente">&lt;?php echo nbs(2);?&gt;</td>

          </tr>

          <tr>

            <td class="TDMenu">

              &lt;?php

                 $Opcion1 = "TAGSMCR";

                 echo anchor('/ethyria/VerTagsMcr',"<button type='submit' class='MiBotonPine'>".$Opcion1."</button>", array('class' => 'SinSubrayadoEnlace'));

              ?&gt;

            </td>

          </tr>

          <tr>

            <td class="TDMenu">

              &lt;?php

                 $Opcion1 = "OPCION 2";

                 echo anchor('/ethyria/VerTagsMcr',$Opcion1,array('class' =>'MiBotonPine'));

              ?&gt;

            </td>

          </tr>

          <tr>

            <td class="TDMenu">

              &lt;?php

                 $Opcion1 = "OPCION 3";

                 echo anchor('/ethyria/VerTagsMcr',$Opcion1,array('class' =>'MiBotonPine'));

              ?&gt;

            </td>

          </tr>

       </table>

     </div>

     <div id="BarraSup">

        <font class="MainFuente">Ethyria Web Access</font>

     </div>

     <div id="MarcoInterior">

          <table id="test" class="display">

          <thead>

            <tr>

              <th>Id</th>

              <th>Tagno</th>

              <th>Descripcion</th>

              <th>Ubicacion</th>

            </tr>

          </thead>

          <tbody>

            <tr>

              <td>loading...</td>

            </tr>

          </tbody>

        </table>

      </div>

    </div>

&lt;/body&gt;

&lt;/html&gt;

My controller is:

Code:
&lt;?php

  class ethyria extends Controller{

      function __construct()

      {

          parent::Controller();

          $this->load->helper(array('html','form','url'));

          $this->load->helper('text');

          // es lo mismo que poner $this->load->helper(Array('html','form','url'));

          $this->load->library('form_validation');

      }

      function index()

      {

          $this->form_validation->set_rules('usuario','Nombre de usuario', 'required');

          $this->form_validation->set_rules('password','Contraseña', 'required|min_length[5]');

           // %s hace referencia al segundo parametro

          $this->form_validation->set_message('required', 'Debe introducir el campo %s');

          $this->form_validation->set_message('min_length', 'Campo %s demasiado corto');

          //    $this->form_validation->set_rules('EdUsuario','Alberto','required');

          //    $this->form_validation->set_rules('EdPassword','44038930','required');

          if ($this->form_validation->run()==FALSE)

          {

              $this->load->view('v_login');

          }

          else

          {

             $this->load->library('table');

             $this->load->model('Ethmodel','',TRUE);

             $usuario = $this->input->post('usuario');

             $password = $this->input->post('password');

             $TieneAcceso = $this->Ethmodel->Tiene_Acceso_Usuario($usuario,$password);

             if ($TieneAcceso==TRUE)

             {

                    $data['titulo_pagina']= 'Ethyria Web Access';

                    $this->load->view('v_view_menu',$data);

             }

             else

                    $this->load->view('v_login');

          }

      }

      function VerTagsMcr()

      {

         $this->load->model('Ethmodel','',TRUE);

         $data['consulta'] = $this->Ethmodel->SacaTagsMcr();

         $this->load->view('v_view_menu',$data);

       }

       public function listener()

       {

         $table = "tagsmcr";

         $columns = array("id","TagNo", "Descripcion", "Ubicacion");

         $index = "id";

         $this->load->model("Datatables_model", "datatables");

         echo $this->datatables->generate($table, $columns, $index);

       }

  }

?&gt;

I have attached a image what i see when i access to "tagsmcr" button.
To be grateful to him for anticipated for his efforts for helping myself