2608 comments found.
Hi ddeveloper,
I’m Daniel Huerta (Envato user dhuerta29). I created Artigrid, a PHP CRUD and dashboard framework, inspired by PDOCrud with improved structure, documentation, and features.
I would like to explore a collaboration to offer Artigrid to your users or as a complement to PDOCrud. It could benefit both of us while keeping our products distinct.
Demo: https://developmentserver.cl/ArtiGrid/docs/demo.php
If interested, we can discuss ideas via email.
Best regards,
Hi
Sure we can discuss. You may send email or let me know your email. Thanks
@xando Hello,
This usually happens because PDOCrud cannot detect the primary key when rendering EDITFORM, so the generated WHERE clause becomes invalid (WHERE = ‘2’).
Try explicitly defining the primary key before rendering:
$pdocrud = new PDOCrud(); $pdocrud->setPK(“id”); echo $pdocrud->dbTable(“producttable”) ->render(“EDITFORM”, array(“id”=>”2”));
@Ronuga Hello,
If you’d like, we can look into this more deeply together. Sometimes these issues depend on specific integrations or project structure, so having more context helps a lot.
You can open a detailed discussion here and share screenshots, console errors, and integration details:
https://artigrid.developmentserver.cl/community/public/I’ll be happy to help you troubleshoot it step by step.
Best regards.
Hi there, Nice system but lots of bugs make it very hard to work with (documentation doesn’t match code, and multiple things don’t work). Eg. echo $pdocrud->dbTable(“producttable”)->render(“EDITFORM”,array(“id” =>”2”)); >> gives SQL error (even if producttable exists and has an id-field with 2). >> SQLSTATE42000: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’= ‘2’’ at line 1
any update soon ??
Hello, support team!
After downloading this PDO CRUD plugin and setting up the config file it was very easy to get my tables displayed. But whatever action I try to do (info, edit, delete, add) I get always this error message: Session has been expired. Please refresh your page to continue.
I am integrating your plugin on a already existing Web App I developed with Bootstrap 4.4.1 (coming with jQuery 3.4.1 and Popper 1.16.0). If I disable my Bootstrap (disabling jQuery and Popper too) it works, i.e. info, edit, delete, add actions start to work. Of course I cannot disable Bootstrap on my app.
I can see that the “Session has been expired. Please refresh your page to continue.” error message comes from the PDOCrudAjaxCtrl.php file in the very beginning. Debuging a little bit the code I can see that the $instanceKey = $_REQUEST[“pdocrud_instance”] does not exist in the $_SESSION[“pdocrud_sess”] variable.
Can you please guide me on how to solve this?
Thank you very much.
Hello, support team! When can I have your help/support on the above issue?
Hello, support team! When can I have your help/support on the above issue? No answer from you for more than a week!
ZERO support!!! I reached out to the dev via comments, email and the contact dev form. I patiently waited for over a month before requesting a refund due to lack of support and then I had to raise a dispute to get a refund because the dev never responded. Don’t waste your time and money. I was duped when I saw the positive reviews and I thought that the negative reviews were from impatient or incompetent buyers but I was wrong. Documentation is not adequate and most of the functionality requires much more than the advertised “just 2-3 lines of code”. I had to add 119 lines of code to get it to display mostly the way that I wanted but still couldn’t figure out how to get anything to work with callbacks or even simple things like detecting duplicate data.
the script support latest php 8.5 and mysql 9.5.0? tks
$pdocrud->checkDuplicateRecord(array("fa_no", "device_name"));
Doesn’t work. “device_name” can be duplicated.
How do you apply checkDuplicateRecord to modifying an existing record? Also, the alert background color shouldn’t be green (alert-success). It should be red (alert-danger).
How do you compare YYYY-MM-DD format dates? I need to change CSS of dates in columns based on date. ``` $pdocrud->tableDataFormatting(“col”, “style”, array(“date_created”, ”<”, ”$expiredate”), array(“color:#808080”)); ```
I just installed and haven’t edited anything. My demo pages do not display like the demo on your site. The text is too small and there are some other issues. Please see this pic: https://i.imgur.com/KyZSQK3.jpeg
How can I fix?
Here are a couple more pics with a side-by-side comparison.
https://i.imgur.com/Q8YJMfA.jpeg https://i.imgur.com/10uYnD8.jpegSomething is wrong with the CSS.
Hi
I have checked it.Please check your config file and make sure that your $config[“script_url”] has correct path, It must be till script folder, doesn’t include script folder. Thanks
The $config[“script_url”] has the correct path. If I change it, to anything else, it breaks.
‘demo/pages/template-selection’ (Pure Bootstrap (V 3.0)) is the only page that looks correct and displays just like the demo on pdocrud.com.
Found another issue. If I use the following code to make a field a select box, what gets saved into the database is 0,1,2,3,4 or 5 depending on the selection. It’s saving the array index instead of the value:
``` <?php $pdocrud = new PDOCrud(); //conditional logic for formatting table colums – e.g apply css style for cells with product price>200 $pdocrud->tableDataFormatting(“col”, “style”, array(“OS”,”<”, “11”),array(“background:#f00”,”color:#ff0”)); $pdocrud->fieldTypes(“Type”, “select”);//change state to select dropdown $pdocrud->fieldDataBinding(“Type”, array(“Desktop”,”Laptop”,”CADDDesktop”,”CADDLaptop”,”Desktop-KIOSK”,”Tablet”), ””, ””,”array”);//add data using array in select dropdown //echo $pdocrud->dbTable(“inventory”)->render(“insertform”); echo $pdocrud->dbTable(“inventory”)->render(); ?> ```
As a test, I installed PDOCrud on an entirely different production server and I get all of the same results that I reported above so I don’t see how these issues are on my end. Please investigate at your earliest convenience.
Also different issues with different versions of PHP.
I have now installed PDOCrud on two Linux servers and a Windows dev machine. The same issues that I reported previously exist in all three installations. Can you please take the time to investigate and fix these issues? We’re not getting off to a very good start here.
Over two weeks and still no support? Petschu reported the same issue. His demo does the same thing: https://c.consultant4you.de/demo/pages/
Script validation for forms is not working, either. I get the generic error messages instead of the custom text that I added to the code. $pdocrud->fieldValidationType(“fa_no”, “pattern”, “^[0-9]{6}$”, “Please enter 6 numbers”);
Hello, can you fix the visibility of date in European format? Please see my old comment about this. Thanks!
Hi
Yes, I will send you an update on this asap. Thanks
Is it possible to reorder records according to a custom order (not necessarily alphabetical) and move them around using drag & drop?
Hi,
You can click on column to sort the orders on the basis of column type. Thanks
Good morning,
The description for PDO CRUD states that Oracle db supported with version 7.1.
In the config file, there is no Oracle parameter to set, only mysql, sqlite, etc.
Also, shouldn’t there be an Oracle compaitable sample database included? I only see the mysql compaitable sample db.
Please advise.
Thanks!
Yesterday I posted an error to you. The problem is solved. In my config I had HTTP instead of HTTPS. regards Peter
Okay. Great. Thanks
I have installed PDOCRUD and everything works fine. But when I use the instruction $pdocrud->relatedData(‘id_imp_gruppo’, ‘gruppi’, ‘id_imp_gruppo’, ‘nome_gruppo’); it throws an error, as you can see in the screenshots. What can I do to fix it? Thank you!
Image with error & database : https://pasteboard.co/gtdIkTAma8BF.png https://pasteboard.co/hkcRn5CIHOWG.png https://pasteboard.co/NrYZHUK8DNqb.pngHi
It is not able to find the id_imp. Can you share the complete code you are using? Thanks
Code: https://pasteboard.co/TuRuMfBJjo2a.png Database: https://pasteboard.co/x63UO6tJ4kkx.png Thanks
Hi,
I see a performance issue when I use the ”$pdocrud->relatedData(....” function. It creates a SQL statement in the background based on FIND_IN_SET. Unfortunately, that variant is extremely slow in MySQL because no indexes can be used. Is it possible to build this into something that works with JOINs?
Hi,
Okay, sure. I will look into this. Thanks
Hi! I would like to purchase PDOCRUD and RESTp, but first I would like to know how I can integrate them into a LARAVEL application. Thanks!
Hi,
You can integrate with Laravel just like you integrate any third-party PHP script. You need to download the required files in the appropriate folder in the Laravel apps and call the required functions. Let me know if you need any more information Thanks
Developer, I have 2 usernames here in Envato Market: - username: codecanyonrpca - username: pathemeforestnet Motive: - I got my username “codecanyonrpca” when I signed up in Codecanyon.net. - I got my username “pathemeforestnet” when I signed up in Themeforest.net. - but both Codecanyon.net and Themeforest.net are websites of Envato Market. I bought my PDOcrud license with my username “codecanyonrpca” of Codecanyon.net. And inadvertently posted supports requests using my username “pathemeforestnet” of Themeforest.net. Sorry for this misunderstanding. Anyway, please help me with this:
I need to have a column of old_notes and new_note, so that when a user writes a new note, that new note is appended (concatenated) in the old notes field, keeping the previous notes in that field and adding the new note. I am trying to do this using a callback function. But it is not working:
``` function copyToNotes($data, $obj) { $ts1 = new DateTime(“now”, new DateTimeZone(‘Europe/Lisbon’)); $ts2 = $ts1->format(‘Ymd-His’); $data“mytable” = “mytable” . $ts2 . ” ” . $data“mytable” . ” ”; return $data; } ``` and the callback function:
``` $pdocrud->addCallback(“before_update”, “copyToNotes”); ```
Can you help?
Hi, developer. Are you alive?
Hi
Your profile is not showing purchased label. Please do a valid purchase for support requests
Hi, I’m trying to create a callback function where the data updated in field_1 will be appended to the data already existing in field_2. I am using this line, but it is not working.
$data“my_table” = $data“my_table”;
Can you help?
Sorry, but the code loses its formatting here. I hope you understand it
Hi
I have checked the email. Can you try to print the $data using print_r($data) in the hook and check the ajax output in the network section of browser tab?This will help to understand the issue. Thanks
This item was featured on CodeCanyon
Elite Author
Contact the Envato Market Help Team
