Forum webmasterów

Kod: Zaznacz cały

<?

$db_name = "testDB";

$connection = @mysql_connect("localhost", "root", "krasnal") 
	or die("Couldn't connect.");

$db = mysql_select_db($db_name, $connection)
	or die("Couldn't select database.");
	
	
// build the query

$sql = "CREATE TABLE $table_name (";

for ($i = 0; $i < count($field_name); $i++) {
	
	$sql .= "$field_name[$i] $field_type[$i]";

	if ($auto_increment[$i] == "Y") {
		$additional = "NOT NULL auto_increment";
	} else {
		$additional = "";
	}

	if ($primary[$i] == "Y") {
		$additional .= ", primary key ($field_name[$i])";
	} else {
		$additional .= "";
	}
	
		
	if ($field_length[$i] != "") {
		$sql .= " ($field_length[$i]) $additional ,";
	} else {
		$sql .= " $additional ,";
	} 

}

$sql = substr($sql, 0, -1);

$sql .= ")";


// execute the query

$result = mysql_query($sql,$connection)
	or die("Couldn't execute query");

if ($result) {     
	$msg =  "<P>$table_name has been created!</p>";
}
 
  
?>

<HTML>
<HEAD>
<TITLE>Create a Database Table: Step 3</TITLE>
</HEAD>
<BODY>

<h1>Adding table to <? echo "$db_name"; ?>...</h1>

<? echo "$msg"; ?>


</BODY>
</HTML>