[RESOLVED] Assigning button values with multiple upload

[AnarchistX]

Hello everyone, I'm having a problem with my code:

I want it to upload images using either upload button. When the button is pressed, a variable named "picturedID" gets assigned either 1 or 2 depending on which submit button was pressed.

I'm doing this so my uploader.php can determine which submit button was used and assign a name to that picture uploaded

such as: button1Image.jpg, button2Image.jpg

As of now: The images upload just fine, but the pictureID doesn't change, it just stays at 1, so any image uploaded is being named button1Image.jpg

Here's my code:

<form enctype="multipart/form-data" action="uploader.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="100000" />
<input name="uploadedfile" type="file" /><br />
<input type="submit" name="submit" value="1" />
</form>

<form enctype="multipart/form-data" action="uploader.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="100000" />
<input name="uploadedfile" type="file" /><br />
<input type="submit" name ="submit" value="2" />
</form>

<?
// Connect to DATABASE
$conn = mysql_connect("localhost","*****","*****");

// Connect to Table and stores connection as variable: conn
$db = mysql_select_db("*****_academicPrograms", $conn);;


$result = MYSQL_QUERY("SELECT * from academicPrograms")
   or die ("Data not found");
$worked = mysql_fetch_array($result);

// Gets all values from table and stores them as variables
$id = $worked[id];
$pictureID = $worked[pictureID];

// ***************************************** END PHP CODE 

  switch ($_GET['submit']) { 

    case '1': 
	  $result = MYSQL_QUERY("UPDATE academicPrograms SET pictureID = 1"); 
      break; 

    case '2': 
	  $result = MYSQL_QUERY("UPDATE academicPrograms SET pictureID = 2"); 
      break; 

    default: 
      print 'None of the cases reached.'; 
      break; 

  } // End: switch ($_GET['submit']) 

?> 

Any help would be appreciated, Thanks

[AnarchistX]

Sorry, this might be easier to Read.

<form enctype="multipart/form-data" action="uploader.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="100000" />
<input name="uploadedfile" type="file" /><br />
<input type="submit" name="submit" value="1" />
</form>

<form enctype="multipart/form-data" action="uploader.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="100000" />
<input name="uploadedfile" type="file" /><br />
<input type="submit" name ="submit" value="2" />
</form>

<?
// Connect to DATABASE
$conn = mysql_connect("localhost","*****","*****");

// Connect to Table and stores connection as variable: conn
$db = mysql_select_db("*****_academicPrograms", $conn);;


$result = MYSQL_QUERY("SELECT * from academicPrograms")
or die ("Data not found");
$worked = mysql_fetch_array($result);

// Gets all values from table and stores them as variables
$id = $worked[id];
$pictureID = $worked[pictureID];

// ***************************************** END PHP CODE 

switch ($_GET['submit']) { 

case '1': 
$result = MYSQL_QUERY("UPDATE academicPrograms SET pictureID = 1"); 
break; 

case '2': 
$result = MYSQL_QUERY("UPDATE academicPrograms SET pictureID = 2"); 
break; 

default: 
print 'None of the cases reached.'; 
break; 

} // End: switch ($_GET['submit']) 

?> 

[ClarkF1]

You might not be able to do it using the value on the submit button. I think that will only return true or false.

You could use another hidden form field and use the switch statement on that value.

[AnarchistX]

Thanks for the advice ClarkF1

I still can't get the pictureID to change, here's what I changed
*I added the hidden field for the buttons, and changed the switch statement from looking at submit to hidden.

<form enctype="multipart/form-data" action="uploader.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="100000" />
<input name="uploadedfile" type="file" /><br />
<input type="submit" value="submit" />
<input type="hidden" name="h3" value="h3"/>
</form>

<form enctype="multipart/form-data" action="uploader.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="100000" />
<input name="uploadedfile" type="file" /><br />
<input type="submit" value="submit" />
<input type="hidden" name="h4" value"h4"/>
</form>

<?
// Connect to DATABASE
$conn = mysql_connect("localhost","*****","******");

// Connect to Table and stores connection as variable: conn
$db = mysql_select_db("*****_academicPrograms", $conn);;

// Queries the user input data with the database data
$result = MYSQL_QUERY("SELECT * from academicPrograms")
   or die ("Data not found");

// Gets boolean value of whether the query worked
$worked = mysql_fetch_array($result);

// Gets all values from table and stores them as variables
$pictureID = $worked[pictureID];

// ***************************************** END PHP CODE 

  switch ($_GET['hidden']) { 

case 'h3': 
  $result = MYSQL_QUERY("UPDATE academicPrograms SET pictureID = 1"); 
  break; 

case 'h4': 
  $result = MYSQL_QUERY("UPDATE academicPrograms SET pictureID = 2"); 
  break; 

default: 
  print 'None of the cases reached.'; 
  break; 

  } // End: switch ($_GET['submit']) 

?> 

Any ideas?

[ClarkF1]

You need to give the hidden fields you added the same name (in your case "hidden").

<input type="hidden" name="hidden" value="h3"/>

and

<input type="hidden" name="hidden" value="h4"/>

Also you're send the form using the POST method but checking the $_GET array.

You need to change $GET to $POST

[AnarchistX]

Hey thanks again ClarkF1,

