This message appears when I try to create a category in Admin navbar. Before that I installed Authentication module and then deleted it.

But if you don’t know this error, I will reinstall CRUD.

If you can email me your FTP access and URL I can have a look, but this is not a known problem, so it’s probably related to your server in a way or another.

Hi,

Yes, the authentication module allows you to create users roles and profiles, and you can assign the appropriate rights to read, edit and create/delete table by table. If your table has a relation with the user you can restrict the rights to his own records.

This is explained here: https://www.phpcrudgenerator.com/tutorials/user-profiles-and-rights

I always write in English here but I’m French too.

If you need anything else you’re welcome,

Gilles

Bonjour Gilles,

C’est plus simple pour moi du coup … Oui, je comprends bien.

Je souhaite gérer mes données d’une base MySQL. L’idée serait d’interdire la lecture de certaines informations à certains usagers.

Mais du coup, c’est possible d’ajouter plusieurs utilisateurs, par exemple ID=8 ou ID=21 dans la base (Au lieu de =) ? Sachant aussi que certains droits sont liés à des ID de profil et non de personne. On peut mettre en place des variables ou truc assimilé pour cela ?

Merci d’avance pour votre retour. Frédéric

Bonsoir,

Lorsque tu crées des profiles tu peux restreindre les droits pour chaque table avec une requête du style: “WHERE table.user = USER_ID”

USER_ID est l’identifiant de l’utilisateur connecté.

Hi,

You can add image fields and setup your preferences (max. width/height, auto-generation of thumbnails), but you cannot add multiple images with a single field.

https://tinyurl.com/ytuewlcn

The reason is it would be complicated to manage the edition of them: how to, for instance, replace the 2nd image and keep the others?

The solution is to create multiple fields in your table, or a separate table for the images with an external relation (i.e. an intermediate table)

Hi Marcos,

Thanks for purchase.

The constants are defined in admin/i18n/[your-language].php

admin/data-forms.php loads /conf/conf.php (the main configuration file) /conf/conf.php loads /conf/user-conf.json (the user custom configuration file) in which your language is set

Then it includes the constants of your language L.78: ADMIN_DIR . 'i18n/' . LANG . '.php'

If you need more help you can email me your FTP access, then I’ll have a look.

Gilles

Hi Alberto,

Fortunately yes, please email me your purchase code and I’ll remove your registrations from the licvensing system, then you can reuse it.

Gilles

Hi,

Yes, PHPCG is Firebird ready.

If you need anything else you’re welcome,

Gilles

Hi,

I don’t know what you’re planning, but there’s nothing specific with PHP CRUD Generator license. You’ll find all the details here: https://codecanyon.net/licenses/faq

I had some time ago this clarification from Envato’s team:

Customers can only develop a single application per license and may not redistribute it (except to one end client, say, as a freelance project). If it is being distributed like that, a new regular license for each user is required. Customers are not allowed to simply purchase a license and sell item as stock elsewhere.

No, if a user has not the “read” rights on a table the table won’t be available for him (not in the navigation, and of course no page).

1. Is it possible to link data from one table to another? 2. Can fields be optional and mandatory in the table?

Yes of course. Everything is explained in the tutorials.

Hi,

The generator will not do it for you but you can edit the appropriate code to achieve this. Here’s how to proceed:

1. Open admin/class/crud/[Table].php in your code editor
2. Find the line where the columns for the query are ste. It starts with “$columns = “
3. Add the columns you want to display into them. Always add the table name beforefield name (ie: “table.column)
4. Find the code part which loops the records. It starts with “while ($row = $db->fetch()) {“
5. Add your values to the appropriagte column. Eg: $this->column_name[] = $row->field . ' - ' . $row->field2 . ' - ' . $row->field3;

If you want you can email me your FTP and other details, then I’ll have a look.

Gilles

Thanks!

You’re welcome

Hi,

Thanks for purchase.

Please first read & try this: https://www.phpcrudgenerator.com/help-center#error-404

If you still have the problem feel free to email me your FTP & URL, I’ll then have a look

Gilles

Hi Jane,

I’m on PC and know almost nothing about mac. I work with MAMP PRO, and recently discovered Laragon which seems to be a good choice too.

I can suggestion a few other things:

• Try to open php-crud-generator/admin/home in your browser. If it works it means you have no problem with .htaccess & rewrite rules.
• When you generate a list or form, check if the files are generated in the admin folder. If they’re not it probably means that you have a permissions issue. You should then google “how to give write permission to folder in mac”
• The problem doesn’t seem to be related to a database issue, but to the 404 error. Double-check that you don’t have a .htaccess at the root that might interfer with the admin rules

I hope it’ll help you,

Gilles

Hi,

Thanks for purchase.

Yes, I’ll help you, please could you email me your FTP access and project URL?

Gilles

Hi,

It’s a typo in generator/generator-templates/item-list-template.php. I already patched the Codecanyon’s package ; please make the following change:

// find this code:
 }}|raw

