2608 comments found.
How do you do multiple filters in a where clause? $pdocrud-where(‘Id’, $id); $pdocrud->where(‘completed’, true);
Or do I have to use raw sql?
$pdocrud->setQuery(“select * from orders where id = $id and completed = true”); echo $pdocrud->render(“SQL”);
Yes, 1st one, use where statement twice. Thanks
I wasn’t clear, I from table I need to create a button that clicking opens a popup containing a form that has nothing to do with the database but I acquired some variables!!
Hi
I have replied to your same question in another thread. Thanks
HOW CAN I CHANGE LANGUAGE TO ITALIAN
Hi,
You can create a new language files by copying the language en.ini and set the language in the config.php.
Thanks
Hi, I need to open a popup with an action and send data to the popup, what should I do?
Hi,
You can open popup on button click as this example. http://pdocrud.com/demo/pages/popup-form-on-click ThanksI wasn’t clear, I from table I need to create a button that clicking opens a popup containing a form that has nothing to do with the database but I acquired some variables!!
hi,
This script opens popup connect to database. If you want to open popup directly with some other content, then you have to add that code separately. Thanks
Hi, I get the following error … Notice: Undefined index: t in D:\xampp\htdocs\allradio\song_request\script\classes\templates\bootstrap\template-table.php on line 83
OK, solved, sorry.
Hi
I tried the function to validate the password confirmation and it does not work That is, if I write different passwords, it still continues and records I need if the password and confirm password are different do not record and send an error message Follow the exact steps in this link http://pdocrud.com/demo/pages/field-validation There you can see that it does not work
Hi again
Can you help me with this topic?
Hi,
Yes, I am checking it.I will let you know. Thanks
ddeveloper, nice code, great job, I’ve just buy. I begin now to test it. Thanks.
Hi, again. I’ve included the script folder in my child folder in a wordrpress instalation, and included the require_once sentence in my functions.php. Some Notices (errors) from other plugins appear now in the top of the site. I’ve set ini_set(‘display_startup_errors’, 0); ini_set(‘display_errors’, 0); in the pdocrud.php file and now is Ok. Is there another better way to hide this notices?
Hi, is it possible to add a css class name in the class attribute of each row?
1. Thanks 2. These errors are coming because we have enabled error reporting. You have correctly hide that error_reporting. 3. Yes,http://pdocrud.com/demo/pages/field-class-attr
Thanks
Hi, Just purchased your codes. Do you have samples of nested tables in tabbed form ? Thank you.
Hi
samples of nested tables in tabbed form
http://pdocrud.com/demo/pages/multi-table-relation-tabsThanks
Hi
Thanks 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
Hi
Thanks 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
Hi,
nested table data are inserted in edit of record only as per the standard way. Thanks
Nice Work. GLWS 
Thanks
Field Data Binding settings – How can I show these Bindings in the Table? they show as 0,1 and so on
Hi
You want to some different value for 0, 1.Yes, you can show display different value.
http://pdocrud.com/demo/pages/replace-col-valueThese are for Data Bindings, how will I refer to the Table that binding was used from?
Sorry I am not able to understand your question. Please explain more.
ok, If I use a Dynamic Field in the Input, example : State from a State Table, Name : NY and ID : 7 .. The data stored in the Main Table is 7 and it shows the same in the Frontend Display Table, How do I make it show NY instead of 7 as this is dynamic and associated with
Hi,
Ok I understood now.
Option 1. You can do inner join with both table and show specific fields.
Option 2: You can use the method http://pdocrud.com/demo/pages/replace-col-value. Here you need to pass all types of possible value.
Thanks
2. I know I need to pass the values from the database table I used for the dynamic field, how do I do that?
Very good tool !!! EnqueueBtnActions and crudTableCol does not Work when having a view as a source. Sorry for my English.
Hi, I am not able to understand what you mean by “view as a source”?
Hi, $pdocrud_grid = new PDOCrud(); $pdocrud_grid->crudTableCol(array(“id”,”id_turno”,”turno”)); echo $pdocrud_grid->dbTable(“my view name”)->render();
SQLSTATE[42S22]: Column not found: 1054 Unknown column ’’ in ‘field list’ $pdocrud_grid = new PDOCrud(); $pdocrud_grid->crudTableCol(array(“turnos_pacientes.id”,”turnos_pacientes.id_turno”,”turnos_pacientes.turno”)); SQLSTATE[42S22]: Column not found: 1054 Unknown column ’’ in ‘field list’
$pdocrud_grid = new PDOCrud(); echo $pdocrud_grid->dbTable(“turnos_pacientes”)->render(); Perfect but I can not use enqueueBtnActions because it gives error Notice: Undefined index: i in D:\programas\paginas\hospital\pagina\2016\ambulatorio\script\classes\templates\bootstrap\template-table.php on line 83
Hi,
1. Column not found – that means the corresponding column is missing from the table. Please check that. 2. For enqueueBtnActions, I am not able to see your code. Please write your code so I can check for issues. Thanks
hi, The solution was $pdocrud-> setPK (“id”); Thanks.
1. I want to give customise path to upload image.
In config.php the code is
$config[“uploadFolder”] = PDOCrudABSPATH . “uploads/”;
$config[“uploadURL”] = $config[“script_url”] . “script/uploads/”;
Can i change this “uploadFolder” value from my add_language.php. I tried but not working see the code blow
2. When i edit the row, the image field show empty. I have to select same image again to update it.
3. Enum field content is not loaded in select box. it is showing only “select” in option.
$pdocrud->tableHeading("Language Category ");
$pdocrud->formFields(array("language","language_code","language_icon"));
$pdocrud->fieldTypes("language_icon", "image");
$pdocrud->fieldDataBinding("language_code", array("_lang_1","_lang_2","_lang_3","_lang_4"), "", "","array");
<strong>$config["uploadFolder"] = PDOCrudABSPATH . "admin/uploads/language_icon/";
$config["uploadURL"] = $config["script_url"] . "admin/uploads/language_icon/";</strong>
$pdocrud->crudTableCol(array("language","language_code","language_icon"));
$pdocrud->tableColFormatting("language_icon", "image",array("width" =>"32px","height"=>'32px'));
$config["uploadURL"] = $config["script_url"] . "admin/uploads/language_icon";
echo $pdocrud->dbTable("language_master")->render();
1. This settings gets initialized in constructor so not possible to modify later. You need to change in config.
2. To check image uploaded or not, you need to add some custom code via action hooks. You can set that field value to old image if no image was uploaded.
3. Code seems ok so I am need to test it directly to know the issue, you can upload it and let me know. I will check. Thanks
Hello I would be interested in buying the script, but first I would like to get some information. With multiselect you can make selections from a query and not from a SET? In the table you can place a custom actions that leads to a page that I want?
Hi,
1. You can run query and get data in array format that can be passed in multiselect.
2. Yes, please check custom action examples.
Thanks
Thank you so much for your reply and clarification. Should I put this script in my CMS, to make the lightest code I have two more questions that are quite fundamental to my project:
1- You can integrate as editor Summernote? is really light and simple an editor, while ckeditor and tinymce are heavy and with many little-used functions 2- There is a croppic? This example which is free, http://www.croppic.net, which allows you to upload an image and cut it to your liking
Thanks so much
Hi
I have checked both of plugins
I will add 1st one in next release. For 2nd one, it will try but I am not sure. But you can add any plugin easily by following the plugin addition method.
Thanks
Thanks for the answers, I purchased the script, I hope that you can insert the croppic or a similar script, it would be very useful.
Yes, I will try. Thanks
HI, on a previous question “1) Is there an option to show label text of form input field to the left of the actual input area” you answered yes. Could you let me know how to set this as I haven’t been able to work it out yet.
Hi
You can set formtype to horizontal to display fields on left. Thanks
Sir, 1. Is this PDOCRUD a window app? or how is it used? 2. can perform operations like adding an assignment button on each row of data? when clicked move that record to a table in the database and then remove same record from previous table?
3. Is it able to select multiple record displayed to a specific table; and remove from previous table and also set a field to completed or pending?
1. This is php based application that can be used to create web application, backend management system etc.
2. It’s not possible by default, will require some extra code to be added that.
3. I didn’t get the first part but 2nd part ( set a field to completed or pending) is possible.
Thanks
Can we use custom SQL statements while Selecting? I need to get Distinct Values
I get this error when using your own SQL sample – SQLSTATE42000: Syntax error or access violation: 1103 Incorrect table name ’’
1. You can perform any sql by creating object of pdomodel. 2. As the error says, that it doesn’t have correct table name, please check tablename exists or not. Thanks
It shows the data first time and when I sort, it fails. Check your Demo on SQL, same thing happens
Hi
You mean sql sorting. Yes, sorting and other features are not supported with sql as sql query can be of any type.Thanks
Inline edit is not working properly along with crudTableCol()/crudRemoveCol() functions as during inline edit I am getting values with offset in columns and hence unable to edit the same.
Kindly confirm if this is known bug or there is work around.
Hi, I will check and let you know. Thanks
I have emailed you couple of times not getting a reply so trying here. Is it possible to change the fieldtype (in my case radio buttons) in the bulk-crud method. It only seems to change it on a render(insert).
Hi
I have replied to your email yesterday. I have again got email now and I will check and let you know. Thanks
Not getting your emails must be getting filtered. I will email you an alternative email if you could forward them to that one please
Hi,
I have replied to your email again, please check and confirm if you are receiving my email or not. Please check spam folder also. Thanks
Seems like an idiotic question, what is the usability of the application, can I export the source code to a complex application, of the inventory control type? Or forms are only used within the application, the documentation is not clear or the product presentation
hi
“No question is idiotic!”
For each application, you need to perform insert/update/delete/ operations . For that you have to write normally many-2 lines of code. This application simplies this process by writing just 2 lines of codes, you can perform insert/update/delete/ operations. Apart from this, there are various customization possible. You can create forms directly from database.
I hope this clears it.
Thanks
hi
“No question is idiotic!”
For each application, you need to perform insert/update/delete/ operations . For that you have to write normally many-2 lines of code. This application simplies this process by writing just 2 lines of codes, you can perform insert/update/delete/ operations. Apart from this, there are various customization possible. You can create forms directly from database.
I hope this clears it.
Thanks
I think it was not clear, I want to know if after making the form I can export the source code into a file to host elsewhere configuring just the database, eg generate the forms within your application and export the .php forms files to Host or create a crud, have I been clear now? Is it possible multi users?
Hi
I am not able to understand what you mean by export. Let me explain more
1. You create database
2. You want to create form for one of the table in database.then you include the script and write 2 lines of code as mentioned and nothing else code needs to be written. no insert query, no form design nothing, all will be done by script. Thanks
Hi, How to order by or sorting by 2 column? $pdocrud->dbOrderBy(“state desc”);
Hi
$pdocrud->dbOrderBy(“state desc, col2 asc”);
Thanks
no code/sql error but the sorting seems apply to the first column only.
Hi,
If you apply order by for two columns it will sort first according to the first column,
Thanks
This item was featured on CodeCanyon
Elite Author
Contact the Envato Market Help Team
