Home > jQuery > jqGrid for PHP

jqGrid for PHP

January 8th, 2010

Hello All,

Today we are launching the Beta of jqGrid for PHP. This is a brand new product created for PHP developers and teams that radically decreases development time with jqGrid and makes it fun and easy. The product will be offered with commercial licenses that will include fast and accurate technical support, source code and subscription based benefits.
Highlight points include:
– all functionality jqGrid has is supported
– no need for tricky javascript – everything is handled in PHP
– the PHP component automatically handles data retrieval, paging, sorting, searching and all CRUD operations (create, read, update, delete). No need for custom code.
– you can have a fully functional grid with just a few lines of PHP
– export to Excel is supported
– database engines supported: MySql, Postgre SQL, Microsoft SQL server

You can see our online demo (50+ examples) here:
http://www.trirand.net/demophp.aspx

You can post questions in our public forums for jqGrid for PHP here
http://www.trirand.net/forum/default.aspx?g=forum

And you can download the trial component here:
http://www.trirand.net/download.aspx

Note: We are using PDO (PHP Data Objects) for automatic grid operations, so depending on your PHP setup you may need to install it before using jqGrid for PHP. PDO is by default installed in PHP 5.1+ distributions.
The above is valid only for MySQL and PostgreSQL databases
Details on PDO:
http://php.net/manual/en/book.pdo.php

For Microsoft SQL Server we are using the driver provided from Microsoft.
Details on Microsoft driver for PHP
Can be found here
and here

Please, let us know what you think. As usual, your feedback is much appreciated.

Regards,
jqGrid PHP Team

Ads by Lake Quincy Media

Tags:
  1. Rene
    January 9th, 2010 at 00:23 | #1

    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

  2. Rumen Stankov
    January 9th, 2010 at 06:23 | #2

    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

  3. Rene
    January 9th, 2010 at 16:07 | #3

    Thanks for the clarifications Rumen.

    Regards,
    Rene

  4. Mojtaba
    January 10th, 2010 at 11:51 | #4

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

  5. tony
    January 10th, 2010 at 11:54 | #5

    Mojtaba,
    The database download link is below the jqGrid for PHP.
    Tony

  6. Mojtaba
    January 10th, 2010 at 12:07 | #6

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

  7. Patrik
    January 10th, 2010 at 18:47 | #7

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

  8. Rumen Stankov
    January 10th, 2010 at 21:10 | #8

    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.

  9. victor
    January 10th, 2010 at 23:49 | #9

    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

  10. Rumen Stankov
    January 11th, 2010 at 11:37 | #10

    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.

  11. jan
    January 11th, 2010 at 16:53 | #11

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

  12. Strx
    January 11th, 2010 at 19:19 | #12

    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

  13. Lance Leonard
    January 11th, 2010 at 20:02 | #13

    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(…);

  14. tony
    January 11th, 2010 at 20:22 | #14

    Hello Lance,
    Thanks. This is possible and will be explained in deep with the upcoming documentation. We hope to publish the development documentation after day or two. The full docs including examples and other cool stuff will be done after a week. We will publish a part of these docs. I will inform you if we are ready with this.
    Best Regards
    Tony
    TriRand Inc

  15. Rumen Stankov
    January 12th, 2010 at 07:52 | #15

    @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

  16. Dick
    January 12th, 2010 at 17:36 | #16

    @Rumen, @Tony

    What’s the latest plans for the MVC version?

  17. Dick
    January 12th, 2010 at 17:39 | #17

    @Rumen, @Tony,

    What’s the current plan for an MVC version?

  18. Rumen Stankov
    January 12th, 2010 at 19:25 | #18

    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.

  19. Ethan
    January 18th, 2010 at 19:50 | #19

    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?

  20. phelgren
    January 18th, 2010 at 23:52 | #20

    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.

  21. Rumen Stankov
    January 19th, 2010 at 01:35 | #21

    @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.

  22. January 21st, 2010 at 08:38 | #22

    You guys removed the Integration part ?
    sad.

  23. January 22nd, 2010 at 09:59 | #23

    @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

  24. irangame
    January 25th, 2010 at 11:35 | #24

    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-

  25. January 26th, 2010 at 09:39 | #25

    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

  26. tony
    January 26th, 2010 at 20:25 | #26

    @Wildan
    Thank you very much for the interest.
    As you known such kind of things can not be estimated easy. There are a couple of things which depend not from the product.
    What we promise is: excellent support from jqGrid Team.
    Best Regards
    Tony

  27. January 27th, 2010 at 06:28 | #27

    @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

  28. David Azevedo
    January 28th, 2010 at 15:40 | #28

    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!

  29. tony
    January 29th, 2010 at 10:59 | #29

    @David,
    Thanks. We just changed the download section. Just click on it and you see the changes
    Best Regards
    Tony

  30. Radek K.
    January 29th, 2010 at 11:06 | #30

    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!

  31. tony
    January 30th, 2010 at 11:08 | #31

    @Radek,
    In the component you can use any SQL command – it is executed in a standard way.
    Also there was a fix when a complex query is used and you want to search, but it is right now in the download section.
    You can simple test you command when you place it in the SQL console and see if it run OK.

    There are is a such option (if I understand right)
    The command(s) can be placed in xml file too (see API docs)

    “It is possible to put the SELECT into different file and point to this file using the setURL() function and create the JSON output”
    Yes we have a three main classes one for the queries, searchs and excel, another for CRUD operations and at end a class which do almost everything with the grid.
    Every class can be used separately in order to meet your requirements.

    We hope to publish the documentation soon with a lot of examples.

    Best Regards
    Tony

  32. ita
    February 1st, 2010 at 10:56 | #32

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

  33. February 2nd, 2010 at 11:33 | #33

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

  34. Subodh Kumar
    February 10th, 2010 at 11:46 | #34

    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.

  35. rabbit
    February 15th, 2010 at 09:51 | #35

    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;
    ?>

  36. February 17th, 2010 at 18:33 | #36

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

  37. tony
    February 18th, 2010 at 11:12 | #37

    Hello FOFA,
    Yes the next release of jqGrid for PHP is supposed to have two additional drivers – Oracle and SQLLite via PHP PDO. We expect this to be done at end of March 2010.

    Best Regards
    Tony

  38. Chris Cole
    June 15th, 2010 at 21:35 | #38

    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.

  39. dayu
    June 29th, 2010 at 12:03 | #39

    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.

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information