WebSite X5Help Center

 
Pál L.
Pál L.
User

Database View - contact form db  en

Autore: Pál L.
Visite 762, Followers 1, Condiviso 0  

PHP 8.3, Win 11 Pro, WSX5 Pro 2023.3.11

https://www.haluskahaz.hu/foglalasok.html

I have created a form to book an appointment for a visit by email. I store the data in MySQL (MariaDB) database. The form sets the names of the fields in the table I created (id, field_1, field_2, etc) independently of me.
When I want to open this data table, with "Database Viewer" only the 'Filter' and "Export CSV" buttons appear next to the filter field, but no data. No error message is displayed either, although PHP error display is enabled (cPanel).

Attached is the image cropping for DB.

Postato il
6 RISPOSTE - 1 CORRETTO
John S.
John S.
User

In the panel for MySql you should be able to view the data.

If there is data in the table you should also be able to see them in the database-viewer.

If you want to be able to edit the data in the viewer you have to make a key for the table.

You could in the panel for the MySql add a automatic key to the table.

So the first thing to check is: Is there existing data in the table?

Leggi di più
Postato il da John S.
Pál L.
Pál L.
User
Autore

Thank You, John,

Of course, there are 3 records already in the table (for test purposes), and an ID field is created when the reservation is made! Attached is the image of the php Myadmin interface.

Leggi di più
Postato il da Pál L.
John S.
John S.
User

OK

You have a database with a table with data.

You have an object that should be able to view data in a table in a database.

Then it must be in the X5 setting for the database or the viewer.

If the data in the table is coming from the X5-form, then the database settings should be OK and it must be the setting for the viewer.

If the data is put in the table "by hand" then first check the X5 database setting.

Leggi di più
Postato il da John S.
John S.
John S.
User

If/when you are able to put data in the table using the X5-form then the database settings in X5 is OK and you can concentrate on the viewer.

If the X5-form is not able to put data in the table you should first concentrate on checking the database settings in X5.

Leggi di più
Postato il da John S.
John S.
John S.
User

As I see it on your pages, you should consider to use a calendar to present reservations. 

If you use the LuxCal calendar you will even be able to make bookings directly in the calendar.

The calendar can send notifications via email, Telegram or SMS. The emails and Telegram messages is free. Also the SMS is free but you have to have a SMS gateway.

The calendar can be set up to send automatic messages xx time before the event/booking is taking place.

You can attach PDF's to a booking/event to inform guests about house-rules and so. The new Telegram function (new version coming in a couple of weeks) is really amazing. It is fully integrated in the calendar.

If you are interested in the calendar, I can supply you with more information. 

If you are interested I will then contact you via the contact form on the contact-page.

Leggi di più
Postato il da John S.
Pál L.
Pál L.
User
Autore

Thank You John,

I guess I didn't word it right or You didn't understand what my problem was. Probably because of my poor English. embarassed
So I solved it by creating a MySQL table viewer page with Pablo WWB19 with a few mouse clicks and displaying it.

Pál.

Leggi di più
Postato il da Pál L.