General

  1. set_col_date() not working properly

    I am having problems with set_col_date(). I am getting teh following error: Please, enter valid date value - d M y

    Here is my code:

    $dg -> set_col_date("QSP_Date", "Y-m-d", "d M y", "yy-mm-dd");
    $dg -> set_col_date("QSP_Expiry", "Y-m-d", "d M y", "yy-mm-dd");

    Not sure what I am doing wrong??

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Develop a simple way to do nested dropdow with data from the database in edit form

    Develop a simple way to do nested dropdow with data from the database in edit form

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  3. Use a different SELECT statement for Export.

    In most grids I use set_col_edittype() to show values for underlying ids. When exported, only the id's are shown, not the values.

    For instance, my SELECT statement would be:
    "SELECT purchase_id, customer_id, article_id, amount FROM purchases"
    using edittype i would set customer_id to view the customer name and article_id to view the article name.
    Only when exported, the id's are exported, but the names are not.
    It would be nice to have an option something like this:
    $dg->set_export_sql("SELECT purchase_id, customer_name, article_name, amount FROM purchases LEFT JOIN customers USING(customer_id) LEFT JOIN articles USING(article_id)");

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Skip grid and go straight to Form

    I'd like to be able to pop up a form without having to go to the grid and hit the +. This would double the usefulness of phpGrid to me, because then I could use it as my form processor too!

    18 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Add error handling (server errors and others)

    Please add functionality for error handling: I want to be able to see if the edited data was saved, and if not, why.

    Eg:
    error: unable to save record, connection to server was lost
    error: unable to insert record, duplicate entry for "column1" found
    ...and so on...

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Let user pick and choose columns that are displayed in the grid

    Give users the functionality to select columns shown in the grid and to order them as they like. Tie in functionality to let them 'save' the columns they've selected so that the next time they hit the grid, it remembers their selection.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  7. Possibility to set time in date selector

    When you have a datetime field in sql the edit form only lets you set the date and not the time. So all input is registered as 00:00:00. It should also be possible to add the time.

    17 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  8. I need load dropdown conditioned for value the other dropdown...can be done?

    I need load dropdown conditioned for value the other dropdown...can be done?

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. add greater/smaller than in search

    I currently miss the options <, , <=, >= in the advances search function. If this is not due to my oversight, I suggest you add this to the menu for search criteria.

    29 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Have a single row view as a form - In Form View with record selector

    I would like to have a full page view of a single row (AKA single record) with record selector - like MS Access single record view. This would be excellent for single unique record CRUD operations. Then have CRUD function as hyperlinks - should be easy to add on existing Java framework.

    24 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Looking for a callback example

    To trigger a phpChart update when the grid is 'searched or filtered'. Ideally, I'd love for a PHPChart to simply graph a PHPGrid column, and auto update the chart based upon the data displayed.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Update/Delete the SQL-Table with a WHERE Statement

    I have a Table which i want to update but with a WHERE Condition. Is that possible and how?

    Update/Delete the SQL-Table with a WHERE Statement

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Export to CSV format

    So... export to XML is great, but if there are a lot of records XML files become to heavy. Could you please add the posibility to export to CSV?Thanks a lot!

    7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  14. We need a way to show a value instead of a key when EDIT is required

    Given you don't support an INNER JOIN, and apparently, when using a view, one can't use edit, we need a way to show a value instead of a key on grids that you want to use for edits. For instance, when listing an Orders table, you want to show the Customer's name, not their ID.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. Export to pdf

    Have export function export to html, excel, CSV or pdf

    16 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. enable_search always toggled on

    Can I have the enable_search always toggled in on? By default it is off and you have to click the icon to get the search boxes in the header. I'd like to have the enable_search on by default.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. why does not exist a phpchart to try?

    I downloaded phpgrid to test and I bought it after test it.
    but phpchart we have to buy first, I'd like to download it too e test it to see if it's so as phpgrid.
    Regards
    José

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  18. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. get_display() to get content (grid) body

    On top of display() which output directly the grid. For ease of integration with other system, get_display() will return the html code of the grid to be output as part of a rendered page.

    Similarly, get_header() to output the html code for <link> and <script>.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. jquery access to data

    allow easy jquery access to selected row data

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1
  • Don't see your idea?

General

Categories

Feedback and Knowledge Base