Retrieving the posted values from a form in PHP

[dream2rule]

[PHP]

<form action='' method='post' name='create_table_form' id='create_table_form' >
<table border='0' cellpadding='0' cellspacing='0' width='95%'><tr><td><br />
<table border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr><td>&nbsp;Database Name:</td>
<td><input type='text' name='db_name' size='20' value=<?php echo $db_name; ?>></td></tr>
<tr><td><br>&nbsp;Table Name:</td>
<td><br><input type='text' name='table_name' size='20' value=<?php echo $table_name; ?>>
</td></tr>
<?php
for($i=0; $i < $num_fields; $i++)
{
?>
<tr><font face='verdana' size='1'>
<td><br>&nbsp;Field: <input type='text' name='fld_name[$i]' size='10'>
<?php
$types = array("varchar","tinyint","text","smallint","mediu mint","int","bigint","float","double","decimal",
"char","tinyblob","tinytext","blob","mediumblob"," mediumtext","longblob","longtext","binary","varbin ary");
?>
<td><br>&nbsp;Type: <select name='fld_type[$i]'>
<?php
for($j=0; $j < count($types); $j++)
{
?>
<option value=<?php echo $types[$j]; ?>><?php echo $types[$j]; ?></option>
<?php } ?>
</select></td>
<td><br>&nbsp;Size: <input type='text' name='fld_size[$i]' size='5'></td>
<td><br>&nbsp;Null: <select name='fld_null[$i]'>
<option value='not null'>Not Null</option>
<option value='null'>Null</option>
</select></td>
<td><br><input type='checkbox' name='fld_extra' value='auto_increment' size='10'> Auto-increment</td>
<td><br><input type='radio' name='fld_keys' value='primary key' size='10'> Primary</td>
<td><br><input type='radio' name='fld_keys' value='unique key' size='10'> Unique</td>
</font></tr>
<?php } ?>
<tr><td><br>&nbsp;<input type='submit' name='create_table_submit' value='Create Table'></td>
<td><input type="hidden" name="num_flds" value="<?php echo $num_fields;?>" /></td>
</tr>
</table>
</td></tr></table>
</form>
[/PHP]

How do i retrieve $fld_name[$i] etc fields from the above form?

Any help would be appreciated. Thanks!

[nathj]

Hi,

Try something like:
[php]

$_POST[$fld_name][$i]
[/php]

As $_POST is just an array, if you load an array into it you can access using the syntax above, I think. give it a try and see where you get to.

Cheers
nathj

Ps merging HTML and PHP as you do makes it really hard to read. I'd do it all in PHP with loats of echo or print().

[dream2rule]

When i retrieve it something like

$fld_name = $_POST['fld_name'][$i]

i get the characters of the last fld_name!!

This is not taking me anywhere.

I would just like to show what i have got after retrieving the posted values.

[PHP]

if(isset($_POST['create_table_submit']))
{

$table_fields = "";
for($i=0; $i < $num_flds; $i++)
{
$fld_name = $_POST['fld_name'];
$fld_type = $_POST['fld_type'];
$fld_size = $_POST['fld_size'];
$fld_null = $_POST['fld_null'];
$fld_extra = $_POST['fld_extra'];
$fld_keys = $_POST['fld_keys'];
/*$tmp = $fld_name[$i]."&nbsp;".$fld_type[$i]."(".$fld_size[$i].")"."&nbsp;".$fld_null[$i]."&nbsp;".
$fld_extra."&nbsp;".$fld_keys;
echo $tmp."<br>";*/
$fld_data = $fld_name."&nbsp;".$fld_type."("."$fld_size".")"." &nbsp;".$fld_null."&nbsp;".$fld_extra."&nbsp;".$fl d_keys;
$table_fields = $table_fields .$fld_data .", ";
}
echo $table_fields;
}

[/PHP]

I am only getting one single row as a result while my aim to retrieve all the data entered in the form.

Any Help?

[nathj]

Hi,

After you have defined $fld_name try print_r($fld_name); . This will print everything to the screen as I think $fld_name is an array and this function will display the contents of the array.

From there you will be able to see the best way to manipulate it - either for() or foreach()

Cheers
nathj

[dream2rule]

Hi,

After you have defined $fld_name try print_r($fld_name); . This will print everything to the screen as I think $fld_name is an array and this function will display the contents of the array.

From there you will be able to see the best way to manipulate it - either for() or foreach()

Cheers
nathj

if i give "dream2rule" in the $fld_name, then after post and printing it, i get just "dr"

I need to get complete "dream2rule" :( :(

[nathj]

Ok, I've had a closer look at the code. There won't be a $_POST['fld_name'] element. There will be a $POST['fld_name1'] element.

The form has a number of text boxes that are called fld_namex. When you read this data out of te $_POST array you need to read it out using the proper input name:

[php]
<?php

for($i=0; $i<=$numfields; $i++)
{
$lcKey = 'fld_name' . $i ;
echo $_POST[$lcKey] ;
}
?>
[/php]

This should print all the fld_name input boxes that have been submitted. This code is a bit slack and would need tightening up for production purposes, but essentially I think it should work

[dream2rule]

tried the same but it is not printing the fld_name at all..
nothing is getting displayed :( :(