Code:
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Places_model extends CI_Model
{
public $place_results;
public $ad_details;
function load_places()
{
$query = " SELECT ad_have.id AS AID,
title,
comments,
date_added,
suburb,
city,
city.name AS cn,
suburb
FROM ad_have
INNER JOIN city
ON city.id = ad_have.city
INNER JOIN members
ON members.id = ad_have.member_id
ORDER BY date_added DESC
LIMIT 40 ";
$places= $this->db->query($query);
foreach ($places->result() as $row)
{
$this->place_results[]= array('AID'=>$row->AID,'title'=>$row->title, 'city'=>$row->cn, 'date_added'=>$row->date_added
, 'suburb'=>$row->suburb);
}
return $this->place_results;
}
function place_details($ad_id)
{
$query = " SELECT ad_have.id AS AID,
title,
comments,
date_added,
suburb,
city,
city.name AS cn,
suburb,
weekly_rent,
ad_have.smoke,
ad_have.views,
security_bond,
furnished,
building_type,
washer_dryer,
tv,
pet,
carpark,
internet,
own_bathroom,
aircondition,
address
FROM ad_have
INNER JOIN city
ON city.id = ad_have.city
INNER JOIN members
ON members.id = ad_have.member_id
WHERE ad_have.id =?
AND active = ? ";
$result = $this->db->query($query, array($ad_id, 'y'));
if($result->num_rows()!=1)
{
return false;
}
else
{
$details = $result->result();
$this->ad_details = array('cn'=>$details[0]->cn,
'comments'=>$details[0]->comments,
'AID'=>$details[0]->AID,
'title'=>$details[0]->title,
'city'=>$details[0]->cn,
'date_added'=>$details[0]->date_added,
'weekly_rent'=>$details[0]->weekly_rent,
'smoke'=>$details[0]->smoke,
'suburb'=>$details[0]->suburb,
'security_bond'=>$details[0]->security_bond,
'views'=>$details[0]->views,
'furnished'=>$details[0]->furnished,
'washer_dryer'=>$details[0]->washer_dryer,
'tv'=>$details[0]->tv,
'carpark'=>$details[0]->carpark,
'internet'=>$details[0]->internet,
'own_bathroom'=>$details[0]->own_bathroom,
'aircondition'=>$details[0]->aircondition,
'address'=>$details[0]->address,
'building_type'=>$details[0]->building_type,
'pet'=>$details[0]->pet
);
return $this->ad_details;
}
}
}