SQL PHP HTML ASP JavaScript articles and free scripts to download
 

MSSQL Data Display using PHP functions

We can collect records or data from MSSQL database by using PHP. Here we will use some exclusive php function to interact and collect data from MSSQL db. These functions will be available for use if MSSQL support is enabled in php configuration file php.ini.

We will use two php functions to interact with MSSQL. We assume that the connection to MSSQL is already established and we will move from that step onwards.

We will use the function mssql_query() to execute the SQL select query.
$query="select * from emp_m ";
$qt=mssql_query($query);
The pointer of this function we will use as input to mssql_fetch_array() , this mssql_fetch_array() function will return the array of records. We will use while loop to display all the records collected inside the array.

Here is the complete code to display the records from a MSSQL table.
$dbusername='';
$dbpassword='';
$servername='';
$link= mssql_connect ($servername,$dbusername,$dbpassword);
$query="select * from emp_m ";
$qt=mssql_query($query);
while($nt=mssql_fetch_array($qt)){
echo "$nt[emp_no]"." $nt[name]";
echo "<br>";
} 
How to display data from mysql table ?
Google+
Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked


Join Our Email List
Email:  
For Email Newsletters you can trust



PHP MsSQL
HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2014 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer