Database Integration ?? 
Author: David B.
Visited 2563,
Followers 2,
Shared 0
I am using X5 Evolution... I have placed a MySQL table on one of my Website pages. The table contains fields for Username, Pasword, ConsultantID, OwedToConsultant and a few more fields.
I want to allow Consultants to login to my site from the Login Page using their Username and Password and then have the site automatically load the page with the database showing just those records that are queried using the login Username and Password.
.. I got it 'sort-of' working in my Evolution version but I had to use PHP and javascript which I am not proficient with.. so it looks very unprofessional.
So.. my question... If I upgrade to the PRO version... does it make such queries and display of the query result easy to implement?
Posted on the
Hello David
No - not at all.
The X5 is NOT a tool for working with databases. Far from...
And the PRO neither.
You can via the database viewer object show data from a table. And you can set the viewer up, so it is possible to edit data. That is all. There is NO link between the protected pages and the database viewer.
I would strongly recommend that you take a look at Appgini. This is a tool where you can very easily create tables - AND the tool has a built in ( via admin ) possibility to restrict access for a user or a user group. But users has to be created when the table or tables is online.
I have an example here : http://www.bramminginfo.dk/brm20/database.html
You can sort and filter on all fields.
Nothing special is made for this table. It was made in 5 minutes and uploaded in another 5 minutes.
All you see is something that is created as standard. And all can be modified.
There is also other database tools, but I will recommend that you take a look at this : https://bigprof.com/appgini
The AppGini is NOT a tool to create good-looking websites. For this you should use X5 - and then integrate the database project via iframes ( as I have done in the example ) or via links.
The When a user logs in and create a record, the userid is put on the record. And then you can set permissions.
Take a look at it - or search the web for other database tools - that will be my advice.
Kind regards
John S.
Hello again
The data is uploaded via a csv-file. The tool has a very smooth csv-uploader.
The uploading of data is after the 10 minutes of development and installation. But it will only take a few minutes.
Author
Thanks John !!
I took a look at AppGini and it looks like it is exactly what I need!
If you find yourself in Toronto Canada I will buy you a beer!!!!
David