upload help please. Blank field entry

[Peredy]

<?php
include("epkheader.inc");

 // read in the connection settings
    require("dbconnection.txt");

// connect to the RDBMS
$db = mysql_connect("$site","$user","$pass") 
    or die_now("<h2>Could not connect to database server</h2><p>Check passwords and sockets</p>");

// select the database
mysql_select_db("$database",$db) 
    or die_now("<h2>Could not select database $database</h2><p>Check database name</p>");

function do_upload() {

// Create an array containing all valid upload file types for this script
$allowed_types = array(
    "image/gif" => "gif",
    "image/pjpeg" => "pjpg",
    "image/jpeg" => "jpeg",
    "image/png" => "png",
    "image/tif" => "tif",
    "image/tiff" => "tiff",
    "image/bmp" => "bmp",

    // Add more types here if you like
);
// Check to see if the file type is in the allowed types array
if(!array_key_exists($_FILES['userfile']['type'], $allowed_types)) 
if(!array_key_exists($_FILES['userfile2']['type'], $allowed_types))  {
    die("Invalid file type.");
}
// Set the maximum uploadable file size => 51200 = 50kb
$maxfilesize = 2008204800;
// Is the file larger than it is allowed to be?
if($_FILES['userfile']['size'] > $maxfilesize) 
if($_FILES['userfile2']['size'] > $maxfilesize){
    die("Total Files too large in size. Please reduce the file size and try again.");
}
// Where will the file be uploaded to?
$uploaddir = $_SERVER['DOCUMENT_ROOT'] . "/bschedule/bsadmin/bandpic/";
$uploaddir2 = $_SERVER['DOCUMENT_ROOT'] . "/bschedule/bsadmin/bandpic/";
// What is the files temporary name?
$file = $_FILES['userfile']['tmp_name'];
$file2 = $_FILES['userfile2']['tmp_name'];
// What is the files actual name?
$filename = $_FILES['userfile']['name'];
$filename2 = $_FILES['userfile2']['name'];






 {
        // Copy the file.
        copy($file, $uploaddir.$filename) and copy($file2, $uploaddir2.$filename2) or 
copy($file, $uploaddir.$filename) or copy($file2, $uploaddir2.$filename2) or 

die("Could not list your image");
    }


$getuid = $_POST['uid']; 


$sqlQ = "UPDATE epk SET  bandpic = '/bschedule/bsadmin/bandpic/".$filename."', bandlogo = '/bschedule/bsadmin/bandpic/".$filename2."'  WHERE id = '".$_POST["id"]."';";
$sqlR = mysql_query($sqlQ)or die("Could not do a mysql query. Reason why: ".mysql_error());
  }
// If the form has been completed, execute the upload function (above).
if($_POST['action'] == "do_upload") {
    do_upload();
}

?>

What I need to do is make this so that if (on the previous page) one of the two fields are blank (if the user does not choose to upload anything) than the info in the database does not change. There is default info set into it.
If the user does choose to upload an image, then this will work, but if they decide to not upload them, or only upload one, then the fields they do not upload changes the info in the database and leaves the horrible red X.

So, I just want to make it so if one is blank, it is ignored in the database and the info in there is left alone... this will also be for the update page in case they only want to update one image instead of both.

Thanks a million for any help.

Peredy

[bastien]

why not check if they are empty before attempting to do anythign with the db? then you can build the sql statement on the fly if they are attempting to update the fields

[Peredy]

I want to be able to allow the user to only upload one of the two in the form if they only want to. Also the ignore thing is for when they update the page, they can update one of the imgaes instead of both. Right now if they only upload one, the other one turns to a blank entry in the database leaving no image.

Thanks a ton.

Peredy

[Peredy]

Any idea how to do this?

Peredy

[bastien]

try

if (!empty($_FILES)){
   $file      = '';
   $file2     = '';
   $filename  = '';
   $filename2 = '';

   $getuid = $_POST['uid'];    


   if (!empty($_FILE['userfile'])) {
     $file      = $_FILES['userfile']['tmp_name']; 
     $filename  = $_FILES['userfile']['name'];
     copy($file, $uploaddir.$filename)

 $sqlQ = "UPDATE epk SET bandpic =  '/bschedule/bsadmin/bandpic/".$filename."' WHERE id = '".$_POST["id"]."';";
   }

   if (!empty($_FILE['userfile2'])){
    $file2     = $_FILES['userfile2']['tmp_name'];} 
    $filename2 = $_FILES['userfile2']['name']; 

copy($file2, $uploaddir2.$filename2)

$sqlQ = "UPDATE epk set bandlogo = '/bschedule/bsadmin/bandpic/".$filename2."' WHERE id = '".$_POST["id"]."';";
$sqlR = mysql_query($sqlQ)or die("Could not do a mysql query. Reason why: ".mysql_error());
  }
}

