"; $y=0; foreach ($dbo->query($sql) as $row) { $y=$y+1; if ($row['target_name_BirthCertificate']<>'') { $birthcertfileextension = substr($row['target_name_BirthCertificate'], -3); if ($birthcertfileextension == 'pdf') {$birthcert = 'PDF';} else {$birthcert = "";} } else {$birthcert='NA';} if (($row['target_name_CasteCertificate']=='Not Applicable') || (empty($row['target_name_CasteCertificate']))) {$castecert='NA';} else {$castecert="";} if ($row['target_name_DisabilityCertificate']<>'Not Applicable') {$disabilitycert="";} else {$disabilitycert='NA';} $dir=$row['mob_no']; echo ""; } echo "
no currentTimestamp memberId candidate_name candidate_parent c_address p_address same_add dob age education otherEducation mob_no email category physicallyDisabled gender income target_dir_photo target_name_photo photo target_dir_BirthCertificate target_name_BirthCertificate birthcertificate target_dir_DisabilityCertificate target_name_DisabilityCertificate disabilitycertificate target_dir_CasteCertificate target_name_CasteCertificate castecertificate isTakingBus busRouteCode busRoute activity1Code activity2Code activity1 activity2 membershipFee busFee totalFee paymentsId memberId payment_status buyer_name payment_id payment_request_id amount buyer_email buyer_phone created_at currentTimestamp
$y $row[currentTimestamp] $row[memberId] $row[candidate_name] $row[candidate_parent] $row[c_address] $row[p_address] $row[same_add] $row[dob] $row[age] $row[education] $row[otherEducation] $row[mob_no] $row[email] $row[category] $row[physicallyDisabled] $row[gender] $row[income] $row[target_dir_photo] $row[target_name_photo] $row[mob_no] $row[target_name_BirthCertificate] $birthcert $row[target_dir_DisabilityCertificate] $row[target_name_DisabilityCertificate] $disabilitycert $row[target_dir_CasteCertificate] $row[target_name_CasteCertificate] $castecert $row[isTakingBus] $row[busRouteCode] $row[busRoute] $row[activity1Code] $row[activity2Code] $row[activity1] $row[activity2] $row[membershipFee] $row[busFee] $row[totalFee] $row[paymentsId] $row[memberId] $row[payment_status] $row[buyer_name] $row[payment_id] $row[payment_request_id] $row[amount] $row[buyer_email] $row[buyer_phone] $row[created_at] $row[currentTimestamp]
"; ?>