<?php
require_once '../include.php';
checkLogined();
//$rows=getAllCate();
// if(!$rows){
// alertMes("No type of user being selected!", "addCate.php");
// }
$id = $_REQUEST['id'];
// �����house_id��ȷ������idȡ����tg_house_img��id��ֵ���������������
// ��Ϊ�� request ��һ��ҳ�������id����ˣ��������ֱ����$id, �������п���ʡ��
$sql = "select * from tg_host_house where house_id={$id}";
$row = fetchOne($sql);
//get the house information by house_id
$houseInfo_cal = getHouseById($id);
$houseInfo_cal['update_time'] = date("Y-m-d H:i:s");
//print_r($row);
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>-.-</title>
<link href="./styles/global.css" rel="stylesheet" type="text/css" media="all" />
<script type="text/javascript" charset="utf-8" src="../plugins/kindeditor/kindeditor.js"></script>
<script type="text/javascript" charset="utf-8" src="../plugins/kindeditor/lang/zh_CN.js"></script>
<script type="text/javascript" src="./scripts/jquery-1.6.4.js"></script>
<script>
KindEditor.ready(function(K) {
window.editor = K.create('#editor_id');
});
<?php
require 'auth.php';
require 'dbadapter.php';
// fetch house info for logged in user
$userRow = mysql_fetch_row(getUserByName($username));
$userHouseId = $userRow[5];
$houseRow = mysql_fetch_row(getHouseById($userHouseId));
//house details
$houseName = $houseRow[1];
$houseRent = $houseRow[3];
$houseSqft = $houseRow[4];
include_once 'header.php';
?>
<h2>House View</h2>
<p>You live in your house, <?php
echo $houseName;
?>
</p>
<?php
if ($houseSqft) {
echo "<p>Your house is {$houseSqft} sq. ft. in size</p>";
}
?>
<p>Your rent is <?php
echo $houseRent;
?>
</p>
<a href="http://localhost/mates/home.php">Home</a>
<?php
include_once 'footer.php';
