problem with form ...

[nomad9]

Hi all,

i've got 2 question :

1. My form contain a lot of field and i want that each time a form is not filled correctly /or the user want to go to the preview page, the form still got the information that the user filled before ... i know that i can do it with session variable but it's mean a lot of variable .... is session variable is the best way ... or the only way ???

2. Inside my form, i've got a section that contain 15 textfield. With this textfield, i've got to make a dropdown list ... so each textfield filled will be an option in html :

<select name="analyseOne">
<option value="1">textfield1</option>
<option value="2">textfield2</option>
<option value="3">textfield3</option>
...
</select>

but the problem is that i don't know how much textfield the user will filled (the user can filled textfield as much as he want).

So How can i detect how much textfield the user have filled.

Thanx alot,

Steve

[cgraz]

1. My form contain a lot of field and i want that each time a form is not filled correctly /or the user want to go to the preview page, the form still got the information that the user filled before ... i know that i can do it with session variable but it's mean a lot of variable .... is session variable is the best way ... or the only way ???

If you're using two seperate files, just make a link using javascript. when they click the link, what they selected or typed in will still be here

<a href="javascript:history.back()">Try again</a>

(note the forum puts a space between java and script. should be one word: javascript

2. Inside my form, i've got a section that contain 15 textfield. With this textfield, i've got to make a dropdown list ... so each textfield filled will be an option in html

So you mean you have 15 text fields (input type = text). If they have values, you need to create a drop down out of that?

Cgraz

[nomad9]

Thanx for the reply ...

For the dropdown list, i mean that whatever the number of textfield filled (textfield ==> input = text) ... my script have to detect how many field have been fill and then create the script for the dropdown list .... here's an example :

textfield1 = Canada
textfield2 = Japan
textfield3 = Australia
textfield4 = "" // empty

so i want my script detect that 3 textfield have been filled and then create the html script :

dropdownlist = <select name="analyseOne">
<option value="textfield1">textfield1</option>
<option value="textfield2">textfield2</option>
<option value="textfield3">textfield3</option>
</select>

hope that it will help you to help me .... thanx alot,

Steve

[cgraz]

Make your text inputs look like this.[code[<input type="text" name="textfield[]">
<input type="text" name="textfield[]">
<input type="text" name="textfield[]">
<input type="text" name="textfield[]">[/code]That will put them into an array. To create a dropdown out of the ones with values, use a loop

echo "<select name='analyseOne'>\n";

foreach ($textfield as $value) {
   echo "<option value='" . $value . "'>" . $value . "</option>\n";
}

Cgraz

[nomad9]

hey cgraz .... look at this please :

$number = 0

foreach ($storeList as $value) {
$listStore[$number] = "<option value='".$value."'>".$value."</option>";
$number = $number + 1
}

i want to create a variable for each $storeList filled ... but it doesn't work .... can u help me ???

Steve

[nomad9]

ok ... now my problem is when i Insert value inside my MySql db, it also create row for the empty field

// Creating Var
$number = 0;

// Input Info Into DB
foreach ($storeList as $value) {
$sql = "INSERT INTO f01200 (formID,formType,formName,formQuestion,formValue) VALUES('','aInfo','storeList[".$number."]','','".$value."')";
$result = mysql_query($sql,$db) or die("Erreur dans la Création du Formulaire");
$number++;
}

... foreach ($storeList as $value) // is there a way to avoid to insert the empty field inside my db ?????

[cgraz]

I don't understand your question or what you're doing. Could you clarify a little?

Cgraz

[nomad9]

ok sorry for my english ... it's cause i'm a french.

First of all, thank u to take some of your time to help me.

What i have to do is to create an application (different form) for my client to allow him to create his own form for his customer.

So the form that i'm trying to build is to allow my client to personnalize his own form.

I hope u understand.

So now, my problem is that inside my form, i allow my client to write word (ex. store name) and with this word, the script will create a dropdown list. So this way, my client have the choice to create a dropdownlist or not. If he select to create it, he can customize his own dropdown list.

if($storeActive = "Yes") {  // Select to create a dropdown list
$sql = "INSERT INTO f".$clientRef."  // Session Var for tablename(formType,formName,formQuestion) VALUES('aInfo','storeActive','".$storeActive."')";
$result = mysql_query($sql,$db) or die(mysql_error());

foreach ($storeList as $value) { // each textfield filled by my client
$sql = "INSERT INTO f".$clientRef." (formType,formName,formValue) VALUES('aInfo','storeList[".$storeNumber."]','".$value."')";
$result = mysql_query($sql,$db) or die(mysql_error());
$storeNumber++; 
}
}

now, it work well but i've got 15 textfield .... the prob is that whatever my client filled 3, 6, 8 ... textfield ... it always create 15 rows inside my db .

If you don't understand .... tell me and i'll try to explain it to you again

Steve

[cgraz]

What code are you using for your drop down ($storeList)?

if you're using

foreach ($storeList as $value) {
$listStore[$number] = "<option value='".$value."'>".$value."</option>";
$number = $number + 1
}

Each optioin has a value assigned to it. Either way you shouldn't get 15 blank entries, you should get 15 entries with values.

Another thing:

if($storeActive = "Yes") { // Select to create a dropdown list

Quick Note:

= means assigned to
== means equal to

The above if statement will always be executed because you assign Yes to the variable $storeActive, and it will always
return true. If you want to check if $storeActive equals yes, use:

if ($storeActive == "Yes"); // watch your caps on yes and Yes (just a note)

[nomad9]

Ok thanx for the advise.

Last thing, how can I detect witch entrie have value and witch are blank .... is there a way in php or javascript ????

[cgraz]

the foreach loop should only return ones with values. If you want to validate the form (meaning they can't submit until they fill out required fields), check out this post: http://www.phpbuilder.com/board/showthread.php?s=&threadid=10222662&perpage=15&pagenumber=2

I posted a javascript example of how to do this there.

Cgraz