<?PHP
function getLinkSql(){
$link = mysql_connect('localhost','root','');
mysql_select_db('fotoblog',$link);
mysql_query("SET NAMES 'UTF-8';");
return $link;
}
function getSqlServer($host='localhost',$root='root'){
return mysql_connect($host,$root,'');
}
function getNewDataBase($dataBaseName,$sqlServer){
$sql = 'CREATE DATABASE IF NOT EXISTS `' .$dataBaseName. '`';
if (mysql_query($sql)){
mysql_select_db($dataBaseName,$sqlServer);
return true;
}else{
return false;
}
}
function createTable($tableName, $dataBaseName, $sqlServer){
$sql = 'CREATE TABLE IF NOT EXISTS `' .$tableName. '` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`ID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;';
//mysql_select_db($dataBaseName, $sqlServer);
return mysql_query($sql);
}
$sqlServer = getSqlServer();
echo getNewDataBase('forums',$sqlServer);
echo createTable('test28','forums',$sqlServer);
?>
Комментариев нет:
Отправить комментарий