0
Welcome Guest! Login
0 items Join Now

ROCKETTHEME IS CLOSING ON JUNE 30, 2025. As a thank-you to our community, enjoy 50% off all themes with the promo code THANKYOU before we shut down. Read our Farewell Blog Post for more details.

Getting internal client info on the web?

Last Post
Search Topic
    • Adamck's Avatar
    • Adamck
    • Elite Rocketeer
    • Posts: 546
    • Thanks: 2
    • Web Developer, IT Assistant, Graphics design, App Developer

    Getting internal client info on the web?

    Posted 14 years 9 months ago
    • Hi Guys,
      My work would like for our clients or brokers to be able to view their clients (limited) info on the web.
      I have the site in joomla, and wondered what the best route is?
      Am i best creating a custom php module, with my php code to get the info from a seperate mySQL database and display the info (using SQLYOG software to run queries on the internal MSSQL and auto-update the mySQL web database) ??

      I have tested out having the clients as registered users (which we create) and i use the username in the query to grab their data
      e.g
      Select * FROM table WHERE BrID = $username

      Or is their any better mothods / extensions in joomla which make use of features like web services that would make the process flow a little easier and quicker??

      I am pretty new to this!

      Cheers Guys.
    • Kiss my RSS
    #544379

Time to create page: 0.057 seconds