Thread

Hello

I want to add one cell click event for flexigrid.How to do?

Thanks your help.

hi, I have some questions to allow more power to flexigrid.

I want to:
-add “actions” columns with no header, that let me Edit/Delete/or custom action.
-autoload FK values, almost table has a FK value, so I want to be able to load a “Descriptor” field.

less Important
-an example of an edit/add form, based on the grid, could be a popup .

May be some “charitable soul” could paste some code here !

Best Regards 😊
Nicolas

Hi Paolo,

I want to use the Flexgrid program but i would like to remove the dropdown menu to remove a field.
Is this possible?

I’m using Flexigrid with CI and it works great.  Well almost…

I have a grid that I’m populating data using JSON, and the data range is determined by parameters passed in the traditional CI way (ie. http://www.domain.com/index.php/Controller/function/parm1/parm2/parm3...)

After spending hours trying to work out why the last parameter was never being correctly handled, I stumbled (via Firebug) as to what is going on.  When the Flexigrid object loads, it calls back to my CI app via JSON to get its data.  It gets its data and displays it perfectly.  But then a 2nd callback is being sent from Flexigrid back to my CI app to get ‘loading.html’

The problem with the 2nd GET request is the way its doing it.  It looks like JS is taking the end of the current URI and removing the last values to the right of the final / character and replacing it with loading.html.  This is wiping out my last parameter from the call which is where I discovered that the data range selected wasn’t being correctly returned to my app (it was on the 1st GET request, but was then being wiped out with the 2nd).

I have no idea why its doing this, other than to possibly display a loading image or XHTML window or something like that.  I’m also not sure if this is being driven by Flexigrid or by the CI implementation of it (I’m using some user contributed code for this, but I’m not exactly sure of its origin - I’ll have to check).  But on the off chance that this is standard behavior of Flexigrid, is there a way to turn off this loading.html GET request that is coming in?  Has anyone else encountered this before?

Myles

Checking it out right now, looks pretty cool!

Just a quick update…

I was able to get FlexiGrid working stable with CI apps, but had to do a bit of hacking with mod_rewrite to intercept the request for the loading.html 2nd request coming in, and effectively ‘throw it away’ so that it wasn’t hitting CI and causing URI requests that were not required and missed key elements.

Once this was done, all is well.  Now if only it would allow editing in the grid, I’d be in heaven…

Myles

hi

I set two flexigrids in one page, but i have got error result. the pages same. and when i click the “Next” button , the two grid show same pageindex.

how to solved the bug?

Thanks

Hello guys,

i just trying to use flexigrid and this works owsome on my CI, but is there any way to upgrade the jquery, cause if i try to used jquery 1.3 the flexigrid don`t show the tabel. if any one have a solution, so that i can upgrade the Jquery.

Please Helpp!!!!

hello,

i am facing a problem in flexigrid. i am trying to add a new button export in the grid. when user click on the button. i am opening a popup which contain the code to generate excel. my problem starts here. i want to post the same variable (sortorder, sortname….) which are posting on the post2.php. but i am failed to get the values of sortorder, sortname on the export.php
following is my code. if (com == ‘Export’) {
window.open("download.aspx?", 'Export', 'width=100,height=100,');
}

i want to pass the sortorder and sortname through querystring on the download.aspx page.

Please help me..

Hi Paulo,

Flexigrid is fantastic but I need some help on quick search. We have managed to fetch from multiple tables and display it but it is difficult to do it through search. How do I modify the function build_querys($querys,$use_where = TRUE) in flexigrid helper?

Please help.

hello,

i am facing a problem in flexigrid. i am trying to add a new button export in the grid. when user click on the button. i am opening a popup which contain the code to generate excel. my problem starts here. i want to post the same variable (sortorder, sortname….) which are posting on the post2.php. but i am failed to get the values of sortorder, sortname on the export.php
following is my code. if (com == ‘Export’) {
window.open("download.aspx?", 'Export', 'width=100,height=100,');
}

i want to pass the sortorder and sortname through querystring on the download.aspx page.

Please help me..

I don’t know if it is a best solution but it works:

if (com == 'Export') {
    var rp = $('select[name=rp]', grid).val();
    var page = $('.pcontrol > input', grid).val();
    var sortname = $('div.hDiv', grid).find('th.sorted').eq(0).attr('abbr');
    //sortorder with 's' prefix (sasc / sdesc)
    var sortorder = $('div.hDiv', grid).find('th.sorted div').eq(0).attr('class');

    //test it:
    alert(rp + ',' + page + ',' + sortname + ',' + sortorder.substr(1));
}

Hey,

I’ve changed flexigrid a bit so it saved the state to cookie, check this post to test it: http://ellislab.com/forums/viewthread/90208/P50/#691086

from the example http://sanderkorvemaker.nl/test/flexigrid/, I am trying to create a update.php from the delete.php example.

I notice there is no way I can display a echo or alert, to see my update.php

inside update.php

$items = rtrim($_POST['items'],",");
$update_sql = "UPDATE service_table SET approved='1' WHERE 'id' IN ($items)";

$total = count(explode(",",$items)); 
$result = runSQL($update_sql);
$total = mysql_affected_rows();

inside index.php

function test(com,grid)
{
    if (com=='Update')
    {
       if($('.trSelected',grid).length>0)
       {
            if(confirm('Approve ' + $('.trSelected',grid).length + ' items?'))
            {
                var items = $('.trSelected',grid);
                var itemlist ='';
                for(i=0;i<items.length;i++)
                {
                    itemlist+= items<i>.id.substr(3)+",";
                }
                
                
            $.ajax
            ({
               type: "POST",
               dataType: "json",
               url: "update.php",
               data: "items="+itemlist,
               success: function(data)
               {
                alert〈"Query: " 
                +data.query+
                " - Total affected rows: "
                +data.total〉;
                
               $("#flex1").flexReload();
               }
             });
            }
        } 
        else 
        {
            return false;
        } 
    }
        
}

I am able to use alert to see what is inside index.php, but alert or echo does not works inside delete.php or update.php.

btw, this link http://webplicity.net/flexigrid/ is not working anymore, is it directed to another link?

Project moved to => http://code.google.com/p/flexigrid/

how to use the flexgrid in print tables