<label class="control-label" for="product-picture">Product Picture</label>
<span class="btn-file file-input btn btn-block btn-primary">
Browse <input name="picture" type="file">
</span>
</div>
<label class="control-label" for="name">Ext</label>
<div class="controls">
<input type="text" id="name" value=' . $row[5] . ' name="ext" placeholder="" class="form-control input-lg">
</div>
<label class="control-label" for="room">Room</label>
<select name="room_id">';
include_once '../classes/db_connection.php';
include_once '../classes/room.php';
$room = new room();
$rooms = $room->select_rooms();
//print_r($rooms);
while ($row = mysqli_fetch_array($rooms)) {
echo " <option name='room_id' value='{$row['0']}'>" . $row[1] . "</option>";
}
?>
</select>
<div class="control-group">
<!-- Button -->
<div class="controls">
<button class="btn btn-success" >Save</button>
<input type="reset" class="btn btn-warning"/>
</div>
</div>
public function getRooms()
{
return $this->hasMany(room::className(), ['building_id' => 'id']);
}
<?php require_once './room.php'; require_once './jsonAdapterRoom.php'; require_once './remoteAdapterRoom.php'; $list = new room(); $list->roomList(new jsonAdapterRoom()); $list->roomList(new remoteAdapterRoom());
<?php require_once './room.php'; $list = new room(); $list->roomList(); $list->roomList();
function del($id)
{
$room = room::find($id);
return $room->delete();
}
<caption>未来3天内各会场使用情况</caption>
<thead>
<tr >
<th>会议室</th>
<th>容量</th>
<th>状态</th>
<th>投影仪</th>
<th>话筒</th>
<th>写字板</th>
<th>详情</th>
</tr>
</thead>
<tbody>
<?php
$row = new room();
$total_arr = array();
for ($i = 0; $i < $num; $i++) {
$single = $re[$i];
$arr = change($single);
$total_arr[$i] = $arr;
$row->initRoom($single, $arr);
?>
<tr>
<td><?php
<?php
if (session_status() == PHP_SESSION_NONE) {
session_start();
}
/** MySQL database password */
define('DB_PASS', '2sJrDmQnhahzSCjM');
include_once 'functions.php';
if (isset($_SESSION["APP"]["room"])) {
$room = new room($_SESSION["APP"]["room"]);
$building = new building($room->getBuildingID());
$_SESSION["APP"]["building"] = $building->getID();
$_SESSION["APP"]["campus"] = $building->getCampusID();
}
<div id="legend">
<legend class="">All Users</legend>
<a href="#"><span class="add"> Add User</span></a>
</div>
<div class="table-responsive" id="mytable">
<table class="table" >
<th>Name</th>
<th>Room</th>
<th>Image</th>
<th>Ext</th>
<th>Action</th>
<?php
include_once '../classes/db_connection.php';
include_once '../classes/users.php';
include_once '../classes/room.php';
$room = new room();
$users = new users();
$page = isset($_GET['page']) ? $_GET['page'] : 1;
if ($page == "" || $page == "1") {
$page1 = 0;
} else {
$page1 = $page * 5 - 5;
}
$query = $users->select_all_users($page1);
$count = mysqli_num_fields($query);
$counting = ceil($count / 5);
while ($row = mysqli_fetch_array($query)) {
echo "<tr> \n\t<td> {$row['1']}</td>";
$rooms = $room->select_room($row[6]);
while ($row1 = mysqli_fetch_array($rooms)) {
echo " <td>{$row1['1']}</td> ";
public function getRoom()
{
return $this->hasOne(room::className(), ['id' => 'room_id']);
}
