Mulitiple TextArea Validation

Anon

function testform() {
for (i=0; i <=1; i++) {
if (document.myform.control.value) == NULL {
alert(Please enter a control name)
}
}

</SCRIPT>

<FORM NAME="myform">
<TEXTAREA NAME="control" COLS=40 ROWS=5>
</textarea>
<TEXTAREA NAME="control" COLS=40 ROWS=5>
</textarea>
<input type="button" value="click" onclick="testform()">

The code above works OK if I use the same name for the textarea, but how can I retrieve all the values and store in a database?

<TEXTAREA NAME="control<%=cnt%>" COLS=40 ROWS=5>
</textarea>
If I use this line above I can validate it but then I can not use the javasript code to check for nulls...

I need to be able to update a database and check for nulls? Please help

Anon

Use your first method

function testform() {
for (i=0; i <=1; i++) {
if (document.myform.control.value) == NULL {
alert(Please enter a control name)
}
}

</SCRIPT>

<FORM NAME="myform">
<TEXTAREA NAME="control" COLS=40 ROWS=5>
</textarea>
<TEXTAREA NAME="control" COLS=40 ROWS=5>
</textarea>
<input type="button" value="click" onclick="testform()">

On your next page use PHP to input it to the database
where
$control[0] is your first form value
and
$control[1] is your second form value

then u can just do
$sql = UPDATE TABLE_X set FIELD_1 = $control[0], FIELD_2 = $control[1]

Where TABLE_X is your table name and FIELD_1,2 are the fields of your textarea column names in the SQL database

Anon

I am not familar with PHP...
Question:
(1)
does the database have to be open using php for me to do an UPDATE via php?
(2)
I working on a Windows platform (SSL) not a unix platform..will this still work?

Anon

PHP will work on windows platforms if that is what you mean. What I am talking about doesnt depend on the platform.

What database are u using(mysql, postgres sql...etc)? The database has to be open for you to do anything to it (select, insert, update, delete)

In PHP you have to open the database before you update it.

For instance if you are using a mysql database
mysql_connect("host", "login", "password"); opens the mysql connection, then you can select a database using
mysql_select("database");
check out the manual on www.php.net for more information about connection to various databases.

If you declare multiple form variables the same name, PHP will treat those variables as an array when they are passed
So in your case $control[0] and $control[1] are your 2 textarea values since they both have the same name. $control[0] is your first textarea, $control[1] is your second text area.

Make your form submit to a test page with the following statement:

<?php
echo "The first textarea is: " . $control[0] . "<br>";
echo "The second textarea is: " . $control[1] . "<br>";
?>

The statement above will echo the values so you can see what I'm talking about