Manage Company
0){ echo '
Company exist.Please use another company name.
';
}
else
{
//save project
$insert_project="INSERT INTO company (company_id,company_name,company_address,company_postcode,company_phone,company_email,created,status)
VALUES
(0,'".$_POST['company_name']."','".$_POST['company_address']."','".$_POST['company_postcode']."','".$_POST['company_phone']."','".$_POST['company_email']."','$time','1')";
$run_project=mysqli_query($con,$insert_project);
}
}
else if(isset($_POST['update']) && $_POST['update']!="") // update project
{
$pid=$_POST['update'];
$update_project="UPDATE company SET company_name='".$_POST['company_name2']."', company_address='".$_POST['company_address']."',company_postcode='".$_POST['company_postcode']."',company_phone='".$_POST['company_phone']."' ,company_email='".$_POST['company_email']."'WHERE company_id='$pid'";
$run_update_project=mysqli_query($con,$update_project);
}
else if(isset($_POST['delete2']) && $_POST['delete2']!="")
{
$pid=$_POST['delete2'];
$update_project="UPDATE company SET status='3' WHERE company_id='$pid'";
$run_update_project=mysqli_query($con,$update_project);
echo '
Company 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 company SET status='$s_value' WHERE company_id='$pid'";
$run_project=mysqli_query($con,$update_post);
}
else
{}
?>
Company Info
Company successfully deactivated.
';
}
else
{}
?>
| No | Company Name | Company Address | Company Postcode | Created | Status | Action |
|---|---|---|---|---|---|---|
| '.$company_phone;
echo ' '.$company_email; ?> |
|