OpenJS Grid - an Open Source JQuery Grid

Open JS Grid is a really really simple to use grid component built into jquery.
The downfall of a lot of JS grids out there, is the setup is pretty hard. Well the secret sauce here is the helper PHP class that does all the hard work for you.

Download at http://square-bracket.com/openjs

This component brings together my knowledge of PHP and Javascript along with jQuery to deliver a really powerful, yet easy to use grid.

Features include:
adding a title
changing columns
initial widths
initial sort orders
paging
searching
column resizing
global resizing
column flexing
column hiding
column selecting
freeze rows
complex fields
complex joins
complex wheres
multiple tables

Category:

Science & Technology

Tags:

• js
• jquery
• grid
• open grid
• open js grid
• sean
• clark
• optikalefx
• excel
• table
• tab
• easy
• super
• php
• order
• by

[LearnThruSong]

ABSOLUTELY AWESOME!

This provides a lot of the framework I need to make modifying some database tables cleanly and securely behind a custom ACL in PHP. I just need to work out a few details and I'll be jumping in there adding this to my site!

Thanks so much for your time developing this!

[optikalefxx]

@LearnThruSong thanks man! Let me know when you work with it, I'd like to see what you come up with

[joanatyu]

i have a question.. can the grid handle thousands of data?

Thank you! =D

[optikalefxx]

@joanatyu The most I've used it with is 26 thousand rows. So yes, it can probably handle millions of rows.

[joanatyu]

can you tell me how?

will that automatically compute the average when i enter the values in those 7 fields in the grid

Thanks for the reply

[optikalefxx]

@joanatyu I need to know your database first, then i can tell you. Email me a SQL dump of your database PM me for my email address

[optikalefxx]

@McL0c0MX well the click is an event ON the tr. So, $(this) refers to the tr, where $(this).attr("primary_key") is the row id

[MakkeSk8]

u talk very fast man.. calm down

[nathangsmith18]

@LearnThruSong I'm having the exact same error as mjcarraco. I've tried just about everything [my very limited programming mind] could think of and I can't get to the bottom of this. I understand the obvious sql syntax errors in the but I haven't changed the class files and have set up the index/ajax files as instructed. For some reason grid.php (or maybe grid.js) is creating some weird sql. Any advice for how I can begin to figure this thang out?

[MylesLeeCrampton]

Spectacular! Can't wait to make use of it. Many thanks for sharing it :)

[LearnThruSong]

@mjcarraco Also, do you really have a field in your 'orders' table called 'orders'? Also are you trying to concatenate the two fields where after SELECT you have "...`orders`.``,orders.id..."?­

[LearnThruSong]

@mjcarraco Hi there, you appear to have a couple of errors in the SQL:

1st - You have the ORDER BY declaration but no argument... you need to tell SQL what to order (the name of the field) by or delete ORDER BY.

2nd - If you put a LIMIT declaration in, it restricts the number of rows - or in your case, orders - that the query will return. By adding a LIMIT 0, no matter what you're selecting, the query will limit SQL to returning zero results.

Hope this helps!!!

[mjcarraco]

It gives me this error:

string(94) " SELECT `orders`.``,orders.id FROM `orders` ORDER BY LIMIT 0, " You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,' at line 8

What that means?

Thank you