I did what you said but my pictureID still doesn't change, Code below:

<form enctype="multipart/form-data" action="uploader.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="100000" />
<input name="uploadedfile" type="file" /><br />
<input type="submit" value="submit" />
<input type="hidden" name="hidden" value="h3"/>
</form>

<form enctype="multipart/form-data" action="uploader.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="100000" />
<input name="uploadedfile" type="file" /><br />
<input type="submit" value="submit" />
<input type="hidden" name="hidden" value="h4"/>
</form>

<?
// Connect to DATABASE
$conn = mysql_connect("localhost","*****","*****");

// Connect to Table and stores connection as variable: conn
$db = mysql_select_db("*****_academicPrograms", $conn);;

// Queries the user input data with the database data
$result = MYSQL_QUERY("SELECT * from academicPrograms")
   or die ("Data not found");

// Gets boolean value of whether the query worked
$worked = mysql_fetch_array($result);

// Gets all values from table and stores them as variables
$pictureID = $worked[pictureID];

// ***************************************** END PHP CODE 

  switch ($_POST['hidden']) { 

case 'h3': 
  $result = MYSQL_QUERY("UPDATE academicPrograms SET pictureID = 1"); 
  break; 

case 'h4': 
  $result = MYSQL_QUERY("UPDATE academicPrograms SET pictureID = 2"); 
  break; 

default: 
  print 'None of the cases reached.'; 
  break; 

  } // End: switch ($_POST['hidden']) 

?> 

Could the problem be in my uploader.php?

This is it below:

<?
// Connect to DATABASE
$conn = mysql_connect("localhost","*****","******");

// Connect to Table and stores connection as variable: conn
$db = mysql_select_db("******_academicPrograms", $conn);;

// Queries the user input data with the database data
$result = MYSQL_QUERY("SELECT * from academicPrograms")
   or die ("Data not found");

// Gets boolean value of whether the query worked
$worked = mysql_fetch_array($result);

// Gets all values from table and stores them as variables
$pictureID = $worked[pictureID];

// Outputs for testing purposes
echo "the picture ID is ".$pictureID;

?>

<?
// Connects to Database for uploading image through FTP
$ftpconn = ftp_connect("*****") or die("Could not connect"); 
ftp_login($ftpconn,"*****","*****");

// The Directory the file will be placed
$target_path = "Images/";

if($pictureID = 1){$uniqueName = "1_img.jpg";}
if($pictureID = 2){$uniqueName = "2_img.jpg";}

//Assigns a the path and the name together
$uniqueID= $target_path.$uniqueName;


//Moves to temp file to the targetpath 
$_FILES['uploadedfile']['tmp_name'];  

if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $uniqueID)) {
    echo "The file ".  basename( $_FILES['uploadedfile']['name']). 
    " has been uploaded";
} else{
    echo "There was an error uploading the file, please try again!";
}
?>

Hmm... but uploader shouldn't matter right? Since the problem comes from the form. I've tried changing double quotes from quotes and back, nothing. I checked to see if my database worked, and used a simple button to send values to it, that worked fine. For some reason, combining uploading images and sending values to the database is giving me problems.

Again, the images upload fine, whether from one box or the other, the pictureID is currently set as 1, and refuses to change.

ClarkF1, thanks again for your help

[AnarchistX]

Oh just a note, I removed the extra ?> <? 's in the middle of uploader.php, forgot to change that in the code above.

[AnarchistX]

Hmm, if it's not the uploader.php, it must be the forms page.

I tested out the switch statement to make sure it works

  switch ($_POST["hidden"]) { 

case "h3": 
  print ' Case 1 Reached ';
  $result = MYSQL_QUERY("UPDATE academicPrograms SET pictureID = 1"); 
  break; 

case "h4": 
  print ' Case 2 Reached ';
  $result = MYSQL_QUERY("UPDATE academicPrograms SET pictureID = 2"); 
  break; 

default: 
  print 'None of the cases reached.'; 
  break; 

Works just fine

Is something wrong with my UPDATE command? academicPrograms is my table, and pictureID is the variable in my table that I am trying to change.

Thanks.

[ClarkF1]

I think it's uploader.php.........

Once it's processed the file it doesn't go back to the page with the form.

The only way you could do that was load the form page again or move switch statement etc. to uploader.php

It's not going to be able to process the query according to $_POST['hidden'] on the form page because it hasn't been sent.

[AnarchistX]

What would I add into uploader to make it revert back to the form after it processes the data?

[ClarkF1]

echo "<script>window.location=\"formpage.php?picID=".$_POST['picID']."\"</script>";

where formpage.php is the page with the form on it.

You'd then need to revert to using $GET['picID'] not $POST as the variable is parsed through the URL

I've changed the 'hidden' to 'picID' ... hidden sounds and looks like it's not meant to be seen....change the form as well if you decided to change it. You don't have to....it just looks strange having a visible variable called hidden. 😃

[AnarchistX]

ClarkF1, you are the man, it works, and I used picID, haha

I guess hidden is too obvious huh lol.

Ok thanks again for all your help

I'm going to run around with the script and show everyone, they are geologists and probably won't know why i'm so excited, but it's OK!

Thanks again 😃

[ClarkF1]

No worries, glad I could help