Building web based interface for mssql

I am maintaining the databases for my organization in mssql. I have many tables for my database. Now I have to develop a web based service so that any user without the knowledge of sql could access the tables and pull the information they want. I have little knowledge in php...can I build the web based interface in php? Or should I do the web interface using other programming language? Sorry if my question sounds silly..Can anyone please suggest me 开发者_JAVA百科regarding this?

Are the tables fixed or may there be new ones often?

http://www.php.net/manual/en/function.mssql-query.php

http://php.net/manual/en/function.mssql-fetch-array.php

If the tables are fixed you could make pages for each database which will select the data you need and then echo it in a table. You could also build forms and then use that data to do INSERT statements so the users can update the tables

I use MySQL but these manuals will help you to use mssql queries within PHP to select rows in the database and then loop though them echoing the Divs and Tables using $row['column name'] to use the variables.

If the tables could change and you can't find a suitable msSQL equivalent to PHPmyAdmin I would seriously consider changing to MySQL.