106 comments found.
hello, May I use sql sentences like group by, having
regards
Yes, the code comes with an example for group by. Having is not explicitly supported, though.
Hello, do you have any documentation about installation, configuration, etc.?
regards
sure, you can check out the documentation here: https://egobits.com/envato/datamanager/documentation/
it has an overall single filter that searches throughout all the columns and rows of the table.
hello, It has the option to add links in the cells?
regards
not directly, but you can easily select a table column like this: CONCAT(‘’, name, ‘‘) and the value of the column would be returned formatted as a link.
hello, it has the option to copy a record?
regards
there’s no copy button, that should be done with a free jquery plugin
ok, which plugin?
regards
you could try: clipboard.js 2.0.11 – https://clipboardjs.com/
Hello, can I show data in multiples pages? has a pagination buttons?
regards
hello, yes you have a paginator that allows you to navigate among the paged records!
hello, it has export to csv or excel?
regads
there is no native way to do this with this plugin, but if you need a custom implementation, ill be happy to set a buget for it once you buy the plugin.
ok, can you please quote me this otion, to export to csv and xlsx
regards
Hi – will this work with SQLite?
Yes. The code comes with a file called db.php—the current code uses php PDO to connect to the database via mysql. You should change that to meet sqlite’s requirements and you’re all set.
Hi, I need a full solution with Password Protected and other. Thanks
Hi! That would be a custom made implementation.
How much will that be?
Hi – i wanted to purchase this script, but it does not run under PHP 8+ Is there any support for current PHP versions?
also, are there screenshots or information for how to specify the table(s) structure for the script to generate the form and update processing?
thank you will
Hi! We just uploaded a new version of the plugin that uses Bootstrap 5 and has php 7 and php 8 support. I hope it is approved in the next 48 hours.
Hi. Do you’ve tested your script on php 7.4 or higer? Thanks in advance.
It works on 7.4, it hasn’t been tested in php 8 though.
Hi.
I have a problem. I have installed and configured to own server, works fine, except not saving the modifications, or not saving new stuff, when i press the add new user. Do you have any idea what is the problem?
hi, could you confirm your php/mysql version please?
Yes. Mysql: 10.3.27-MariaDB, Php: 7.1 (but i can switch in cPanel)
I have a 100k records, it can handle?
Honestly, haven’t tried with that many. 5k seem to be handled ok though.
Will you upgrade to the latest version of php and mysql?
when i try to add i have this error. But is not required
error_500_desc SQLSTATE23000: Integrity constraint violation: 1048 Column ‘created_by’ cannot be null
fixed. Line in functions.forms.php replace $stmt->bindValue(’:’.$k, NULL, PDO::PARAM_NULL); with $stmt->bindValue(’:’.$k, ’’, PDO::PARAM_STR);
that’s a database error. Which version of MySQL are you using ?
MySQL 8
Happy to know you fixed the issue on your env!
Hi there is the possibility to upload and download files?
Thanks
Not with the basic plugin, but i have a more robust solution (that includes login and file upload as well). That one costs 100 USD.
Is the Form Password Protected to allow selected Users to access the Forms. Can I create forms and allocate to different Departments, for selected Users in that Department.
Hi Dzimili, that feature is no available in this package, but if your budget is ok, I can implement a customized solution for you independently.
How much will that be?
I can implement a full solution for 100 USD that integrates directly with the core of the Datamanager plugin. If you want, I can send you a video with a demo of all the features (login, protected pages, etc). Please let me know where to send it.
Once again your script is amazing. Question: If I add a new column in the “user” table and add column information to the index.php, will I be able to search data using the search function? The data is text. Thanks
yes, you can. as long as it is in the table, it will be searchable (search is performed on the browser via javascript, so it actually is a local filter more than a search query).
Thanks for the quick response. I’ll check it out. A+ support and feedback!
You’re welcome!
I tried researching it on my own, but was unsuccessful. It’s no big deal if it can’t be done easily. I thought I would just ask. Is there a way to display the date as “MM/DD/YYYY” on the forms.
I understand mysql needs the format as “YYYY-MM-DD” in the database.
I’ve look at the code in the functions.forms.php. Had no successful under # javascript $js[] = ’$(function(){ $(”#control_’.$id.’_holder”).datetimepicker({
format: "YYYY/MM/DD",....Thanks again!
The format is managed by the moment 2.22.2 plugin, bundled in this component. Please check line 477 of the inc/functions.forms.php file
In there you should be able to play with the desired formats 
Thank you so much!
Amazing application! I have a question regarding column concatenate. Can I concatenate $sql‘fields’ = array(‘user.last_name’, ‘last_name’); and $sql‘fields’ = array(‘user.first_name’, ‘first_name’); to display on the index.php? Thanks
Yeah sure, just use the sql function inside: $sql‘fields’ = array(‘ CONCAT ’, ‘fullname’);
Amazing and thank you!
It seems envato’s commenting system commented half of the code I posted above hehe, but im glad you got the point!
