On my page there are 3 fields that the user must not leave blank (Implementor_value,
Title_value, AddOPtext_value). I figured out how to prevent the user from saving the
page unless these fields are entered. My problem now is the project will not save.
Here's the code i'm using:
if value for Implementing Agency, OP and Title is not entered"
if(strlen($Implementor_value) == 0)
{$error_message = "An Implementing Agency must be selected.";}
if(strlen($AddOPText_value) == 0)
{$error_message = "At Least One Output must be selected.";}
if(strlen($Title_value) == 0)
{$error_message = "A Project Title must be entered.";}
If values for implementor, OP, title, estimated cost, start date and end date
validated this is code used to create project:
if ($Implementor_value != 0 and $AddOPText_value != 0
and $Title_value != 0 and $result1 != 0 and $result1b != 0 and $result2 != 0 and
$result3 != 0 and is_numeric($Duration_value) == true){
// Find the project owner
$UserName_alt = $_SESSION['MM_Username'];
$query_alt = "Select Agency from user where UserID = '$UserName_alt'";
$Result_alt = mysql_query($query_alt) or die(mysql_error);
$Result_row_alt = mysql_fetch_assoc($Result_alt);
$Owner_value = NULL;
if(isset($Result_row_alt)){$Owner_value = $Result_row_alt['Agency'];}
// Find today's date and format start and end dates into mysql formats
$Today = date("Y-m-d",time());
$Start_value2 = format_date2($Start_value);
$End_value2 = format_date2($End_value);
if (strlen(trim($Start_value)) <> 0)
{$Start_value3 = format_date($Start_value);}
else
{$Start_value3 = null;}
if (strlen(trim($End_value)) <> 0)
{$End_value3 = format_date($End_value);}
else
{$End_value3 = null;}
// Insert project summary into db or update according to $mode
if (isset($mode) and $mode != "Edit"){
if (isset($Implementor_value)){$Implementor_value = $_POST['Implementor'];}
if (isset($AddOPText_value)){$AddOPText_value = $_POST['textAddOP'];}
if (isset($Title_value)){$Title_value = $_POST['title_field'];}
$EC_value2 = format_money($EC_value);
$AC_value2 = format_money($AC_value);
$use_default_start = "0";
if ($_POST['defaultStart'] or ($Start_value == default_date())){$use_default_start = "1";}
$use_default_end = "0";
if($_POST['defaultEnd'] or ($End_value == default_date())){$use_default_end = "1";}
$project_query = "Insert into projects_copy (Owner, Implementor, OP, SubcatID,
Title, Description, ProjectStatus, FundingStatus, EstimatedCost, ActualCost, Duration,
Remarks, StartDate, EndDate, DateCreated, CreatedBy,DefaultStart, DefaultEnd, ProjectLink)
values ('$Owner_value', '$Implementor_value', '$AddOPText_value', '$Title_value',
'$Description_value', '$Project_value', '$Funding_value', '$EC_value2','$AC_value2','$Duration_value',
'$Remarks_value','$Start_value3','$End_value3','$Today','$UserName_alt','$use_default_start',
'$use_default_end','$AddInfo_value')";
$Insert_result = mysql_query($project_query) or die(mysql_error);
// Get recently created project id
$ID = mysql_insert_id();
for($counter = 0; $counter < $num_ops;$counter++)
{
$To_Insert = trim($OP_list[$counter]);
$insert_query = "Insert into projectops_copy values ('$ID','$To_Insert')";
mysql_query($insert_query);
}
$confirmation_message = "New Project Sucessfully Created";
$mode = "Edit";}
else
{$EC_value2 = format_money($EC_value);
$AC_value2 = format_money($AC_value);
$use_default_start = "0";
if ($_POST['defaultStart'] or ($Start_value == default_date())){$use_default_start = "1";}
$use_default_end = "0";
if($_POST['defaultEnd'] or ($End_value == default_date())){$use_default_end = "1";}
$project_query = "Update projects_copy set Implementor = '$Implementor_value', OP='$AddOPText_value',
SubcatID='', Title ='$Title_value', Description='$Description_value',ProjectStatus = '$Project_value',
FundingStatus='$Funding_value',EstimatedCost='$EC_value2',ActualCost = '$AC_value2',
Duration='$Duration_value',Remarks='$Remarks_value',StartDate='$Start_value3',EndDate='$End_value3',
LastUpdatedDate='$Today',UpdatedBy='$UserName_alt',DefaultStart = '$use_default_start',DefaultEnd = '$use_default_end',
ProjectLink = '$AddInfo_value' where ProjectID='$ID'";
$Update_result = mysql_query($project_query) or die(mysql_error);
$deletion_query = "Delete from projectops_copy where ProjectID='$ID'";
mysql_query($deletion_query);
for($counter = 0; $counter < $num_ops;$counter++)
{
$To_Insert = trim($OP_list[$counter]);
$insert_query = "Insert into projectops_copy values ('$ID','$To_Insert')";
mysql_query($insert_query);
}
$confirmation_message = "Project Successfully Edited";
$mode = "Edit";}
}
