General
26 results found
-
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 -
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.
-
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/
-
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 -
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/
-
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
-
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.
-
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.
-
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.
-
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 -
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!
-
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/
-
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 -
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.
-
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 -
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
-
enable_search always toggled on
Can I have the enablesearch 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 enablesearch on by default.
3 votes$(function() { var grid = jQuery(“#orders”); grid0.toggleToolbar(); }); -
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 -
3 votes
-
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?