<?php
include './modules/func.php';
func_mysqlconnect();

$sql = 'CREATE TABLE `news` ( 
`subject` VARCHAR( 255 ) NOT NULL, 
`text` TEXT NOT NULL, 
`id` VARCHAR( 255 ) NOT NULL, 
`date` VARCHAR( 255 ) NOT NULL, 
PRIMARY KEY ( `id` )
)'; 
mysql_query( $sql, $connection ) or die (mysql_error()); 
echo "Таблица отвечающая за новости создана!<br>"; 


$sql = 'CREATE TABLE `comments` ( 
`comment` TEXT NOT NULL, 
`newsid` VARCHAR( 255 ) NOT NULL, 
`commentid` VARCHAR( 255 ) NOT NULL, 
`commentname` VARCHAR( 255 ) NOT NULL, 
`commentemail` VARCHAR( 255 ) NOT NULL, 
`commentwebsite` VARCHAR( 255 ) NOT NULL,  
`commentposttime` VARCHAR( 255 ) NOT NULL, 
`commentip` VARCHAR( 255 ) NOT NULL, 
PRIMARY KEY ( `commentposttime` )
)'; 
mysql_query( $sql, $connection ) or die (mysql_error()); 
echo "Таблица отвечающая за комментарии создана!"; 
?>

<?php
echo '
		<center>
		<form action="" method="POST">
		<p>Сервер MySQL</p>
		<input type="text" name="host">
		<p>Пользователь MySQL</p>
		<input type="text" name="username">
		<p>Пароль MySQL</p>
		<input type="text" name="pass">
		<p>Имя базы данных MySQL</p>
		<input type="text" name="dbname"><br>
		<input name="sum" type="submit" />
		</form>
		</center>
	';

	$sqlhost = $_POST['host'];
	$sqlusername = $_POST['username'];
	$sqlpassword = $_POST['pass'];
	$dbname = $_POST['dbname'];
if(isset($_POST['sum']))
	{
		$connection = mysql_connect($sqlhost,$sqlusername,$sqlpassword) or die (mysql_error());
		$db = mysql_select_db($dbname) or die (mysql_error());

		$sql = 'CREATE TABLE `news` ( 
		`subject` VARCHAR( 255 ) NOT NULL, 
		`text` TEXT NOT NULL, 
		`id` int(10) unsigned NOT NULL, 
		`date` TEXT NOT NULL, 
		PRIMARY KEY ( `id` )
		)'; 
		mysql_query( $sql, $connection ) or die (mysql_error()); 
		echo "Таблица отвечающая за новости создана!<br>"; 


		$sql = 'CREATE TABLE `comments` ( 
		`comment` TEXT NOT NULL, 
		`newsid` int(10) unsigned NOT NULL, 
		`commentid` VARCHAR( 255 ) NOT NULL, 
		`commentname` VARCHAR( 255 ) NOT NULL, 
		`commentemail` VARCHAR( 255 ) NOT NULL, 
		`commentwebsite` VARCHAR( 255 ) NOT NULL,  
		`commentposttime` VARCHAR( 255 ) NOT NULL, 
		`commentip` VARCHAR( 255 ) NOT NULL, 
		PRIMARY KEY ( `commentposttime` )
		)'; 
		mysql_query( $sql, $connection ) or die (mysql_error()); 
		echo "Таблица отвечающая за комментарии создана!"; 
	}	
?>