106 comments found.
Hi Very interested to purchase your script but have one question before I do so.
I do see a ‘Search’ feature at your demo here but does the script/plug-in has got a ‘filter’ feature as well as indicated at you product description???
Thanks
The filters are defined server-side. The search is a string match for the server-side initial results.
I wonder if it is to integrate with column filter, ? For the preview I did not notice.
If not, how much they charge to integrate with the column filter?
Hi Max, do you mean you want to select which columns to display? That can be easily done server-side.
Hi, First of all I would like to say this is an amazing plug in. My question is that why am I getting error_validation whenever I save changes to a new record. Im using WAMP server, PHP 5.5 and i do have the short tags on. It would be great if you can help me out. thanks!
Thanks, could you tell me the exact headers and response you’re receiving? Please check on the network tab in Chrome Dev Tools.
Im getting this respond whenever i click on the save changes http://imgur.com/2M3XZHj
Can’t seem to find anything in those screenshots. Any way you can facilitate a public url to test your demo?
I’m getting this error in example.edit.php Fatal error: Call to undefined function cnn() in C:\xampp\htdocs\datamanager\example.edit.php on line 45
and the tables is empty. no data at all. please do reply asap.
all the datas are in the right position as I just extract what I download it here in envato.
What php / mysql version do you have currently installed?
Hello there
I’m throwing an error when trying to save a record and it’s always at exit(m(‘error_validation’)); that point, can someone tell me how to elaborate on that error, so I know what’s going on?
hi, what php version do you use? do you have the short tags property on?
Hi, does it work with EAV tables?
Haven’t tried EAV tables, so I wouldn’t know. Perhaps it is adaptable.
Andufo—Any updates??
New CMS is still not ready, and changes are not final yet, i’ll post them as soon as it is a finished product to avoid bugs 
How do you move the search box to the left side?
Solution:
In functions.table.php add $options[] = '"sDom":"flrtip"';
In datatables.css change float to left in div.dataTables_filter label
That works!
When trying to access example.edit.php or simply delete a record, I get the following error: Whilst accessing example.edit.php:
Fatal error: Call to undefined function cnn() in path \functions.forms.php on line 11
db.php is existing and includes cnn() function. PDO is enabled on my server PHP 5.3.13
Any ideas? THX
if it is undefined, it means that it is not finding the function which should be included. Perhaps you’re placing files in different directories?
The DEMO has No data in it …
You have to import the sql data before, it has lots of records for you to test.
No YOUR demo site..
It looks like the demo site has has ALL the records deleted.. and even adding new ones, still displays an empty table..
The demo site has lots of examples: http://egobits.com/envato/datamanager/example.php
Hi
It seems that the “alias” will not accept anything with a space; how would you set the column name to something like “Price per Unit”?
Thanks Jamie
Hi! Actually aliases represent the variable names ($m), and inside $m you can define any name you want (with spaces included).
Nice little package.. two quick questions.. is there an easy way to use full php tags, short tags aren’t as secure, and any changes, additions coming in the next few weeks..
Thanks
Hi! Actually, short tags are not a security issue, it’s just a compatibility issue with servers that don’t have the short tags set in the php.ini – the easy way to use full php tags would be to edit all .php files in the bundle, and just replace <? with <?php
New additions? Not quite feature additions, but there will be improvements on the field validation system pretty soon.
Best regards!
Sweet.. Looking forward to seeing them..
Any idea of when??
As soon as I finish a new CMS that uses this very same plugin. While developing the CMS new features and bugs are corrected. Sorry but I don’t have an estimated date yet :s
Excellent!!! Cant wait to see the new changes..
!
Hello! Your script seems to be really great! One question: Can I create a password to an user and then he (user) or I (admin) can access their form to edit the fields if necessary? The user has to be able to access only their form, ok? I’m not sure if I made myself clear, but it would be great if this is possible. Thanks in advance, Pedro
Yes, you could do that; but you have to implement some kind of user role system before that.
Thanks for your answer, do you recommend any user role system?
Since it could depend on your current setup and it would be a simple implementation, I would recommend doing it on your own, it shouldn’t be too complicated. Depending on the user role, you could display (or hide) certain tables and forms, e.g.: user table so that admin users can edit other users.
Hi, how we can format date output to mm/dd/yyyy or dd/mm/yyyy?
Can you provide a example? thanks.
Hi, you mean inside the forms or in the datatable?
Hi, first of all Great Work!
I decided to purchase and testing, i work with values, is it possible to have a last line with the total?
Best regards!
How many columns can be manage? if I put more than 6 columns, I can not see the records!!!
I moved this script to a webserver and the problem remains, i get no data in the table with more then 6 columns. Any idea?
Thanks in advanced
@chinoca you can manage as many columns as you want, but if you start to add more columns than your window width, they will stay hidden. Still, the first 6 columns should always be visible. Remember that the first column is the row ID.
Regarding the other question, there is currently no “totals” row at the bottom, that should be done programmatically in php.
Hi andufo, thank you for your reply.
I think that has nothing to do with my window width!!!
I may not have explained well, here’s an image with 6 columns and everything works fine https://www.dropbox.com/s/ezyghrvc1xs3mmt/image01.jpg?dl=0
here’s an image with 7 columns https://www.dropbox.com/s/8x0iz8ex60aa85g/image02.jpg?dl=0
here’s an image with 7 columns but the last one is hidden https://www.dropbox.com/s/0em82qnewgx3d9l/image03.jpg?dl=0
I apologize for this confusion, i really need your help!
The action_edit and action_delete columns are special types of columns for specific actions. Can you provide the code you’re using? Perhaps I can diagnose the error easily by having a sneak peek. Also, refer to the example that covers the action_edit column.
# cols array(column, alias, asc/desc, type)
$sql['cols'][] = array('user.id_user', 'id');
$sql['cols'][] = array('user.flg_access', 'flg_access', false, 'boolean');
$sql['cols'][] = array('user.name', 'name', 'asc');
$sql['cols'][] = array('company.name', 'id_company');
$sql['cols'][] = array('user.birthday', 'birthday', false, 'date');
$sql['cols'][] = array('user.id_user', 'action_edit');
$sql['cols'][] = array('user.id_user', 'action_delete');
if i add this column after user.name:
$sql['cols'][] = array('user.id_level', 'Level');
records disappear, please, check if happens to you!
I wasn’t able to reproduce your error. I just tried that with my table… I added 5 EXTRA columns (11 in total) and it renders fine. Do you have that code online? So I can check the network console.
I’m considering a purchase of DataManager, i have a table of products, i need to select products and display it as a grid. If needed the possibility to make changes. At the end send the entire grid information by email Is this possible?
Everything is doable with the current script, except the last part. If you need to send the entire grid info via email, that can be easily managed in an additional script.
Hello,
I have questions very important to me:
1) How to add a JQuery Auto-complete (not all text fields)?
2) How define a Select field dependent it from another one (By example: Country and Capitals)?
3) I have records saved in more than one table, so I need to use tabs and accordions in way to organize relational data separated, not all together. So, I can include more than a form and every one can be show o hide after a user click in tab and accordion?
4) Is there a way to include some AJAX code in way to search, validate or show info inside the form?
Thanks in advanced JR
Hi meridiano,
1) that would need a a customized implementation in the form handler function.
2) that would also need an additional implementation. search for: jquery chained selects
3) you can invoke several data tables in one single page, but each individual data table will have its own search form.
4) the search only works for the data table, if you need to search for info in the form, you also need a personalized implementation.
Best regards!
Hello,
I managed it to run in WAMP in the end.
I have problems getting datas in the table from the database. Used your given .sql. When I access /example.php i get no data in the table. Any idea?
Need to solve this problem as soon as possible.
Hi, can you check your dev console in Chrome (network tab) to see what the request is actually responding?
In console i get this:
<br />
<b>Notice</b>: Undefined variable: sFilter in <b>C:\wamp\www\datatables\inc\datatables.php</b> on line <b>126</b><br />
{"sEcho":1,"iTotalRecords":"629","iTotalDisplayRecords":"629","aaData":[["301","1","Adgman Alain","1973-01-18","301","301"],["247","1","Adriana Lucila","1976-02-15","247","247"],["680","0","Alberto","1973-03-24","680","680"],["600","1","Aldo","1988-07-14","600","600"],["194","1","Alex Bladimir","1977-08-01","194","194"],["685","1","Alex Fabian","1980-08-12","685","685"],["452","0","Alexandra Beatriz","1984-08-19","452","452"],["690","1","Alexandra Pamela","1985-01-28","690","690"],["222","1","Alexis Efren","1985-05-20","222","222"],["113","1","Alison Gabriela","1980-09-16","113","113"]]}
New record is working. So the script is connected to the database.
Undefined variable: sFilter
This is the problem. Need to solve this. thank you
Oh, that’s an easy one. The error levels in your php.ini are way too high. Open your php.ini, find the error_reporting variable and set it to:
error_reporting = E_ALL & ~E_NOTICE
Restart apache web server afterwards and you’re set to go!
Now another issue
<br /> <b>Fatal error</b>: Call to a member function prepare() on a non-object in <b>C:\wamp\www\datatables\inc\datatables.php</b> on line <b>102</b><br />This is from browser console
I can’t understand why every single people need to ask the author to solve all these errors. Please update your script and solve your errors/notices. This way I will be forced to ask for a refund.
Hope you can solve this and help me.(NOTE: No changes were made over the script)
What’s your php version?
hi! im using this datamanager with different browers. with ie, opera, chrome i can save numbers with 5.50 in firefox its only saving the number: 5.5 so its dont save the zero at firefox. do u have an idea?
That strange behaviour seems to be a firefox issue.
hi! I have a problem! Everytime i save the form it says me “You still have unsaved items …” After i click ok leave it safes the entrance. how can i fix this?
Hi! Actually that alert only appears if you try to get out of the form without saving changes first (and only if you’ve made changes).What browser are you currently testing this on?
I use the latest chrome. I click the save button but then it shows me the message. On your example page it’s not showing.
Do you have a public link so I can check your implementation?
it seems you’re trying to add a non-existent filter for the UUID field. The only allowed values are: idcheck, ssn, phone, datetime, date, password, email, checkbox, number (please check the readme)