// replace with:
|raw }}

Then rebuild your lists, or make the same change to them in admin/templates

If you need anything else you’re welcome,

Gilles

Hi,

Yes, it’ll work.

When you add your filters enable Ajax loading. This way your 10 million records won’t be loaded on page load and PHPCG will use Ajax and autocomplete the values when you start typing.

You can see a live example at https://www.phpcrudgenerator.com/admin/actor with the actor’s “name” filter.

If you need anything else you’re welcome,

Gilles

Thanks for the answer. I will buy!

One last question, is it possible to limit the number of records that a user can read/export?

Could I create this adaptation with the help of a PHP dev?

Hi,

You can choose the number of records displayed in each list, of course you can custmoize it in the code easily. If you need something more specific I might do it for you, or at least guide you on how to proceed.

Hi,

If it says you have reached the maximum number of installations it means that you did it.

Please email me your purchase code and I’ll tell you which domains are registered, and remove them if you want.

Thanks,

Gilles

Not sure where to install php crud generator. Our company domain houses all our database files and we have five website domains that access the company databases. Not sure where to install the crud generator scripts??

followed all help instructions and not able to proceed as installation continues to fail- “An unknown error occurred” not much of a help but seems to be all we are told? Spent good part of the day trying to setup and at this time we just need to get back to our work!

Hi,

I’m sorry you have these difficulties and will do my best to help you quickly and efficiently.

I need first to understand how your company works. Please email me or try to reach me on chat at https://www.phpcrudgenerator.com/, and give me some details:

• How many databases do you have
• How many domains do you have
• Which domain uses which database

If you can send me the access: FTPs, URLs, Database credentials (hostname, username, password) I can do the job and make it work for you

Else I’ll tell you how to proceed.

Thanks for your prompt response, now it works, but I have a problem, the image is not visible, I think I have something configured wrong. attached images . https://prnt.sc/a4xbQlmyyGbX https://prnt.sc/6b-HH12QOxgz https://prnt.sc/JYZul6AWWxOM https://prnt.sc/pIA-4KD7O6Jh

There’s probably something wrong with the image url you set.

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

If you want you can reach me now on chat at https://www.phpcrudgenerator.com

go

Hi,

No, it supports firebird, mysql, oci & pgsql, I didn’t work on ODBC yet.

Thanks Gilles, i tried as you mentioned but it did not worked

Also how to post the review?

Thanks for your excellent review!

I made a mistake in the code, please try it again with the following replacement:

# old wrong code:
if ($(this).val() == '') {

# replace with this one:
if ($(this).val() == 'Requested') {

Double-check that the option value is the same (“Requested” with the first letter capitalized)

I’m connected now, so you can also reach me on my chat at https://www.phpcrudgenerator.com

Hi,

Thanks for purchase.

The forms are located in crudfolder/admin/inc/forms/ (the admin structure details are available here: https://www.phpcrudgenerator.com/tutorials/admin-panel-tree-structure-files-and-logic)

1. Open [table]-edit.php (where [table] is the name of your db table) in your code editor
2. The form is build with PHP Form Builder: https://www.phpformbuilder.pro/. Edit the fields and add “readonly” to the arguments. This will do the job. E.g.:

   $form->addInput('text', 'user-name-1', 'value', 'User Name', 'required, readonly');

When you add users to the admin you must enter their email and password. This will be their login.

If you need anything else you’re welcome,

Gilles

Thanks a lot Gilles, it worked.. However i made the date field readonly it is working but it showing the date as Dec 03, 1900 where as the actual date is 01 March 2023

The date issue is probably not related to the readonly, but to a date formatting issue. The value from your database should be ‘2023-03-01’, and the form should understand it.

Did you change the date format in the CRUD generator?

Date & time format management is a big challenge, you’ll find all the details here, but I don’t know if it can help you: https://www.phpcrudgenerator.com/tutorials/date-time-formats-management-logic-for-coders

Else I’d need your CRUD, Admin & FTP access to help you with this.