jQuery Grid Plugin – jqGrid

Hallo there,

unfortunately it isn’t really clear to me at the moment under what kind of license jQGrid for PHP is being run. It the sourcecode freeware and only support for commercial user? Or does one even have to pay for the sourcecode?

Regards,
Rene

Hello Rene,

Indeed, we wanted to release early and still have not finished our licensing page about PHP. Our licensing for this PHP framework will be very similar in licencing terms and pricing to what we have already setup for our commercial ASP.NET component. You can read details about this here:

http://www.trirand.net/licensing.aspx

I anticipate that we will be able to finalize licensing and update our licensing page this weekend.

Regards,
Rumen Stankov
Trirand

Thanks for the clarifications Rumen.

Regards,
Rene

Hi there,
Thanks for first release!
Can you upload sample database(northwind) for testing samples 🙂 ?

Ohh, Sorry Tony.
I’m missed a little!
Thank again.

I have added Hungarian support. Where do you want me to send the file?

Hello Patrik,

Thanks a lot for the localization updates. You can send the update to support@trirand.net and we will make sure it is included in the next release of jqGrid.

Thanks again.

Good day,
I have used PHP jqgrid in many of the sites I’ve developed and I am somewhat uneasy about the new licensing policy for this component.
This commercial license only apply to new versions? or for all? and if so, will then have to replace the component on the developments already made?

I’ll be waiting for your reply to take corrective action

Sorry for my english

Hello Victor,

The licensing for jqGrid (javascript version) will not change, so you should not worry about that. jqGrid will continue to be delivered with GPL & MIT licenses.

Our recent ASP.NET & PHP commercial products are aimed at developers & teams who would like to get extra benefits, like extra features, ease of development (tied with the framework), guaranteed support, bugfix, additional services, etc. Just like some teams require open source licenses, others do require commercially backed support and this is what we are doing with the PHP and ASP.NET components.

You need not worry – everything will continue as it was, with just a few commercial products to keep us going. We need the commercial model to support commercial teams and to make sure we have enough incentive to continue developing jqGrid. This plays well for everyone. The jqGrid & jqSuite brands will continue to evolve and be supported/developed and this is what counts the most.

If you have any additional questions, just let us know.

Regards,
Rumen Stankov
Trirand Inc.

Your trial already cracked……better use another alternatif trial…….

There are issues of 4 months ago on GitHub (16/18 opened); personally I’ve added 2 issues without response…How can I trust you for commercial support???

Better support Open Source, and Open Source People will support You, without licenses

Thanks anyway, Straps

I’m glad to see a PHP option. When will documentation be available? What about the ability to set a javascript variable to the grid as I can with the jQuery plugin so that I can interact with it from the client-side?

var grid = jQuery(‘#grid’).jqGrid(…);

@jan No matter how hard we try to encode the product it will always be cracked if it is popular. We do not want to make licensing hard (e.g. activation, etc), we are just providing an alternative service

@Strx In a product of this scope and popularity, there will always be open issues. We get 4,000 unique visits per day, thousands of downloads and hundreds of questions each day. Commercial vendors at this point have huge teams to support that and still fail to do it perfectly. I am sure you know that.

Like I said, nothing will change, jqGrid will continue to ship as it was and I anticipate even more often now. For example, we released 3.6.2 a few days ago with many fixes:

http://www.trirand.com/jqgridwiki/doku.php?id=wiki:change#jqgrid_3.6.2_changes_and_fixes

@Rumen, @Tony

What’s the latest plans for the MVC version?

@Rumen, @Tony,

What’s the current plan for an MVC version?

ASP.NET MVC development is well under way and we will be ready with a Beta soon, however we indeed underestimated the effort needed to ship 3.6.2, the ASP.NET WebForms and PHP releases, so we still need some time.

The component is shaping up great, the API will be pretty much the same as the ASP.NET component, the jqGrid client-side will of course be 3.6.2 jqGrid, we just still need some time.

I believe we will be able to ship before the end of January. Please, excuse us for the inconvenience.

So, if I understand correctly, if I purchase the PHP version I will not get updated to the final version unless I buy the subscription license?

What are the limitations of the demo vs. licensed?

Still willing to help out with a Java version of the grid. Maybe we could jointly develop something similar to the PHP version if you guys would be will to help with the technical details.

Just let me know.

@Ethan: subscription gets you all updates for an year + source code + priority support. This is no different than what all vendors do in this area. You can still go for the free MIT & GPL licensed javascript version, should you decide to go that way. No changes here

@phelgren: yes, we are interested. At this point we are willing to discuss which platform is the most promising, as Javaland is very fragmented. We are thinking of picking Google Web Toolkit (GWT) – are we wrong? – please, write an email to support@trirand.net and we well discuss this in detail.

Thanks.

You guys removed the Integration part ?
sad.

@TheDiLab

This is not true. The page is just moved to another location.
http://www.trirand.com/jqgridwiki/doku.php?id=links
Best Regards
Tony

Hi all,
It seems that some of your demos in jqGripPHP allow to delete records in DB!
for example
http://www.trirand.com/blog/phpjqgrid/examples/editing_data/inline/default.php

Please check it.
-Mojtaba-

I’m symfony users and have a plan to buy this product.
How much effort will i spend to integrate this jqgrid php lib to symfony MVC style ?

Thanks

Warm Regards,
Wildan

@tony
Hi Tony,

Thanks for the quick answer. Yes, i realize that, it’s also very depend on my own
expertise … :). But one thing for sure is, there is no doubt that support from jqGrid team is very excellent.

