Problem with inserting into DB a disabled field

argrafic

Hello to all,

I have a form that has a textfield that will enable/disable depending on an option of a menu/list.

The problem I have is that when the textfield is disabled it "disappears" from the form and then when I try to insert it to MySQL I get the error "Undefined index:" of the form field of the disabled textfield.

How can I POST even if it's disabled?

Thanks!

rulian

the best approach is to build your sql so that it asks if the post value for that text field has been submitted or not

something like:

$SQL="INSERT INTO `mytable`(`id`,`value1`,`value2`) VALUES (NULL, ";
$SQL .="'".$_POST["alwayspresenttext"]."'";  

if (isset($_POST["mytext"])) $SQL .="'".$_POST["mytext"]."'"; 
else $SQL .= 'NULL'; 
$SQL.=")"; 
mysql_query($SQL);

of course that is just an example, you should never enter any unfiltered user data into your tables. so your query should actually look something like so:


function InsertMYStuff($V1,$V2)
{
$SQL="INSERT INTO `mytable` (`id`,`value1`,`value2`) VALUES (NULL,'%s','%s')"; 

mysql_query(springf($SQL,mysql_real_ecape_string($V1),mysql_real_ecape_string($V2))); 
}

if (isset($_POST["myOptionalText"])) InsertMyStuff($_POST["myConstantText"], $_POST["myOptionalText"]); 
else InsertMyStuff($_POST["myConstantText"], "NULL");

or something of the sorts

NogDog

Per the HTML specification, disabled form fields are not transmitted as part of the form data. If you want a field to be non-modifiable but still have its value transmitted with the other form fields, then maket it "readonly" instead of "disabled".

argrafic

thanks for the help guys.

i tried various ways and couldn't get it.

so i really cracked my head and came up with a rather easy solution.

a hidden field that would recieve the value of the enabled/disables field with an "onChange" event.

then, i would have the field available for the database.

again, thanks!

bogu

argrafic wrote:
a hidden field that would recieve the value of the enabled/disables field with an "onChange" event.

then, i would have the field available for the database.

What is happening if I stop javascript into my browser?