Flexigrid CodeIgniter Implementation

[eluser]anthrotech[/eluser]
Really need the EDIT ROW to work dynamically...can you share your solution?

[eluser]inp[/eluser]
i hope some one like this..
the implements flexigrid with code igniter is coll grid.
you can try this source, i was changes some aplications with mod_rewrite and add the some features with Edit Item and Add New item.
i can't handle more Question for this cz my english is bad.., i just translate this post with google translate.
i hope you are understand. :lol:

[eluser]anthrotech[/eluser]
inp...good job!

I am wondering if anyone knows how to make the following more flexible and dynamic, so that I can update multiple rows with data passed from Flexigrid table?

Code:

for ($i=0;$i<count($_POST['FamilyHistorySID']);$i++){
                            $id =  $_POST['FamilyHistorySID'][$i];
                            $familymember = $_POST['FamilyMember'][$i];
                            $medicalcondition = $_POST['MedicalCondition'][$i];    
                            $livingdeceased = $_POST['LivingDeceased'][$i];
                            $age = $_POST['Age'][$i];
                            $dobmm = $_POST['DOBMM'][$i];
                            $dobdd = $_POST['DOBDD'][$i];
                            $dobyyyy = $_POST['DOBYYYY'][$i];
                            $sql = "UPDATE $table_name
                            SET FamilyMember = '$familymember',
                            MedicalCondition = '$medicalcondition',
                            LivingDeceased = '$livingdeceased',
                            Age = $age,
                            DOBMM = '$dobmm',
                            DOBDD = '$dobdd',
                            DOBYYYY = '$dobyyyy'
                            WHERE FamilyHistorySID = $id";
                            $this->db->query($sql);
                        }

It would be optimal to not create case switches for each table being updated for each data grid (which I have about a dozen, 12, in one of my Web sites), and also use active record codes rather than raw SQL statement for each UPDATE query.

Thanks in advance for any advice.[/b]

[eluser]Unknown[/eluser]
Hey there, thanks for the awesome implementation, I have started using it in a project and so far its seems good.

One tiny suggestion is to add onsuccess to the $string_exceptions array in flexigrid_helper.php.

I was trying for ages to create a call back, not realising it was wrapping it in 'single quotes'

[eluser]german.zvonchuk[/eluser]
Hello guys.

Flexigrid - it's a great script.

In the code below there is no need in ordering clause, so I think it could be removed in future versions.

Code:

SELECT count(id) as record_count FROM (`ib`) WHERE `state` = 1 ORDER BY `ib_create_datetime` DESC

ORDER BY `ib_create_datetime` DESC

[eluser]easternsolo[/eluser]
Hi it is a basic step but I am stuck, I setup the whole demo in a similar way as explained on
http://flexigrid.eyeviewdesign.com/index...id/example

but I am getting blank page on result, I dont have debug installed on Eclipse but I tried with $this->output->enable_profiler(TRUE) on Flexigrid controller. I felt that there is no queries to Ajax controller, is there any way I can figure out what is going on ?

Your quick response will highly be appreciated.


Updates
-------
It is resolved now, I have to make php short codes <? to <?php


Thanks & Regards,
Asim

[eluser]zend[/eluser]
how to load two tables from the database and merge them?
I have two tables Users and Groups I want to show customers and to show what group they belong to the Administrator or Normal User

[eluser]Basketcasesoftware[/eluser]
[quote author="zend" date="1297181635"]how to load two tables from the database and merge them?
I have two tables Users and Groups I want to show customers and to show what group they belong to the Administrator or Normal User[/quote]

It looks like the developer hasn't worked on it in a while. As I have replied to you in that other thread it looks like it needs some updating and made to work with the control model rather than querying databases directly.

[eluser]indrajit_l[/eluser]
the flexgrid example is not working i CI 2.0, can u pls post an example that works in CI 2.0

thanks

[eluser]Basketcasesoftware[/eluser]
Not without a major rewrite. Flexigrid looks nice, but it depends on a certain database table setup among other things. If the creator doesn't get back on it, or someone else doesn't do it, I'll take over the project. It will just another item in an already long list of "to do - eventually".