Display Database Records

[Chris M]

I don't want anyone going to any lengths on this as I do have a (poor) solution.

Is there a pretty way to display the records of an SQL database? This particular project has a form that collects and stores data in a db and I would like to display that data without opening MySQL or phpMyAdmin to do so.

The records don't need to be secure and won't be public facing.

[Initiostar]

You could simply extract the SQL data into a Google sheet, format and embed it into a web page. I'd guess that's where you are now?

Mu business does this for real-time data using our OmniDisplay software, but it's an on-site corporate application - https://initiostar.co.uk/projects.htm - the Google Finance table is in real-time for financial indices.

[Chris M]

You could simply extract the SQL data into a Google sheet, format and embed it into a web page. I'd guess that's where you are now?

Mu business does this for real-time data using our OmniDisplay software, but it's an on-site corporate application - https://initiostar.co.uk/projects.htm - the Google Finance table is in real-time for financial indices.

Similar. I'm looking at MyWebSQL which literally gives full access to the db via a browser. Full access is fine in this case, but I'd rather it was read only and/or cleaner to look at. I keep gravitating to Airtable as I've used it before, but it isn't cheap.

[Acorn]

Assuming it is a MySQL database, I might have jumped in with https://editor.datatables.net/manual...xample-package.
I'm sure Google Sheets will have a live database mechanism, probably JSON.

How real-time does it have to be?

Acorn

[Chris M]

Assuming it is a MySQL database, I might have jumped in with https://editor.datatables.net/manual...xample-package.
I'm sure Google Sheets will have a live database mechanism, probably JSON.

How real-time does it have to be?

Acorn

It doesn't have to be real time. All it is is a glorified address book. New members add their details via online form which is then stored in MySQL dab. When events become available the organisers search the database to see which members match the genre.

This is still in the 'I've-had-an-idea' stage so clunky is fine.

[Initiostar]

Maybe an SQL Reporting tool? https://www.holistics.io/blog/top-5-...shboard-tools/. Only to do anything for real there's a cost.

[Chris M]

Assuming it is a MySQL database, I might have jumped in with https://editor.datatables.net/manual...xample-package.
I'm sure Google Sheets will have a live database mechanism, probably JSON.

How real-time does it have to be?

Acorn

This one does the job perfectly and I didn't even break a single keyboard trying to work out the codelantic language.

[Chris M]

Ah, spoke too soon, it doesn't update at all. Unless I'm missing something (highly likely) you have to manually add records to the db. It looks nice and clean though.