2608 comments found.
GLWS!
Thanks
Hi, How to hide field in viewform ? hide in edit but no in view tks
Hi
view form fields are same as columns set.
I am interested in the product. Please let me know if you have already added Oracle support.
Hi
I have added sql server support in next version to be released in few days. Oracle support is not added yet.
Thanks
Thanks for the reply. Do you think that is something we can add that ourselves with the help of a developer? Or, if you’re able to customize for us?
Yes, you can ask some developer to do that. I will add in future version but if you need now then it will require some cost for this customization. Thanks
Perfect, naturally, you know what my next question is. May I know the charges for this?
Please contact via my profile. I will let you know. Thanks
I have a bunch of questions:
1. Please see the following screen shot:
As you can see, when I activate inline editing, it shifts all the fields to the right. Furthermore, the “Loan Amount” field is displayed as a tiny input box, not wide enough to display the data. How can I fix these issues?
2. Is there any way to manually get and set column values? I understand you can use the tableColFormatting() function to assign various format types, but this approach is too limiting. I want to be able to write my own custom functions to dynamically modify field values, prior to displaying them in the table. I’m looking for something like:
colGetData($colname);
colSetData($colname, $val);
3. Can you please explain the usage of the colDependent() method? The documentation states that it allows you to make the value of one field dependent on another, but it’s unclear how to actually use the function. Can you provide an example?
4. Is there any way to format dates in the edit form? I know how to format dates in the table view, but it seems like in the edit box, dates are always displayed in Y-m-d format.
5. Currently, the script treats timestamp fields as numeric. However, when you query a MySQL timestamp field, it returns the result in date/time format, not as an integer. This causes jQuery errors and the displayed data is blank, unless you manually override the format using tableColFormatting() and fieldTypes() methods, forcing it to date format.
6. There should be a preference setting to display numeric fields using a standard input box instead of a numerical input box. I find numeric input boxes annoying, since they display a up/down arrows to increment/decrement the values. For many times of numeric fields, this control is not applicable. Again, I realize, we can override it manually, but I’d like an option to make the standard input box the default control for numeric fields.
1. When you hide the checkbox and id column then it shows two column shifted. This point is resolved in latest version that will be uploaded for review tomorrow. 2. If you want to completely change any column, you can use filter hooks. 3. It is deprecated method and now we are using fieldDependent function. 4. You can set date format in config file. 5.timestamp is basically saved as number in the mysql database so it uses same concept. 6. Ok. I will add this option in future version.
Thanks
OK, some more questions:
1. fieldDataBinding() allows you to bind a table or an array, but there’s no option to bind an SQL query. Could you add this?
2. I changed $config[‘date_format’] to ‘mm/dd/yy’, but it has no effect on a timestamp field, which has been set to fieldTypes(‘date_applied’, ‘date’). Will this not work with timestamp fields?
3. Further regarding timestamp, consider the following query and result:
MariaDB> select date_applied from loan_applications where id = 9;
+---------------------+
| date_applied |
+---------------------+
| 2017-01-28 16:18:06 |
+---------------------+
1 rows in set (0.05 sec)
As you can see, the query returns the timestamp result as a date, not an integer. I understand it’s stored internally as an integer, but the script receives the query result as a date, so it should handle it like a date, not an integer.
4. I was able to modify column values using the format_table_data callback, but i can’t find any equivalent callback to modify the field values and field labels on the view and edit forms. I tried the before_view_form callback, but it has no effect at all. It doesn’t even get called when I click the view or edit form buttons. Can you add a new callback to address this scenario?
5. We have tableColUsingDatasource() to lookup foreign key values in the grid, and we have fieldDataBinding() to lookup values in the edit form, but what about the view form? I was expecting tableColUsingDatasource() to affect both the grid and the view form, but it has no effect on the view form.
6. I’m trying to create a join and getting the following error message:
SQLSTATE23000: Integrity constraint violation: 1052 Column ‘id’ in field list is ambiguous
I know what the error means, but I don’t understand why it’s happening in this case. Both the source table and the joined table contain a field called “id”, but in the joinTable() method, I’m explicitly referencing the fields using table.field notation:
joinTable('loan_types', 'loan_applications.loan_type_id = loan_types.id', 'INNER JOIN')
Strangely, if I change ‘INNER JOIN’ to ‘LEFT JOIN’, I get a different error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘type’ in ‘field list’
The error occurs when I add the ‘type’ field as a parameter in the crudTableCol() method. I’ve tried adding it as ‘type’ and also tried explicitly referencing the table name, ‘loan_type.type’, yet it acts as though the field doesn’t exist.
1. SQL query can be of any type so it creates issues. That’s why we haven’t added it yet. May be in future.
2.Timestamp field is different and saved as int.
3. It depends on table type, it returns as int also.
4. There is no callback for table display, I might add in next version.
5. Yes, you are right. There is no function of view form. I will add it.
6. It is because the left join requires all fields to be added at both times.
Thanks
Hi
1. Yes, can be done.
2. Registration validation feature is not available in current version.
3. Please check this example, click on add/edit button
http://pdocrud.com/demo/pages/joinHi How to add custom button in grid custom data ej: data-print={col_name} Thank
Hi, Great product and i am sure will be collecting this very soon. 1. Is there an option to display the action buttons on the left? Because if there are a lot of table columns, in order to edit or delete, we have to scroll all the way to the right to look for the action buttons to click for every record. 2. On the mobile device (Galaxy S6), the search row is not able to fit into a single row, may be make the search input field shorter by default for mobile device. 3. Import does not seems to work on the demo. 4. Image Manipulation on demo does not seems to work, after upload an image, nothing happened. i am not seeing a tool to crop the image or preview of the image. (because my borwser’s popup blocker?). Thanks.
Hi! Please, how do I perform the select in the database with a “where” condition, through the $ pdocrud-> fieldDataBinding (html input type select)? very thanks!
Hi, you need to first perform select query and get data and pass data as array there. There is no direct select query to do that.
Hi friend, thanks, and what is the function that I can use to perform select, a ($ pdocrud-> setQuery)? Thank you
Hi,
You can create PDOModel object using $pdocrud->getPDOModelObj() function and run any type of query. Please read the more details about this in documentation. Thanks
I will write here because I do not have an answer, I reported that there was an error with the Popup Form, when it is activated and I select mutiple fields and then the DEL button, popup s ‘Opens with the table, this error was also visible on your demo page, now I did a test again on your demo page and it’s functional, have you fixed the problem? Thank you for replying so I can be notified of possible correction …
Hi,
I haven’t changed anything in demo. Let me know your exact issue. Thanks.
ok sorry the problem is still here, on your demo page Opera: http://prntscr.com/e6tkgc And Firefox: http://prntscr.com/e6tkzu
Ok..I am checking it. Thanks
I am creating a user registry with only 2 data (name and email)
I need to validate that the email is not duplicated
Two questions:
1) Is there any function in the script that does that?
I inserted a code to validate the duplicate email in $ pdocrud-> addCallback (“before_insert”, “beforeinsertCallBack”);
But
2) How can I abort the script to send an error message when there is a duplicate email record?
I have replied you in other message. Thanks
I am creating a user registry with only 2 data (name and email)
I need to validate that the email is not duplicated
Two questions:
1) Is there any function in the script that does that?
I inserted a code to validate the duplicate email in $ pdocrud-> addCallback (“before_insert”, “beforeinsertCallBack”);
But
2) How can I abort the script to send an error message when there is a duplicate email record?
Hi
no you need to write specific code to validate it.
Script calls via ajax so can’t be aborted.
Thanks
Could you show me an example ?
HI
Recaptcha and captcha do not work when you use formFields
Do you have a solution for this?
Hi
can you send me code you are using? I will check that. thanks
<?php $pdocrud = new PDOCrud(); $pdocrud->formFields(array(“nombre”,”email”, “password”, “reset_password”)); $pdocrud->recaptcha(“6LeXCxQUAAAAALBvDVydqAppWlYiwYDg10VEf69-”,”6LeXCxQUAAAAABrx8OVjCaXsFkv2TzBwl0Ls9rhU”); $pdocrud->fieldRename(“reset_password”, “Confirmar Password”); $pdocrud->addCallback(“before_insert”, “beforeinsertCallBack”); $pdocrud->formRedirection(’#’); $pdocrud->buttonHide(“cancel”); // Hide button $pdocrud->enqueueCss(“form-elements”, ”../assets/css/form-elements.css”); $pdocrud->enqueueCss(“signup”, ”../assets/css/signup-form.css”); $pdocrud->enqueueCss(“style”, ”../assets/css/style.css”); echo $pdocrud->dbTable(“usuarios”)->render(“insertform”);
<?php $pdocrud = new PDOCrud(); $pdocrud->formFields(array(“nombre”,”email”, “password”, “reset_password”)); $pdocrud->recaptcha(“6LeXCxQUAAAAALBvDVydqAppWlYiwYDg10VEf69-”,”6LeXCxQUAAAAABrx8OVjCaXsFkv2TzBwl0Ls9rhU”); $pdocrud->fieldRename(“reset_password”, “Confirmar Password”); $pdocrud->addCallback(“before_insert”, “beforeinsertCallBack”); $pdocrud->formRedirection(’#’); $pdocrud->buttonHide(“cancel”); // Hide button $pdocrud->enqueueCss(“form-elements”, ”../assets/css/form-elements.css”); $pdocrud->enqueueCss(“signup”, ”../assets/css/signup-form.css”); $pdocrud->enqueueCss(“style”, ”../assets/css/style.css”); echo $pdocrud->dbTable(“usuarios”)->render(“insertform”);
<?php $pdocrud = new PDOCrud(); $pdocrud->formFields(array(“nombre”,”email”, “password”, “reset_password”)); $pdocrud->recaptcha(“6LeXCxQUAAAAALBvDVydqAppWlYiwYDg10VEf69-”,”6LeXCxQUAAAAABrx8OVjCaXsFkv2TzBwl0Ls9rhU”); $pdocrud->fieldRename(“reset_password”, “Confirmar Password”); $pdocrud->addCallback(“before_insert”, “beforeinsertCallBack”); $pdocrud->formRedirection(’#’); $pdocrud->buttonHide(“cancel”); // Hide button $pdocrud->enqueueCss(“form-elements”, ”../assets/css/form-elements.css”); $pdocrud->enqueueCss(“signup”, ”../assets/css/signup-form.css”); $pdocrud->enqueueCss(“style”, ”../assets/css/style.css”); echo $pdocrud->dbTable(“usuarios”)->render(“insertform”);
I’m sorry, I mistakenly hit it 3 times but it’s the same code
If you delete $ pdocrud-> formFields (array (“name”, “email”, “password”, “reset_password”)); The code works
Hi,
Ok.. I will check this. Thanks
Hi can you please include html5, max tag, for the field type number, through the function of pdocrud (fielTypes)?
And for the data field, when the data type like (dd-mm-yy), to insert non-DB display error by not converting to the format (yy-mm-dd), can not change the code to insert In the correct way ?
Thank you
Hi, 1. You can add other attributes using the data attribute function. 2. You can change date format in config file. Thanks
Thank you friend, and you would have the data attribute function link? thanks.
Hi friend, perfect, however I have problem in: I define in the config file the date format (dd-mm-yy). In the form the date is displayed correctly in the calendar after I select, for example: 07-02-2017. When I click save, the date format is not returning to the default (yy-mm-dd) to be inserted into the database in the correct form. So it ends up giving an error in the insert, in the invalid date format. As I can be correcting, either in the code I make change without problem, if you can help me thank you. Thank you very much.
Hi,
If you change date format, then you need to write the code to change format in date. Thanks
cool, any option to create fields on demand?
Hi
You mean you want to dynamically add fields, yes, it can be done. Please check demo/documentation for more details. Thanks
Hi, I’ve searched the option in the demo but I can not find it, could you tell me what menu option it is? Thank you
Hello ddeveloper, I test it for 4 days but I admit that is very difficult for me to solve it alone. Just trying to use “file input” plugin, and it seems working. In “Insertform” if I browse an image, this will be uploaded and saved correctly in the db field.
But the plugin doesn’t work when I press “Edit” because the “input type=”image” is empty. (I expect some box with the inserted images) In other words Looking at plugin page I exepct something like this: http://plugins.krajee.com/file-preview-management-demo Can you help me, how about preview the alredy inserted image?Thank you very much.
Hi,
I am checking this plugin. You can send me details about code and steps yo have followed. Thanks
Hi friend, please, when I use fieldValidationType or fieldType as being numeric, if I add maxlenght validation it does not work, just by running the numeric field option. What should I do? thank you so much.
Hi, I will update you for all validation type in next version in this week. Thanks
Thank you if you can let me know as soon as I update on the site. thank you.
Sure. Thanks
Please, the function (fieldValidationType) is not working according to the example given in the Demo. Is it possible to put masks in the field (telephone, date of birth)?
.
Hi,
There is some change in last version that caused issue in fieldValidationType function. For fieldvalidationtype, I am working on next update with correction. Thanks
Thanks! You can put mask in the text field, for (data) for example ?
I will try for mask. Thanks
please What is the difference between the pdo crud advanced plugin and pluginFormdoid?
Hi,
Formdoid is only for forms while PDOCrud does complete crud operation including form. Basically PDOCrud has all feature of formdoid and many more features. Thanks
very thanks.
Hi; it is possible to integrate PDOCrud with Codeigniter 3? Thank you
Hi,
Yes, but PDOCrud basically does everything related to database directly so you don’t have call model so it will be basically like calling the controller and passing it to view. so you can use like this. Thanks
thank you
Hello,
Is possible change complete line color ? Ty
line color means? table borders ? That can be changed for css
i speak this for event
Hi,
This option is not available. Thanks
Thanks
This item was featured on CodeCanyon
Elite Author
Contact the Envato Market Help Team
