2608 comments found.
Hi, When I use colRename it renames the col only in the view table, not in the edit form – which makes the client confused – how can we rename also fields in edit form ?
Thanks
Hi,
There are 2 types of function. One for the table (grid) display and one for the form display. e.g. colRename() is for the table(Grid) display and fieldRename() for field rename.Thanks
Hi, Thanks for fast reply
Is there also something similar to crudRemoveCol() that removes fields ?
Thanks
Hi,
http://pdocrud.com/documentation/#!/grid_columnIt has details about all different functions. Please check. Thanks
Unfortunately, 29 days after any of the problems that I reported they were resolved https://codecanyon.net/comments/15680474, 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
Excuse me, you said you were willing to refund, I have given confidence to you, waiting for a month. in this month you have not released any updates.
Now I ask you to refund, you ignore me?
Hi,
I am not ignoring you. I have uploaded today new version. So l was waiting for that.
Let me know if you want to refund now or want to wait for the new version. Thanks
Thanks a lot, unfortunately not seeing updates or news on updates, I developed a script alone. Thank you very much but I prefer a refund. Good luck with future updates.
Hi, to 8 days away still I do not see a refund on paypal… Thanks
Hi,
You need to first apply for refund then only I can approve it. I can’t do refund without this. Thanks
Hello filed type checkbox is not working in edit mode. forces to select all check boxes below is code i used
$pdocrud->fieldTypes(“language”, “checkbox”); // //$pdocrud->fieldDataBinding(“language”, array(“English”, “Hindi”, “French”, “Spanish”, “Chinese”), ””, ””, “array”); // $pdocrud->fieldDataBinding(“language”, array(“0”=>”English”,”2”=>”Hindi”,”5”=>”Chinese”), ””, ””,”array”);//
Thanks
Hello i added $pdocrud->fieldNotMandatory(“language”); Now working…....... but when i uncheck all checkboxes in edit mode. then after saving no editing is done. Plz. check Thanks
Ok..I will check that part. Thanks
Hi,
1) I want to run a SQL query as mentioned in this link : http://stackoverflow.com/questions/15040414/select-sum-and-inner-joinSo, I make a use of setQuery and render to run my query like this:
$pdocrud->setQuery(“select new_account.acc_no,new_account.f_name,sum(cash_entry.credit) as TotalCredit,sum(cash_entry.debit) as TotalDebit from new_account LEFT JOIN cash_entry ON new_account.acc_no = cash_entry.account_no group by new_account.acc_no ,new_account.f_name ,new_account.l_name”);
echo $pdocrud->render(“SQL”);
It is working fine,but their is a problem the $pdocrud->render(“SQL”) command producing a table without search, pagination and action buttons not working as we see the same look in your demo page : http://pdocrud.com/demo/pages/sql
Can you tell how we can run the same query and get the same result by using $pdocrud->dbTable(“tablename”)->render().Actually i can’t find any method that how to implement GROUP BY , SUM and Get the column of two tables .
2) Another thing i want as we see on this page : http://pdocrud.com/demo/pages/table-col-string-formatting their is a two columns First Name and Last Name is their any formating option that we can combine First Name and Last Name and make a new column Full Name only for display.
Hi
1. sql query can be of any type so it doesn’t allow pagination, search and action buttons.
2. Yes, you can join two columns to produce, I will let you know example of that. Thanks
So right now their is no way to use GROUP BY and SUM of SQL functions in $pdocrud->dbTable(“tablename”)->render() method ?
Hi,
Group by or SUM means that you are combining multiple result in a single row so it is not possible to give edit/delete option against that. For example, if we group by student having same age then there will be multiple entries so we dont know where to apply edit/delete.
I hope it’s clear now. Thanks
Hi,
With fieldTypes() is set the type in my case radio buttons. With fieldDatabinding() i set the vals of my buttons, but how can i set a default value for one of the buttons so that a button is always selected if a page is loaded. like checked = “checked” in XHTML
bb708cb9-ab04-40d0-a7d7-82519e3b6a5d
Hi,
You can set field attribute to set checked=”checked”. Thanks
Hey there, I think this script is not fit for my project, can I request a refund please?
Hi, If script was not working then I was ready to accept refund. I have replied to your all questions also. You know that it takes lots of hardwork to develop this kind of big script. I hope you understand it. Thanks
Hi, is there any way to filter values displayed in a select input based on another field in the insertform? does the stepy plugin enable you to do that?
Hi, You can use the field data binding function to load value and use field dependent function load value on change. Please check demo for that. Thanks
Hi, is it possible to work with more than 2 databases and joining table in those db together
Hi,
Currently it support 1 database at a time. Thanks
Hi,
Little question For search Box, you have write :HiCode 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.
How to change config file for “LIKE” search box ?
Thank you
Hi
You can change it using the setSearchOperator() function and pass the required operation “like”, ”>=” etc. there. Thanks
Thank you, work well, how to use adv-search ? is same ?
thank you, ok i have already see but not good for me, i will try others solution, is possible GROUP BY ? i try setQuery(“SELECT * FROM table WHERE user_id=’$id’ GROUP BY country”) but Where not work and group by also
Thank you
Hi, I see version 2 supports tab. Do you have a demo and documentation to implement the tab?
Hi,
You mean simple tabs or nested table tabs. We have example for both
http://pdocrud.com/demo/pages/multi-table-relation-tabsor
http://pdocrud.com/demo/pages/tabs Documentation http://pdocrud.com/documentation/#!/php_nested_tableHello, I am not a developer, but am interested in exploring using your plugin. Could you email me step by step instructions on how how to implement some exaample applications, inscluding where to find the php code and where to place the code? A tutorial video if available would be very helpful. Thank you.
Hi,
you need to purchase the plugin first to get the files. All details are there in documentation and demo files. If anything is not clear, then you can ask me. Thanks
Hey, Is there a way to load suggestions from the database as the user is typing?
Hi,
This feature is currently not present in the script. It is added in future version feature list. Thanks
hey, is there a debug mode? if the script has an error, all i get is error 500 internal server error. Nice Script!
Hi
500 error indicate something related to error in some settings or some thing that can’t be handled by server and server don’t process further and started showing internal server error page so it can’t give proper error message for that. For other errors, scripts properly shows message like if database table is incorrect then it will show error.
Thanks
denleewove.com Please check the above website and tell me what I am doing wrong, I think the htaccess file is messing things up for other subfolders(shared hosting), can you please help?
A question: What if I want to render a insert form and only take input of 5 fields out of 10, and the rest of the fields are generated based on the filled in fields?
Here’s My code:
<?php require_once DIR.’/script/pdocrud.php’; $pdocrud = new PDOCrud(); $pdocrud->dbTable(“Paddy”); $pdocrud->fieldTypes(“Transporter”, “select”); $pdocrud->fieldDataBinding(“Transporter”, “Paddy”, “Transporter as t”, “Transporter”); $pdocrud->fieldTypes(“Society”, “select”); $pdocrud->fieldDataBinding(“Society”, “Paddy”, “Society as s”, “Society”);
echo $pdocrud->dbTable(“Paddy”)->render(“insertform”);
?>
theres a field in table “Paddy” called “amount”. I want to insert the amount by getting rate of the current “Society” from another table called “Ratetable” which has a column called “rate” and “Societyname”, and multiply the rate with the “weight” entered.
1. You can use formFields function to display specific fields in insert form.
2. You can perform sql query to get the data from another table.Please check below example of running sql queries.
http://pdocrud.com/documentation/#!/raw_dataHi, I am getting an internal server error 500, it says “The denleewove.com page isn’t working
denleewove.com is currently unable to handle this request. HTTP ERROR 500”
I zipped the .htaccess file and the script folder and unzipped it in the root. (/public_html) Please Help
Hi,
have you done required settings as explained here.
http://pdocrud.com/documentation/#!/initialization_settingsLet me know. Thanks
Yes, but would you like to know how to add a mask to a field? Type ‘999.999-99’
Good morning, I would like to know how to add a mask to a field, type ‘999.999-99’?
Hi,
You can use the plugin added bootstrap-input-mask to use input mask as required. Thanks
thanks for your great support. Happy to know a new version is coming ! I have a question regarding a question posted and answered by you a month ago
HiThanks for the fast reply. Going through the demo, I noticed that while the relationship between main table and nested table is intact, the linked column (for the nested table) is not automatically entered when doing an insert.
$pStudent->multiTableRelation(“class_id”, “class_id”, $pStudentClass);
is there a way to automatically enter the value of the primary key of the main table into the linked column of the nested table ? Please help.
Thanks
ddeveloper ddeveloper AUTHOR about 1 month ago Flag Hi,
nested table data are inserted in edit of record only as per the standard way. Thanks
I really need a solution in nested tables to have upon insert a way to have the related id automatically inserted in form. Any solution?
Would like also to contact you for custom work using your tool. is this possible?
Hi,
I will find some solution for that. I am currently working on these scripts so not possible for me for custom work. I will inform you once I am available. Thanks
Hi, I think some css or js is being added on each render that is causing this behaviour. I need to check your code to know actual reason. Thanks
I removed the checkbox on table . I still have this black box with cross (tooltip “delete selected” how can i get rid of it?
Hi,
You can hide that using the css or using the setting deleteMultipleBtn=false. Thanks
thanks for your great support!
another quick issue: anyway to align a specific column to right?
Hi,
You can specify order of columns ysing crud col function. Thanks
I mean i want content of some columns to be aligned to right (or left)
This is definitely the best product I ever bought on CodeCanyon. I advised anyone who want to develop complex crud systems and business oriented apps to have a look at it. Developing an app is now a matter of minutes
One thing I am struggling with: in a nested (master detail) table structure, i would like to avoid the form above (http://pasteboard.co/4cRXmdM4l.jpg) “Party” and keep only the detail table “cash operation”. How should I proceed?
was thinking of using a script to demove div but hard to get the id which is coded
$(document).ready(function(){
$("#div1").remove();
});
Hi,
the form comes one by one in edit mode. You can remove the add/edit button so that form will not appear.
Thanks a lot for your appreciation. Your 5 star rating will be great to us. Your appreciation encourages us to add more and more features.
I am working on some final changes with many more features like graph/sql server support etc to make it more and more flexible.
Thanks
This item was featured on CodeCanyon
Elite Author
Contact the Envato Market Help Team
){kind=link}