Untitled

<!-- In step 1, you created variables to hold the name of the table ($_POST[table_name]) and the number of fields in that table ($_POST[num_fields]). In this step, you'll create a php script to display additional form elements needed for further definition of the fields: name, type, and length. -->

<?php

// Check that values were actully entered for $_POST[table_name] and $_POST[num_fields]. If they weren't, direct them back to the form and exit the script.
if ((!$_POST['table_name']) || (!$_POST['num_fields'])) {
header ("Location: show_createtable.html");
exit;
}

/* Start building a string called $form_block, starting with the form action and method. Assume that the method is POST and the action is a scriped called do_createtable.php. Remember to escape your quotation marks! Add a hidden field to hold the value of $_POST[table_name], which you'll use at the end of the sequence just to show the user that the proper table has been created. Display your form in an HTML table so that the fields line up nicely. Start with a row of column headings and close the $form_block string for now. */
$form_block = "
<form method=\"POST\" action=\"do_createtable.php\">
<input type=\"hidden\" name=\"table_name\" value=\"$_POST[table_name]\">
<table cellspacing=5 cellpadding=5>
<tr>
<th>Field Name</th><th>Field Type</th><th>Field Length</th>
</tr>";

/* Start a for loop to handle the creation of the form fields. Like a while loop, a for loop continues as long as a condition is true. in this case, the for loop starts out with the variable $i having a value of 0, and it continues for as long as $i is less than the value of $_POST[num_fields]. After each loop, $i is incremented by 1. Within the for loop you'll add to the original $form_block. You'll add one row for each field you want to have in your database table. Start with the table row tag abd a table data cell containing an input type for trhe field name. The use of the brackets (the []) after field_name in your input field indicates an arry. for each field you defione in this form, you'll be adding a value to the $_POST[field_name] array. In the next table data cell, create a drop down list containing some common field types. In the final table data cell, create a text field for the length of the field and close your table row. Also close the $form_block string because your done with it for now. */
for ($i = 0; $i < $_POST['num_fields']; $i++) {

$form_block .= "
<tr>
<td align=center><input type=\"text\" name=\"field_name[]\"
<size=\"30\"></td>

<td align=center>
<select name=\"field_type[]\">
<option value=\"char\">char</option>
<option value=\"date\">date</option>
<option value=\"float\">float</option>
<option value=\"int\">int</option>
<option value=\"text\">text</option>
<option value=\"varchar\">varchar</option>
</select>
</td>

<td align=center><input type=\"text\" name=\"field_length[]\"
size=\"5\"></td>
</tr>";

// Close the for loop.
}

// Add the final chucnk of HTML to the form_block string. You'll add one row that holds the submit button and then close your table and form.
$form_block .= "
<tr>
<td align=center colspan=3><input type=\"submit\" value\"Create Table\"></td>
</tr>
</table>
</form>";

?>

<html>
<head>
<title>Create a Database Table: Step 2</title>
</head>
<body>

<h1>Define fields for <?php echo "$_POST[table_name]"; ?></h1>

<!-- Display contents of $form_block. -->
<?php echo "$form_block"; ?>

</body>
</html>