[Peredy]

Thanks for the help.. but,

I am getting this now:

Parse error: parse error, unexpected T_VARIABLE in /home/jpaudiol/public_html/bschedule/bsadmin/epkenter3.php on line 91

Which is:

$sqlQ = "UPDATE epk SET  bandpic = '/bschedule/bsadmin/bandpic/".$filename."' WHERE id = '".$_POST["id"]."';"; 

Which doesnt make any sence since it is also used in the later part of the page and there is no errors with it there. Any ideas? This is what I have all together with what you put now....

<?php
include("epkheader.inc");

 // read in the connection settings
    require("dbconnection.txt");

// connect to the RDBMS
$db = mysql_connect("$site","$user","$pass") 
    or die_now("<h2>Could not connect to database server</h2><p>Check passwords and sockets</p>");

// select the database
mysql_select_db("$database",$db) 
    or die_now("<h2>Could not select database $database</h2><p>Check database name</p>");

function do_upload() {

// Create an array containing all valid upload file types for this script
$allowed_types = array(
    "image/gif" => "gif",
    "image/pjpeg" => "pjpg",
    "image/jpeg" => "jpeg",
    "image/png" => "png",
    "image/tif" => "tif",
    "image/tiff" => "tiff",
    "image/bmp" => "bmp",

    // Add more types here if you like
);
// Check to see if the file type is in the allowed types array
if(!array_key_exists($_FILES['userfile']['type'], $allowed_types)) 
if(!array_key_exists($_FILES['userfile2']['type'], $allowed_types))  {
    die("Invalid file type.");
}
// Set the maximum uploadable file size => 51200 = 50kb
$maxfilesize = 2008204800;
// Is the file larger than it is allowed to be?
if($_FILES['userfile']['size'] > $maxfilesize) 
if($_FILES['userfile2']['size'] > $maxfilesize){
    die("Total Files too large in size. Please reduce the file size and try again.");
}
// Where will the file be uploaded to?
$uploaddir = $_SERVER['DOCUMENT_ROOT'] . "/bschedule/bsadmin/bandpic/";
$uploaddir2 = $_SERVER['DOCUMENT_ROOT'] . "/bschedule/bsadmin/bandpic/";
// What is the files temporary name?
$file = $_FILES['userfile']['tmp_name'];
$file2 = $_FILES['userfile2']['tmp_name'];
// What is the files actual name?
$filename = $_FILES['userfile']['name'];
$filename2 = $_FILES['userfile2']['name'];


if (!empty($_FILES)){ 
   $file      = ''; 
   $file2     = ''; 
   $filename  = ''; 
   $filename2 = ''; 

   $getuid = $_POST['uid'];     


   if (!empty($_FILE['userfile'])) { 
     $file      = $_FILES['userfile']['tmp_name']; 
     $filename  = $_FILES['userfile']['name']; 
     copy($file, $uploaddir.$filename) 

 $sqlQ = "UPDATE epk SET  bandpic = '/bschedule/bsadmin/bandpic/".$filename."' WHERE id = '".$_POST["id"]."';"; 
 $sqlR = mysql_query($sqlQ)or die("Could not do a mysql query. Reason why: ".mysql_error()); 
   } 

   if (!empty($_FILE['userfile2'])){ 
    $file2     = $_FILES['userfile2']['tmp_name'];} 
    $filename2 = $_FILES['userfile2']['name']; 

copy($file2, $uploaddir2.$filename2) 

$sqlQ = "UPDATE epk set bandlogo = '/bschedule/bsadmin/bandpic/".$filename2."' WHERE id = '".$_POST["id"]."';"; 
$sqlR = mysql_query($sqlQ)or die("Could not do a mysql query. Reason why: ".mysql_error()); 
  } 
} 



 {
        // Copy the file.
        copy($file, $uploaddir.$filename) and copy($file2, $uploaddir2.$filename2) or 
copy($file, $uploaddir.$filename) or copy($file2, $uploaddir2.$filename2) or 

die("Could not list your image");
    }


$getuid = $_POST['uid']; 


