<?php
mysql_connect
('localhost:3306',
$user,
$password)
or die
("Nelze se připojit: " . mysql_error
());
mysql_select_db
("databaze");
$result = mysql_query
("select * from tabulka")
or die
("Chyba dotazu: " . mysql_error
());
# vrátí informace o sloupci
$i = 0;
while ($i < mysql_num_fields
($result)) {
echo "Informace pro sloupec $i:<br />\n";
$meta =
mysql_fetch_field($result);
if (!
$meta) {
echo "Nejsou dostupné žádné informace<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);
?>