How to rename file on upload
I am trying to rename a file upon upload. The name will be some data from a recordsets separated by underscores. For some reason the name isn't coming out correctly. Here is my code:
<?php
$applicants = new WA_MySQLi_RS("applicants",$cori,1);
$applicants->setQuery("SELECT * FROM applicants WHERE applicantID = ?");
$applicants->bindParam("i", "".(isset($_GET['applicantID'])?$_GET['applicantID']:"") ."", "-1"); //colname
$applicants->execute();?>
<?php
$fname= $applicants->getColumnVal("fname");
$lname=$applicants->getColumnVal("lname");
$dob=$applicants->getColumnVal("dob");
$ssn=$applicants->getColumnVal("ssn");
// WA_UploadResult1 Params Start
$WA_UploadResult1_Params = array();
// WA_UploadResult1_1 Start
$WA_UploadResult1_Params["WA_UploadResult1_1"] = array(
'UploadFolder' => "verification_files",
'FileName' => "".$lname ."_".$fname ."_".$dob ."_".$ssn ."",
'DefaultFileName' => "",
'ResizeType' => "0",
'ResizeWidth' => "0",
'ResizeHeight' => "0",
'ResizeFillColor' => "" );
// WA_UploadResult1_1 End
// WA_UploadResult1 Params End
?>
<?php
WA_DFP_SetupUploadStatusStruct("WA_UploadResult1");
if(isset($_POST["submit"]) || isset($_POST["submit_x"])){
WA_DFP_UploadFiles("WA_UploadResult1", "id_image", "2", "[NewFileName]_[Increment]", "false", $WA_UploadResult1_Params);
}
?>
<?php
if (isset($_POST["submit"]) || isset($_POST["submit_x"])) {
$InsertQuery = new WA_MySQLi_Query($cori);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "verifier";
$InsertQuery->bindColumn("applicantID", "i", "".$_GET['applicantID'] ."", "WA_DEFAULT");
$InsertQuery->bindColumn("staffID", "i", "".((isset($_POST["staffID"]))?$_POST["staffID"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("verificationID", "s", "".((isset($_POST["status"]))?$_POST["status"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("verification_type", "s", "".((isset($_POST["verification_type"]))?$_POST["verification_type"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("id_image", "s", "".($WA_DFP_UploadStatus["WA_UploadResult1"]["WA_UploadResult1_1"]["serverFileName"]) ."", "WA_IGNORE");
$InsertQuery->bindColumn("staff_signature", "s", "".((isset($_POST["staff_signature"]))?$_POST["staff_signature"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("verification_date", "t", "".((isset($_POST["verification_date"]))?$_POST["verification_date"]:"") ."", "WA_DEFAULT");
$InsertQuery->saveInSession("");
$InsertQuery->execute();
$InsertGoTo = "email_verified.php?applicantID=".$_GET['applicantID'] ."";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>