106 comments found.
Hi I am trying to figure out how to use the form select with an alias. By this I mean that I have a form select on my form and it is working ok with the following code….
<? $sql = ‘SELECT id_trex, trex_range FROM lawsons_trex ORDER BY id_trex’; $stmt = cnn()->prepare($sql); $stmt->execute(); $trex = $stmt->fetchAll(); ?> <?form_select('id_trex', $trex, $data['id_trex'], !$id)?>But I don’t want the label for the form select to be “id_trex” I want it to be “Trex_Range” but if I change the code to <?form_select('Trex_Range', $trex, $data['id_trex'], !$id)?>
It fails with an error on trying to save records.
Im stuck and need a response as soon as possible please so I can hit my deadline for delivery.
Regards
Alan Edwards
Sorry didn’t read well the first time. In that case you should edit the language pack, so that id_trex prints out what you need to display (you can do that before the form_select() call. Example: $m[‘id_trex’] = ‘Something’; form_select(...
Really appreciate your response and great that it was so quick but I do not understand what you are asking me to do
Regards Alan
The quickest fix would be to add this line just before your form_select() statement: $m[‘id_trex’] = ‘Your text here’;
Thanks andufo worked OK
Possible to create users login / out and user roles ?
It’s not actually implemented but I could have it done for an extra fee. Would you be interested? If so pls facilitate your email address to me.
Hi, I have been trying for weeks now to get the form to work with datetime and time form fields but have had no success.
Do you have examp[les of this working so I can adapt to work with my form?
Regards
Alan
Hi, please check the demo. There’s an example on how to use the date field:
1. prepare field
$fields[‘birthday’] = array(true, ‘date’);
2. print field
<?form_date('birthday', $data['birthday'])?>I need date and time not just the date.
Alan
The datamanager uses this jquery plugin https://uxsolutions.github.io/bootstrap-datepicker/ which doesn’t support time format in the control. Sorry. If you want time you have to implement a different jquery library within the datamanager.
hi buddy. i set the options but i can see the submit button at example.edit.php file
check here: http://site.liberdadereligiosa.org.br/contatos/example.edit.phpthanks
hi, i think i found the solution thanks
Perfect 
Let me know if you need anything else.
yes. actually i need help to show in the table the level of the user in example.php
i have to set another inner join ? how to?
- table $sql[‘table’] = ‘user INNER JOIN company ON company.id_company = user.id_company, INNER JOIN level ON user_level.id_level = user.id_level’;
$sql‘cols’ = array(‘level.name’, ‘Cargo’);
Well, there seems to be an error in your SQL sintaxis. Please remove the comma that you have before your second INNER JOIN.
still not working, its shows no results in example.php page
Then it must be something else. Please attach a screenshot of the network response in the Developer Tools of your browser to check the specific error.
theres another way to contact you to send the information? skype? telegram?
send an email via the contact form, so i can reply in there.
Hi how can I change the “Search:” & “records per page” labels? Thank you
Hi luigixpl, please check the jquery.datatables.js file and search for the definition of sLengthMenu in oLanguage.
Thank you
Hi I’m Luis from Spain
the edit page gives me validation error
See in www.factoriacad.com/midespensa/datamanager/fabricante.php
Code: <? include(‘inc/config.php’); $page[‘title’] = ‘Edición de fabricante’;
- table $table[‘name’] = ‘fabricante’; $table[‘id’] = ‘id_fabricante’; $id = ($data = form_check()) ? $_GET[‘id’] : false;
- fields arrayname $fields[‘nombre_fab’] = array(true, false, 2, 50); $fields[‘email_fab’] = array(true, ‘email’); $fields[‘telefono_fab’] = array(true, false, 2, 15);
- save data form_save(); ?> <?include(‘header.php’)?>
<?form_header()?>
<?form_input('Nombre', $data['nombre_fab'])?> <?form_input('Email', $data['email_fab'])?> <?form_input('Teléfono', $data['telefono_fab'])?>Thank you
I’m glad you figured it out. It was mostly probable a php configuration setting (smart tags or something like?)
As you appear not to be supporting this software any more and I have just purchased can I please have a refund as the support is lacking somewhat.
Both questions are now answered. Sorry for the delay, I wasn’t getting any email notifications of these comments.
Hi I have already posted one comment which has still to be answered.
I now want to show the date format in dd/mm/yyyy when it is selected by the user as I am in the UK.
The mysql database is formatted as yyyy-mm-dd though.
Is this possible to do and if so how do I do it? What needs to be changed?
Alan
As you seem to be not responding to support can I please have a refund as this support is lacking somewhat.
The date format will always be yyyy-mm-dd (for both server-side and client-side). If you need to change the client-side, you’ll have to modify the code. The server side should automatically detect that because it parses the date as a string and deconstructs its chunks, and then puts it back together into the mysql format of yyyy-mm-dd.
Hi looking to possibly purchase but cannot see any reference or demo of disabled fields. I need to be able to have disabled fields in my forms
Alan
Hi, actually there is an option for disabling fields.
Please check the parameters of the form_input method for the form class:
1) $id 2) $value=false 3) $label=true 4) $size=false 5) $disabled=false
If you set disabled to true, the field will be delivered in disabled mode.
The file provided are not complete and missing lines, they do not function as per the demo. Can you please upload proper files?
Hi, the demo works alright. Most probably you didn’t read the Readme. You have to activate short tags, and set low error levels in your php.ini
I just can´t make it work. I getting the following notices: Notice: Undefined index: data in D:\xampp\htdocs\datamanager\datamanager\inc\functions.table.php on line 16
Notice: Undefined offset: 2 in D:\xampp\htdocs\datamanager\datamanager\inc\functions.table.php on line 39
Notice: Undefined offset: 2 in D:\xampp\htdocs\datamanager\datamanager\inc\functions.table.php on line 39
Notice: Undefined offset: 2 in D:\xampp\htdocs\datamanager\datamanager\inc\functions.table.php on line 39
Notice: Undefined offset: 2 in D:\xampp\htdocs\datamanager\datamanager\inc\functions.table.php on line 39
Notice: Undefined index: filters in D:\xampp\htdocs\datamanager\datamanager\inc\functions.table.php on line 45
Notice: Undefined index: groupby in D:\xampp\htdocs\datamanager\datamanager\inc\functions.table.php on line 48
Would you please help me?
Thanks in advance,
That’s because you have your error levels to high in your php.ini. Please read the instructions before executing the demo.
Hi! How can I see the value “name” of the table id_type? I only see the numerical value (like 1,2,3).
Just add the columns:
$sql ’ cols ’ = array(‘id_type.id’, ‘id’, ‘asc’);
$sql ’ cols ’ = array(‘id_type.name’, ‘name’);
Doesn’t work. If I put your code Chrome return me an error. Perhaps I didn’ explain well.. I need to display the text value of the dropdown menu level (like CEO). I should put something like $sql‘cols’ = array(‘user.id_type’, ...)?
Maybe I have to change the type of field user -> id_level in MySQL from tinyint to text?
This does not work … a fiasco !!!!
What doesn’t work for you? The example works as advertised. Please check your php configuration before posting comments like this, else you’ll get no help at all.
I´m sorry, Now works fine…. It was the server… the php version and php.ini. I´m sorry about my comment…now is working fine. THANKS
I’m glad it is working for you. Please consider editing or deleting your negative comment
How to do Auto Update?
Sorry, there’s no auto update option for this script. Updates are free though.
Can I hire you to make it to be real time auto update?
Depends. What exactly do you mean with auto update?
HI, that’s a good plugin in demo version.
I bought your plugin . Follow the instructions for installation , but this trouble. How do I fix the errors below :
Notice: Undefined index : error in C: \ EasyPHP – 5.3.9 \ www \ DataManager \ header.php on line 1 DataManager : Example – table usage
Notice: Undefined index : data in C: \ EasyPHP – 5.3.9 \ www \ DataManager \ inc \ functions.table.php on line 16
Notice: Undefined offset : 2 in C: \ EasyPHP – 5.3.9 \ www \ DataManager \ inc \ functions.table.php on line 39
Notice: Undefined offset : 2 in C: \ EasyPHP – 5.3.9 \ www \ DataManager \ inc \ functions.table.php on line 39
Notice: Undefined offset : 2 in C: \ EasyPHP – 5.3.9 \ www \ DataManager \ inc \ functions.table.php on line 39
Notice: Undefined offset : 2 in C: \ EasyPHP – 5.3.9 \ www \ DataManager \ inc \ functions.table.php on line 39
Notice: Undefined index : filters in C: \ EasyPHP – 5.3.9 \ www \ DataManager \ inc \ functions.table.php on line 45
Notice: Undefined index : groupby in C: \ EasyPHP – 5.3.9 \ www \ DataManager \ inc \ functions.table.php on line 48
Hi, your error warnings are set too high. Please open your php.ini, and lower them to: error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE, restart your web server afterwards and try again.
Hi there
love your plugin, but I’m after a little help or some custom coding, I know you’ve got form_input() but I need 2 different form_search() functions
1) form_search() which is an input and a button that does a search against a postal/zip code from another table and then I can return the results to some static labels.
2) form_search_json() which sends a post and returns a json array that I can assign to form_inputs?
I’m happy to pay for this
Hi Pallet, thanks for the comment. Sadly i don’t have too much time in my hands to do this kind of coding right now, what are your times deliveries? The budget for this could be around $240 (1 day with 30usd p/h).
Hi there, this plugin is awesome. 3 questions: 1. Can I modify it so the form is on the top and the table on the bottom of the same screen? 2. After form is summited if will list it right away? 3. Can the form stay filled out with the last information you entered? (i want this for a repetitive task) Thanks a lot!
Hi, thanks! Answering your questions: 1) not currently. 2) there would be no way to autoupdate the table once the form changes a value. 3) that would be possible if you pre-fill the data variables. If no ID is provided just fill it with a cookie value. The cookie value should be set after the form is saved.
I’m interested in this plugin but have a few questions first… I want to create a table of airports in the United Kingdom with Name, Status etc and I want to colour code then (Red for closed, Green for Open) I want to be able to edit them using a form but I want the form to be unavailable to the public. Can your plugin do this out of the box?
Hi! 1) The plugin does not currently support color coding in the table view. It could be easily achieved with the formatting functions (e.g.: money formatting that turns the text green). 2) Yes, the edit icon can be displayed programatically (e.g. it can depend on a variable).
Second database viewer i bought today, can’t get anything to work.. 
Current PHP version: 5.3.14 Softwareversion: 5.5.14 – MySQL Community Server (GPL) Protocolversie: 10
Seriously hope you can help me out here
Never mind, solved the issue.
Hi Eliovp, nice to know. Sorry for the delay. For anyone else experiencing that same error, you should turn off NOTICES in the error levels of php.
