Load mysql data with database as login
Load mysql data with database as login
![luizfsfnet1](https://secure.gravatar.com/avatar/96b61690869b822824485d831a7ca3f1/?default=https%3A%2F%2Fvanillicon.com%2F96b61690869b822824485d831a7ca3f1_200.png&rating=g&size=120)
Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:
Hello guys
I've been trying for a few days but I'm almost giving up.
I'm making a vehicle registration system, which has admin user and supplier user (common users).
I would like the admin user to visualize all the registrations via datatables (this I achieved with the standard code kkk) but what I really wanted was that when each supplier (common user) logs into the system, he would only visualize their registrations, without loading the of others.
Can someone help me? Do I need to finish my project? i'm not finding anything for me to finish this.
Answers
Are you using a web framework and if so does it support user login?
You will need to create a login solution for your web page.
Once the user is authenticate you can send the user id to the server using
ajax.data
, similar to this example. Then your server script can query for all the data for the admin or filter the data for the supplier user.Kevin