how can i fix this?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • babansky
    New Member
    • Aug 2010
    • 7
    #1

    how can i fix this?

    ERROR:
    Undefined property: form_all_single _record_table_a pl::$add_sitio
    Undefined property: form_all_single _record_table_a pl::$unmarried_ lname
    Undefined offset: 6
    Tags: None
    • TheServant
      Recognized Expert Top Contributor
      • Feb 2008
      • 1168
      #2
      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.

        Comment

        • babansky
          New Member
          • Aug 2010
          • 7
          #3
          Please use [code] tags when posting code!

          Code:
          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
          Last edited by Atli; Sep 1 '10, 05:22 PM.

            Comment

            • code green
              Recognized Expert Top Contributor
              • Mar 2007
              • 1726
              #4
              $add_sitio
              $unmarried_lnam e
              are not defined in your code

                Comment

                • babansky
                  New Member
                  • Aug 2010
                  • 7
                  #5
                  how can i define them..?

                  $ofc_add_sitio = {ofc_add_sitio} ;
                  $unmarried_lnam e = {unmarried_lnam e};

                  -are these codes didnt define them??

                    Comment

                    • TheServant
                      Recognized Expert Top Contributor
                      • Feb 2008
                      • 1168
                      #6
                      You're using a templating engine or something: {rank} is not normal PHP. I imagine that where ever {ofc_add_sitio} and {unmarried_lnam e} 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.

                        Comment

                        Previous template Next
                        Working...