Generate Bootstrap admin single record view

A Single Record REAd list will show the complete data of a single record in your dashboard instead of a list of records.
This view is useful for a configuration / settings table, or user preferences, ... in brief, any table that has only a single to show.

What can a Single Record list view be used for?

A database sometimes uses a table that will only contain a single record, which cannot be deleted. The most common example is a configuration table, or user settings.

In this case it is more appropriate to display all preferences in the admin panel on a single page.

You can do this very easily with PHPCG:

  1. Open the CRUD Generator in your browser
  2. Choose your MySQL table in the dropdown list
    Choose your table to build CRUD operations
  3. Check the "Single Record List" radio button
    Single Record List radio button
  4. Choose your options for each field then submit the form
  5. Your list is ready, you can see it in the admin panel.

It's often a good idea to enable the Edit In Place option for all the fields.

This way you won't have to implement the update form, the end-users will be able to edit the record directly from the List page.

Prerequisites

To build a Single Record REAd list with PHPCG you must beforehand:

The CRUD Generator

PHP CRUD tutorial main page