?php
mysql_connect(
'localhost:3306'
,
$user
,
$password
)
or
die
("Could
not
connect")
;
mysql_select_db("database")
;
$result
=
mysql_query("select
*
from
table"
)
or
die("Query
failed")
;
/
*
get
column
metadata
*
/
$i
=
0
;
while
($i
mysql_num_fields($result)
)
{
echo
"Information
for
column
$i
:
br
/
\n"
;
$meta
=
mysql_fetch_field($result)
;
if
(!$meta
)
{
echo
"No
information
available
br
/
\n"
;
}
echo
"
pre
blob
:
$meta
-
blob
max_length
:
$meta
-
max_length
multiple_key
:
$meta
-
multiple_key
name
:
$meta
-
name
not_null
:
$meta
-
not_null
numeric
:
$meta
-
numeric
primary_key
:
$meta
-
primary_key
table
:
$meta
-
table
type
:
$meta
-
type
unique_key
:
$meta
-
unique_key
unsigned
:
$meta
-
unsigned
zerofill
:
$meta
-
zerofill
/
pre
"
;
$i++
;
}
mysql_free_result($result)
;
?
|