#hostingforum.kr
php

odbc_foreignkeys ( resource $odbc_link, string $table_name, string $pk_name, string $fk_name )

#hostingforum.kr
php

// ODBC 연결 설정

$dsn = 'mysql:host=localhost;dbname=mydb';

$username = 'myuser';

$password = 'mypassword';



$odbc_link = odbc_connect($dsn, $username, $password);



// 외래 키를 반환하는 함수

function get_foreign_keys($odbc_link, $table_name, $pk_name, $fk_name) {

    $result = odbc_foreignkeys($odbc_link, $table_name, $pk_name, $fk_name);

    return $result;

}



// 외래 키를 반환

$table_name = 'orders';

$pk_name = 'id';

$fk_name = 'customer_id';



$foreign_keys = get_foreign_keys($odbc_link, $table_name, $pk_name, $fk_name);



// 결과를 출력

if ($foreign_keys) {

    while ($row = odbc_fetch_array($foreign_keys)) {

        echo "Foreign Key: $row[fk_name], Primary Key: $row[pk_name]
";

    }

} else {

    echo "Foreign Key not found.
";

}



// ODBC 연결 닫기

odbc_close($odbc_link);