256 comments found.
Installed the Wordpress PDO Crud plugin after purchasing. Created new Wordpress page and added the code in the text view of the editor: [pdocrud table=”mynewtable” render=”crud”]
Published the page. When viewing the published page received the following error: SQLSTATEHY000 Unknown MySQL server host ‘c5ff41269310801.db.41269310.67c.hostedresource.net:3306’ (0)
Please advise.
Hi
By default, it connects to the database of wordpress. It picks db details from the wordpress config file. so if wordpress is connecting the database then it should also. If you have database details separately then you can try one thing by replacing config database variable in plugin/pdocrud/config.php folder. If you are not able to do so, please send me access details via email using profile page, I will check. Thanks
I have emailed you access details using your profile page. I first tried your default config.php in the plugin. Then modified to same as in WP config. Still no joy. In the test page I have sent you in the email, the revisions will show prior attempts.
I’ve sent you the FTP details earlier. Please let me know where things stand as soon as you can.
Hi
As per our email conversation, it is working for you. Thanks
Yes, it does now display data from the MySql table. What still seems to be an issue is why the following code will not display the checkbox fields as checkboxes instead of as text fields?
[code] // pc_func fieldattributes fieldname=”EMI_Hearing_L” data-type=”checkbox” [/code]
Hi, installed plugin and added shortcode but all i get is error message…
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘dbgttech_74g3.jm_users’ doesn’t exist.
How do i set this up? Do i have to make a table in a db first, how??
Thanks
Hi
Yes, you need to have database table. It’s basically crud application for wordpress, you only need to create tables in database, rest this application does.
Thanks
Hi, thanks for the very prompt reply. So just to be sure and to help others who may have purchased this product thinking that a table etc would be built in, one has to create a table or database? Is it a table in the WP database or a new database? Please explain briefly how this is done if its WP. I know how to create a new database but not sure how you add to the WP one – Thank you
Hi
Wordpress has already database. So you can use any tables of wordpress or you can create your own table and perform crud operation for that. For example, You want to manage the wordpress user table, you can directly do that as it’s already there or if you want to add a new table say student table, then you can create table first and perform crud operations. Please go through all the demo examples and documentation. It will make easier to understand it.
Thanks
Hi, thanks for the explanation, I have it working now and have created a new table in the wp db. One of my fields attributes is enum as i need a drop down list to select from. Problem is when the form displays, i see the field but no options. It asks to select an option but none can be seen. Is this an error in myphpadmin or does the plugin not support enum type fields?
$pdocrud = new PDOCrud();
...
$pdocrud->setTDalign_center('fieldname1, fieldname2');
// OR
$pdocrud->setTDalign_center(array('fieldname1', 'fieldname2'));
$pdocrud->setTDalign_right('fieldname1, fieldname2');
// OR
$pdocrud->setTDalign_right(array('fieldname1', 'fieldname2'));
- in script / style.css:
.pdocrud-td-center{
text-align:center;
}
.pdocrud-td-right{
text-align:right;
}
.pdocrud-td-left{
text-align:left;
}
- in files script/classes/templates/xxx/template*.php
<code>
<td class="pdocrud-row-cols pdocrud-td-<?php if(array_key_exists($col, $settings['alignment'])) echo $settings['alignment'][$col]; else echo 'left'; ?> ...
</code>
- added in class PDOCrud (script/classes/PDOCrud.php)
<code>
private function initializeSettings() { // existing function
...
$this->settings['alignment'] = array(); // added
}
private function setTDalign($cols, $align) { // new finction
if (is_string($cols))
$cols = explode(',', $cols);
elseif (!is_array($cols))
return;
if (count($cols) == count($cols, COUNT_RECURSIVE))
foreach($cols as $col)
{
$col = trim($col);
if ($col != ">settings['alignment'][$col] = $align;
}
}
public function setTDalign_center($cols){ // new finction
$this->setTDalign($cols, 'center');
}
public function setTDalign_right($cols){ // new finction
$this->setTDalign($cols, 'right');
}
@+</td></code>
Hi
ok…thanks 
Hi, I have just purchase your plugin and trying to integrate in my wordpress blog I got following error:
<base-url>/wp-admin/admin-ajax.phpscript/pdocrud.php 404 (Not Found)
It is not showing you have purchased this plugin. Please provide the purchase code so that I can help you further.
Thanks
I have purchased with other account Here is my purchase code : b101dace-bd0f-467b-80e3-991255ab014f
Ok, Thanks. Please send me access details via email using my profile page. I will check it immediately. Thanks
Ok, Thanks. Please send me access details via email using my profile page. I will check it immediately. Thanks
Actually I have setup it in my local machine.
Hi,
If it was on server, I could have checked directly. As per your message, I don’t understand where you are getting this message. Are you trying to navigate this page or you have written some shortcode on a page and you are trying to access that? Please explain more so that I can help. Thanks
Yes, I have just testing it via shortcode on home page,Data of table display properly but While I am trying to add new record or edit existing record Loader stucks loading and in console I got above error 404.
It means there may be issue in the script_url. It should call ”/wp-admin/admin-ajax.php” for ajax request. Please contact me via email using profile page. I will send you solution. Thanks
Hello, When I click on any action button, ajax-loader.gif is showing… and nothing happens. I retrieved the source code of the page, and I noted: pdocrud_js = {“pdocrudurl”: “http://mydomain/wp-admin/admin-ajax.php”, ... Is this normal? thank you in advance
Hi,
Yes, it is normal. You can contact me via email using my profile page so that I can check your issue. Thanks
Hi: I’ve installed the plugin and am rendering a crud, but the edit, delete buttons, etc don’t work. I’ve tried deactivating other plugins and many other things, nothing works. Also, I’d like to use php instead of shortcodes because I need to use the image resize and thumbnail functions, and I have a plugin that let’s me execute php inside the post. I can render the crud that way but it ignores any other functions I attempt.
purchase code: f3f99c1d-ee4e-47f4-8374-c846f5b0b685
Hi,
please send me access details via email so that I can check. Also, I have uploaded latest version for review so I will send that to you also. Thanks
I have sent them to you via email – thanks..
Hi
I have replied to your email. Thanks
Hi: I accidentally posted on the other forum for the standalone app, sorry. I’ll consolidate it here:
I have it pretty close, but now the Add and Remove buttons don’t work for adding images in new records or for updating them in existing ones. Neither do the Save, Save and Back or Cancel buttons at the bottom of the edit screen. Here’s the code I’m using:
<?php $pdocrud = new PDOCrud(); $pdocrud->colRename(“stockno”, “Stock #”); $pdocrud->fieldTypes(“img1”, “FILE_NEW”); $pdocrud->fieldTypes(“img2”, “FILE_NEW”); $pdocrud->fieldTypes(“img3”, “FILE_NEW”); $pdocrud->fieldTypes(“img4”, “FILE_NEW”); $pdocrud->fieldTypes(“img5”, “FILE_NEW”); $pdocrud->fieldTypes(“img6”, “FILE_NEW”); $pdocrud->formFields(array(“stockno”,”img1”,”make_model”,”year”,”mileage”,”options”,”img2”,”img3”,”img4”,”img5”,”img6”)); $pdocrud->tableHeading(“Parts Cars Inventory”); $pdocrud->crudTableCol(array(“stockno”,”img1”,”make_model”,”year”,”mileage”,”options”,”img2”,”img3”,”img4”,”img5”,”img6”)); $pdocrud->tableColFormatting(“img1”, “image”); $pdocrud->tableColFormatting(“img2”, “image”); $pdocrud->tableColFormatting(“img3”, “image”); $pdocrud->tableColFormatting(“img4”, “image”); $pdocrud->tableColFormatting(“img5”, “image”); $pdocrud->tableColFormatting(“img6”, “image”); $pdocrud->viewColFormatting(“img1”, “image”); $pdocrud->viewColFormatting(“img2”, “image”); $pdocrud->viewColFormatting(“img3”, “image”); $pdocrud->viewColFormatting(“img4”, “image”); $pdocrud->viewColFormatting(“img5”, “image”); $pdocrud->viewColFormatting(“img6”, “image”); $pdocrud->resizeImage(array(“800”=>”600”)); $pdocrud->thumbnailImage(800, 600); $pdocrud->fieldNotMandatory(“img1”); $pdocrud->fieldNotMandatory(“img2”); $pdocrud->fieldNotMandatory(“img3”); $pdocrud->fieldNotMandatory(“img4”); $pdocrud->fieldNotMandatory(“img5”); $pdocrud->fieldNotMandatory(“img6”); $pdocrud->fieldNotMandatory(“mileage”); $pdocrud->fieldNotMandatory(“options”); $pdocrud->setSearchOperator(“like”); echo $pdocrud->dbTable(“cars_parts”)->render(); ?>
It’s on a private page so you’d need to log in with the credentials I emailed you in order to view it: https://new.a1autosupplyblog.com/parts-cars-admin/It’s not producing a javascript error on the front end in the console, and deactivating all the plugins doesn’t make a difference. I’ve been trying to get it to work for 3 days now. I tried using the default wordpress theme, with all other plugins deactivated, to no avail, the buttons remain dead.
I am using a plugin that allows me to execute php in Wordpress pages. It works very well I’ve never had a problem with it. But just to test, I made another page (/test/) that uses just shortcodes, and it does the same thing. I also tried using the very simple example you gave me, same results. I even tried it on another, basic wordpress install.
I’d like to use the php code instead of shortcodes because I don’t see shortcodes for some of what we need (tableColFormatting, viewColFormatting, resizeImage, thumbnailImage, fieldNotMandatory, setSearchOperator) but maybe I’m missing something.
This is the only thing preventing us from launching the site so I’m hoping you can help us.
Thank you!
Hi,
I am checking your url. Thanks
I see you were able to log in, did you have any luck figuring out why the Add and Remove image buttons don’t work on the edit screen?
Hi I have replied to your email. Thanks
Please check your email again for the correct url to examine.
I’ve set up another fresh install, default everything, no other plugins, same issue. Please check your email for details. Thanks
Yesterday I sent the ftp access you requested. Please check your email. Thanks.
Hi
I have resolved your issue and send you email also. Thanks
That did it – I have it working on the main parts site as well – thank you for all your help, we are ready to launch!
One last question: is there a relatively easy way to display the image thumbnail on the edit screen instead of just the filename? We can live without it if need be but it would be nice…
Thanks again.. -Dennis
Hi,
We have tried to achieve that also but we are facing some issue in implementing that feature. It’s already in list so We will let you know once it is completed. Thanks
Ok sounds good thank you. Just one more question please before we launch this puppy:
We’re trying to remove items from the search drop down, since it doesn’t make sense for users to search for image fields, etc.
We tried: $pdocrud->setSearchCols(array(“make_model”,”year”,”mileage”,”options”));
but it’s not having effect
we also tried it as a list rather than an array: $pdocrud->setSearchCols(“make_model”,”year”,”mileage”,”options”);
I see someone else had this question on the forum but the answer wasn’t public.
what are we missing?
Thank you…
Hi
I have replied to your email. Thanks
HI last email I got said “I will recheck once. Thanks” – did I miss one? It’s still ignoring it – I’ve tried it several different ways…. -thanks..
Hey dev i’m pretty happy with the PHP version and was wondering when you could update the wordpress version to the latest changes too !?
Any ideas when you will update this plugin to match the PHP version ?
Hi
Yes, after today’s new version release that will be also updated and released. Thanks
Awesome. I’m eager to see today’s new update for wordpress
Hi,
I’m looking for a plugin to build a multistep form, in which I need to validate a specific ID field with my employees (users) table in my DB, and depending if this ID exists or not, display some others fields in the form.
Can I achieve this with your plugin?
Thanks in advance!
Hi
multistep form is available but you need to write specific js to do this work. Thanks
My theme (wordpress twentyseventeen) got bootstrap. this is conflicting with the plugin. what to do?
Hi,
You can remove bootstrap either from theme or either from script.
To remove bootstrap from script, easy way to do this is by removing the bootstrap js and css from PDOCrud\script\classes\templates\bootstrap folder
or you can use the dequeue functions of the script.
Thanks
Hi, is it possible to connect to a different database than my wordpress database? The database is on the same server and uses the same username and password to connect to as my wordpress database. Thanks
Hi,
Yes, it’s possible to connect with different database also but it will require some changes in the code.
Thanks
Is this something I could be instructed to do myself or would you offer this customization at an additional charge? My site is local right now, so I am hoping it could be explained which files would need modified so I can follow instructions to do it myself. Thanks.
Hi,
Try to change the database related config settings in the plugin/wp-pdo-crud/script/ config folder and check for it.
Thanks
Hi, Thank you. I have opened the file and made the following changes. My database name is data2017, my username is root and there is no password since it is running on my local machine. I’m not sure I am using the right syntax or what I need to change. This is not working though:
[code]
//script url – Enter complete url inside which script folder is placed
$config[“script_url”] = WPPDOCRUD_PLUGIN_URL . ”/”;
/* * ** database * /
//Set the host name to connect for database
$config[“hostname”] = “localhost”;
//Set the database name
$config[“database”] = “data2017”;
//Set the username for database access
$config[“username”] = “root”;
//Set the pwd for the database user
$config[“password”] = ””;
//Set the database type to be used
$config[“dbtype”] = “mysql”;
//Set the database type to be used
$config[“characterset”] = “utf8”;
//Encryption and Decryption salt
$config[“salt”] = ”@3dsfsdf*9934324”; [/code]
Hello, I am interested in purchasing this plugin. My form has many fields that require the user to scroll horizontally. I am looking for a plugin that will display a limited number of fields on the initial list layout, then once an item is clicked on, the full details will be listed. Basically a short list display until the full fields are available on the individual item page. Thanks, great looking plugin!
Hi,
This feature is currently not available. Thanks for your interest.
Hi, some questions:
1) if we buy a license, is it perpetual ? 2) We will receive the updates forever ? 3) Is the license linked only to a web site ? how does it work ? 4)is possible to manage in frontend crud tables with blob columns for videos or images ? 5)is there any way to manage a master slave situation for tables (for example a master table of customers and a slave table with all sales , and changing the customer changes also the slave records ) ? 6)is possible to have in the same page more tables ? Regards
Hi,
1. Yes 2. Yes 3. You can use it on any no. of websites 4. blob option is not available. 5. Yes, left join and inner join both are supported. 6. Yes.
Please check demo and documentation in details before purchase so you will be clear on everything. Let me know if you have more questions.
Thanks
@Ddeveloper thanks for the update but you changed the calendar from YYYY-MM-DD to March 1, 2017 ???
How to rever back to YYYY-MM-DD ? The dasboard settings do not work!
When you make changes please NOTIFY!
Please help and fix the last update is breaking the datetime format overall website!
DATE (YYYY-MM-DD) = NOT WORKING !
DATETIME (YYYY-MM-DD HH:mm:ss) = NOT WORKING !
I’m tyring all possible formats and none is working even if i do it manually!
I don’t need March 1, 2017
HI,
There is no change in date time format in code. You can set date time format using dashboard page or you can directly do in php file plugin/script/config.php.
Thanks
Then why is not working anymore after update ? I see you made changes related to datetime on various files!
Now the date is shown in this format :”March 1, 2017” and i need the script to read and keep the current DB format as “DATE” or “DATETIME” like the previous version .
I need the ‘datepicker’ to work as before : 2017-03-01
Hi,
I have rechecked. It is showing default YYYY-MM-DD format at my end.
Also You can set date time format using dashboard page or you can directly do in php file plugin/script/config.php.
NOT working on my end! The previous version works ok, the new version does not !?
What can be the problem? I seen you did some changes on the datetime picker! How do i rever those changes back and still keep the update?
Hi! Is it posible to remove Save and Cancel buttons on Edit Form without using css? Thank you.
Hi, cancel button can be hide using settings but save button needs to be hide from css only.
Thanks
HI! Is it posible to do something like http://pdocrud.com/demo/pages/filters?
Hi,
It’s added in new version. I am releasing one more version of plugin with latest PDOCrud features. Thanks
Hi! It’s me again
Is it posible to do a callback using col enqueueActions? I need to rename a file when a col switch enqueueActions happen.
Thanks in advance.
Hi,
No callback available for this but you can add it in similar way as done for others.
Thanks
Hi, only need setting $pdocrud->addCallback(“after_switch_update”,”after_switch_updateCallback”); It’s working.
Hi! I am testing left join…
$pdo_crud = new PDOCrud(); $pdo_crud->crudTableCol(array(“ID”,”meta_key”,”meta_value”,”user_login”)); $pdo_crud->joinTable(“wp_user_meta”, “wp_users.ID = wp_user_meta.user_id”, “LEFT JOIN”); echo $pdo_crud->dbTable(“wp_users”)->render();
I get error : SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘meta_key’ in ‘field list’
Hi, When you are using the left join then in crud table it shows by default the columns of the main table in grid as left join can contains multiple entries for same record.
Hi! Nice work! It was my first buy on codecanyon. Is it posible to redirect URL using selectform method, like a login? Redirection is working using insertform but selectform, I don’t know why.
Hi,
Redirect must work with select form also. You are using redirectURL function, right? I will check also once.
I can’t write code here.. It doesn’t show properly. Please check this image…
Thank you.
Hi,
I need to check that. I will check and let you know. Thanks
I purchased Wordpress PDO Crud because it was described as being identical to PDO Crud, except in the form of a WordPress plugin. However, after installing it, I discovered it’s actually based on version 1.70 of PDO Crud, which is an old build, lacking many features. Therefore, I went ahead and also purchased PDO Crud and integrated it into WordPress myself. I’m wondering if you’d consider refunding my original purchase of WordPress PDO Crud, as I have no use for it and intend to continue using PDO Crud.
Ok..give me details on my email about both invoice Id/purchase Id. I will check and then you can ask for refund. I will approve it.
Thanks
OK, I just sent you an email.
Ok.
Hi, I’ve purchased the plugin but I can’t get it to display in the right place . It always appears at the top using both the short code and php code.
Hi,
Let me know access details so I can check. Thanks
