Posting textbox details to next page

MitchEvans

I want to be able to press submit on my page and whatever is entered in the text boxes (approx. 6 of them) I would like to appear on the next page in a table the same as the one sent. Any ideas my code for the page is shown the text box i want the results for is the TEXTAREA?

<FORM method='POST' action='cert1pdf.php?id=$hello'>

<table bgcolor=#ffffff border=1><tr>

<td><strong>Quality Management</strong></td><td><strong>Yes</strong></td><td><strong>No</strong></td><td><strong>Notes</strong></td></tr>";
echo"<tr><td><strong>1 - Service Operations</strong></td></tr>";
$productsql1 = "SELECT * FROM survey WHERE rtid=1 ORDER BY id";
$productResults1 = mysql_query($productsql1);
while ($productRow1 = mysql_fetch_array ($productResults1)){
$ProductName1 = $productRow1["requirement_txt"];

echo"
<tr>
<td>$ProductName1</td>
<td>Yes:<INPUT type='checkbox' name='myradio{$productRow1['id']}[]' value='yes'></td>
<td>No:<INPUT type='checkbox' name='myradio{$productRow1['id']}[]' value='no'></td>
<td><TEXTAREA NAME='text{$productRow1['id']}[]' ROWS=3 COLS=60>
</TEXTAREA></td>
</tr>";}

Currently i'm using the code below on the second page, this gives the results of the check boxes but not the text boxes, the word "array" appears with this code:

$res="SELECT * FROM survey WHERE rtid=1 ORDER BY id";
				$results= mysql_query($res,$connection); 
$num= mysql_num_rows($results);  

for ($i=0; $i<$num; $i++) { 
   // Fetch data from survey table here 
   $rows= mysql_fetch_array ($results); 

   $s='';
   $t=''; 
   $u=''; 

   $array_name= 'myradio'.$rows['id']; 
  $array_name1='text'.$rows['id'];
 if (isset($_POST[$array_name])) { 
      foreach ($_POST[$array_name] as $key => $val) { 
        if ($val=='yes') $s='Yes' AND $t=$_POST[$array_name1]; 
        else if ($val=='no') $s='No' AND $t=$_POST[$array_name1];

Tezread

Hi Mitch.

Best of using sessions for this kind of thing. here is an example:

on the first page have this at the top of the code/HTML

<?php
session_start();
require_once('common_functions.php'); 
$_SESSION['form1_data']='';

?>

where require once is

<?php    

// Quote variable to make safe 
function quote_smart($value) 
{ 
   // Stripslashes 
   if (get_magic_quotes_gpc()) { 
       $value = stripslashes($value); 
   } 
   // Quote if not integer 
   if (!is_numeric($value)) { 
       $value = "'" . mysql_real_escape_string($value) . "'"; 
   } 
   return $value; 
} 
?>

then on your formhandler page you can do an insert for each textbox in the form and its corresponding field in the database

<?php
include("connect.php");
session_start();
require_once('common_functions.php'); 
$_SESSION['form1_data'] = $_POST;
$sql = "INSERT INTO tableno SET id =  NULL ";
	foreach ($_SESSION['form1_data'] as $col =>$val ){
		if($col <> 'submit'){
		$sql .=", $col = '$val' ";
		}
	}

this should get you started

Tezread

you could also use a prepopulated form to show your results i.e

$sql = "SELECT field1, 
               field2 
        FROM   table 
        WHERE  username= '".$username."'"; 

$result = mysql_query($sql); 

//fetch it
if(mysql_num_rows($result) > 0) { 
   $row = mysql_fetch_array($result); 
} 
?> 

<html> 
<head> 
</head> 
<body> 
<form> 
Field 1: <input type="text" name="field1" value="<?=$row['field1']?>"> 
<br /> 
Field 2: <input type="text" name="field2" value="<?=$row['field2']?>"> 
<br /> 
<input type="submit"> 
</form> 
</body> 
</html>

MitchEvans

Cheers for helping, mind you my head hurts now ouch :o
I'm still quite lost on this,

How would i echo the following results, do i need to have a "value=" on this somewhere:

<TEXTAREA NAME='text{$productRow1['id']}[]' ROWS=3 COLS=60>
</TEXTAREA>

Tezread

MitchEvans wrote:
How would i echo the following results, do i need to have a "value=" on this somewhere:
<TEXTAREA NAME='text{$productRow1['id']}[]' ROWS=3 COLS=60>
</TEXTAREA>

i think you would have a value attribute the same as I demonstrated in the last post... i think

Tezread

To redisplay the text you should not place the text in the "value" attribute of the textarea tag. Instead, you should write the text between the textarea and the /textarea tags.