I have a plan to buy ‘Developer License PHP Subscription’ next month.

Best Regards,
Wildan

Hi guyz, before anything i would like to congratulate the jqGrid team for the fantastic job.

I’ve been using jqgrid about one year and now i use it in all my websystems and websites.

I’ll try to buy the licensed version of jqgrid but until then i would like to ask one thing to jqGrid team just to clarify things to all people:

In my understanding “JqGrid for php” is a commercial product and “Javascript JqGrid” a free one.

I would like to ask that you post the link where we will be always able to download the latest version of the free JqGrid.

Thank you again JqGrid Team, JqGrid is awesome!

hi,
I would like to say big THANK YOU for the PHP framework of the jqgrid!

Anyway – I need to use quite complicated SELECT (JOINs, LIMITs, WHEREs…) using MSSQL database – and when I place the SELECT into the SelectCommand – I am getting the “Error while executing Resource id #18” error.
Could I ask if there are some limitations of the possible SELECT command in the SelectCommand?
It is possible to put the SELECT into different file and point to this file using the setURL() function and create the JSON output, but – when I would like to export in excel – this does not work and I cannot find any rules around it. If the using external search.php (like in previous version of jqgrid) is good step – what I have to write into the script to support the exportToExcel() functionality?

Thank you a lot!

hi,
how uses jquery grid in code igniter, if possible there’s full example?

@ita
im using jqgrid with codeigniter…
but in indonesian…
http://gambasvb.blogspot.com/2009/12/jquery-dan-codeigniter.html

How we use jqGrid for PHP with Yii framework. Because I am working on an ERP web application and use these jquery feature in my apps.

Hello. I am using the jqgrid with PHP. Having trouble with the ‘masterdetail’ example. I want to have the detail view lookup data based on a certain field value from the selected row in the main grid. Right now the detail view displays data based on the first field/column of what I have selected in the master grid.

In other words, I am wanting to have the detail show data that uses a specific column data from the main grid.php. Make sense?

* The comments in the masterdetail example referring to “// Get the needed parameters passed from the main grid”… that is where I cannot figure out how to direct it to a certain field value for my SELECT statement.

Please see code below. Thank you in advance for your comments.

query(“SET NAMES utf8”);
// Get the needed parameters passed from the main grid
if(isset ($_REQUEST[“id”]))
$rowid = jqGridUtils::Strip($_REQUEST[“id”]);
else
$rowid = “”;

// Create the jqGrid instance
$grid = new jqGridRender($conn);
// Write the SQL Query
$grid->SelectCommand = “SELECT login_date, login_time FROM custom_user_log WHERE user_id= ?”;
// set the ouput format to json
$grid->dataType = ‘json’;
// Let the grid create the model
$grid->setColModel(null, array(&$rowid));
// Set the url from where we obtain the data
$grid->setUrl(‘detail.php’);
// Set some grid options
$grid->setGridOptions(array(
“rowNum”=>10,
“footerrow”=>false,
“userDataOnFooter”=>false,
“sortname”=>”login_date”,
“height”=>250
));
// Change some property of the field(s)
//$grid->setColProperty(“RequiredDate”, array(
// “formatter”=>”date”,
// “formatoptions”=>array(“srcformat”=>”Y-m-d H:i:s”,”newformat”=>”m/d/Y”),
// “search”=>false
// )
//);
$grid->navigator = true;
$grid->setNavOptions(‘navigator’, array(“excel”=>true,”add”=>false,”edit”=>false,”del”=>false,”view”=>false));
// Enjoy
//$summaryrow = array(“Freight”=>array(“Freight”=>”SUM”));

$grid->renderGrid(“#detail”,”#pgdetail”, true, $summaryrow, array(&$rowid), true,true);
$conn = null;
?>

is there any way to use jqGrid for PHP with sqlite database ????
thanks

jqGrid for PHP is the most amazing development tool I’ve come across in years..
Exactly what I’ve wanted for years… thanks so much for the SQL Server support.

1. i was downloading the jqGridPHP 3_6_3 and i was following step by step of the quick instalation guide in READMEPHP file. but why I can’t see anything in my browser when i tried.
2. when i’m trying to use jqGridPHP 3_7 trial version i found the same problem. i was following the steps in READMEPHP file but my browser show me this message “Fatal error: Class ‘PDO’ not found in D:\AppServ\www\e\jqGridPHP_3_7\myfirstgrid.php on line 8”.
please help me what wrong because i’m just beginner.