note 103073 deleted from function.mysql-field-name by danbrown
| From: | danbrown@php.net | Date: | Thu, 24 Mar 2011 13:55:04 +0000 |
| Subject: | note 103073 deleted from function.mysql-field-name by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-178157@lists.php.net to get a copy of this message | ||
Note Submitter: ever4vr at gmail dot com
----
Get an array of fields and values from all tables in a database with their tables and foreign fields
<?php
$database = 'vipstour';
$connect = mysql_connect('localhost','everoot','everoot');
mysql_selectdb( $database, $connect );
$j=0;
$db_tables = mysql_list_tables( $database );
while( $tables = mysql_fetch_row( $db_tables ) )
{
$table = $tables[0];
$fields = mysql_query("SELECT
ke.referenced_table_name child,
ke.referenced_column_name field_child,
ke.table_name parent,
ke.column_name field_parent,
ke.constraint_name
FROM
information_schema.KEY_COLUMN_USAGE ke
WHERE
ke.referenced_table_name IS NOT NULL
AND ke.TABLE_SCHEMA = '".$database."'
AND ke.table_name = '".$table."'
ORDER BY
ke.referenced_table_name", $connect);
$values = mysql_fetch_row($fields);
echo "<pre>";
echo "CONSTRAINTS FOREING TO:
<b>".$table."</b><br><br>";
echo mysql_field_name($fields, 0).":";
echo $values[0]."\n";
echo mysql_field_name($fields, 1).":";
echo $values[1]."\n";
echo mysql_field_name($fields, 2).":";
echo $values[2]."\n";
echo mysql_field_name($fields, 3).":";
echo $values[3]."\n";
echo mysql_field_name($fields, 4).":";
echo $values[4]."\n";
echo "</pre>";
?>