General

I suggest you ...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
    • 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
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
      • 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
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          completed  ·  2 comments  ·  Admin →
        • 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
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
          • 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
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
            • 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
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                1 comment  ·  Admin →
              • 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
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  1 comment  ·  Admin →
                • 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
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                  • 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
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                    • 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
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                      • 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
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                        • 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
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                          • 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
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              1 comment  ·  Admin →
                            • 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
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                completed  ·  3 comments  ·  Admin →
                              • Export to pdf

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

                                16 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                • 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
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                  • 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
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      completed  ·  1 comment  ·  Admin →
                                    • 3 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        completed  ·  0 comments  ·  Admin →
                                      • 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
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                        • jquery access to data

                                          allow easy jquery access to selected row data

                                          1 vote
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            1 comment  ·  Admin →
                                          ← Previous 1
                                          • Don't see your idea?

                                          General

                                          Feedback and Knowledge Base