Flexigrid - Lightweight but rich data grid

[eluser]Myles Wakeham[/eluser]
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

[eluser]lihanqin[/eluser]
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

[eluser]- Obonk -[/eluser]
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!!!!

[eluser]Unknown[/eluser]
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..

[eluser]Unknown[/eluser]
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.

[eluser]Unknown[/eluser]
[quote author="lalit mohan" date="1250158303"]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..[/quote]

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

Code:

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));
}

[eluser]mjsilva[/eluser]
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

[eluser]jikowhitewolf[/eluser]
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

Code:

$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

Code:

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?

[eluser]BaRzO[/eluser]
Project moved to => http://code.google.com/p/flexigrid/

[eluser]myqmanager[/eluser]
how to use the flexgrid in print tables