Hi Brujump,

Do you mean themes & styles of the admin dashboard?

They should be available like in the demo, when you click the palette in the top navbar a right sidebar with themes & styles should open.

Didn’t you forget to upload the stylesheets? for instance admin/assets/stylesheets/themes/

Do you see any error in the browser’s console?

Feel free to email me your access (FTP, admin, ...) if you want me to have a look,

Gilles

Hi,

I understand you are disapointed in your situation, but I’ll do my best to help you and hope you’ll appreciate PHPCG once you get everything working.

First, an “active installation” is a registered installation. A license allows 2 registered installations. Before reinstalling you have to unregister one of your previous installations. Everything is explained here: https://www.phpcrudgenerator.com/tutorials/how-to-uninstall-reinstall-php-crud-generator

“On live server, it doesnt generate any code“

This isn’t normal of course. The first thing to do is to turn PHP display_errors On in your php configuration (php.ini or from your cPanel). Then the errors will be displayed on screen and will help to understand why the files are not created. This can be caused by different things depending on your server: maybe your chmod (writing rights for PHP) are not properly set, or your PHP version might be too old, or you may have a .htaccess somewhere with redirections, ...

As you can see I cannot tell you why it’s not working because it’s due to your server configuration.

Please send me your server access (FTP, server manager (cpanel or similar), URL of the project) and I’ll make it work and solve any problem.

Thanks,

Gilles

About the license:

PHPCG uses Codecanyon’s standard license. The conditions of use are the same as for all the tools you can buy on this platform.

You must therefore purchase a license for each of your projects..

1 project =

1 domain name + unlimited subdomains 2 simultaneous active installations: 1 for your localhost and the 2nd for your production server You can uninstall / reinstall without any limitation. The only condition is that you can’t have more than 2 simultaneous active installations

A generator is connected to one single database.

But you can for instance install it on multiple subdomains, and connect each installation to its own database.

So you can create multiple admin dashboards (with a single regular license), but each one has to be connected to a single database.

2nd question (CSV import)

I used to import CSV (or Excel) spreadsheets in some projects for clients ; there’s no built-in feature for this (it’s not possible because of the infinity of possibilities in the spreadsheet as well as from the database structure).

In short:

• This class to deal with spreadsheets: https://github.com/PHPOffice/PhpSpreadsheet
• I would add a form to upload the file somewhere in the admin, then use the PHP Form Builder Validation class to validate the data
• I would use PHP Form Builder’s DB class to build the queries: https://www.phpformbuilder.pro/documentation/class-doc.php#database-overview
• You can test your data and send an insert or update query accordingly.

If you need anything else you’re welcome,

Gilles

Thanks for that detailed information, very helpful Could you also help with this question, please: Does a read list has to be based on a table only, or can it be based on a query which uses multiple tables? If it can, then will the filters also be able to work on such read list?

A read list is based on one table with all its relational tables.

For instance, you can display the customers addresses if the addresses table is linked to the customers table, with direct or indirect relation.

Based on the same logix, if you select “advanced” in the generator to add a filter you can build your query with joins to filter from a relational table. Click the “Need Help?” button to see the details on how to fill the advanced filter fields (Label, Value(s), ...)

More details are available here: https://www.phpcrudgenerator.com/tutorials/how-to-manage-database-relations

Hi,

The CRUD generator doesn’t use API or webhooks.

If you want to update any data from your database you can for instance send Ajax requests to a PHP file which will use the provided DB class from PHP Form Builder to build and send the queries.

If you need anything else you’re welcome,

Gilles

Hi,

Thanks for purchase.

There’s something wrong from your server, it can be many things, including a .htaccess coming from somewhere, or your PHP session settings, or some directives I can’t guess from a firewall, ...

To help you I’d need your server manager access (cPanel or similar), could you email me please?

A FTP access might be sufficient but I’m not sure at all.

Thanks,

Gilles

Thanks a lot. There was an htaccess on root directory. I’ve renamed it and installation has been completed succesfully. Thank you very much!

Thanks for your feedback, I’m glad you succeeded.

If you need anything else you’re welcome,

Gilles

Please rebuild your list from the Generator. I did it a few minutes ago, then opened the list in the admin and your record was present.

admin/class/MembershipStatistics.php was 0kb because the generator failed to build its content.

The generator failed to build its content because generator/generator-templates/item-class-template.php was missing on your server.

Thanks Gilles, brilliant as always

You’re welcome

Hi,

I need your purchase code,please email me and I’ll do it as soon as I receive your message

Hi,

Yes, everything is possible and this is fairly easy to achieve, but you have to program this in PHP.

You can find on the website the detailed structure and logic (router, PHP classes, TWIG templates) and some examples of admin pages codes:

If you need anything else you’re welcome,

Gilles

Hi Alykhan,

Virtual columns are detected as stored (i.e.: “normal”) columns.

That’s perfect for the READ lists, but it generates the fields in the add/update forms (and of course I agree, it shouldn’t).

You can easily remove the fields from these forms: delete the fields, the validation part that concern them and remove them from the insert/update queries.

This will do the job for now, and I added “virtual fields management” in my TODO list.

If you need anything else you’re welcome,

Gilles

Hi,

