Form Problems

axman505

I am trying to make a form that will allow a user to add a table to a mysql database. The first form looks like this:

<?php

if ( $_SERVER['REQUEST_METHOD'] == "POST") {

    $tablename=$_POST['tablename'];
    $fields=$_POST['rows'];

    if ( $fields > "20" ) {
            die();
    }

    print "<table border='1'>";
    print "<tr bgcolor='#3300FF'><th>Field</th><th>Type</th><th>Length</th><th>Null</th>";
    print "<th>Default</th><th>Primary</th><th>Unique</th></tr>";
    $i="1";
    print "<html><body>";
    print "<form method='post' action='addtable1.php'>";
    for ($r=0; $r<$fields; $r++) {
            print <<<HEREDOC

<tr>
<td><input type=text name='field$i' size='15'></td>
<td><select name='type$i'>
<option value="VARCHAR">VARCHAR</option>
<option value="TEXT">TEXT</option>
<option value="DATE">DATE</option>
<option value="INT">INT</option>
<option value="FLOAT">FLOAT</option>
<option value="DOUBLE">DOUBLE</option>
<option value="TIME">TIME</option>
<option value="YEAR">YEAR</option>
<option value="CHAR">CHAR</option>
</select></td>
<td><input type=text name='length$i' size='5'></td>
<td><select name='null$i'>
<option value="NOT NULL">NOT NULL</option>
<option value="NULL">NULL</option>
</select></td>
<td><input type=text name='default$i' size='5'></td>
<td align='center'><input type=radio name='primary' value='yes'></td>
<td align='center'><input type=radio name='unique$i' value=$i></td>
</tr>
HEREDOC;
$i++;
}
print "<input type=hidden name=fields value='$fields'>";
print "<tr><td colspan=7 align=center><input type=submit value='Create Table'>  ";
print "<input type=reset value='Reset Table'></td></tr></form>";

} else {
?>

<html>
<body>
<form action="<?php $_SERVER['PHP_SELF'] ?>" method='post'>
<table>
<tr><td>Table Name:</td><td><input type='text' name='tablename'></td></tr>
<tr><td># of Rows:</td><td><input type='text' name='rows'></td></tr>
<tr><td colspan='2'><input type='submit' value='submit'></td></tr>
</form>
<?php
}
?>

How do i receive these valiues in the second form? Since i do not know how many values i willbe receiving, it will need to be in some kind of a loop. I am stumped. Any suggetions would be greatly appreciated. thanks!

dalecosp

How 'bout using arrays? Ditch the '$i', declare $unique and $default and $length and all those...

$unique=array();

Change the keys in your script fom $i to $r, with brackets....

<td><input type=text name='field[$r]' size='15'></td>

Then, pass them using the 'hidden' field, like you are doing with $fields....

print "<input type=hidden name=unique value='$unique'>";

HTH,

axman505

but then when these are passed tot he next sceipt, im gonna have stuff like name[1]="test", name [2]="something"

how do i write a loop to capture a unset number from the pervous form?

nemonoman

if you use the following method in your form:
<input type=text value='inputONE' name='myarray[]'>
<input type=text value='inputTWO' name='myarray[]'>

etc.

You would $_POST an array that PHP would reference as $myarray

You could then get

$arraysize=count($myarray);

and set up a for or while loop --

or do a foreach loop

foreach($myarray as $key=>$value) {//do something here}

The values of $myarray[0], $myarray[1]...etc will the values as entered in the form in the order they were stated. In the case I showed above, $myarray[0] would be 'inputONE', $myarray[1] would be 'inputTWO'

If you have a field that wants to be included, say in a SQL statement, but not made available for editing you can pass it as a hidden value
<input type=hidden value='InputTHREE' name='myarray[]'>.

Hope this clarifies what dalescop was telling you.