SEARCH PLANHOLDER
";
echo "ENTER CONTRACT NO. : ";
echo "";
echo "
";
}
while ($row=mysql_fetch_assoc($result))
{
$contracts=$row["contractno"];
$plnames=$row["plastname"];
$pfnames=$row["pfirstname"];
$middlenames=$row["middlename"];
echo "CONTRACT NO. $contracts LASTNAME $plnames ";
echo "FIRSTNAME $pfnames ";
echo "MIDDLE NAME $middlenames ";
}
while ($row=mysql_fetch_assoc($result))
{
$tbranch=$row["branchname"];
$dates=$row["datesign"];
echo "BRANCHNAME $tbranch ";
echo "DATE $dates ";
}if (isset($_POST["optcontractno"]))
{
$cus=$_POST["optcontractno"];
$sql="SELECT contractno,plastname,pfirstname,middlename,datesign,branchname,lotstreet,brgy,citymunicipal,province,contactno,occupation,emailadd,religion,dob,age,sex,status,income,height,weight,namefirst,addressfirst,agefirst,relationfirst,namesecond,addresssecond,agesecond,
relationsecond,namethird,addressthird,agethird,relationthird,namefourth,addressfourth,agefourth,relationfourth,conttype,contprice,typepayment,amounttype,timetype,collecttype,ins,commissiontype,tatype,agentno,lastname,firstname,position,fsno,fslastname,fsfirstname,fsposition FROM planholder WHERE contractno='$cus'";
$result=mysql_query($sql,$con);
echo "";
echo "
";
}
while ($row=mysql_fetch_assoc($result))
{
$lotstreets=$row["lotstreet"];
$brgys=$row["brgy"];
$citys=$row["citymunicipal"];
$provinces=$row["province"];
echo "LOT/STREET $lotstreets ";
echo "BARANGAY $brgys ";
echo "CITY/MUNICIPAL $citys ";
echo "PROVINCE $provinces ";
}if (isset($_POST["optcontractno"]))
{
$cus=$_POST["optcontractno"];
$sql="SELECT contractno,plastname,pfirstname,middlename,datesign,branchname,lotstreet,brgy,citymunicipal,province,contactno,occupation,emailadd,religion,dob,age,sex,status,income,height,weight,namefirst,addressfirst,agefirst,relationfirst,namesecond,addresssecond,agesecond,
relationsecond,namethird,addressthird,agethird,relationthird,namefourth,addressfourth,agefourth,relationfourth,conttype,contprice,typepayment,amounttype,timetype,collecttype,ins,commissiontype,tatype,agentno,lastname,firstname,position,fsno,fslastname,fsfirstname,fsposition FROM planholder WHERE contractno='$cus'";
$result=mysql_query($sql,$con);
echo "";
echo "
";
}
while ($row=mysql_fetch_assoc($result))
{
$contacts=$row["contactno"];
$occupations=$row["occupation"];
$emails=$row["emailadd"];
$religions=$row["religion"];
echo "CONTACT NO. $contacts OCCUPATION $occupations ";
echo "E-MAIL ADDRESS $emails ";
echo "RELIGION $religions ";
}if (isset($_POST["optcontractno"]))
{
$cus=$_POST["optcontractno"];
$sql="SELECT contractno,plastname,pfirstname,middlename,datesign,branchname,lotstreet,brgy,citymunicipal,province,contactno,occupation,emailadd,religion,dob,age,sex,status,income,height,weight,namefirst,addressfirst,agefirst,relationfirst,namesecond,addresssecond,agesecond,
relationsecond,namethird,addressthird,agethird,relationthird,namefourth,addressfourth,agefourth,relationfourth,conttype,contprice,typepayment,amounttype,timetype,collecttype,ins,commissiontype,tatype,agentno,lastname,firstname,position,fsno,fslastname,fsfirstname,fsposition FROM planholder WHERE contractno='$cus'";
$result=mysql_query($sql,$con);
echo "";
echo "
";
}
while ($row=mysql_fetch_assoc($result))
{
$dobs=$row["dob"];
$ages=$row["age"];
$sexs=$row["sex"];
$statuss=$row["status"];
$incomes=$row["income"];
$heights=$row["height"];
$weights=$row["weight"];
echo "DATE OF BIRTH $dobs ";
echo "AGE $ages ";
echo "SEX $sexs ";
echo "STATUS $statuss INCOME $incomes ";
echo "HEIGHT $heights ";
echo "WEIGHT $weights ";
}if (isset($_POST["optcontractno"]))
{
$cus=$_POST["optcontractno"];
$sql="SELECT contractno,plastname,pfirstname,middlename,datesign,branchname,lotstreet,brgy,citymunicipal,province,contactno,occupation,emailadd,religion,dob,age,sex,status,income,height,weight,namefirst,addressfirst,agefirst,relationfirst,namesecond,addresssecond,agesecond,
relationsecond,namethird,addressthird,agethird,relationthird,namefourth,addressfourth,agefourth,relationfourth,conttype,contprice,typepayment,amounttype,timetype,collecttype,ins,commissiontype,tatype,agentno,lastname,firstname,position,fsno,fslastname,fsfirstname,fsposition FROM planholder WHERE contractno='$cus'";
$result=mysql_query($sql,$con);
echo "";
echo "
";
}
while ($row=mysql_fetch_assoc($result))
{$names1=$row["namefirst"];
$address1=$row["addressfirst"];
$ages1=$row["agefirst"];
$relations1=$row["relationfirst"];
echo "BENEFICIARY NAME $names1 ADDRESS $address1 ";
echo "AGE $ages1 ";
echo "RELATION $relations1 ";
}if (isset($_POST["optcontractno"]))
{
$cus=$_POST["optcontractno"];
$sql="SELECT contractno,plastname,pfirstname,middlename,datesign,branchname,lotstreet,brgy,citymunicipal,province,contactno,occupation,emailadd,religion,dob,age,sex,status,income,height,weight,namefirst,addressfirst,agefirst,relationfirst,namesecond,addresssecond,agesecond,
relationsecond,namethird,addressthird,agethird,relationthird,namefourth,addressfourth,agefourth,relationfourth,conttype,contprice,typepayment,amounttype,timetype,collecttype,ins,commissiontype,tatype,agentno,lastname,firstname,position,fsno,fslastname,fsfirstname,fsposition FROM planholder WHERE contractno='$cus'";
$result=mysql_query($sql,$con);
echo "";
echo "
";
}
while ($row=mysql_fetch_assoc($result))
{$names2=$row["namesecond"];
$address2=$row["addresssecond"];
$ages2=$row["agesecond"];
$relations2=$row["relationsecond"];
echo "BENEFICIARY NAME $names2 ADDRESS $address2 ";
echo "AGE $ages2 ";
echo "RELATION $relations2 ";
}if (isset($_POST["optcontractno"]))
{
$cus=$_POST["optcontractno"];
$sql="SELECT contractno,plastname,pfirstname,middlename,datesign,branchname,lotstreet,brgy,citymunicipal,province,contactno,occupation,emailadd,religion,dob,age,sex,status,income,height,weight,namefirst,addressfirst,agefirst,relationfirst,namesecond,addresssecond,agesecond,
relationsecond,namethird,addressthird,agethird,relationthird,namefourth,addressfourth,agefourth,relationfourth,conttype,contprice,typepayment,amounttype,timetype,collecttype,ins,commissiontype,tatype,agentno,lastname,firstname,position,fsno,fslastname,fsfirstname,fsposition FROM planholder WHERE contractno='$cus'";
$result=mysql_query($sql,$con);
echo "";
echo "
";
}
while ($row=mysql_fetch_assoc($result))
{$names3=$row["namethird"];
$address3=$row["addressthird"];
$ages3=$row["agethird"];
$relations3=$row["relationthird"];
echo "BENEFICIARY NAME $names3 ADDRESS $address3 ";
echo "AGE $ages3 ";
echo "RELATION $relations3 ";
}if (isset($_POST["optcontractno"]))
{
$cus=$_POST["optcontractno"];
$sql="SELECT contractno,plastname,pfirstname,middlename,datesign,branchname,lotstreet,brgy,citymunicipal,province,contactno,occupation,emailadd,religion,dob,age,sex,status,income,height,weight,namefirst,addressfirst,agefirst,relationfirst,namesecond,addresssecond,agesecond,
relationsecond,namethird,addressthird,agethird,relationthird,namefourth,addressfourth,agefourth,relationfourth,conttype,contprice,typepayment,amounttype,timetype,collecttype,ins,commissiontype,tatype,agentno,lastname,firstname,position,fsno,fslastname,fsfirstname,fsposition FROM planholder WHERE contractno='$cus'";
$result=mysql_query($sql,$con);
echo "";
echo "
";
}
while ($row=mysql_fetch_assoc($result))
{$names4=$row["namefourth"];
$address4=$row["addressfourth"];
$ages4=$row["agefourth"];
$relations4=$row["relationfourth"];
echo "BENEFICIARY NAME $names4 ADDRESS $address4 ";
echo "AGE $ages4 ";
echo "RELATION $relations4 ";
}if (isset($_POST["optcontractno"]))
{
$cus=$_POST["optcontractno"];
$sql="SELECT contractno,plastname,pfirstname,middlename,datesign,branchname,lotstreet,brgy,citymunicipal,province,contactno,occupation,emailadd,religion,dob,age,sex,status,income,height,weight,namefirst,addressfirst,agefirst,relationfirst,namesecond,addresssecond,agesecond,
relationsecond,namethird,addressthird,agethird,relationthird,namefourth,addressfourth,agefourth,relationfourth,conttype,contprice,typepayment,amounttype,timetype,collecttype,ins,commissiontype,tatype,agentno,lastname,firstname,position,fsno,fslastname,fsfirstname,fsposition FROM planholder WHERE contractno='$cus'";
$result=mysql_query($sql,$con);
echo "";
echo "
";
}
while ($row=mysql_fetch_assoc($result))
{
$ctypes=$row["conttype"];
$cprices=$row["contprice"];
$tpayment=$row["typepayment"];
$amounts=$row["amounttype"];
$times=$row["timetype"];
$places=$row["collecttype"];
$tcommissiontype=$row["commissiontype"];
$ttatype=$row["tatype"];
$tins=$row["ins"];
$tagentno=$row["agentno"];
$tlastname=$row["lastname"];
$tfirstname=$row["firstname"];
$tposition=$row["position"];
$tfsno=$row["fsno"];
$tfslastname=$row["fslastname"];
$tfsfirstname=$row["fsfirstname"];
$tfsposition=$row["fsposition"];
echo "CONTRACT TYPE $ctypes CONTRACT PRICE $cprices >";
echo "TYPE OF PAYMENT $tpayment ";
echo "AMOUNT $amounts ";
echo "INSURED TYPE $tins BEST TIME TO COLLECT $times BEST PLACE TO COLLECT $places ";
echo "AGENT COMMISSION $tcommissiontype ";
echo "TA COMMISSION $ttatype ";
echo "AGENT NO. $tagentno LASTNAME $tlastname ";
echo "FIRSTNAME $tfirstname ";
echo "POSITION $tposition ";
echo "FSS NO. $tfsno LASTNAME $tfslastname ";
echo "FIRSTNAME $tfsfirstname ";
echo "POSITION $tfsposition ";
}
echo "";
?>