note 11163 modified in function.mssql-fetch-field by felipe
| From: | felipe@php.net | Date: | Tue, 22 Jul 2008 18:48:20 +0000 |
| Subject: | note 11163 modified in function.mssql-fetch-field by felipe | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-142521@lists.php.net to get a copy of this message | ||
It seems fairly hard to get a list of the tables from your database using MSSQL but this seems to do
the trick. This is set to get only the User Tables and ignores the sytem tables.
<?php
mssql_connect("server","","") or die ("help me!");
mssql_select_db("") or die ("Noooo!");
$result = mssql_query ("sp_tables");
$fields = mssql_num_fields ($result);
$rows = mssql_num_rows ($result);
for ($f=0; $f<$rows; $f++) {
$CHKTYPE=GetField($result,"TABLE_TYPE",$f);
if($CHKTYPE=='TABLE'){
//$name = mssql_fetch_field($result, 2);
$field=GetField($result,"TABLE_NAME",$f)."<br>";
echo $field;
}
}
?>
--was--
It seems fairly hard to get a list of the tables from your database using MSSQL but this seems to do
the trick. This is set to get only the User Tables and ignores the sytem tables.
function GetField($res,$field,$number) {
return stripSlashes(mssql_result($res,$number,"$field"));
}
mssql_connect("server","","") or die ("help me!");
mssql_select_db("") or die ("Noooo!");
$result = mssql_query ("sp_tables");
$fields = mssql_num_fields ($result);
$rows = mssql_num_rows ($result);
for ($f=0; $f<$rows; $f++) {
$CHKTYPE=GetField($result,"TABLE_TYPE",$f);
if($CHKTYPE=='TABLE'){
//$name = mssql_fetch_field($result, 2);
$field=GetField($result,"TABLE_NAME",$f)."<br>";
echo $field;
}
}
http://php.net/manual/en/function.mssql-fetch-field.php