106 comments found.
I follow the documentation and created a db called envato_dm in my localhost (xampp), i change the db.php and run index.php.
I get a blank screen page ? where did i go wrong ?
Hi Martin, what url are you running the script from? Did you follow all the previous instructions? Be sure to have short_open_tag=On in your php.ini / Be sure to have a proper error configuration in your php.ini. Recommended setting: error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE & ~E_WARNING
i am running on the localhost and following on the instruction. i have short_open_tag =On and error reporting too. I restart my xampp but also blank page running /datamanager/index.php
any thing else to try.
Hi Andufo, i tried out again and this time, i have error message.
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘admin_envato.user’ doesn’t exist
I didnt create envato.user , do i have to create this user in my phpmyadmin ?
martinwo
i got it to work.
Great 
I’m getting errors and super slow loading pages. You can contact me via email. Thanks!!
Hi starpop, which errors are you receiving? Also, how many records does the table contain?
It had 1-2k records but now none. The page loads fast but I still get errors starting with Undefined index: method in inc/functions.tables.php on line 11 and so one like Undefined offset: 3 in /inc/functions.tables.php on line 109 and Undefined index: filter in /inc/functions.tables.php on line 144 do you have an email address I can send this info to as I am only posting a few of the many errors.
That’s because you need to lower your error reporting level in php. Please refer to the instructions: Be sure to have short_open_tag=On in your php.ini / Be sure to have a proper error configuration in your php.ini. Recommended setting: error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE & ~E_WARNING / This plugin has been successfully tested on PHP 5.5, PHP 5.6, PHP 7.0, PHP 7.1 and PHP 7.2. If you are using PHP 7.3 or higher, please wait until we make the proper tests before acquiring the script.
Pre Sales Question: 1. Can we create multi users for different team members to submit the data in the same table /different table. 2. Manage user permission (only read or rw) 3. Sql error display on the from itself and user should not be able to submit the form incase of any duplicate record ?
1) there’s no login system for this module, but you can integrate the plugin with any login system, and afterwards, you can filter the table results based on the user ID (using the filter feature) 2) same as 1st point. you can filter records based on any id. 3) forms allow to add NEW records or edit existing records. Depending on user ID you can easily allow (or not) the modification of existing records.
Hi, and happy new year !
I bought your plugin nearly two years ago, and today, I was wondering if there was a way to add a duplicate line fonction… Is there an option, or a way to do it ?
Thans per advance
Hi mattheoh, thanks for your purchase Not really, there is no record duplication function.
Thanks for the feedback Andufo !
And is there a way or option to go directly to last page through pagination ?
You mean programmatically? Yes, you could do something this after the data has been properly loaded: $(‘ul.pagination’).find(‘li’).last().click()
Thanks for the trick. You mean in functions.tables.php ?
Or function.common.php ? I made some tries but with no success… Thanks for your help
no, that should be done in the .js
Hello. Can you add the following feature?
I need that each entry in the table to have the possibility to be added a reminder (sent to the user’s email address).
For example
01. Project 1 | Reminder 01-07-2020 02. Project 2 | Reminder 21-08-2020 03. Project 3 | Reminder 06-09-2020
Thanks
Hi! The plugin allows you to display the data in a nice table format, and edit those records dynamically with forms, including date fields. The automatic email reminder can be easily coded using the reminder date field, but it doesn’t come bundled with the script.
Hi just a question
May I validate a float field (calification) between 0.00 and 10.00 (with decimals- no range)
Thanks
yes, just validate it as “number” or “money”, using the min, max parameters, decimals will be validated as numeric values as well.
yes i have done all changes in shortcode and my php version 7, can you help wit teamviwer ?
Can you activate your php reporting errors setting to know the exact issue?
Also, please reply in the same thread instead of adding a new one, makes it harder to follow the context of the problem.
Hi i couldn’t install your plugin , never run or gives no warning and errors. i have followed instruction what u provided.
Hi, which php version are you using? Did you activate the short tags? What does your Dev console display in the Network tab?
I installed it on my server. The demo data is loaded in the MYSQL database and the access data in the db.php updated. But I only get a blank page.
Hi, please activate your php errors to actually see what is happening (error_reporting)
Hi, I have a problem with validating numbers (prices). Numbers are entered on my editing page (decimal separated by comma: 12,99) Can the number with a point be saved in the database as a decimal separator (12.99)?
How can I change or insert the validation for price?
Thanks and Greetings
Hi! It all depends on your local configuration. If you’re using the money filter, then it will check if the value is filter_var($_POST[$k], FILTER_VALIDATE_FLOAT), so if you are using commas, it will return true or false depending on what your setlocale LC_MONETARY and LC_NUMERIC configuration is. On the otherside, MySQL will ALWAYS save float numbers with a dot.
Hi,
I bought the code but not sure how to install it on share hosting, can you help?
Hi! I’m not exactly sure what your current problem is about. Can you be more specific? Thanks.
Hi, I don’t see how to activate and configure the pagination … Thanks for your help
The pagination is automatically added to the tables if there is at least one record.
Thans for your reply. In fact , it works for one table but not for the other one… (27000 entries). I m going to check if my code is the same.
I have another problem. I don’t have the footer in the index.edit.php page… I can’t see any errors. Any idea ? Thanks
If it works fine in one table, that means that you’ve correctly configured everything. Now, if it doesn’t work in the other table, it’s most probably a sql syntax error. If your error_reporting is set for a dev environment, the data manager should throw an exception error in your screen. If not, try setting this at the top of the file to check any errors: <?php ini_set(‘display_errors’, 1);error_reporting(E_ALL & ~E_NOTICE & ~E_STRICT); ?>
thanks for the answer. There’s absolutely no error even if the error reporting activated. I sent you the URL through the contact form. You should be able to see it from your eyes 
I just loaded the link you sent me. I can see the footer clearly It says 26491 records and of course the paginator is included.
You’re right ! the number of entries is so huge, that you have to wait a few minutes… and after the pagination appears. Sorry for the false alert !
I sent ou another link , it will be (I hope) my last question : on the edit page, save / back buttons are missing … still no errors. Thanks again for your help.
Everything works fine perfectly, thanks a lot !
I m actually in the optimizations
Have you ever tried to add a simple WYSIWYG menu for textarea fields edition ?
Thanks for your help
No problem, glad to help! We did include a WYSIWYG editor, but had to remove for it to be approved by Envato, because it was an entire different plugin.
Hello! How can I set to display in the table the last recordings on the first page? Ty!
You mean the order of the records? You can do that by using the order option when setting the field information with asc/desc values. Examples:
$sql‘fields’ = array(‘column_name’, ‘column_alias’, false); //no particular order
$sql‘fields’ = array(‘column_name’, ‘column_alias’, ‘asc’); //ascending
$sql‘fields’ = array(‘column_name’, ‘column_alias’, ‘desc’); //descending
You can set the order for multiple columns, but the first found order will be the more relevant.
Yes, the order of the records, where exactly I have to add ’$ sql’fields’ = array (‘column_name’, ‘column_alias’, ‘desc’); // descending? Can you help me? Ty!
At the top of the file. Please refer to the example code attached in the zip you downloaded: /main/datamanager/index.php – there is a basic and simple example in there
Hi – I bought this item as I’m developing using PHP7.x Your readme shows support for 5.x
Does this mean that this will not work with 7.x ?
It shows 7.x in the item description.
It should work fine, without any issues on PHP 7.x
it works but always send me to this page: mywebsite.com/undefined.php?id=728
Sorry, we found a small bug, it has been fixed and sent to envato for review. In the meantime, please edit “div/header.php” and include this line below line 3: $js[] = ‘settings.file=”’.$file.’”;’;
Question before purchase, Will this support two table joint ? like fetch category from another table and how can i add edit that table in background
Hello, yes it does. As long as you specify the JOIN statement in the $sql definition, you can have as many columns from as many tables as you need. That’s for the list script. For the form script you can edit fields from other tables as long as you have them linked. The save function has a callback_before and callback_after arguments that invoke functions so you can execute anything you want on other tables before or afterwards the main table information has been properly saved.
I want to delete other tables except database user table. what should i do if i remove it in php files but other data doesn’t come from?
the FROM table should be the one you want to delete records from (because of the ID). and then you could just JOIN it with the main table.
Is it possible to write the sum of the columns below?
Hi, there’s currently no option for that, but it would be easily to add the sum in the tfoot section of the html.
Hello, i’ve installed it, all works weel, except that form no updates and no inserts nothing in DB 
, what i can do?, thanks.
are you sure you mysql server is up? and the data in db.php is correct?
Hi I need a checkbox with several values from the database that can be selected. How can I implement this?
The easiest way would be to implement a loop of those values echoing a form_checkbox(“id”, “value”) and then just saving the selected ones in a function (second parameter of form_save())
could you show me an example?
Hi very nice script. I have question how can I assign two variable to action_edit: SO I WOULD LIKE TO ADD edit.php?id=” + data + and NAME=”data how can I add name in URL as well? if($action_edit) $defs[] = ‘{ “aTargets”: [’.$action_index—.’], “bSortable”: false, “bSearchable”: false, “sClass”: “action”, “mRender”: function(data){ return “”; } }’;
Hi alimehboob, I think that’s gonna be a complicated issue, because you’ll need to edit the datatables js file and php file. Can I ask why would you need to send an extra variable?
I am using this for a document management where I need to download file with its filename and ID.
The problem in your solution, is that the change will be applied to all datatables. Also, the parameter data that places the id in the edit column, has 1 value only, so there should be lots of modifications if you want to achieve your requirement. Perhaps there’s a better solution. Do you have the filename attached to the ID in the database table? If so, you could implement a php that just downloads the file that’s linked to the id. Check out this thread: https://stackoverflow.com/questions/7263923/how-to-force-file-download-with-php
