Hi,

Thanks for purchase.

Sql server uses the PHP PDO_SQLSRV driver, which is not currently implemented with PHP CRUD Generator. I can only suggest you to migrate your database to another DB Engine, got no other solution for you, except if I make this development for you but it might be a bit expensive …

Gilles

Hello,

No there’s not. You can setup your own but this is not a built-in feature.

Hi,

Thanks for purchase.

You can turn php display_errrors On in your php configuration (php.ini) but I’m not sure it’ll help.

You should try to change your password:

1. Open conf/user-conf.json in your code editor
2. set “admin_locked” to false
3. You can then open your admin in your browser at admin/home, go to your user list and change your password.
4. Then revert “admin_locked” to true and see if it works.

If you need anything else you’re welcome,

Gilles

It works! Thks

Perfect, thanks for your feedback

Hi,

In admin\secure\class\secure\Secure.php testUser(), from L.185 the user data is stored in the PHP SESSION.

You can user these data to test the connected user and display your data accordingly. For instance, in a TWIG template:

{% if session.secure_user_profiles_name == 'admin' %}
// do stuff
{% endif %}

If you need more details feel free to ask,

Gilles

i want to know if it possible to separate action “create/delete phpcg_store” by “create phpcg_store” and “delete phpcg_store” ? in your app these two action are one !

This is not a built-in feature, but like I explained before you can customize the code.

This sait, it’s logical to tie the create & delete rights between each other. If someone creates a record with errors he’ll need at least to be able to delete it.

Hi Tomas,

The form to add users to the admin is in /admin/inc/forms/users-create.php

When you add a user the password is encrypted in calling Secure::encrypt($_POST['password']), which is located in admin\secure\class\secure\Secure.php

The pass is encrypted using the php password_hash() function – https://www.php.net/manual/en/function.password-hash.php

I let you look deeper in these functions & hope you’ll find your way

Hi Josh,

Thanks for purchase.

PHP CRUD Generator uses URL rewriting to have clean nice-looking URLs in the admin.

The rewriting is managed by the admin/.htaccess on Apache servers, but as you are on Nginx you have to edit your configuration (nginx.conf) and add the following rules:

location /admin/ {
    try_files $uri /admin/index.php;
}

This is explained here: https://www.phpcrudgenerator.com/tutorials/install-phpcg-on-nginx-and-microsoft-iis-server

Also if you want more information about the files generated by the CRUD Generator, here’s the admin logic & structure: https://www.phpcrudgenerator.com/tutorials/admin-panel-tree-structure-files-and-logic

The main generated files are in admin/class/crud and admin /inc/forms

If you need anything else you’re welcome,

Gilles

Hi,

Thanks for purchase.

It seems that you’re trying to install the authentication module but you didn’t add any table list to your admin dashboard. And the admin 404 error seems to be the same kind of problem. You should be able to open /admin/home. I’d need more information to help you more. Feel free to email me your FTP access & other details if you need.

Gilles

Hi,

Thanks for purchase.

You probably have a problem with url rewriting on your server. Did you check your apache configuration? – https://www.phpcrudgenerator.com/help-center#error-404

I’d be happy to help you but I’d need your server access with access to the apache conf.

You can email me if you want me to have a look.

Gilles

Thank you very much. Been able to sort it out. If the .404 error still occurs, get the entire directory for it to work. Thanks

Thanks for your feedback

Hi Shahzad,

This is not a built-in feature but PHP CRUD Generator is designed with clear, organised and accessible code for PHP developers.

You can generate your reports and invoices with PHP PDF Libraries like MPDF https://mpdf.github.io/, or TCPDF, or even DOMPDT.

I won’t program it for you but I can lead you on the right track.

If you need anything else you’re welcome,

Gilles

Hi,

Thanks for purchase.

I cannot answer without access to the generator & your admin, I need to see your tables, relations and how you configured the whole.
If you want you can email me your FTP access, then I’ll have a look.

Gilles

Hi,

You already have the count of the external relations records, for instance Rental “here”: https://www.phpcrudgenerator.com/admin/customer

You can edit your Users class, which should be admin/class/crud/Users.php and its template if you want to display anything differently.

The admin structure & logic is detailed here: https://www.phpcrudgenerator.com/tutorials/admin-panel-tree-structure-files-and-logic

Hi,

1. Yes you can. That’s the reason why a single license allows 2 active installations. https://www.phpcrudgenerator.com/tutorials/how-to-use-phpcg-on-a-localhost-and-a-remote-server
2. Your tables and fields must respect some basic standards: each table must have a primary key, etc. It’s explained here: https://www.phpcrudgenerator.com/documentation/index#requirements

If you need anything else you’re welcome,

Gilles

how to show total no. of counts or result both in regular result and nested result

Hi,

Thanks for your message. Yes, you just have to open the installer and click “uninstall”: https://www.phpcrudgenerator.com/tutorials/how-to-uninstall-reinstall-php-crud-generator

If for some reason you can’t you can email me your purchase code and I can unregister for you.

Gilles

Thanks. I can’t do the uninstall any more so I’ll send you the key.

Hi,

Thanks for purchase.

The name of the root folder doesn’t matter, the 500 error is probably not due to that. You’ll need to find out what the error is from your error.log file, or activate display_errors in your php configuration to display the error on screen (which is recommended when you’re in the development phase).

If you need any further help, don’t hesitate to send me your access details (URL + FTP).

Gilles

Hi,

Thanks for purchase. The error 500 might be caused by something else, did hyou have a look to your server php logs? Or you can turn display_errors On, the error message will then be displayed on screen.

I hope it’ll help,

If you need anything else you’re welcome,

Gilles

Thanks, looks like i managed to sort it out by manipulating the admin\assets\.htaccess file.

Nice. Thanks for your feedback.

Hi,

The generator will not build this, but it’s easy to code. If you buy and send me your FTP I can make it for you.

Gilles

Hi,

I found your installations and removed them from the system, so you can reinstall now, but why do you say the installation fails? any error message?

For more help you can If you want you can email me your FTP access and others details I might need, then I’ll have a look.

Gilles

This discussion is public, anyone can connect if you publish your FTP access here! it’s risky!

I’ll flag your comment and the Codecanyon team will remove this information.

This said, I opened the generator (/generator/generator.php) and it doesn’t show any table: it looks like your database is empty. You have first to create your tables, add fields and relationships, then click the “Refresh” button. You can then start to add your content to the admin panel.

The admin URL is /admin/home. I opened it, everything looks fine, except that you have no content, for the same reason as above.

So if you add some content to your database, then generate the admin using the generator everything will be fine.

If you need anything else you’re welcome,

Gilles

Hi,

Thanks for purchase.

I opened your generator and the admin in my browser, everything is ok, except that your database is empty, the admin only shows the users table. I’d be happy to help you but found no issue.

Hi,

Yes, it’s perfectly well-adapted.

Hi Andrew,

It’s worth moving to the version 2, there’s many improvements, but you’ll have to rebuild your admin from scratch, you cannot update from v1.x to v2.

You just have to download it, then upload to any host and run the installer.

On localhost you have to install a local server like MAMP or Laragon.

For more help please email me.

Gilles

thank you!

you’re welciome