http://wbex.ru/index.php?action=history&feed=atom&title=PHP%2FMySQL_Database%2FDatabase_MetaData
PHP/MySQL Database/Database MetaData - История изменений
2026-04-04T22:14:58Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://wbex.ru/index.php?title=PHP/MySQL_Database/Database_MetaData&diff=1104&oldid=prev
в 10:37, 26 мая 2010
2010-05-26T10:37:34Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 10:37, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://wbex.ru/index.php?title=PHP/MySQL_Database/Database_MetaData&diff=1105&oldid=prev
Admin: 1 версия
2010-05-26T07:06:21Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Get MySQL client information==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="html4strict"><br />
<br />
<?php<br />
mysql_connect("mysql153.secureserver.net","wbex","password");<br />
echo mysql_get_client_info();<br />
?><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Get MySQL host information==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="html4strict"><br />
<br />
<?php<br />
mysql_connect("mysql153.secureserver.net","wbex","password");<br />
echo mysql_get_host_info();<br />
?><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Get MySQL server information==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="html4strict"><br />
<br />
<?php<br />
mysql_connect("mysql153.secureserver.net","wbex","password");<br />
echo mysql_get_server_info();<br />
?><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==List all database==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="html4strict"><br />
<br />
<?php<br />
mysql_connect("mysql153.secureserver.net","wbex","password");<br />
$dbs = mysql_list_dbs();<br />
echo "Databases: <br />";<br />
while (list($db) = mysql_fetch_row($dbs)) {<br />
echo "$db <br />";<br />
}<br />
?><br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==List all tables in a database==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="html4strict"><br />
<?php<br />
mysql_connect("mysql153.secureserver.net","wbex","password");<br />
$tables = mysql_list_tables("wbex");<br />
while (list($table) = mysql_fetch_row($tables)) {<br />
echo "$table <br />";<br />
}<br />
?><br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Print all MySQL status value==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="html4strict"><br />
<?php<br />
mysql_connect("mysql153.secureserver.net","wbex","password");<br />
$status = explode(" ", mysql_stat());<br />
foreach($status as $value) echo $value."<br />";<br />
?><br />
<br />
<br />
</source></div>
Admin