<?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';