doqpm82240 2010-11-19 04:18
浏览 92
已采纳

Firebird:如何在html页面中显示表结构?

I try to use the code below to show table structure in html page:

<HTML>
<HEAD>
<TITLE>PHP + Firebird / Interbase test (connection)</TITLE>
</HEAD>
<BODY>
<H3>FB Connect test.</H3>
<?php
// DB definition of account
define("DBNAME","xx.xxx.xx.xxx:D:\DATABASE\OCS DATA.FDB"); // data bsse name
define("DBUSER","USER"); // user name
define("DBPASS","USER"); // password

// DB connection
$dbh = ibase_connect(DBNAME,DBUSER,DBPASS);
echo ibase_errmsg();
if ($dbh == FALSE) {
echo 'could not connect to DB<BR>';
} else {
echo 'success to connect to DB<BR>';
}
$ibsql = "SHOW TABLE DOC_TO";
echo ibase_errmsg();
$result=ibase_query($ibsql);
echo $result;
?>

</BODY>
</HTML>

but why it just show the result as "success to connect to DB"?

  • 写回答

2条回答 默认 最新

  • douhu3424 2010-11-19 04:53
    关注

    Firebird does not seem to have a SHOW TABLE or SHOW TABLES command which are specific to MySQL.

    The documentation on the IBphoenix web site states that the SHOW TABLES command is only available in the isql command line tool and nowhere else.

    In MySQL, you can do SHOW TABLES. You can use the same in Firebird's isql command-line tool, but nowhere else.

    It goes on and provides the following SQL code as a roughly equivalent solution:

    SELECT RDB$RELATION_NAME FROM RDB$RELATIONS;

    This query will show you both system and user tables. To select user tables only, use this:

    `SELECT RDB$RELATION_NAME FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG = 0;

    Maybe you can get something equivalent from what you were trying to accomplish by querying the RDB$RELATIONS table (or maybe some other runtime information tables provided by Firebird). See also Lorenzo Alberton's post on extracting META information from a Firebird database.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 VMBox虚拟机无法访问
  • ¥15 skd显示找不到头文件
  • ¥15 机器视觉中图片中长度与真实长度的关系
  • ¥15 fastreport table 怎么只让每页的最下面和最顶部有横线
  • ¥15 R语言卸载之后无法重装,显示电脑存在下载某些较大二进制文件行为,怎么办
  • ¥15 java 的protected权限 ,问题在注释里
  • ¥15 这个是哪里有问题啊?
  • ¥15 关于#vue.js#的问题:修改用户信息功能图片无法回显,数据库中只存了一张图片(相关搜索:字符串)
  • ¥15 texstudio的问题,
  • ¥15 spaceclaim模型变灰色