note 6712 deleted from ref.mssql by jimw
| From: | jimw@php.net | Date: | Sat, 15 Dec 2001 22:23:49 +0000 |
| Subject: | note 6712 deleted from ref.mssql by jimw | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-22878@lists.php.net to get a copy of this message | ||
<PRE>
<h1>TestSql.php</h1><hr>
This is a direct connection to the MS SQL7.0 database. Using PHPver4.01P2 on Win NT/IIS
4.0<br>
<?
// YOUR MSSQL 7.0 SERVER PARAMETERS
$hostname = "wruslan";
$username = "wruslanpubs";
$password = "wruslanpubs";
// YOUR MSSQL 7.0 DATABASE
$dbname = "pubs";
$tablename = "employee" ;
// CONNECT TO THE MSSQL 7.0 DATABASE
$connection = mssql_connect($hostname,$username,$password);
mssql_select_db($dbname);
$sql_query = "select * from $tablename" ;
$query_result =mssql_query($sql_query) ;
$number_rows = mssql_num_rows($query_result) ;
$number_fields = mssql_num_fields($query_result) ;
// TEST YOUR QUERY
if($number_rows == 0) :
print "<br>The query does not produce any data row ! <br><br> " ;
elseif ($number_rows > 0) :
print "<br> Yes there are " . $number_rows . " rows resulting from the
query. <br><br>" ;
endif ;
// DISPLAY TABLE FIELD HEADERS
print "<table border><tr><th>row</th>" ;
for ($field_number = 0 ; $field_number <= $number_fields - 1 ; $field_number++ )
{
$field_name = mssql_field_name($query_result, $field_number) ;
print "<th>" . $field_name . "</th>" ;
}
print "</tr>" ;
// DISPLAY INDIVIDUAL ROWS - POPULATING THE TABLE
for ($row_number = 0 ; $row_number <= $number_rows - 1 ; $row_number++)
{
print "<tr><td>" . $row_number . "</td>" ;
for ($field_number = 0 ; $field_number <= $number_fields - 1 ; $field_number++)
{
print "<td>" . mssql_result($query_result, $row_number, $field_number) .
"</td>" ;
}
print "</tr>" ;
}
print "</table>" ;
mssql_close($connection);
?>
All the best to you. .... Alhamdulillah ... wruslan ... 17 July 2000 ....