input fields truncate after space....

97transam

Hello all,

I'm at a lost on how to pass a "full sentence" of data from a web form to MySql.
I'm running a For Loop that has a $index++ with no problems.

The page is showing a brief description from a holding table using a simple MySql query with an approve yes/no radio button next to each record. Those records that have a "Yes" get those records sent to another table. This is all works fine, except some of the data fields are sentences and I only end up with the first word in the destination table.

do {
$for_obStr = for_ob.$index;

//  the following is fine, long complete sentences can be seen in webpage view source
echo "<input type=hidden name=\"$for_obStr\" value=\"$row[11]\">\n";
$index++;
$index_count++;

} while ($row = mysql_fetch_row($resultCA));

echo "<input type=hidden name=counter value=$index_count>\n";
echo "<input type='submit' name='Submit' value='Process approvals'></form>\n";




for ($index = 0; $index <= $counter; $index++) {

// But the following only gives the first word, nothing more
$for_obvalue = ${'for_ob'.$index};


blah blah 
   } // end of For loop

I have echo'd the $for_obvalue and it's truncated before I run the input sql.
I'm sure it's something with proper escaping on the last line, but I haven't been able to figure it the correct combo.

Thanks in advance...

Rodney_H_

Explain two things to me:

1) Where are you defining the CONSTANT 'for_ob' that you are using in the first line of code:
$for_obStr = for_ob.$index;

2) What exactly are you trying to accomplish here: $for_obvalue = ${'for_ob'.$index}; ?

97transam

Strange... it's working this morning. 😃

But just so that you know, the concept is that a set of corrective actions are entered into a holding table until the entry and plan of action are "approved". The form presents all the records in the the holding table with the ability to click a radio button for approval. Then the form is proceesed all the entries that are "approved" are entered into the "active" table and deleted for the holding table. The form has to be dynamic in the sense that the data in the source table is always changing, yet I had to "grab" the correct record by a dynamic field name...

Initially I run a query:

		[CODE]$resultCA = mysql_query("
		SELECT * 
		FROM $tableSource 
		ORDER by for_id
		",$db); 

	 	$row = mysql_fetch_array($resultCA);[/CODE]

I set up the form and later with table layout statments:

echo "<form method=post action=$PHP_SELF  enctype='multipart/form-data'>\n";

The do/ while loop with index++ allows me to create a "unique" filed name on the fly...
So $for_ob1, $for_ob2, $for_ob3....

do {			$for_obStr = for_ob.$index;

I assigned the source table data to this unique field, do a printf of the some of the values along with the radio buttons and end with loop.

echo "<input type=hidden name=\"$for_obStr\" value=\"$row[11]\">\n";

$index++;
$index_count++;

} while ($row = mysql_fetch_row($resultCA));

Now using the index_count value, I can do another loop to process the "approved" records...

  for ($index = 0; $index <= $counter; $index++) {
	$for_obvalue = ${'for_ob'.$index};

if ($Approvedvalue == '-1')
 {
mysql_query( "INSERT INTO $table (
 for_ob
) VALUES (
 '$for_obvalue'
	)");

   } // end of If Approved

} // end of For loop

I cleared out two and a half tons of other fields names and values for readability, but it seemed to be straight forward and I couldn't see where the value would be truncated. Usually that happens if the value isn't in quotes, but I had done so.

Anyways, I fired everything up and it is working as expected. Maybe the server cached an earlier version? Whatever, glad it's working and I can move on to the next "problem"....

ron