2608 comments found.
Hi, I notice that ckeditor only goes with insertform, how to use it on normal table?
????
Hi,
I didn’t got your question. CKEditor bound to a textarea i.e. form field so what it means by using on normal table. Please explain.
If I use insertform works correctly, if I don’t use insertform, when I click on insert or edit textarea comes out without ckeditor
Hi,
I have checked with normal table render function also and ckeditor is working with that also. Send me your code so that I can check. Thanks
Hi,
You haven’t called loadPluginJsCode() for ckeditor.
How does id to loadPlugin …?
I can’t understand the issue of ID
Hi, You can check the ID of form element using the view source of that page.
HELLO! I need a plugin so new users can register and then from the website create a table that only this user can have access, the table should be created uploading a Excel file to mysql dB. Same for many users. Can I have this with this plugin?
Hi, This feature is not available in this script. Thanks
Hello…... I wanted to know if your code supports video upload…. If it doesnt, how can i enable this?? Thanks
Hi,
script support uploading of files, similar way you can upload video. To play video, you will need to add some extra code.
Hello, please HELP! Simple col rename is also not possible… $pdocrud = new PDOCrud(); $pdocrud->colRename(“Targetgroup”, “Target”); Or is there perhaps a kind of a cache activated? Thanks.
Hi
Col rename renames the column in table/grid display and fieldRename changes the field name in form display.
Thanks
Hello,
sorry but we have some problems, now simple mysql enum filed will not be listed as select list…
Thanks, Olaf
Hi,
Sorry, I am not able to understand your point. Please explain more. Also, Please check how to create select list in demos for more details
Thans
Hello,
we bought your CRUD tools btw, grea tool! 6fa42a29-c533-451b-9c64-874708a7e7b8
Now he have subcontent in one db field like “24:6,12:6,56:8”. We want to extract correctly with PDO for input and listing and editing, how is that possible.
Thanky you for your time, Regards, olaf
Hi,
You can format value before saving and before display using the callback functions. More details about callback function: http://pdocrud.com/documentation/#!/php_callback_functions
i just purchased this product but its asking me for a password when i try to extract it…. how can i go about this?
sorry…i understood how to go about this after reading download terms/ conditions …thanks
Ok..no problem. Please also go through documentation and demo to understand many functionality script has. Thanks 
hey ,am loving the back end functionality …. but can i use my own front end designs with your backend? eg when it comes to the look and feel of forms ? $config[“dbtype”] = “mysql”; and use pdo and $config[“salt”] = ”@3dsfsdf**9934324”; to use libsodium ? thanks
also, can i changeHi,
I am not able to understand your question. Please explain in detail. Just to let you know that Script can be used to display data in frontend as well as backend.
hello, my question was ... in config file , instead of using mysql , can i use pdo?
also, i had designed a few forms before i purchased this product, i was wondering if its possible to use your code as backend , but my forms for front end… since am good at frontend development (bootstrap and material design framework) but a beginner in backend development (php) thanks
Hi,
Just to explain, PDO is connection method and mysql is type of database. In config, we have multiple option in term of database like mysql, pgsql or sqlite. It always uses PDO for connection as it is the best way to do connection in php with database. Yes, you can use our script to create forms.
Thanks
How do you send form data via email ? I want to update the DB and then send confirmation email. Do I add before update callback ? If so, what command/function name? I tried sendemail and formSendEmai but nothing is sent.
I added $pdocrud->formSendEmail($to …...); to the app file and constructed the message component in callback. App works without errors but no email generated.
Have put smtp settings in config.php
Hi,
Make sure $config[“emailMode”]= SMTP if you want to use smtp.
Check this demo for code example.
http://pdocrud.com/demo/pages/send-email-using-pdocrudThanks
Hi – I have a a field of type “Date”. The field is not mandatory and I’ve set the parameter in PDO crud to be such. In the db the default is set to Null. However, if I don’t enter a value in the date field, I get the error message:
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: '' for column 'myFieldName' at row 1
Please can you advise how to correct this? I don’t really want to add a date into the db if I don’t have to.
Hi
As you can check that this is sql related error. It is saying you can’t enter the ’’ value in date field. So you need to either change that field type in database or you need to use the callback function to modify date value to some default value.
Thanks
Thanks… though surely I should be able to enter a “Null” value into a field type of Date? MySQL supports Null as a value for field types of Date?
My suspicion is that the PDO Code is seeing the field as blank and is trying to pass it an empty string rather than a NULL – which wouldn’t be supported for a Date field. Please could you check and advise?
Hi – I wondered if you’d had a chance to look at this at all?
Hi – any further update at all?
Hi,
As I explained, if data is not entered, then it takes default value as empty string. You need to either set it to null manually using the callbackfunction or change the data type in table.
Thanks
Ok – so for date fields, your code isn’t able to send Null when the field is empty? Instead it sends empty string? Can you add this as improvement for next version please?
Hi,
I will try for this. Thanks
Hi since you are not seeing my emails or just ignoring them I thought I would try here.
Does your script support a second left join (onto already left joined data)?
Hi,
what’s your email Id and when you have send me message? We always reply all messages to asap.
Regarding your question, currently it support one left join only.Thanks
You weren’t getting my emails from my purchase email so we started corresponding via my gmail (nigel.refresh@googlemail.com). I sent emails from this with purchase code proof but you aren’t seeing/responding to these either.
How do you orderBy on the joined table data?
Hi,
I have replied to your email today afternoon on the email from which I have received your codecanyon message. I have resent it again. Here are the content of the message.
Hi,
order by is same for join table as the without join table. For join table, you can specify like ‘tablename.column_name’ to order by.
I have checked your gmail id and emails were going in spam. I have whitelist that email so I will now receive your email from gmail id also. Thanks
Hello !
i m facing following error “Notice: Undefined index: pdocrud_sess in G:\PROJECT\gst\script\classes\PDOCrudAjaxCtrl.php on line 9 Fatal error: Call to a member function render() on a non-object in G:\PROJECT\gst\script\classes\PDOCrudAjaxCtrl.php on line 32”
please help me to solve .
Hi,
This notice means that default php sessions are not allowed. You need to allow php session to make it work. Thanks
Hello, I am interesting buying your plugin as frontend builder for my database But I have some questions: - Could I link this plugin with my SQL? - Can you customize the data base fields that I want to show on the frontend? - Could I export a certain data to the plugin frontend? - Make reports about my data or/and customize the reports fields? If any of these points are not available, do you have a modification ability to achieve the required above? Note* after we reach to Point of agreement we can discuss the pricing. Thank you.
Hello, I am interesting buying your plugin as frontend builder for my database But I have some questions: - Could I link this plugin with my SQL? - Can you customize the data base fields that I want to show on the frontend? - Could I export a certain data to the plugin frontend? - Make reports about my data or/and customize the reports fields? If any of these points are not available, do you have a modification ability to achieve the required above? Note* after we reach to Point of agreement we can discuss the pricing. Thank you.
Hello, I am interesting buying your plugin as frontend builder for my database But I have some questions: - Could I link this plugin with my SQL? - Can you customize the data base fields that I want to show on the frontend? - Could I export a certain data to the plugin frontend? - Make reports about my data or/and customize the reports fields? If any of these points are not available, do you have a modification ability to achieve the required above? Note* after we reach to Point of agreement we can discuss the pricing. Thank you.
I am struggling with callback functions syntax. I am updating a expenditure record and want to calculate the net field from 2 others. I did this but it doesn’t work. No errors.
function beforeUpdateCallBack ($data, $this) {
$temptotal = $data["spent_total"];
$tempvat = $data["spent_vat"];
$tempnet = $temptotal - $tempvat;
$data["spent_net"] = $tempnet;
return $data;
}
Is there further documentation on callbacks other than the standard documents, which I have studied? Or can you advise what is wrong with my approach?
Thank you for your support.
Sorry, just noticed these errors on page :
Notice: Undefined index: spent_total in /var/www/html/fotshr/script/pdocrud.php on line 41
Notice: Undefined index: spent_vat in /var/www/html/fotshr/script/pdocrud.php on line 42
Hi,
Is it resolved now? The notice means these 2 index are not present. To see what’s there in the $data using the firefox or chrome console to check the ajax output. Thanks
No, sadly not resolved. These are correct data fields from mysql database print_r($data); shows the fields named as such within $data Cannot see anything in console that helps understand the issue
However from the output of print_r($data) I observed that the array includes the table name. Which is why I was asking if there is a syntax error. It seems the table name needs to be specified
function beforeUpdateCallBack ($data, $this) {
$temptotal = $data["pcexpense"]["spent_total"];
$tempvat = $data["pcexpense"]["spent_vat"];
$tempnet = $temptotal - $tempvat;
$data["pcexpense"]["spent_net"] = $tempnet;
print_r($data);
return $data;
}
This now works
Your software is awesome. It would really help to have more examples of how to use callbacks. I appreciate it is not your job to debug applications where it is used. But more documentation of how the very valuable callback function can be used would be helpful.
For example is there a possibility to use afterUpdateCallBack or afterInsertCallBack ? I am not clear what the range of options is, or what syntax needs to be observed.
hi,
I have already added example for most of the things. Here is the documentation for callback functions
http://pdocrud.com/documentation/#!/php_callback_functionsThanks
I am trying to check session after using the sample login procedure. Do you have an example of how to do this?
Here is login demo page
http://pdocrud.com/demo/pages/login-demo-exampleThank you. I was asking about checking sessions on subsequent pages after login.
Hi,
It’s standard way in any simple php code you do..
For example
If(isset($_SESSION[“username”])) //do something. else //redirect to login page.
Thanks
Are you still planning to make a version available with pure Bootstrap classes? If so, any idea on a timeline.
Hi,
Yes, I am working on that. It will take some time. I will try to do that asap. Thanks
Thanks, I look forward to it.
Awesome update and glad to finaly see support for pdo charts.
Will test and let you know how it goes
Thanks
Hi – I see a new version has been released – thank you!
Could you tell me whether it includes the fix to the Join issue I raised (I think it’s on Page 6 of these comments) ? (The issue was that joins inserted, updated and deleted from both tables, rather than just the one table…)
Hi,
I have completed some of the points as you have mentioned. The above point is still under development and I will surely made it work in next release. Thanks
Hi – with Image upload, if I select an image and press save the url is added to the db. But if I then edit the record, the File/Image field is not populated with the db value. Which means I have to select the image again, and it’s uploaded again.
How can I change this please? I’d like:
a) the file/image field to be pre-populated with the url in the db and
b) if there is no change to the url then no upload occurs.Your guidance would be appreciated!
Hi,
This feature is currently not available. I have already added in next version release list. Thanks.
Thanks. It would also be great if a ‘file picker’ was available so that you could choose existing files that had already been uploaded.
Yes, I am working on something like that. Thanks
This item was featured on CodeCanyon
Elite Author
Contact the Envato Market Help Team
