I got your email, will answer it in a few minutes

I know that you respond me but I lost the email, it was deleted. Can you give indicate me the next steps to fix the issue please? Write me an email. Thanks

I guess you found it back, I got your answer.

Hi,

It hasn’t been tested with these versions, PHPCG works with PDO, so you shouldn’t have any problem with Mysql 9.5 but I can’t guarantee.

I’d recommend you to try it, then if you encounter any issue try to downgrade your php version.

In such a case I’ll accept refund if you really have a problem with the php/mysql versions you use.

Hi,

The CRUD Generator will generate the 3 forms you need for your table (insert/update/delete). If you need something else you can customize the class and the template to link to thoers custom forms. I might work for you if you ask (freelance work for customization).

Gilles

Hi,

The problem comes from your server (local I guess). The message means that MySQL/MariaDB is configured to use the https plugin (likely for secure connections), but the required shared library (https.so) is missing or not found at the specified path.

Not yet. If you want a custom development I might work on it but especially for you, as freelancer.

P.S. I helped you this morning (morning for me in France), suddenly you leaved the chat (I guessed the issue with your local server was solved). A “bye, thanks” would have been apprciated.

Sorry about that. Our power went out and I lost Internet for a few hours. It wa midnight here so I called it a night. I was able to get the fix in that you suggested lastnight. Thanks for the help. to use an ODBC database in the db connection test php where do you specify the dSN name. Host, port, user, password, database, table]

Oh I understand, sorry for my remark.

When you install you choose your database driver from the dropdown list in the installer.

To change the driver open `class\phpformbuilder\database\db-connect.php` and set your driver here with the PDO_DRIVER constant.

If you need anything else you’re welcome,

Gilles

Thank you! I will try it. And thank you for your fast answer!

Thanks to you

Just to say that I sent an email to Migli to access to my cPanel and make the changes and he was very fast in making this changes! I am very pleased with this script and with the support!

Bonjour,

Le certificat du domaine koamotte.app n’est pas valide. Ce qui provoque une erreur de sécurité, empêche le chargement de la page, et des dépendances (css/js).

De plus le http est redirigé vers https, donc on ne peut pas charger en simple http non-sécurisé non plus.

Il faudrait corriger ce problème de certificat, ensuite tout devrait aller bien.

Pour plus d’aide n’hésite pas à m’envoyer des infos par email depuis https://www.miglisoft.com#contact.

Gilles

for development, is there way to use a localhost db with PCG installed remotely?

since the application configures auto-configures when installing, does the database have to be installed on the same server as the application?

PHPCG must be able to connect to your database wherever it is. You just have to enter your connection settings during the installation. Your database can be on any server but of course it must allow the access.

The installer write these settings in php-crud-generator\class\phpformbuilder\database\db-connect.php.

If you know what you’re doing you can edit this file manually to set your database connection.

You’ll find here the standard recommendations on how to deal with development and production: https://www.phpcrudgenerator.com/tutorials/use-phpcg-on-a-localhost-and-a-remote-server

Hi,

Please try this carefully: https://www.phpcrudgenerator.com/tutorials/uninstall-reinstall-php-crud-generator#clean-up-your-installation

Then if you still need my help please email me your FTP access, your purchase code and your server manager access (I need access to your phpmyadmin), then I’ll make it work.

Gilles

we managed to get the install completed but one question remains. Our table has 75 fields and we only need to control 10 of these fields. Is there a way to limit the field list to just these 10 before loading the table rather than loading all 75 fields and having to then remove the unneeded fields one at a time ?

Hi,

In the generator you have a “Do not show in the list” radio button on each field.

With the forms you have no way to completely exclude the fields ; my advice would be to choose “hidden” and no validation for all the fields you don’t want to see. Then you can remove them manually from the forms if you want, but there’s no hudge impact if you let them.

If you need anything else you’re welcome,

Gilles

Hi,

Thanks for purchase.

You found the right solution, that’s fine. You have to enter the path/url relative to the project’s base folder. The CRUD (the project) is in your “crud-cms” folder, but the images are in a subfolder of the parent folder.

If you need anything else you’re welcome,

Gilles

Thank you Gilles and thanks for your great work.

Thanks to you!

Hi,

1. Yes, everything is customizable with the TWIG templates, the php classes and css. If you give me more details I can lead you on the right track, or customize for you if you send me your FTP¨, for free or as Freelancer if it requires some more time.

2. Same answer as #1.

You can email me from my contact page here: https://www.miglisoft.com/#contact

Gilles

Hi,

The licensing servcer is up & running, there’s no issue with it.

You can open conf/conf.php and set “generator_locked” and “admin_locked” to false temporarly, it’ll unlock everything (but don”t forget: anyone can access!)

If you need more help please email me your url, ftp and purchase code, I’ll check it.

Gilles

Your E-Mail-Form at: https://www.miglisoft.com/#contact does not work: captcha error

It works, but you have to refresh your browser cache.

Toutes mes excuses, j’ai pensé que tu paralais simplement d’https.

Pour une connection SSL:

1. Ouvre le fichier /class/phpformbuilder/database/DB.php dans ton éditeur de code

2. Dans la fonction __construct(), tu trouveras le code suivant:

$this->pdo = new \PDO(
    $dsn,
    $username,
    $password
);

Tu peux ici y ajouter les options pour une connection SSL:

$options = [
    PDO::MYSQL_ATTR_SSL_CA     => '/path/to/ca-cert.pem',
    PDO::MYSQL_ATTR_SSL_CERT   => '/path/to/client-cert.pem',
    PDO::MYSQL_ATTR_SSL_KEY    => '/path/to/client-key.pem'
];

