ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Flexigrid CodeIgniter Implementation

September 05, 2008 4:07pm

Subscribe [63]
  • #76 / May 09, 2010 4:12pm

    newbieCI

    16 posts

    I’ve problem

    my data doesn’t out to my view
    NOT appear to my page
    @oracle
    thanks

  • #77 / May 09, 2010 10:09pm

    anata_arie

    11 posts

    I’ve problem

    my data doesn’t out to my view
    NOT appear to my page
    @oracle
    thanks

    What is message error appear at http://your_domain/index.php/ajax/ ?

  • #78 / May 09, 2010 10:21pm

    newbieCI

    16 posts

    I’ve problem

    my data doesn’t out to my view
    NOT appear to my page
    @oracle
    thanks

    What is message error appear at http://your_domain/index.php/ajax/ ?


    table have appear BUT,data doesn’t appear
    JUst “Processing Please wait”

  • #79 / May 09, 2010 11:14pm

    newbieCI

    16 posts

    hello thor,

    Can you tell me what kind of URL you are using to access the application? Like http://localhost/CodeIgniter/index.php/?

    url was http://127.0.0.1/flexgrid/index.php/....

    and that was the problem. changed base_url from 127.0.0.1 to localhost 😝

     

    I’ve problem
    why my data from Database oracle can’t display my page
    just display table without data and “Processing,Please wait”

  • #80 / May 09, 2010 11:20pm

    newbieCI

    16 posts

    I’ve problem
    why my data from database oracle can’t display to table on my page
    display just table without data and “Processing,Please wait”
    thanks

  • #81 / May 09, 2010 11:44pm

    anata_arie

    11 posts

    I mean open url : http://localhost/flexgrid/index.php/ajax/

    If there are appear json data like this:
    {"page":1,"total":"8","rows":[{"id":"1","cell":["1","AF","AFGHANISTAN","Afghanistan<\/span>","AFG","4","<\/a> "]},{"id":"2","cell":["2","AL","ALBANIA","Albania<\/span>","ALB","8","<\/a> "]},{"id":"3","cell":["3","DZ","ALGERIA","Algeria<\/span>","DZA","12","<\/a> "]},{"id":"4","cell":["4","AS","AMERICAN SAMOA","American Samoa<\/span>","ASM","16","<\/a> "]},{"id":"5","cell":["5","AD","ANDORRA","Andorra<\/span>","AND","20","<\/a> "]},{"id":"6","cell":["6","AO","ANGOLA","Angola<\/span>","AGO","24","<\/a> "]},{"id":"7","cell":["7","AI","ANGUILLA","Anguilla<\/span>","AIA","660","<\/a> "]},{"id":"8","cell":["8","AQ","ANTARCTICA","Antarctica<\/span>",null,null,"<\/a> "]},{"id":"9","cell":["9","AG","ANTIGUA AND BARBUDA","Antigua and Barbuda<\/span>","ATG","28","<\/a> "]}]}

    That is mean your data has been loaded but there are some problem with your browser or something. But if there are some message error, what is it?

  • #82 / May 10, 2010 12:07am

    newbieCI

    16 posts

    I mean open url : http://localhost/flexgrid/index.php/ajax/

    If there are appear json data like this:
    {"page":1,"total":"8","rows":[{"id":"1","cell":["1","AF","AFGHANISTAN","Afghanistan<\/span>","AFG","4","<\/a> "]},{"id":"2","cell":["2","AL","ALBANIA","Albania<\/span>","ALB","8","<\/a> "]},{"id":"3","cell":["3","DZ","ALGERIA","Algeria<\/span>","DZA","12","<\/a> "]},{"id":"4","cell":["4","AS","AMERICAN SAMOA","American Samoa<\/span>","ASM","16","<\/a> "]},{"id":"5","cell":["5","AD","ANDORRA","Andorra<\/span>","AND","20","<\/a> "]},{"id":"6","cell":["6","AO","ANGOLA","Angola<\/span>","AGO","24","<\/a> "]},{"id":"7","cell":["7","AI","ANGUILLA","Anguilla<\/span>","AIA","660","<\/a> "]},{"id":"8","cell":["8","AQ","ANTARCTICA","Antarctica<\/span>",null,null,"<\/a> "]},{"id":"9","cell":["9","AG","ANTIGUA AND BARBUDA","Antigua and Barbuda<\/span>","ATG","28","<\/a> "]}]}

    That is mean your data has been loaded but there are some problem with your browser or something. But if there are some message error, what is it?

     

     


    An Error Was Encountered

    The configuration file flexigrid.php does not exist.


    But flexigrid.php have my libraries

    ajax.php

      function index()
      {
    $valid_fields = array('COMPLAIN_NO');

    $this->flexigrid->validate_post('COMPLAIN_NO','asc',$valid_fields);

    $records = $this->operator_model->get_countries();

    $this->output->set_header($this->config->item('json_header'));
    foreach ($records['records']->result() as $row)
    {
    $record_items[] = array($row->COMPLAIN_NO,
    $row->COMPLAIN_NO,
    );
    }
     
          $this->output->set_output($this->flexigrid->json_build($records[‘record_count’],$record_items));
      }

  • #83 / May 10, 2010 12:11am

    anata_arie

    11 posts

    Check folder system/configuration/ , is there file flexigrid.php?

    and don’t forget to changes:

    controller\ajax.php line 39

    //Print please
    if (isset($record_items))
                $this->output->set_output($this->flexigrid->json_build($records['record_count'],$record_items));
            else
                $this->output->set_output('{"page":"1","total":"0","rows":[]}');
  • #84 / May 10, 2010 12:59am

    newbieCI

    16 posts

    Check folder system/configuration/ , is there file flexigrid.php?

    and don’t forget to changes:

    controller\ajax.php line 39

    //Print please
    if (isset($record_items))
                $this->output->set_output($this->flexigrid->json_build($records['record_count'],$record_items));
            else
                $this->output->set_output('{"page":"1","total":"0","rows":[]}');

     

    Fatal error: Cannot redeclare class Flexigrid in C:\wamp\www\CI\system\application\config\flexigrid.php on line 16

  • #85 / May 10, 2010 1:25am

    anata_arie

    11 posts

    Check folder system/configuration/ , is there file flexigrid.php?

    and don’t forget to changes:

    controller\ajax.php line 39

    //Print please
    if (isset($record_items))
                $this->output->set_output($this->flexigrid->json_build($records['record_count'],$record_items));
            else
                $this->output->set_output('{"page":"1","total":"0","rows":[]}');

     

    Fatal error: Cannot redeclare class Flexigrid in C:\wamp\www\CI\system\application\config\flexigrid.php on line 16

    I’m sorry, please don’t copy file flexigrid.php from controller folder configuration folder. Read detail at http://flexigrid.eyeviewdesign.com/ and place the files like that demo that you can donwnload it from that site.

  • #86 / May 10, 2010 3:03am

    newbieCI

    16 posts

    Check folder system/configuration/ , is there file flexigrid.php?

    and don’t forget to changes:

    controller\ajax.php line 39

    //Print please
    if (isset($record_items))
                $this->output->set_output($this->flexigrid->json_build($records['record_count'],$record_items));
            else
                $this->output->set_output('{"page":"1","total":"0","rows":[]}');

     

    Fatal error: Cannot redeclare class Flexigrid in C:\wamp\www\CI\system\application\config\flexigrid.php on line 16

    I’m sorry, please don’t copy file flexigrid.php from controller folder configuration folder. Read detail at http://flexigrid.eyeviewdesign.com/ and place the files like that demo that you can donwnload it from that site.

  • #87 / May 10, 2010 3:05am

    newbieCI

    16 posts

    Check folder system/configuration/ , is there file flexigrid.php?

    and don’t forget to changes:

    controller\ajax.php line 39

    //Print please
    if (isset($record_items))
                $this->output->set_output($this->flexigrid->json_build($records['record_count'],$record_items));
            else
                $this->output->set_output('{"page":"1","total":"0","rows":[]}');

     

    Fatal error: Cannot redeclare class Flexigrid in C:\wamp\www\CI\system\application\config\flexigrid.php on line 16

    I’m sorry, please don’t copy file flexigrid.php from controller folder configuration folder. Read detail at http://flexigrid.eyeviewdesign.com/ and place the files like that demo that you can donwnload it from that site.

     

     

     

     

     

     

    A PHP Error was encountered

    Severity: Notice

    Message: Undefined property: stdClass::$record_count

    Filename: models/operator_model.php

    Line Number: 23
    {"page":1,"total":null,"rows":[{"id":"235","cell":["235"]},{"id":"236","cell":["236"]},{"id":"237","cell":["237"]},{"id":"238","cell":["238"]},{"id":"239","cell":["239"]},{"id":"240","cell":["240"]},{"id":"241","cell":["241"]},{"id":"243","cell":["243"]},{"id":"244","cell":["244"]}]}

     

    public function get_countries()
      {
    //Select table name
    $table_name = "COMPLAIN";
    $this->db->select('COMPLAIN_NO')->from($table_name);
    $this->CI->flexigrid->build_query();
    $return['records'] = $this->db->get();
    $this->db->select('count(COMPLAIN_NO) as record_count')->from($table_name);
    $this->CI->flexigrid->build_query(FALSE);
    $record_count = $this->db->get();
    $row = $record_count->row();
    $return['record_count'] = $row->record_count;
    return $return;
    }

  • #88 / May 10, 2010 6:22am

    anata_arie

    11 posts

    changes :
    $return[‘record_count’] = $row->record_count;

    to

    $return[‘record_count’] = $row->RECORD_COUNT;

    change all Field Name ($row->[Field Name]) as Capital character.

  • #89 / May 10, 2010 11:23pm

    newbieCI

    16 posts

    changes :
    $return[‘record_count’] = $row->record_count;

    to

    $return[‘record_count’] = $row->RECORD_COUNT;

    change all Field Name ($row->[Field Name]) as Capital character.

     


    Thanks for alll
    But,Why if I search can be happen?
    just “Processing Please wait” again

  • #90 / May 17, 2010 4:25am

    newbieCI

    16 posts

    quick search function wont work @oracle with active record. any solution?


    same problem
    do you got it to solve this pr

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases