General
26 results found
-
SUM of columns
It would be nice to be able to add a SUM of one or more columns both the SUM of a single Column and the SUM of two or more columns
36 votesVirtual column is now part of phpGrid 5.5.
-
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 votesSee this recent KB please:
http://phpgrid.uservoice.com/knowledgebase/articles/490211 -
24 votes
Ajax file upload feature is now available in phpGrid 5.0.
-
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 votesIt is rolled out as a separate product due to its complexity. Please see http://phpDatabaseForm.com and download a free copy!
-
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 votesphpGrid 7 now supports form-only mode http://phpgrid.com/example/form-only-mode/
-
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 votesIt has been added as set_col_datetime() method to be released as 6.52.
-
Export to pdf
Have export function export to html, excel, CSV or pdf
16 votesIt will available to the release in Jan 2013. Thank you and Happy New Year!
phpGrid.com
-
16 votes
This feature is now available with set_databar() method.
-
phpGrid Export - Excel Upgrade
Hello,
I as wondering if you could upgrade the exporting of excel from .xls to the new excel format .xlsx for better support.
11 votes -
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 votesIt’s now fully supported in both FORM and INLINE edit mode. Visit: http://phpgrid.com/example/nested-dropdown/
-
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 votesGeneral error returns from the database since version 6.1
-
Use a different SELECT statement for Export.
In most grids I use setcoledittype() 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 purchaseid, customerid, articleid, amount FROM purchases"
using edittype i would set customerid to view the customer name and articleid 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->setexportsql("SELECT purchaseid, customername, articlename, amount FROM purchases LEFT JOIN customers USING(customerid) LEFT JOIN articles USING(articleid)");7 votes -
set_col_date() not working properly
I am having problems with setcoldate(). I am getting teh following error: Please, enter valid date value - d M y
Here is my code:
$dg -> setcoldate("QSPDate", "Y-m-d", "d M y", "yy-mm-dd");
$dg -> setcoldate("QSPExpiry", "Y-m-d", "d M y", "yy-mm-dd");Not sure what I am doing wrong??
7 votesPlease see updated document on this function to address the confusion.
-
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 votesIt will be released in Jan 2013.
-
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 votesThis is supported. See nested_dropdown.php example.
-
Ability to add new records in subgrid
This is, to have all the funcionality of master table, as in master/detail functionality
7 votes -
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 -
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 votesphpGrid, phpChart integration example is now online live!
http://phpgrid.com/example/phpgrid-phpchart-integration-with-live-example/
-
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 votesSee column chooser feature in version 6.
-
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 votesget_display() is now available. Please see documentation page for details.
- Don't see your idea?