$this->pdo = new \PDO(
    $dsn,
    $username,
    $password,
    $options
);

Never received. Are you using an illegal copy? Take care of your server, with this kind of things you might someday wake up and have lost everything … who knows?

getting a captcha error if i try to mail you

No captcha here: https://codecanyon.net/user/migli (or try to refresh your browser cache at https://www.miglisoft.com/#contact) EDIT: I received your email, will answer soon. Thanks

Sorry for the complications – I’m having a temporary problem with php versions between my domain and a tool I’ve just published (https://github.com/migliori/visual-diff-merge). I must update my page.

In the meantime could you please send your message from https://codecanyon.net/user/migli ?

Thanks for your understanding

I just resent the request. Can you look at it asap please.

If the problem is because I have changed DB fields then how can this be remedied in the future?

I just answered your email.

Hi,

Yes, according to the Envato license terms. But you can unregister / register elsewhere as many times as you wish. If you can’t unregister you can email me your purchase code and I’ll do it for you.

I made a return request. The reason I bought the product was to dress it in any theme I wanted, but since there is no such thing, your product does not work for me. Please accept my return. The dollar exchange rate is very high in my country.

Done. But you should question before buying, I paid for your mistake.

I’m sorry and thank you very much.

Hi Penseur9,

Most of the time, if a user can create, they must also be able to delete, as they may have created a record by mistake, for example.

User rights are managed by the PHP class r\admin\secure\class\secure\Secure.php. If you open this file you will find in the code comments the various functions available and an example of use.

To dissociate the Create/Delete Phpcg Users rights, here is how I would proceed:

1. Create your profile, for instance named ‘create_only’ and allow it to create/delete phpcg_users.
2. Open \admin\data-forms.php and edit the code this way:

   /* Original code
   ===================================== */
   
   // lock page
   if ($action == 'edit' && Secure::canUpdate($table) !== true && Secure::canUpdateRestricted($table) !== true) {
       Secure::logout();
   } elseif (($action == 'create' || $action == 'delete') && (Secure::canCreate($table) !== true && Secure::canCreateRestricted($table) !== true)) {
       Secure::logout();
   }
   
   /* replace with this
   ===================================== */
   
   // lock page
   if ($action == 'edit' && Secure::canUpdate($table) !== true && Secure::canUpdateRestricted($table) !== true) {
       Secure::logout();
   } elseif (($action == 'create' || $action == 'delete') && (Secure::canCreate($table) !== true && Secure::canCreateRestricted($table) !== true)) {
       Secure::logout();
   } elseif ($action == 'delete' && $_SESSION['secure_user_profiles_name'] == 'create_only') {
       Secure::logout();
   }

3. Open \admin\templates\phpcgusers.html and edit the code:

   /* Original code
   ===================================== */
   
   {% if object.can_create == true %}
   <a href="{{ constant('ADMIN_URL') }}{{ object.item }}/delete/{{ object.pk_url_params[loop.index0] }}" class="btn btn-sm btn-danger" data-bs-toggle="tooltip" data-bs-title="{{ constant('DELETE_CONST') }}" data-delay="500"><span class="{{ constant('ICON_DELETE') }} icon-md" /></a>
   {% endif %}
   
   /* replace with this
   ===================================== */
   
   {% if object.can_create == true and session.secure_user_profiles_name != 'create_only' %}
   <a href="{{ constant('ADMIN_URL') }}{{ object.item }}/delete/{{ object.pk_url_params[loop.index0] }}" class="btn btn-sm btn-danger" data-bs-toggle="tooltip" data-bs-title="{{ constant('DELETE_CONST') }}" data-delay="500"><span class="{{ constant('ICON_DELETE') }} icon-md" /></a>
   {% endif %}

This way the “delete” button will be removed from the list and the delete form will be disallowed for the ‘create_only’ users.

Gilles

My apologies. Anyway, if you have any bugs to report, you’re welcome and I’ll do my best. A precise description and access to the server are always preferable if it concerns special cases/configurations.

I’m very glad to see these fixed and hoped try it again but I also recall being unable to do any action in my own servers, because the licensing server was down, and the software requires a successful call to your server for every single action even after installation. (undisclosed anywhere in https://www.phpcrudgenerator.com/tutorials/about-php-crud-generator-license)

I understand the licensing/pirating issue at hand, but this license solution kills the product potential as custom and independent solution.

I couldn’t add a row in my database, or do anything else, in my server, and there was nothing I could do to fix it although nothing wrong on my server.

Would likely try it again if it wasn’t for that.

There has indeed been a one-off problem with the licence server, the only one since it went live more than 10 years ago. I understand your concern, but I have no other choice. Many programs use the same protection (WP themes and plugins, etc.). The licence server, like all servers, is about 99% available. Everything is ready if I ever had to disable it, users would not be affected.

If you need anything else you’re welcome

Great. I’m available for help of course.

I have a problem, please help me. I tested via localhost

1. I created only a database, no table yet. I want to have a login system. What kind of table do I need to create? What do I need?

2. When I first installed, I put my own logo but it didn’t show.

Thank you.

Hi,

1. For the login system you don’t have to create any table, the CRUD Generator will do it for you, but the logic is first to add your tables, then install and enable the authentication module at the end. The authentication module will create 2 tables: “project_users” and “project_users_profiles” where “project” is a prefix you can set as you wish. The module has to know the tables of your project to let you assign view/edit/delete rights to each profile. Please read this then tell me if you have more questions:
   https://www.phpcrudgenerator.com/documentation/index#admin-user-authentication-module
   https://www.phpcrudgenerator.com/tutorials/user-profiles-and-rights
2. In conf/user-conf.json you should see your filename ("admin_logo"). The image file should be in the admin/assets/images/ folder.