how can i fix this?

[babansky]

ERROR:
Undefined property: form_all_single_record_table_apl::$add_sitio
Undefined property: form_all_single_record_table_apl::$unmarried_lname
Undefined offset: 6

[TheServant]

We need some code to look at. Preferably code that is around where this problem occurs.

Basically that error comes up when you have not given a variable you're trying to use a value.

[babansky]

sc_exec_sql("DELETE from pdf_temp_table");
 
 
$rank = {rank};
$afpsn = {afpsn};
$lname = {lname};
$fname = {fname};
$mname = {mname};
$add_num = {add_num};
$add_street = {add_street};
$add_sito = {add_sito};
$add_brgy = {add_brgy};
$add_province = {add_brgy};
$add_region = {add_region};
$add_postal = {add_postal};
$position = {position};
$income = {income};
$tin = {tin};
$com_cert_no = {com_cert_no};
$ofc_add_num = {ofc_add_num};
$ofc_add_street = {ofc_add_street};
$ofc_add_sitio = {ofc_add_sitio};
$ofc_add_brgy = {ofc_add_brgy};
$ofc_add_cty = {ofc_add_cty};
$ofc_add_province = {ofc_add_province};
$ofc_add_region = {ofc_add_region};
$ofc_add_postal = {ofc_add_postal};
$ofc_name = {ofc_name};
$spouse_lname = {spouse_lname};
$spouse_fname = {spouse_fname};
$spouse_mname = {spouse_mname};
$spouse_position = {spouse_position};
$spouse_ofc_name = {spouse_ofc_name};
$spouse_tin = {spouse_tin};
$spouse_com_cert_no = {com_cert_no};
$total_networth = {total_networth};
$oath_lname = {oath_lname};
$oath_fname = {oath_fname};
$oath_mname = {oath_mname};
$oath_designation = {oath_designation};
$issued_at = {issued_at};
$oath_dte = {oath_dte};
$printing_dte = {printing_dte};
$business_interest = {business_interest};
$irgs_working_in_government = {irgs_working_in_government};
$assets_real_total = {assets_real_total};
$assets_pop_total = {assets_pop_total};
$liabilities_total = {liabilities_total};
$assets_pop_kind = {assets_pop_kind};
$assets_pop_yr_acquired = {assets_pop_yr_acquired};
$assets_pop_cost = {assets_pop_cost};
$assets_real_kind = {assets_real_kind};
$assets_real_location = {assets_real_location};
$assets_real_yr_acquired = {assets_real_yr_acquired};
$assets_real_mode_acquisition = {assets_real_mode_acquired};
$assets_real_nature_property = {assets_real_nature_property};
$assets_real_assessed_value = {assets_real_assessed_value};
$assets_real_fair_value = {assets_real_fair_value};
$assets_real_cost_bldg = {assets_cost_bldg};
$assets_real_cost_improvements = {assets_real_cost_improvements};
$bifc_lname = {bifc_lname};
$bifc_fname = {bifc_lname};
$bifc_mname = {bifc_mname};
$bifc_company_name = {bifc_company_name};
$bifc_company_add = {bifc_company_add};
$bifc_nature_business_interest = {bifc_nature_business_interest};
$bifc_financial_connection = {bifc_financial_connection};
$bifc_dte_acquisition = {bifc_dte_acquisition};
$bifc_yr_acquisition = {bifc_yr_acquisition};
$liabilities_nature = {liabilities_nature};
$liabilities_creditors_name = {liabilities_creditors_name};
$liabilities_amount = {liabilities_amount};
$irgs_lname = {irgs_lname};
$irgs_fname = {irgs_fname};
$irgs_mname = {irgs_mname};
$irgs_relationship = {irgs_relationship};
$irgs_office_name = {irgs_office_name};
$irgs_office_add = {irgs_office_add};
$unmarried_lname = {unmarried_lname};
$unmarried_fname = {unamrried_fname};
$unmarried_mname = {unmarried_mname};
$unmarried_birth_dte = {unmarried_birh_dte};
 
 
sc_exec_sql("INSERT INTO pdf_temp_table(rank, 
                    afpsn, 
                    lname, 
                    fname, 
                    mname,
                    add_num, 
                    add_street, 
                    add_sito, 
                    add_brgy, 
                    add_city, 
                    add_province, 
                    add_region, 
                    add_postal, 
                    position, 
                    income, 
                    tin, 
                    com_cert_no, 
                    ofc_add_num, 
                    ofc_add_street, 
                    ofc_add_sitio,
                    ofc_add_brgy, 
                    ofc_add_cty, 
                    ofc_add_province, 
                    ofc_add_region,
                    ofc_add_postal, 
                    ofc_name, 
                    spouse_lname, 
                    spouse_fname, 
                    spouse_mname,
                    spouse_position, 
                    spouse_ofc_name, 
                    spouse_tin, 
                    spouse_com_cert_no,
                    total_networth, 
                    oath_lname, 
                    oath_fname, 
                    oath_mname, 
                    oath_designation,
                    issued_at, 
                    oath_dte, 
                    printing_dte, 
                    business_interest, 
                    irgs_working_in_government,
                    assets_real_total, 
                    assets_pop_total, 
                    liabilities_total, 
                    assets_pop_kind,
                    assets_pop_yr_acquired,
                    assets_pop_cost,
                    assets_real_kind, 
                    assets_real_location,
                    assets_real_yr_acquired, 
                    assets_real_mode_acquisition,
                    assets_real_nature_property, 
                    assets_real_assessed_value, 
                    assets_real_fair_value,
                    assets_real_cost_bldg, 
                    assets_real_cost_improvements,
                    bifc_lname, 
                    bifc_fname, 
                    bifc_mname, 
                    bifc_company_name, 
                    bifc_company_add,
                    bifc_nature_business_interest, 
                    bifc_financial_connection,
                    bifc_dte_acquisition, 
                    bifc_yr_acquisition, 
                    liabilities_nature,
                    liabilities_creditors_name, 
                    liabilities_amount, 
                    irgs_lname,
                    irgs_fname, 
                    irgs_mname, 
                    irgs_position, 
                    irgs_relationship,
                    irgs_office_name, 
                    irgs_office_add, 
                    unmarried_lname, 
                    unmarried_fname,
                    unmarried_mname, 
                    unmarried_birh_dte
                    )
        values('$rank', 
            '$afpsn', 
            '$lname', 
            '$fname', 
            '$mname',
            '$add_num', 
            '$add_street', 
            '$add_sito', 
            '$add_brgy', 
            '$add_city', 
            '$add_province', 
            '$add_region', 
            '$add_postal', 
            '$position', 
            '$income', 
            '$tin', 
            '$com_cert_no', 
            '$ofc_add_num', 
            '$ofc_add_street',
            '$ofc_add_sitio',
            '$ofc_add_brgy', 
            '$ofc_add_cty', 
            '$ofc_add_province', 
            '$ofc_add_region',
            '$ofc_add_postal', 
            '$ofc_name', 
            '$spouse_lname', 
            '$spouse_fname', 
            '$spouse_mname',
            '$spouse_position', 
            '$spouse_ofc_name', 
            '$spouse_tin', 
            '$spouse_com_cert_no',
            '$total_networth',
            '$oath_lname', 
            '$oath_fname', 
            '$oath_mname', 
            '$oath_designation',
            '$issued_at', 
            '$oath_dte', 
            '$printing_dte', 
            '$business_interest', 
            '$irgs_working_in_government',
            '$assets_real_total', 
            '$assets_pop_total', 
            '$liabilities_total', 
            '$assets_pop_kind',
            '$assets_pop_yr_acquired', 
            '$assets_pop_cost', 
            '$assets_real_kind', 
            '$assets_real_location', 
            '$assets_real_yr_acquired',
            '$assets_real_mode_acquisition',
            '$assets_real_nature_property', 
            '$assets_real_assessed_value', 
            '$assets_real_fair_value',
            '$assets_real_cost_bldg', 
            '$assets_real_cost_improvements',
            '$bifc_lname', 
            '$bifc_fname', 
            '$bifc_mname', 
            '$bifc_company_name', 
            '$bifc_company_add',
            '$bifc_nature_business_interest', 
            '$bifc_financial_connection',
            '$bifc_dte_acquisition', 
            '$bifc_yr_acquisition', 
            '$liabilities_nature',
            '$liabilities_creditors_name', 
            '$liabilities_amount', 
            '$irgs_lname',
            '$irgs_fname', 
            '$irgs_mname', 
            '$irgs_position', 
            '$irgs_relationship',
            '$irgs_office_name', 
            '$irgs_office_add', 
            '$unmarried_lname', 
            '$unmarried_fname',
            '$unmarried_mname', 
            '$unmarried_birh_dte'
            )");
 
echo $unmarried_lname;
 
//sc_redir(print_saln.php);

->here is my code

[code green]

$add_sitio
$unmarried_lname
are not defined in your code

[babansky]

how can i define them..?

$ofc_add_sitio = {ofc_add_sitio};
$unmarried_lname = {unmarried_lname};

-are these codes didnt define them??

[TheServant]

You're using a templating engine or something: {rank} is not normal PHP. I imagine that where ever {ofc_add_sitio} and {unmarried_lname} are defined is where your problem is. Can you explain a bit more about that?

Also, put any code in [code] tags so they read easier on the forum.