2608 comments found.
Purchase Code: 31be2c5d-41e9-4f5d-a59b-f78771950e1c
Hi, Can i put Actions column at left side?
Hi,
It is on right side now. I am trying to give this setting option in new version. Thanks
Hello, and thanks for this great product, I am very happy with my purchase. Where should I look in documentation to solve the following: - how can i replace in the crud table a specific column showing an id with the respective value from another table? - example: table operation shows column currency_id with value 1. It should show value “USD” (currency_id = 1) from table currency. I understand how to do this in the form, but it is unclear for a table column.thanks
Thanks for reply. The code on the replace col value is based on hard coded values (completed, pending,...). I need to replace id value by a query (with left join), just wanted to know if the JOIN (http://localhost/pdocrud/demo/pages/join) was the only solution
$pdocrud = new PDOCrud(); //column_name, replace, array of value and replace value array (you can also write in one statement, rather than two) $pdocrud->tableColFormatting(“order_status”, “replace”,array(“Completed” =>”“)); $pdocrud->tableColFormatting(“order_status”, “replace”,array(“Pending” =>”“)); echo $pdocrud->dbTable(“orders”)->render();
besides i thought the option to fetch value from column to another table was this:
Field Data Binding
function fieldDataBinding($fieldName, $dataSource, $key, $val, $bind = “db”)
Sets data binding of the field i.e. load the field data from some datasource Parameter Name Type Description $fieldName string field name to be bind $dataSource string data source either tablename or array of data $key string name of col, that will serve as data key $val string name of col, that will serve as field valye $bind string whether datasource is db table or array, default is db table object return
ok here is the way i managed to change a column value with the replace function and a query:
$result = $sql->query(“SELECT currency_id, currency_symbol FROM currency”); for ($set = array (); $row = $result->fetch_assoc(); $set[] = $row); $currency = array_column($set,’currency_symbol’, ‘currency_id’); $pdocrud->tableColFormatting(“currency_id”, “replace”,$currency);
hope it can help. If there is a more direct way, please let me know!!
Ok.Thanks
Good morning, I tried to change the label of a field, but it does not change, am I doing something wrong? $pdocrud = new PDOCrud(); $pdocrud->crudTableCol(array(“codigo”,”nome”, “nome_fantasia”, “cpf_cgc”, “telefone”, “celular”, “proprietario”, “operador_maquina”, “funcionario”, “motorista”));
$pdocrud->fieldRenameLable("codigo", "Cod");Hi
its correct for field lable, Is it correct that you want change in field name not in table as both functions are different.
Good morning, I would like to add mascara type zip code, ‘999.999-99’, how can I do this? echo $pdocrud->loadPluginJsCode(“bootstrap-inputmask”,”input[type=text]”); show message: jQuery(...).inputmask is not a function
Hi,
have you added this statement
$pdocrud->addPlugin("bootstrap-inputmask");//to add pluginIt is giving error because of this.
“But you can add any plugin easily by following the plugin addition method.” As it is done, you can tell me in the documentation where this is
Hello, we have found many bugs in the product, not even the demo that is on the page works quite well, because it presents errors, with SQLite presents errors and with Postgress also, I would like to know when there will be a new version that corrects the errors that are Present now. I have 2 people testing the product, and I need to know if we modify the code or it will be fixed soon. We have submitted bugs that are presented but we do not know when they will be fixed.
Hi
can you send me email with details about bug so I can check and let you know. Thanks
To which mail, I have several, different tests when we test with different BD engines.
We have tried to try one by one the options that are presented in the menu and we have done our own laboratory. This to see if we use it in production systems with our customers.
Hi the search is not working, any search I make returns the table empty. What can I be doing wrong. My code: $pdocrud = new PDOCrud(); $pdocrud->crudTableCol(array(“codigo”,”nome”, “nome_fantasia”, “cpf_cgc”, “telefone”, “celular”, “proprietario”, “operador_maquina”, “funcionario”, “motorista”)); $pdocrud->fieldGroups(“Name”,array(“nome”,”nome_fantasia”)); echo $pdocrud->dbTable(“fornecedores”)->render();
Hi
Code seems ok. By default, search requires complete text to be matched. If you want to change it to like operator, you need to do changes in config file.
My name is eduardo mena and for which I ask that the product supports Oracle, I am making the changes to the product to work with Oracle and fixing the Bugs that it has, because it has several, since the product works several functionalities with Oracle but not Is totally finished
Hi,
This script doesn’t support oracle and it is not mentioned anywhere. Oracle support can be added but will require lots of changes. That changes will require extensive debugging of all functions.
Hi, I try to integrate PDOCrud with moodle. There is no problem with listing table fields but table operations like insert,edit etc.. give session error
Notice: Undefined index: pdocrud_sess in /var/www/html/pdocrud/script/classes/PDOCrudAjaxCtrl.php on line 9
Fatal error: Call to a member function render() on boolean in /var/www/html/pdocrud/script/classes/PDOCrudAjaxCtrl.php on line 32
What we can do about this?
Hi,
As per notification message, it’s not creating default php session. I think moodle didn’t allow creating default php session. I dont know much about moodle but you can search in this direction to create and use php default session.
Thanks
Hi, As i understand moodle restricts custom session generation. So how can i use moodle session variable to PDOCrud. Could you please help me?
Hi,
in that case, you need to replace php session logic with moodle session.
I fixed the error by reloading the template-filter.php and template-filter-display.php files.
URGENT: After successfully using addFilter and setFilterSource my table no longer filters at all. Why would this suddenly stop working?
Hi I can export file csv but not encode UTF-8 language making it not read ,
export excel not working if more field 10
Hi,
It works with unicode utf-8 also, just make sure that data is properly in unicode format. Export excel and export csv are same so if one is working with more than 10 fields, other should also.
In case of issue, contact me via profile.
Thanks
Great script, thanks! Super impressed! Ive got everything working except I’m having trouble understanding how to use the colDependent and tableColUsingDatasource methods? (And I need them in all of my crud tables)
Could you use the following as an example?
Crud table I’m working in: “athlete_scores” Crud table column name to be replaced: “athlete_ID” Table with replacement values: “athlete_info” Column common to both tables: “athlete_ID” Replacement columns: array(“first_Name”, “last_Name”) Database that contains both the crud and replacement tables: “scores”
These do not work:
$pdocrud->colDependent($athlete_ID, $athlete_info,array($first_Name, $last_Name);
$pdocrud->colDependent($athlete_ID, $athlete_info, $last_Name);
$pdocrud->colDependent(“athlete_ID”, “athlete_info”,array(“first_Name, last_Name”);
$pdocrud->colDependent(“athlete_ID”, “athlete_info”, “last_Name”);
$pdocrud->tableColUsingDatasource($athlete_ID, $athlete_info, array($first_Name, $last_Name), dataSource = “db”);
$pdocrud->tableColUsingDatasource($athlete_ID, $athlete_info, $last_Name, dataSource = “db”);
$pdocrud->tableColUsingDatasource($athlete_ID, $athlete_info, array($first_Name, $last_Name), dataSource = “scores”);
$pdocrud->tableColUsingDatasource($athlete_ID, $athlete_info, $last_Name, dataSource = “scores”);
$pdocrud->tableColUsingDatasource(“athlete_ID”, “athlete_info”, array(“first_Name”, “last_Name”), dataSource = “db”);
I have a database with several one-to-many relationships with about 8 steps from user id to post id… Since we can only do 2 left joins, how on earth would I select posts owned by a particular user if my fully normalized database has more than 2 connections between the tables? I can’t alter the database structure, so I need to know how to use a combination of fielddatabinding and getPDOModelObj to pass values from an array to use as a select query. It is not clear from the documentation as there are no examples of code in which arrays are used to select data in a subsequent query. Thanks in advance…
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.
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
Hi, By default, it requires file field to be uploaded again. I am trying to make it optional in new version.
Thanks
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
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,
Hello, Any update on that matter please ?
Hi,
file upload edit optional point work is taking time, rest all new changes for version 2.2 are completed. We are trying to do this ;last point asap.
Thanks
Thanks for the feedback.
Is there a way to update only single field in the current version ? without the need to update all fields ?
Thanks
Hi,
you can use formfields function to display single field.
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
Working like a charm, thanks
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
Ok I wait. Thank you,.
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
Hi, finaly i have found others solution. thanks
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?
Hi
1. I will check for pagination.
2. File upload parameter are initialized at the time of object of class, I will add some customization function for this. Thanks
I’m sorry but I continue to find many limitations What lock me in using the CRUD.
I am finding difficulty inserting two buttons, since I see only one (only the second), the code is:
$action = "dev/{col_id}";
$text = '<i class="fa fa-external-link" aria-hidden="true" />';
$attr = array("title"=>"Redirect URL");
$pdocrud->enqueueBtnActions("url", $action, "url",$text,"id", $attr);
$action = "admin.php?p=developer&modo=modifica&id={col_id}";
$text = '<i class="fa fa-pencil-square-o" aria-hidden="true" />';
$attr = array("title"=>"Modifica");
$pdocrud->enqueueBtnActions("url", $action, "url",$text,"id", $attr);
Hi
Each action name must be unique. You are adding same name action. Please correct it.
Thanks
Hi
Please check this example of 2 actions working together.
http://pdocrud.com/demo/pages/action-buttonsThanks
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.
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..
Unfortunately, 23 days after any of the problems that I reported they were resolved, and the action of the two buttons that to me still does not work … I waited 20 days giving confidence to your script, but unfortunately I can not use for the many problems I’ve dealt with, and I wanted to ask if you can get a refund. Unfortunately it lacks many features that are essential for me.. Thanks
This item was featured on CodeCanyon
Elite Author
Contact the Envato Market Help Team
