Display content based on user / client login

A few years ago I designed a php / mysql website in dreamweaver that displayed data from a database query based on the client who had logged in.

I’m looking into whether I can re-design the site in WordPress to make it more efficient to administer and update the html / css code.

There are multiple users from multiple clients, and each user had their own username and password to log into the website.

So for example, ‘User 1’ who works for ‘Company A’ can log in using their own username and password and view data on that Company. They would not be able to see other company’s data.

When they log in they can search by ‘site name’ or ‘job number’, the results page would display a list of relevant results, each with a link to view the detail page of a particular record.

The detail page would display data and images for that particular site.

This was done using a query in the database, and then the code in the web page calls that query and displays the data based on the user id.

It got complicated when I had requests to allow certain users to see multiple companies, and the search box was limited in what it could search for.

So I’m hoping WordPress can address these problems and make my life easier. It would be great if I had control over the individual permissions of each user and choose what companies each and every user could see using tick boxes in an admin panel.

Is it possible to display content from a database query – based on who is logged in – on template pages in wordpress, and also have a powerful search facility?

Many thanks.