1. JSON values usually come from a set of predefined values (https://www.phpcrudgenerator.com/tutorials/how-to-manage-arrays-of-values-with-select-multiple-and-checkboxes)
   I don’t understand why not creating 3 individual fields (1 text, 2 booleans) in your table structure, it would be the most clean and simple solution, but maybe there’s a reason.
   If you want to keep your single text field in JSON you can edit your 2 forms codes (create / update) and replace the single field with an input and 2 radio buttons.
   It’s easy to do with PHP Form Builder’s functions :https://www.phpformbuilder.pro/documentation/functions-reference.php#elements
   If you have to regenerate these 2 forms later you can use the comare/merge tool to merge your custom code with the newly generated forms: https://www.phpcrudgenerator.com/tutorials/regenerate-lists-forms-which-have-been-customized
   I can help if you send me the information (FTP access and admin URL)
2. PHPCG uses some constants for paths and URLs. The constants are defined in conf/conf.php
   ROOT is the path on your server from the root, i.e.: public_html/
   BASE_URL is the URL to your project root, i.e.: https://mysite.com/
   I can make it work if you send me your access.
3. 1. The clean way: change the order of the columns in your database, then rebuild your list.
   2. The quick way: Edit the READ list template in admin/templates/ , and reorder the table cells (<th></th> and <td></td>).
      If you regenerate your list after this kind of code customization you can use the File comparison tool to merge the newly generated file with the previous changes.
   This is explained here in the tutorials: https://www.phpcrudgenerator.com/tutorials, last “tips & tricks” at the very bottom of the page

If you need anything else you’re welcome,

Gilles

Gilles,

Thanks. I got things sorted. Was working on a legacy DB I inherited so I just migrated the DB to a more suitable layout.

1. The reason there was JSON is because each JSON column/row held an array of JSON sub-groups, not just one group. Phpcrud didn’t see that it was an array of many identically structured JSON groups. I migrated the JSON info to a separate table without JSON and used foreign keys to reference my main table. Works great now.

2. Could never get images to work when phpcrud was in a subfolder. I moved phpcrud to the root of my site and images work fine. What was happening was that phpcrud was always appending the name of it’s installation folder to the URL. I’m sure there’s something in the conf/conf.php that would fix this, but I took the easy way out.

3. I just rearranged my column order in the DB. Was migrating anyway, so that worked.

Thank you for your excellent support.

Great!

I’m happy to see that you sorted out everything and appreciate PHPCG

Don’t forget to rate it on Codecanyon if you wish, it’s always appreciated

If you need anything else you’re welcome,

Gilles

Hi,

The scripts for the READ lists are in admin\templates\data-lists-js.html

You can add your own functions.

It’s a TWIG template, so you can use PHP variables inside using the TWIG syntax.

The lists call the main “init” function. this function loads some dependencies with the help of LoadJS.

There’s a callback function, you may add your own scripts inside:

loadjs.ready('core', function() {
    // ... add scripts here
});

If you need anything else you’re welcome,

Gilles

Hi Marcos,

Thanks for purchase.

Here’s how to proceed:

1. Upload your project to your new server and copy your database
2. Follow the “How to clean up your installation” process described here: https://www.phpcrudgenerator.com/tutorials/how-to-uninstall-reinstall-php-crud-generator

If you need anything else you’re welcome,

Gilles

Thanks for that, Cleared the cache but that didn’t help so worked my way carefully through to 2.3.1, no issues at any point other than after each update I did a quick CRTL-F5 but the generatr was still saying up to date . I don’t seem to have an update.logfile either, is that important or just for info?

Cheers Mike

The logfile is just for info, but if you want to email me your server access I can check and see what’s wrong with the auto-update on your server. I’m curious to know why it’s not working, but can’‘t reproduce the problem.

No problem, sent details to your gmail address, subject ‘ftp for rsf crud files’

Hi Jane,

I just updated the documentation, some sessential information was missing: you have to put the drag-n-drop-form-builder folder into the class folder, then it’ll work fine (sorry, my fault, I should have given this information before): https://www.phpcrudgenerator.com/documentation/index#php-form-builder

If you need anything else you’re welcome,

Gilles

This worked. Thank you

Hi,

When you click to export records the generated view is displayed using Datatables.

You can customize the layout as desired. To send the data by email I’d send a POST request then send the email with the PHP Form Builder’s sendMail() function.

There’s no built-in form to register users. It’s an admin dashboard, so the usual process is that the main administrator creates some others profiles and users, assign them some rights then give them the access.

When I need a client account with admin I usually duplicate the authentication (Secure PHP class) module, and build the client accounts apart from the main admin.

I understand, but users will be able to access their own data.

Yes, each user will access his own data if your database structure is properly conceived. It’s explained here in “How to restrict the user’s permissions to its own records?“

Hi Elimedia,

The translations are inside admin/i18n

If you have others questions you’re welcome,

Gilles

Hi,

Sorry, I had a very exceptional issue with an Apache module, now it should be ok.

Could you please test, and email me everything I might need if you still have any problem? (url, ftp, purchase code, ...)

Thanks,

Gilles

1. do you want to log the actions of the users made on the CRUD Generator or on the admin dashboard?
2. is it sufficient for you to log them in a .log file or do you want a web report?

you want to log user actions performed in the administration panel

Ok. So here’s how I would proceed:

1. I’d create a php file to log the users actions, e.g.: admin/log-actions.php
2. In this file, you wrap the content with a condition: if ($_SERVER["REQUEST_METHOD"] == "POST") {// ...}
3. In each admin form (admin/inc/forms), after $db->transactionCommit(); I’d add an include toward the previous file: include_once ADMIN_DIR . 'log-actions.php';
4. In log-actions.php, I’d get the DB debug content with $db->getDebugContent(), get the user data registered in the session by the admin/secure/class/Secure.php and register all the data into a file, or database.

That’s the idea.

CURL Request has been sent successfully. API

Request Time: 2023-07-01 23:55:17 Request Method: POST Request Data: GET/POST: Array ( [name] => John Doe [submit] => 1 )

Hi Gerry,

Thanks for purchase.

You have this message because your server is not properly configured to send cUrl requests. This might be caused by your firewall ; you’ll find more details about this error here: https://www.phpcrudgenerator.com/help-center#error-connection-to-remote

If you need anything else you’re welcome,

Gilles