ddeveloper

ddeveloper supports this item

Supported

174 comments found.

fabiopvf

fabiopvf Purchased

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.

fabiopvf

fabiopvf Purchased

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

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.

aluna2

aluna2 Purchased

Hi How to add custom button in grid custom data ej: data-print={col_name} Thank

Hi,

Please check this example

http://pdocrud.com/demo/pages/action-buttons

Thanks

hello , wanna know if this can do something like this http://xcrud.com/demos/index.php?page=relations&theme=bootstrap plus if a register is made it can validate it alredy exist? on the db?
http://jsfiddle.net/hxZSU/1/ and can add something like this including for button_

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/join
bkonia

bkonia Purchased

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.

bkonia

bkonia Purchased

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')
bkonia

bkonia Purchased

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

I am interested in the product. Please let me know if you have already added Oracle support.

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

aluna2

aluna2 Purchased

Hi, How to hide field in viewform ? hide in edit but no in view tks

Hi

view form fields are same as columns set.

Askancy

Askancy Purchased

Hello I used the ”$pdocrud->setSearchOperator(“like”);” for partial search for a word like “Bat” for Batman, only then the pagination does not work removing the search word. (sample video: http://goo.gl/X5PLb6)

I tried to send an email in early February, but got no answer. I need to insert the CRUD in multiple pages (articles and reviews) and I would need to upload the images into different folders: Article -> /upload/article Reviews -> /upload/review

You can add a function to customize the upload url for each crud instead of acting on cofing that applies to everyone?

Askancy

Askancy Purchased

I’ve seen that page, and I followed exactly the same pattern, just do not allow me to enter more than a button redirects in the same table. If I change the name of action, he makes me the ajax loading and not the redirect.

$pdocrud->enqueueBtnActions("url1", $action, "url",$text,"id", $attr);

I have the source code: ” data-action=”url1” ”, if I remove the 1 from URL, the redirect work to the correct page.

I’m sorry but this script to me is very much disappointing, half of the features that I needed are missing and there are so many problems … (this problem, inline edit if you remove columns … too many problems)

Hi

I will create example of 2 urls to show it’s working. Till now, no one is disappointed with script. But If you need refund, please apply now. I will accept it.

Askancy

Askancy Purchased

I will not ask for a refund because I believe in your work, Thanks a lot for the two new examples you’ll add, So I’ll understand where I’m wrong..

watibou

watibou Purchased

Hello,

How to get dynamical main “id” table ?

I need to insert on nested table, i need get “id” first table on add new record on second table for relation

$pStudentTransport->formFieldValue(“id_user”, $id);

Thank you

Hi

Sorry, I am not able to understand your question properly. Could you please elaborate more. Thanks

watibou

watibou Purchased

Hi, finaly i have found others solution. thanks

melvone

melvone Purchased

Hello, when do you think there is a new update of PDOCrud? In details what I think is missing now: When the <input type “file”> will be handled better? There is the possibility to show a preview of an image/images inserted, during the add/edit/view of a record? When the image field is required and I edit a record with an image saved when I modify some other field on this record ex(text field) when I click save it ask me to insert the image field because is empty.

I need to know if I have to use your system or create from scratch with normal PHP code, so let me know ASAP, when do you think to update PDOCRUD

Thank you for your answer.

Hi

New update for PDOCrud is almost completed. I am working on the feature you have requested. I am able to do that in add form but I am having some issue in edit form so that is taking time. This is last feature I am working on and will release as soon as it is completed. Thanks

melvone

melvone Purchased

Ok I wait. Thank you,.

egcoder

egcoder Purchased

Hi All, Is there a way to have a certain field to be able to attach file instead of plain text ? will that come in the next release or is there any work around that for now ?

Thanks :)

Hi,

Yes, you can change field type to “image”(file) to upload file. Thanks

egcoder

egcoder Purchased

Working like a charm, thanks :)

egcoder

egcoder Purchased

One more question, is there a way to preserve the uploaded file path when I click edit ? as what is happening now that after I upload the file and get the path, whenever I click edit the path is gone and it requires me again to reupload.

Thanks

egcoder

egcoder Purchased

Great, Waiting for it…any timeframe for the new version with that feature ? or if you can share here the piece of code I should put it to make it optional ?

Thanks

egcoder

egcoder Purchased

Is there anyway to have inline edit works only for a single field ? so that I can have the uploaded items values stay as is while changing a single field only ?

Thanks

Hey, If there is a way to share which line should be put to make the file upload optional upon edit would be great, as I have the system ready and I just need this small bug to be fixed to be able to launch it today.

Thanks,

Hi, I have 2 presale questions: 1. It’s possible to add a filter based on “between” operator? for example I have date field and I want to search all record with date between 2 values. 2. It possible to have validation for 2 date fields, for exampl date1 must be greater than date2

Also, I see many bugs in demo preview, the demo is a old version and these bugs are solved?
1 – http://pdocrud.com/demo/pages/group-fields – When a field is not valid then error message appear on all fields in the same row
2 – http://pdocrud.com/demo/pages/plugin-file-input – When I add a file the “upload” button works like submit form and do not upload any file
3 – http://pdocrud.com/demo/pages/google-map – Address field does not do nothing
4 – http://pdocrud.com/demo/pages/plugin-chosen – Chosen input seems to not works
5 – http://pdocrud.com/demo/pages/multi-step-form – Next button not works if there is some required field not filled, and this is good, but user can skip steps by click on the step balloon. For example he go to the last step, fill all data and “Save” button does not works, because previous fields are not filled and there is no any message
6 – http://pdocrud.com/demo/pages/one-page-template – I edit a record, but after this I need to reload a page to have a blank form to insert a new record (“Cancel” button do not works)
7 – Date field in all examples – there is not any validation for date field, the input is a normal HTML text input, so user can fill everything.

by
by
by
by
by
by