如何用php获取数据库信息并显示

获取ppq数据库的所有表名的代码：

?php

$server='localhost'

$user='root'

$pass='12345'

$dbname='ppq'

$conn=mysql_connect($server,$user,$pass)

if(!$conn)

die("数据库系统连接失败！")

$result=mysql_list_tables($dbname)

if(!$result)

die("数据库连接失败！")

while($row=mysql_fetch_row($result))

{

echo

$row[0]."

"

}

mysql_free_result($result)

?

mysql_list_tables

(PHP

3,

PHP

4

,

PHP

5)

mysql_list_tables

--

列出

MySQL

数据库中的表

说明

resource

mysql_list_tables

(

string

database

[,

resource

link_identifier])

mysql_list_tables()

接受一个数据库名并返回和

mysql_query()

函数很相似的一个结果指针。用

mysql_fetch_array()或者用mysql_fetch_row()来获得一个数组，数组的第0列就是数组名，当获取不到时

mysql_fetch_array()或者用mysql_fetch_row()返回

FALSE。

抄来的 不求最佳 只是希望对你有帮助

require_once("././././config.php")

require_once(SYSTEM."db.php") //导入db类

$db = new DB(DB_DRIVER, DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE)//实例化db

$sql= "SELECT * FROM setting "

$query = $db->query($sql)

$rows = $query->rows

$appid = '5'

$mchid = '1'

$key= 'a'

$appsecret = 'c'

$sslcert_path = 'apiclient_cert.pem'

$sslkey_path= 'apiclient_key.pem'

$curl_proxy_host= '0.0.0.0'

$curl_proxy_port= 0

$report_levenl = 1

$config = "

class WxPayConfig

{

const APPID = '$appid'

const MCHID = '$mchid'

const KEY = '$key'

const APPSECRET = '$appsecret'

const SSLCERT_PATH = '$sslcert_path'

const SSLKEY_PATH = '$sslkey_path'

const CURL_PROXY_HOST = '$curl_proxy_host'//'10.152.18.220'

const CURL_PROXY_PORT = $curl_proxy_port//8080

const REPORT_LEVENL = $report_levenl

}

"

eval($config)

unset($config, $appid, $mchid, $key, $appsecret, $sslcert_path, $sslkey_path, $curl_proxy_host, $curl_proxy_port, $report_levenl)

//echo WxPayConfig::APPIDexit

//不清楚可以问联系我：web$ebaitian.cn(将$换为@)

$con = mysql_connect("localhost","root","")//连接数据库

mysql_select_db("btxiazai",$con)//选择数据库

mysql_query("set names utf8")

$sql = "select * from persons order by id desc limit 2"//获取persons中的数据，并按id倒叙排列，取其中两条

$get = mysql_query($sql)//执行sql

while($result = mysql_fetch_assoc($get)){//取回数据

}

---