anuradhu

Wow !! thanks a ton !! The problem is exactly that - comp->pvc is string(5) "EMPTY"

Here is the code if ($comp -> pvc[$real_bas_id]['name']!="") continue; $tpl -> setVariable(array( 'BAS' => $real_bas_info['name'], 'BAS_ID'=> $real_bas_id, )); and here is what i see when i try to dump the REAL_BAS_ID array array(23) { [7]=> array(1) { ["name"]=> string(11) "value" } [14]=> array(1) { ["name"]=> string(12) "value" } [23]=> array(1) { ["name"]=> string(13) "value" } [1]=> array(1) { ["name"]=> string(17) "value" } [20]=> array(1) { ["name"]=> string(18) "value" } [6]=> array(1) { ["name"]=> string(15) "value" } [13]=> array(1) { ["name"]=> string(16) "value" } [10]=> array(1) { ["name"]=> string(11) "value" } [19]=> array(1) { ["name"]=> string(12) "value" } [9]=> array(1) { ["name"]=> string(6) "value" } [17]=> array(1) { ["name"]=> string(7) "value" } [3]=> array(1) { ["name"]=> string(9) "value" } [21]=> array(1) { ["name"]=> string(10) "value" } [8]=> array(1) { ["name"]=> string(10) "value" } [15]=> array(1) { ["name"]=> string(11) "value" } [4]=> array(1) { ["name"]=> string( "value" } [16]=> array(1) { ["name"]=> string(9) "value" } [5]=> array(1) { ["name"]=> string(7) "value } [12]=> array(1) { ["name"]=> string( "value" } [22]=> array(1) { ["name"]=> string(9) "value" } [11]=> array(1) { ["name"]=> string(4) "value" } [2]=> array(1) { ["name"]=> string(7) "value" } [18]=> array(1) { ["name"]=> string( "value" } }

Could someone here explain me the reason for this error in detail..... FYI - i am just more than a fresher in PHP..... Fatal error: Cannot use string offset as an array

Thanks for all your help!! The last post helped me resolve the issue.

When i make the code like this $this -> $what = addslashes($value); I receive the following error: Fatal error: Cannot access empty property in /export/web/application/engine/employee.class on line 223

Hi - thanks for the reply... I am almost sure that the code i have placed here is causing the problem since this is the flow - i tryed to insert manual breakpoints and figured out the flow.. The query should actually be like this, i.e i have changed the value of the employee_firstname in the form UPDATE employee SET last_change=now(),employee_firstname = 'newvalue',updated='0' WHERE id='143525' where as it is like this ---- the values from the form are placed into the object and then the object is looped to frame the query.. UPDATE employee SET last_change=now(),updated='0' WHERE id='143525'

I added this code and I see a list of NOTICE items displayed. When i try to hardcode the Update query, it works without any problem and even with this dynamically generated query the only problem is that the variable values are not populated; the Update query gets executed just with the initial query.

thank you i did this.... but - do you still have any other clue for my problem? pls...

Ah - I missed to mention this I am using the below code to generate the values into a local scope from the FORM POST - to cope with the migration to PHP 5. foreach ($_REQUEST as $field => $value) { $$field = $value; }

Ok- i have made the changes you suggested - but still my problem is not yet resolved

Hi anupamsaha i tried your change - but eventually it just assigns the variable name to the $this->this_field;

Sorry -here is teh code.... class teleworking_employee{ var $lang = 'nl'; var $error = ''; var $error_nr = ''; var $dbh = ''; var $employee_id = ''; var $employee_name = ''; var $employee_firstname = ''; var $company_id = ''; var $project_id = ''; var $employee_fields = array( 'id', 'last_change','first_entry', 'company_id','project_id', 'name','firstname', 'phone', 'comment', 'updated'); /** * constructor: * set the language * @param language, database handle, company_id[,project_id] * @return void **/ function teleworking_employee($lang,$dbh,$company_id,$project_id=''){ $this -> lang = $lang; $this -> dbh = $dbh; $this -> company_id = $company_id; if($project_id != ''){ $this -> project_id = $project_id; } } function get_employee_info($employee_id,$company_id = ''){ if(!$company_id){ $company_id = $this -> company_id; } $query = "SELECT id, last_change, first_entry, company_id, project_id, name, firstname, phone, deleted, comment, updated, billed FROM employee WHERE company_id='$company_id' AND id='$employee_id'"; if($this -> project_id != ''){ $query .= " AND project_id='".$this -> project_id."'"; } //print $query; #$get = mysql_query($query,$this -> dbh); $get = mysql_query($query); if(mysql_num_rows($get)){ $result = mysql_fetch_object($get); foreach($this -> employee_fields as $key => $field){ if($field == 'id'){ $field = 'project_'.$field; } $this_field = 'employee_'.$field; $this -> $this_field = stripslashes($result -> $field); } return TRUE; }else{ $this -> error .= 'no employee found'; $this -> error_nr = ''; return FALSE; } } function change_employee_info($employee_id){ $query = 'UPDATE '; return $this -> do_query($query,$employee_id); } function set_value($what,$value){ if($what == 'employee_phone'){ $value = preg_replace('/[^\d]/','',$value); } $this -> what = addslashes($value); } } }

The class is a very huge one -i have included the member variable declaration and the methods used in my code....here class teleworking_employee{ var $lang = 'nl'; var $error = ''; var $error_nr = ''; var $dbh = ''; var $employee_id = ''; var $employee_name = ''; var $employee_firstname = ''; var $company_id = ''; var $project_id = ''; var $employee_fields = array( 'id', 'last_change','first_entry', 'company_id','project_id', 'name','firstname', 'phone', 'comment', 'updated'); /** * constructor: * set the language * @param language, database handle, company_id[,project_id] * @return void **/ function teleworking_employee($lang,$dbh,$company_id,$project_id=''){ $this -> lang = $lang; $this -> dbh = $dbh; $this -> company_id = $company_id; if($project_id != ''){ $this -> project_id = $project_id; } } function get_employee_info($employee_id,$company_id = ''){ if(!$company_id){ $company_id = $this -> company_id; } $query = "SELECT id, last_change, first_entry, company_id, project_id, name, firstname, phone, deleted, comment, updated, billed FROM employee WHERE company_id='$company_id' AND id='$employee_id'"; if($this -> project_id != ''){ $query .= " AND project_id='".$this -> project_id."'"; } //print $query; #$get = mysql_query($query,$this -> dbh); $get = mysql_query($query); if(mysql_num_rows($get)){ $result = mysql_fetch_object($get); foreach($this -> employee_fields as $key => $field){ if($field == 'id'){ $field = 'project_'.$field; } $this_field = 'employee_'.$field; $this -> $this_field = stripslashes($result -> $field); } return TRUE; }else{ $this -> error .= 'no employee found'; $this -> error_nr = ''; return FALSE; } } function change_employee_info($employee_id){ $query = 'UPDATE '; return $this -> do_query($query,$employee_id); } function set_value($what,$value){ if($what == 'employee_phone'){ $value = preg_replace('/[^\d]/','',$value); } $this -> what = addslashes($value); } } }

Thank you all... i have tried changing this -- $field=$this->this_field; this returns me empty string.

This is the code of the that manipulates the data from the form ----------------------------------------------------------------------------------------------------------------------------------------- if($empl = new tel_employee('en',$dbh,$company_id)){ //get employee info $empl->get_employee_info($employee_id,$company_id); //change the info for that employee_id in the db foreach($employee_fields as $key => $field){ $post_field=$field; if($field == 'id'){ $field = 'employee_id'; } $value = $$field; $new_field = 'employee_'.$field; $empl -> set_value($new_field,$value); } #change the info for employee if(!($empl -> change_employee_info($employee_id))){ error('change employee '.$empl -> error); }else{ echo 'Success'; } } } ----------------------------------------------------------------------------------------------------------------------------------------- This is code which forms the query for update ----------------------------------------------------------------------------------------------------------------------------------------- function do_query($query,$update = 0){ $query .= "employee SET "; //look if any of the fields have a value and change them if so foreach($this -> employee_fields as $key => $field){ $this_field = 'employee_'.$field; if($this -> $this_field != ''){ $query .= "$field='".$this -> $this_field."',"; } } if($update){ //we are updating an existing employee $query .= " WHERE id='$update'"; } else{ //adding a new employee, set the initial date $query .= ",first_entry=now(),split_plan_new_status = '1'"; } if(mysql_query($query)){ $this -> employee_id = $update; return $update; } else{ $this -> error .= 'something wrong with the query : '.$query.'<br>'.mysql_error(); $this -> error_nr = ''; return FALSE; } } -----------------------------------------------------------------------------------------------------------------------------------------