Manage Invoice Reference
0){ echo '
Project exist.Please use another email.
';
}
else
{
//save project
$insert_project="INSERT INTO project (project_id,project_name,project_remarks,project_status,created,status)
VALUES
(0,'".$_POST['project_name']."','".$_POST['project_remarks']."','".$_POST['project_status']."','$time','1')";
$run_project=mysqli_query($con,$insert_project);
echo '
Project successfuly created.
';
}
}
else if(isset($_POST['update']) && $_POST['update']!="")
{
$pid=$_POST['update'];
$update_project="UPDATE project SET project_name='".$_POST['project_name2']."', project_remarks='".$_POST['project_remarks2']."', project_status='".$_POST['project_status']."' WHERE project_id='$pid'";
$run_update_project=mysqli_query($con,$update_project);
echo '
Project successfuly updated.
';
}
else if(isset($_POST['delete2']) && $_POST['delete2']!="")
{
$pid=$_POST['delete2'];
$update_project="UPDATE project SET status='3' WHERE project_id='$pid'";
$run_update_project=mysqli_query($con,$update_project);
echo '
Project successfuly deleted.
';
}
else if(isset($_POST['project_id_status']) && $_POST['project_id_status']!="")
{
$s_value=$_POST['stats'];
$pid=$_POST['project_id_status'];
$update_post="UPDATE project SET status='$s_value' WHERE project_id='$pid'";
$run_project=mysqli_query($con,$update_post);
}
else
{}
?>
Invoice Reference Info
Project successfully deactivated.
';
}
else
{}
?>
| No | Invoice Reference | Invoice Reference Remarks | Invoice Reference Status | Created | Status | Action |
|---|---|---|---|---|---|---|
|
|