$sqlQ = "UPDATE epk SET  bandpic = '/bschedule/bsadmin/bandpic/".$filename."', bandlogo = '/bschedule/bsadmin/bandpic/".$filename2."'  WHERE id = '".$_POST["id"]."';";
$sqlR = mysql_query($sqlQ)or die("Could not do a mysql query. Reason why: ".mysql_error());
  }
// If the form has been completed, execute the upload function (above).
if($_POST['action'] == "do_upload") {
    do_upload();
}

?>

[Peredy]

I just tried arranging this in a lot of different ways. Seems to make sence, but also doesnt work no matter where I put it. Am I missing something? I know that I must be, but what am I doing wrong?

Much appreciation for the help.

Peredy

[Peredy]

UPDATE and still need some help, but getting there...

I have done this so far...

    // Are the files empty?
    if (empty($filename))  {
    $filename = '../images/nopic.jpg';


}

if (empty($filename2))  {
$filename2 = '../images/nopic.jpg';


}

And what that has done is made it so if they dont upload anything it goes to that image.... BUT
I still cant get it to put in absolutely nothing, and leaving what is already in the database there if there is nothing being sent in the file field.

Any help is greatly appreciated.

Peredy

[Peredy]

Okay.. I think I have reached all that I can do with this. I will massively appreciate any help.
Thus far I have managed to make it so if no value is entered (empty upload) then it simply enters nothing into the database.... problem is, it enters a blank entry that erases what is already in there.
I need it to not change anything, almost like the database is ignoring the entry if nothing is uploaded.

This is what I have now....

<?php
include("epkheader.inc");

 // read in the connection settings
    require("dbconnection.txt");

// connect to the RDBMS
$db = mysql_connect("$site","$user","$pass") 
    or die_now("<h2>Could not connect to database server</h2><p>Check passwords and sockets</p>");

// select the database
mysql_select_db("$database",$db) 
    or die_now("<h2>Could not select database $database</h2><p>Check database name</p>");

function do_upload() {

// Create an array containing all valid upload file types for this script
$allowed_types = array(
    "image/gif" => "gif",
    "image/pjpeg" => "pjpg",
    "image/jpeg" => "jpeg",
    "image/png" => "png",
    "image/tif" => "tif",
    "image/tiff" => "tiff",
    "image/bmp" => "bmp",

    // Add more types here if you like
);


// Check to see if the file type is in the allowed types array
if(!array_key_exists($_FILES['userfile']['type'], $allowed_types)) 
if(!array_key_exists($_FILES['userfile2']['type'], $allowed_types))  {
    die("Invalid file type.");
}
// Set the maximum uploadable file size => 51200 = 50kb
$maxfilesize = 2008204800;
// Is the file larger than it is allowed to be?
if($_FILES['userfile']['size'] > $maxfilesize) 
if($_FILES['userfile2']['size'] > $maxfilesize){
    die("Total Files too large in size. Please reduce the file size and try again.");
}
// Where will the file be uploaded to?
$uploaddir = $_SERVER['DOCUMENT_ROOT'] . "/bschedule/bsadmin/bandpic/";
$uploaddir2 = $_SERVER['DOCUMENT_ROOT'] . "/bschedule/bsadmin/bandpic/";
// What is the files temporary name?
$file = $_FILES['userfile']['tmp_name'];
$file2 = $_FILES['userfile2']['tmp_name'];
// What is the files actual name?
$filename = $_FILES['userfile']['name'];
$filename2 = $_FILES['userfile2']['name'];
// What is the addy?
$addyname = '/bschedule/bsadmin/bandpic/';
$addyname2 = '/bschedule/bsadmin/bandpic/';



// Are the files empty? 
    if (empty($filename))  { 
    $filename = NULL;
    $addyname = NULL;

} 

if (empty($filename2))  { 
$filename2 = NULL;
$addyname2 = NULL;



}

{
        // Copy the file.
        copy($file, $uploaddir.$filename) and copy($file2, $uploaddir2.$filename2) or 
copy($file, $uploaddir.$filename) or copy($file2, $uploaddir2.$filename2) or 

die("Could not list your image");
    }




$sqlQ = "UPDATE epk SET  bandpic = '".$addyname."".$filename."', bandlogo = '".$addyname2."".$filename2."'  WHERE id = '".$_POST["id"]."';";
$sqlR = mysql_query($sqlQ)or die("Could not do a mysql query. Reason why: ".mysql_error());
  }
// If the form has been completed, execute the upload function (above).
if($_POST['action'] == "do_upload") {
    do_upload();
}

?>

Any help is greatly appreciated.

Thank you.

Peredy

[Peredy]

Any ideas? I'm realy stuck.