<?php
/*
 *
 * MySQLデータベース関連
 *
 */
function getFIELDname($tablename) {
	$sql = "SHOW FIELDS FROM `$tablename`";
	$rs = mysql_query($sql);
	!$rs && die("DB Error, could not list tables MySQL Error: " . mysql_error());
	$Fields = array();
	while ($row = mysql_fetch_row($rs)) {
		${Fields}[] = $row[0];
	}
	mysql_free_result($rs);
	return($Fields);
}
function getTABLEname($dbname) {
	$sql = "SHOW TABLES FROM $dbname";
	$rs = mysql_query($sql);
	$Tables = array();
	if (!$rs) {
    	die("DB Error, could not list tables MySQL Error: " . mysql_error());
	}
	while ($row = mysql_fetch_row($rs)) {
		${Tables}[] = $row[0];
	}
	mysql_free_result($rs);
	return($Tables);
}
function createDB($host, $uid, $upw, $dbname) {
	$link = mysql_connect($host, $uid, $upw);
	if (!$link) {
    	return("MySQLデータベースサーバに接続できません。" . mysql_error());
	} else {
		$sql = "CREATE DATABASE $dbname";
		if (mysql_query($sql, $link)) {
			return('');
		} else {
    		return("データベースの作成に失敗しました: " . mysql_error());
		}
	}
}
function getDBname($host, $uid, $upw) {
	$dbh = mysql_connect($host, $uid, $upw);
	$db_list = mysql_list_dbs($dbh);
	$dblist = array();
	while ($row = mysql_fetch_object($db_list)) {
		${'dblist'}[] = $row->Database;
	}
	mysql_close($dbh);
	return($dblist);
}
?>