I am trying to utilize your carbogrid because it is the best one out there compared to what I need. I have installed all the files but I am trying to figure out how to use it for my existing tables.

Ok I figured what I needed to do. Loving CarboGrid still working the model aspect.

I have figured out how to add rows but the problem I am working is how to delete and edit a single row. Based off the jquery the delete links post the row number and not the id of the table row. What do I need to do to change that? I am java newbie Thanks.

You pass the data in an array for the grid, right? Make sure that the array is an associative array which has your id as key (instead of index). E.g $data[124] = array(...)

Anyway, CarboGrid is under major changes, the current version isn’t too flexible and has some issues. It will take a config array as paramater and will generate the CRUD querys based on config. Built in database setup will be dropped for a while.

Maybe in a few weeks I can come up with something.

Cheers

Yeah what I did was taken the id from the row and used that to find the user id and deleted info that way.

Carbogrid 0.9 is out.

What changed?

- Instead of setup stored in the database, the Carbogrid library is initialized with a config array
- Multiple grids per page are now supported
- Full ajax history
- Filtering now supports different operators (=, !=, <, <=, >, >=, like, not like, starts, ends)
- Multi-column sort
- New types: date, time, datetime, experimental file upload

Carbogrid is hosted now on Google Code and has a new site at carbogrid.com

Visit the site to download, try the live demo and read the documentation

Thanks for the fantastic grid system. I wanted to use this in my project, but I need one option which I think is not working. It is about columns visible, for example in the configuration array I have:
‘columns_visible’ => array (0,1,2)
but nothing happens - still displays all the columns. I do not want all the columns initially visible. Is this possible? Thanks for the advice.

@Emet:
Thank you for the bug report. I fixed the issue with the initial column visibility. You can clone the latest code from the repository (http://code.google.com/p/carbogrid/source/checkout), until I release a new version.

Carbogrid 0.9.1 released

Changelog:
- Now you can set initial column visibility
- IE9-10 row hover fix (whitespace was added if grid had a scrollbar)
- Scrollable area now has a border

Download the latest release

Hi dioslaska,

I just came across this today and it looks like it could be the perfect grid for me

I just have two questions which i hope you can answer.

Is it possible to load data into the grid and make it have a “checked” attribute? I need to use the checkbox function of the grid to allow people to search for data, select it, then for those selections to be stored on the server and retrieved next time the person visits that page so that the grid loads the same dataset, but some of the rows will already be checked.

I haven’t been able to see anything in the code that will allow me to do that, but maybe i’m looking in the wrong place?

Thanks!

hello,

i have just come across carbogrid and loving the clear commented files and presentation, thanks!

i have followed instructions in readme.txt and uploaded files and made configuration changes, but when i browse to the ‘Single grid’ page it is not there, it seems because the ‘sample’ folder is not in the download file like the one on http://carbogrid.com/index.php/sample/home  .

thanks!

update to above post: 

i think this is the problem - the links in the downloadable zip file in application/views/header.php all point to a ‘sample’ folder and there is no ‘sample’ folder in the download. please someone help, i have posted and searched everywhere for a fix to this but can’t find one yet.  if i change the links to just point to the individual files in application/view (‘grid_single.php’ etc) then i get permissions and 404 errors :(. 

can someone please tell me how to get the downloadable package set up exactly the same as the one in the demo?

thanks!

@rw1: There is no sample folder in the download package, because sample is not a folder, it’s the controller in application/controllers/sample.php. Links does not point to php files, they are routes to a controller’s method. Are you familiar with Codeigniter and MVC? I just downloaded and tested the package and it works just fine. Maybe you can attach your config.php file and I can take a look at it.

hello,

thank you very much for your reply. 

i have re-download and re-installed carbogrid and the problem i am getting now is different. 

when i click on ‘Single grid’ or ‘Multiple grid’ it just loads the homepage again (even though the url looks like http://mysitename.com/subdirectory/sample/single and http://mysitename.com/subdirectory/sample/multiple resp.). 

steps i followed per readme.txt instructions:

1. Edit application/config/config.php

- set your site URL here: $config[‘base_url’] = “http://mysitename.com/subdirectory/”;

2. Import database

- create a new database (i already had a database)

- run database.sql ( i did not do this because i already had a database)

3. Setup database connection: (yes i did this)

- edit system/application/config/database.php:

  $db[‘default’][‘hostname’] = “your_host”;

  $db[‘default’][‘username’] = “your_user”;

  $db[‘default’][‘password’] = “your_db_password”;

  $db[‘default’][‘database’] = “your_db_name”;

4. To test file upload create files and files/temp folders and make sure that they are writeable (files is 755, and files/temp is 755)

5. Get rid of index.php from URL (apache mod_rewrite required)

- if application is not in your server root, edit last line in htaccess.txt: RewriteRule ^(.*)$ /path/to/app/index.php/$1 [L]
 
my htaccess at http://mysitename.com/subdirectory/.htaccess looks like:

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ /home/username/public_html/subdirectory/index.php/$1 [L]

- edit system/application/config/config.php: $config[‘index_page’] = “”;

yes i did this. 

- rename htaccess.txt to .htaccess

yes i did this. 

please see attached config.php file.  [edit: forum won’t allow me to attach files). 

thank you very much. 

ps there also seems to be typos in the readme.txt file. there are incorrect references to:

system/application/config/database.php
system/application/config/config.php

the ‘application’ folder is not in the ‘system’ folder.

in the file error_log i can see:

PHP Warning:  PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/uploadprogress.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/uploadprogress.so: cannot open shared object file: No such file or directory in Unknown on line 0

PHP Warning:  PHP Startup: Unable to load dynamic library ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/ffmpeg.so’ - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/ffmpeg.so: cannot open shared object file: No such file or directory in Unknown on line 0

It seems to me, that you have a .htaccess problem
First avoid 5. form the readme.txt, so remove the .htaccess file put back and $config[‘index_page’] = “index.php”

If that works, and you want to get rid of index.php from the URL change this line

RewriteRule ^(.*)$ /home/username/public_html/subdirectory/index.php/$1 [L]

to:

RewriteRule ^(.*)$ /subdirectory/index.php/$1 [L]

About the typos you’re right. Prior to Codeigniter 2.0 the application folder was inside the system folder, I forgot to update the path.