[RESOLVED] Passing data between pages help

[turtleton09]

Hope someone can help with this, as the two steps forward one step back thing is starting to make my brain turn to mush!

I have standard form where users input various data - when this is completed it takes them to a second page where they can add keywords to the record by checking various boxes.

This all works fine with the form page, and the add keywords page.

The add keywords page contains the code to insert the fields form the preceding form page :

Code:

<?php
mysql_select_db($database_Photolibrary, $Photolibrary);
$query_Recordset1 = "SELECT * FROM photos";
$Recordset1 = mysql_query($query_Recordset1, $Photolibrary) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<?php

move_uploaded_file ($_FILES['uploadFile'] ['tmp_name'], "Photos/{$_FILES['uploadFile'] ['name']}")

?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}

/********************
*
*insert Vacancy details into db
*
********************/

//sql string

  $insertSQL = sprintf("INSERT INTO Photos (Link_ID, Title, Rights, Rights_Details, Credit, Image_Size, Year, Supplier, Photo_File, Orientation, Admin, Region, Country, Easting, Northing) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['Link_ID'], "text"),
                       GetSQLValueString($_POST['Title'], "text"),
                       GetSQLValueString($_POST['Rights'], "text"),
                       GetSQLValueString($_POST['Rights_Details'], "text"),
	          GetSQLValueString($_POST['Credit'], "text"),
	          GetSQLValueString($_POST['Image_Size'], "text"),
                       GetSQLValueString($_POST['Year'], "text"),
                       GetSQLValueString($_POST['Supplier'], "text"),
                       GetSQLValueString($_FILES['uploadFile']['name'], "text"),
	          GetSQLValueString($_POST['Orientation'], "text"),
                       GetSQLValueString($_POST['Admin'], "text"),
                       GetSQLValueString($_POST['Region'], "text"),
                       GetSQLValueString($_POST['Country'], "text"),
	          GetSQLValueString($_POST['Easting'], "text"),
                       GetSQLValueString($_POST['Northing'], "text"));


//insert

$Result1 = mysql_select_db($database_Photolibrary, $Photolibrary); mysql_query($insertSQL); echo mysql_error();

/********************
*
*Retrieve PhotoID
*
********************/

$Photo_ID = mysql_insert_id ();

?>

However, if i change the form page to point first to my validation.php, rather than the add keywords page, with it only progressing to that page if the form validates, then the date isn't being carried through.

What code do I need to add to the validation page to pass it through to the add keywords page?

[rgermain]

You would need something to pull the variables from you form.

Say you had a text box like - <input type="text" name="supplier" size="20"> - in your form.

You will need to have $supplier = $_POST['Supplier']; To pull that variable.

[turtleton09]

Where does this need to go exactly? At the moment, if I just go straight from my form page, to the page to add keywords, it all works fine.

ie addphoto.php > addkeywords.php (code above) is all fine.

but when I go :

addphoto.php > validation page (created using Forms to Go) > addkeywords.php, where addkeywords.php is the page that the validation script redirects to if it passes the validation.

[rgermain]

They would need to go at the top of the page.

Any variable being passed by the form would need to be retrieved using a $_POST[''];

[turtleton09]

rgermain wrote:

They would need to go at the top of the page.

Any variable being passed by the form would need to be retrieved using a $_POST[''];

so basically use 'get' for the form page, and then add in

<? php
$field1 = $POST['field1'];
$field2 = $POST['field2'];
$field3 = $_POST['field3'];
etc
?>

at the top of the page in the form's action?

[rgermain]

No... Ok.

If you are going for page1 which contains the form. To page2 which contains the validation code.

You will need in the forms action the validation page name. and for the method you will use POST and then on the top of the validation page you will need the to use the $_POST[''] to pull the form data.

Like $first_name = $_POST['f_name'];

f_name being the name of a input text box in your form.

[turtleton09]

Sorry - got the get from somewhere else.

I was trying to add in a recordset yesterday, and filter on Photo_ID, using the form variable on the validation page, but it was getting the error message :

Warning: Cannot modify header information - headers already sent by (output started at C:\wamp\www\Photolibrary\validationNew.php:9) in C:\wamp\www\Photolibrary\validationNew.php on line 438

A clear head this morning will hopefully help.

Now I've got Forms to Go dumping the fields directly into mySQL, so currently have it working as far as the validation all working, and the record being added correctly.

So currently :

addphoto.php, with a form action of validation.php, using post, which validates the form and adds the record to the database if it checks out, and progresses on the addkeywords.php page.

But how do I then pass the Photo_ID through to the addkeywords page, so that that page can then be used to add keywords to the record currently / just been added?

I've been trying different combinations of :

$Photo_ID = $_POST['Photo_ID'];

mysql_select_db($database_Photolibrary, $Photolibrary);
$query_Recordset1 = "SELECT * FROM photos";
$Recordset1 = mysql_query($query_Recordset1, $Photolibrary) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

$colname_Recordset1 = "1";
if (isset($_POST['Photo_ID'])) {
  $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_POST['Photo_ID'] : addslashes($_POST['Photo_ID']);
}
mysql_select_db($database_Photolibrary, $Photolibrary);
$query_Recordset1 = sprintf("SELECT Photo_ID FROM photos WHERE Photo_ID = %s", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $Photolibrary) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

$Photo_ID = $_POST['Photo_ID'];

In both my validation and addkeyword pages, but am not having any joy with any.

Hopefully it's along the right lines tho', but I'm just not seeing it?

[turtleton09]

Got it - it was :

?php 
// Max Sizes 
$th_max_width = 120;  // Maximum width of the thumbnail 
$th_max_height = 120; // Maximum height of the thumbnail 

//------------------- 

// File 
$filename = $_GET['file']; 

// Get image sizes, type & mime 
$img_data = getimagesize($filename); 
$width = $img_data[0]; 
$height = $img_data[1]; 
$img_type = $img_data[2]; // Numeric value (check in manual) 
$mime = $img_data['mime']; 

// Content type 
header('Content-type: ' . $mime); 


// Resize 
$ratio = ($width > $height) ? $th_max_width/$width : $th_max_height/ 
$height; 
$newwidth = round($width * $ratio); 
$newheight = round($height * $ratio); 

// Load 
$thumb = imagecreatetruecolor($newwidth, $newheight); 

switch ($img_type){ 
case 1: 
  $source = imagecreatefromgif($filename); 
  break; 

case 2: 
  $source = imagecreatefromjpeg($filename); 
  break; 

case 3: 
  $source = imagecreatefrompng($filename); 
  break; 

case 4: 
  $source = imagecreatefromwbmp($filename); 
  break;

//  Other file types... 
} 

//Resize 
imagecopyresized($thumb, $source, 0, 0, 0, 0, $newwidth, $newheight,   

$width, $height); 

// Output 
imagejpeg($thumb); 
?> 

<?php 
exit; 
?>