• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
access variable from different method within same model class

#1
[eluser]ranjitbd[/eluser]
// this is a model class
class Holiday_model extends Model
{
function Holiday_model()
{
parent::Model();
$this->load->database('holiday', TRUE);
}

function view_package()
{
$sql = "select * from package_details";
// i want to use this $sql in the method get_package_details()mentioned below

$query = $this->db->query($sql);
return $query->result_array();
}

function get_package_details($id)
{
// here how can i access the $sql from view_package() method mentioned above.and set it within $new_sql

$new_sql = ;//please write here the code

$row = $new_sql." where id = '$id'";

$query = $this->db->query($row);
return $query->row_array();
}

}
?>

#2
[eluser]Krzemo[/eluser]
Code:
// this is a model class
class Holiday_model extends Model
{
  var $sql;

  function Holiday_model()
  {
      parent::Model();
      $this->load->database(‘holiday’, TRUE);
  }

  function view_package()
  {
      $this->sql = “select * from package_details”;
      $query = $this->db->query($this->sql);
      return $query->result_array();
  }

  function get_package_details($id)
  {
      $new_sql = $this->sql;//please write here the code

      $row =  $new_sql.” where id = ‘$id’”;
    
      $query = $this->db->query($row);
      return $query->row_array();
  }

}
?>
I'd dont see any point in doing it this way. IMHO it only complicates the code and makes it harder to maintain.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.