2608 comments found.
I am interested in purely bootstrap styling (including but not limited to buttons that follow the btn-danger, btn-success and so on). The ‘skins’ you have don’t really suit me and I don’t want a lot of extra work to make the layout appear like the XCRUD product I previously bought from Envato. That developer vanished so I look to you as my new CRUD system. You seem to cover most all the features of that system, and better.
Also, does your tool work whendatabase tables have segmented primary keys?
I have another question. If you would look at the XCRUD demo page, there are tabbed and nested detail pages. These help organize the form fields in a manageable way as well as leveraging data relations. Can your tool do similar functionality?
Hi,
Yes, our script support tabbed pages but not nested one in current version. We are continuously adding more and more functions in our script. We can organize in many more ways data using our script. Regarding the pure bootstrap, we have made it for customized feel so we have used specific classes instead of default bootstrap classes. To change it for pure bootstrap, please contact me via my profile. Thanks.
Thanks for your support,
i have one small question.
it will allow to display form with table only? incase i want to display some popup form…
for example, in my index page i have sign in and signup input buttons , on click of each buttons respective popup form should get open(without table)...
Thanks and Regards, Alam
Hi
Yes, you can display form on button click also.
here is the code
// 1st parameter is button text, 2nd parameter is modal header
$pdocrud->formDisplayInPopup("Open Product Details popup","Product Details");//display form in popup
echo $pdocrud->dbTable("producttable")->render();
Hi,
yesterday i had purchased this application, i tired following up the steps provided in the guide, but didn’t get.
can you please help in using this, just i want to know a simple criteria how i can use (like i have my index.php page and i want some data entry popup or detail form with bootstrap and css linked.
Regards,
Hi,
Let me explain it
1. Open the PDOCrud/script/config/config.php file and required database details (hostname, username, pwd, databasename and url (path of the script folder)) 2. In your index.php file, include file pdocrud.php in script folder
require_once “script/ pdocrud.php”;
3. Now you can run 2 line code like below
$pdocrud = new PDOCrud();//create object of PDOCrud Class
echo $pdocrud->dbTable("employee")->render(); // call render function
on database table
to generate crud operation.
I hope this will help you. Nothing extra needs to be done for bootstrap and css linking.
Thanks
Thanks for your support,
i have one small question.
it will allow to display form with table only? incase i want to display some popup form…
for example, in my index page i have sign in and signup input buttons , on click of each buttons respective popup form should get open(without table)...
Thanks and Regards, Alam
Hi, I have replied your question in another message thread. Thanks
ccdbe47a-f348-4b96-a284-271186126fe2
$pdocrud->fieldTypes(“customer_country_id”, “select”); $pdocrud->fieldDataBinding(“customer_country_id”, “countries”, “country_id”, “country_name”, “db”);
This works when editing a single record. But when the field is displayed in a grid, the Country ID is displayed rather than the Country name. Any ideas?
Hi,
Please note that grid columns and form fields are managed differently.
http://pdocrud.com/documentation/#!/grid_columnand here is the example of multiple field binding.
http://pdocrud.com/demo/pages/load-dependent-data.phpPlease check this and let me know if you need further information.
Thanks
Thanks for the quick reply. Form field works perfectly. I don’t see the equivalent function for the grid column.
You mean inline edit option? I will check and let you know. Thanks.
I have a field called Country ID. When I render the grid of data, the ID of the country displays instead of the name of the country from the Countries Table. When I click on inline edit, a dropdown list appears with the names of the countries, then when I save the record, instead of the country name, the Country ID appears. In single record edit, it shows the country name rather than the ID which works as it should. I used fielddatabinding for that. Is there something like columnDataBinding? Thanks,
Is there a way I can send you a screenshot of the problem?
If you hide the first column then inline editing columns are shifted to the right
Hi,
Let me explain.
$pdocrud->fieldDataBinding("country", "country", "country_id", "country_name", "db");//add data using another table name country
here first parameter is field name, 2nd is table name 3rd is key and 4th is value parameter of select so if you want both key and value as same country_name then you can use like this
$pdocrud->fieldDataBinding("country", "country", "country_name as country", "country_name", "db");//add data using another table name country
You can contact via my profile to send screenshot. Thanks
Let me do a better job explaining:
Two tables. CountriesLookup provides country names for Customers:
Customers:
CustomerName: CountryID
CountriesLookup:
countries_id countryName
$CustomerCountryFieldName = "countryID";$pdocrud->fieldTypes($CustomerCountryFieldName, "select");$LookupTable = "CountriesLookup";
$LookupKey = "countries_id";$LookupReplacement = "CountryName";$pdocrud->fieldDataBinding($CustomerCountryFieldName, $LookupTable, $LookupKey,$LookupReplacement, "db");works perfectly in edit or inline edit – countryName appears in the edit field. In grid mode the CountryID appears instead of the countryName.
Ok, I understand now.
This can be done in 2 ways.
1st you can use inner join between table as you have countryname in another table.
both left and inner join option http://pdocrud.com/demo/pages/inner-join.php http://pdocrud.com/demo/pages/join.php2. You can use replace function and pass array of country id and country name..
http://pdocrud.com/demo/pages/replace-col-value.phpThanks
Purchase codes 4cdbc2bd-1147-4e76-876e-b1af024a90c5
Hi,
- How can I change the width in a pull-down?
- How can a value when saving with transferred to the database?
- How can the box be disabled in the form ?
- How can I arrange input fields which are arranged horizontally left-aligned?
Best regards
Dirk
Hi,
I have already replied to your comment
Purchase codes 4cdbc2bd-1147-4e76-876e-b1af024a90c5
Hi,
- How can I change the width in a pull-down?
- How can a value when saving with transferred to the database?
- How can the box be disabled in the form ?
- How can I arrange input fields which are arranged horizontally left-aligned?
Best regards
Dirk
Hi
1. You mean the column width
http://pdocrud.com/demo/pages/table-column-attr.php or field width
$pdocrud->fieldCssClass("first_name", array("class1", "class2"));// add css classes
More details
http://pdocrud.com/documentation/#!/grid_column
2. You mean change value? Yes, can be done using the various action hooks or callback function
http://pdocrud.com/demo/pages/callback-function-php.php 3. You can set any attribute like this
$pdocrud->fieldAttributes("email", array("disabled"=>"disabled"));// any attribute name and it's value
4. Please check various demo forms for code example. You need to group fields
http://pdocrud.com/demo/pages/group-fields.phpHello, I was wondering if there is an easy way to implement action for ordering/ranking with PDOCRUD when displaying a table.
Hi, you mean the action button addition.
Here is an example
http://pdocrud.com/demo/pages/action-buttons.phpThis is available in new version that we are going to publish today, with some more features. Also, please let me know what else we can do to it 5 star rated product. Thanks 
Purchase codes 4cdbc2bd-1147-4e76-876e-b1af024a90c5
Hi,
Do you have a exemple form my ?
2. http://pdocrud.com/demo/pages/field-class-attr.php
You can define width and height attribute also
Dirk
Hi,
most easy way to do this is to add css class using folllowing code
$pdocrud->fieldCssClass("first_name", array("class1", "class2"));// add css classes
in your css
.class1{
width :100px;
}
Thanks
Purchase codes • 4cdbc2bd-1147-4e76-876e-b1af024a90c5
Hello,
- How can I disable the validation of a single field in the form ? - How can change the width of an input field in the form ? - How can I change the labels in the “view” view ?
Regards
Dirk
Hi,
1. fieldNotMandatory($fieldName) ; //here you can specify field name
2. http://pdocrud.com/demo/pages/field-class-attr.php
You can define width and height attribute also
3. $pdocrud->colRename("first_name", "client name"); this will rename view lable also.
Thanks
Purchase code: 4cdbc2bd-1147-4e76-876e-b1af024a90c5
Hi,
I have a many questions:
- How can i the heading of the colums in the table change?
- How i can hide individual input fields in the form?
- How can i text elements to insert in form between the input fields?
- How can i a calculate variable transfer into the database steht save the form?
Regards Dirk Kling
Hi,
Here are reply
1. http://pdocrud.com/documentation/#!/grid_column
$pdocrud->colRename("customer_name", "client name");//rename customer_name to client name in grid
2. You can use formRemoveFields($fields) , where $fields is the array of name of fields to removed.
3.
a) formStaticFields("personalinfo", "html", "<h3>1.Personal Info </h3><br /><small>Enter your personal information</small>"); //this function add static field like html, etc.
and
fieldDisplayOrder(array("personalinfo","first_name","last_name","phone", "gender", "birth_date","city","state"));
changes the display order
More details are available in the demo forms in the latest code.
4. I didn’t get your question. Please write again.
Thanks
An error occurs when i use sqlite databese: SQLSTATE[HY000]: General error: 1 near “SHOW”: syntax error. How can i solve this? Thanks.
Hi,
Please explain which operation you are using. Default CRUD operation or anything else. So that I can check. Thanks
when i use this statement error occurs:
$pdocrud = new PDOCrud();
echo $pdocrud->dbTable("MYTABLENAME")->render();
Only $pdocrud->render(“SQL”); statement works other operations not.
Maybe in classes/PDOModel.php Line: 668 “SHOW INDEXES FROM…” not compatiple with sqlite???
Ok, I am checking it. I will get back to you. Thanks
??
Hi, I have checked and it worked with sqlite version 2.0. For which version, you are checking it. Please let me know. Thanks
sqlite3.
Hi, Ok..I will check for sqlite3 also. Thanks
i am SUPPORTED client. i have been waiting for months.
Hi, I have got your email, I am checking it. Thanks.
im still waiting!!!
hi, we are already discussing over email. Previously we discussed about using the dbTable function instead of sql query and now you have provided FTP so I am checking that. Thanks
Awesome work, i’m impressed
So far i encountered some minor issues but will do more testing to make sure is not something i’m doing wrong.
What are the folder rights ?
Warning: scandir(/public_html/script/plugins/knob/css/): failed to open dir: No such file or directory in /public_html/script/classes/PDOCrud.php on line 3461 Warning: scandir(): (errno 2): No such file or directory in /public_html/script/classes/PDOCrud.php on line 3461
Can you please add Google Recaptcha too ? https://www.google.com/recaptcha/intro/index.html
Overall, well done!
Thanks a lot.for your nice comment.
I will add google recaptcha also. Currently, I am working on 4-5 new features that will released by tuesday.
As per message, it is not able to find the css folder at following location script/plugins/knob/css/
Please check that location, if css folder is present or not and please make sure to give read permission for the plugins folder. Please check this once http://pdocrud.com/documentation/#!/add_plug_ins
This will give more idea how I implemented the javascript plugin concept.
In case of still issue, please contact me via profile. I will check code and resolve it. Thanks
All folders exist and have CHMOD 755 though i still get that error.
Thank you.
Hi,
As per error message, it is indicating that folder doesn’t exists. Please contact me via profile page. I will check. Thanks
Hi, just to let you know Recaptcha is also added
Awesome, thank you! Will try and let you know. Well done!
Hi, I’ve tried really hard to get Actions Buttons and Add Button to work but they don’t seem to be working in my environment (Debian: Rasspbian Jessie running on top of Raspberry Pi 3, LAMP configuration running php5 apache2 ) i tried adding PDO extensions and etc. to php.ini but nothing seem to be working, I’m really frustrated with this right now can you please give me any guidance on initial installation configurations that needs to be done in order to get PDOCrud features to work. Thank You in-advance.
Hi,
You are having some issue in initial installation or some issue in particular function.
Please contact me via my profile. I will check and let you know. Thanks
You can check pdo enabled or not using the php_info() function. Also, Just to let you know PDO is included in version 5.3.
Please go through documentation for installation part once also. I am available here, you can contact me in case of any issue. Thanks
can I display the state_name and country_name in row? I had tried to save the *_name of select but failed .thanks $pdocrud = new PDOCrud(); #$pdocrud->formFields(array(“user_name”,”password”)); $pdocrud->formDisplayInPopup(); $pdocrud->fieldTypes(“state_id”, “select”); $pdocrud->fieldDataBinding(“state_id”, “state”, “state_id”, “state_name”, “db”); $pdocrud->fieldTypes(“country_id”, “select”); $pdocrud->fieldDataBinding(“country_id”, “country”, “country_id”, “country_name”, “db”); echo $pdocrud->dbTable(“city”)->render()
Hi,
In a row means horizontal row right, Yes, you can.
here is an example of showing 2 fields in one row
http://pdocrud.com/demo/allforms/order/order.phpThanks
Purchase codes: 4cdbc2bd-1147-4e76-876e-b1af024a90c5
Hello,
I unfortunately have a few questions for Framework :
1. Is it possible to set multiple filters to a table ?
$ Pdocrud = new PDOCrud ( ) ; $ Pdocrud- > where ( ” ORDER_AMOUNT ” , ” 50 ” , ” > ” ) ; echo $ pdocrud- > DbTable ( ” orders” ) – > render ( ) ;
2. How can I change the headers of the table ? 3. How do I get the title at the end of the table away ?
Thanks Dirk
Hi,
You can ask any question you want, no issue
1. Yes, it can be done in same way
2. Please check following demo http://pdocrud.com/demo/pages/table-operations.php
3. I didn’t get your question. Please explain again.
Thanks
Purchase codes: 4cdbc2bd-1147-4e76-876e-b1af024a90c5
I would like only certain rows in a database in the table represent is also workable (view, delete, edit).
How can I achieve this with the software?
Hi,
You mean filter records (i.e. add where condition).
Here is example of where condition
http://pdocrud.com/demo/pages/where-condition.phpPlease check.
Thanks
Would you please email me the SQL required to define and populate the employee table (demo database).
Many thanks.
hi,
Here it latest demo db
https://www.dropbox.com/s/llh6ysvu4wrcnwv/pdocrud.sql?dl=0I am also submitting new version with few more features by tomorrow.
Thanks
Thanks, much appreciated.
Hello,
sorry i have forgoten:
Purchase codes 4cdbc2bd-1147-4e76-876e-b1af024a90c5
Dirk
Hi, you don’t need to send purchase code here. I have replied to your question. If still you have doubt, you can ask me further. Thanks
Hello, If I use this SQL code disappears the option to edit the records.
$ Pdocrud = new PDOCrud (); $ Pdocrud-> setQuery (“select * from orders”); echo $ pdocrud-> render (“SQL”);
Question: How can the SQL statement to apply and the processing let me get (View, Delete, Update).
Dirk
Hi,
sql statement can be anything so view, delete, and update options is not possible for sql statement. You can perform view/edit/delete on a table so use
$pdocrud->dbTable(“orders”)->render();
to generate view/delete/update
Hi, Very nice work! How i can add a custom action button? Ex. i want to add a button with custom url and sending the current row id as parameter query string… (ex onclick go to page… http://customedtipage.php?id=currentRowId ). Thanks a lot.
Hi, you can convert column to url like following example.
http://pdocrud.com/demo/pages/col-data-type.phpRegarding the action button, it doesn’t allow any custom action button. It will be available in future versions.
Thanks
This item was featured on CodeCanyon
Elite Author
Contact the Envato Market Help Team
