Не получается, выдает ошибку Table 'diplom.tables' doesn't exist. Как я понял - путаются подключения. Почему так?
Вот весь код
| Код |
<?php
define('DB_NAME','diplom');
$link = mysql_connect("localhost", "root", "") or die (mysql_error());
mysql_select_db("information_schema",$link) or die (mysql_error());
$link2 = mysql_connect("localhost", "root", "") or die (mysql_error());
mysql_select_db("diplom",$link2) or die (mysql_error());
mysql_query("set character_set_client ='cp1251'");
mysql_query("set character_set_results ='cp1251'");
mysql_query("set collation_connection ='cp1251_general_ci'");
$sql = mysql_query("SELECT * FROM TABLES WHERE TABLE_SCHEMA='".DB_NAME."';",$link) or die(mysql_error());
while($tables = mysql_fetch_assoc($sql)){
dump($tables);
?><table border="1">
<tr>
<th><?PHP echo $tables['TABLE_NAME'] ?></th>
<td><?PHP echo "Записей:".$tables['TABLE_ROWS'] ?></td>
<td><?PHP echo "След:".$tables['AUTO_INCREMENT'] ?></td>
</tr>
<tr><?PHP
$sql2 = mysql_query("SHOW COLUMNS FROM ".$tables['TABLE_NAME'],$link2) or die(mysql_error());
while($columns = mysql_fetch_assoc($sql2)){
?><th><?PHP echo $columns['Field'] ?></th><?PHP
}
?></tr>
</table><?PHP
}
mysql_close($link);
?>
|
|
)