| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/hkosl.com/dirsignage/html/webadmin/ |
Upload File : |
<?php
include 'config.php';
// Check if the user is logged in
if ((!isSet($_SESSION['loginname'])) || ($loggin <> '1')) {
header("Location: login.php");
exit;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>告示牌內容管理系統</title>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<!-- Main Menu -->
<link rel="stylesheet" type="text/css" href="css/menu.css"/>
<script type="text/javascript" src="js/jquery-1.11.1.min.js"></script>
<script type="text/javascript" src="js/jquery-migrate-1.2.1.min.js"></script>
<script type="text/javascript" src="js/ddaccordion.js"></script>
<script type="text/javascript" src="js/menuddaccordion.js"></script>
<!-- End Main Menu -->
<script type="text/javascript">
function DeleteRow(id) {
if (confirm("確定刪除這個記錄?")) {
window.location.href = 'company_delete.php?id=' + id;
}
}
</script>
</head>
<body>
<table width="1000" height="600" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200" align="left" valign="top">
<table width="200" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="70" align="left" valign="middle"> </td>
</tr>
<tr>
<td width="200" align="left" valign="top"><!-- Main Menu -->
<?php require("menu.php");?><!-- End Main Menu --></td>
</tr>
</table>
</td>
<td width="800" align="left" valign="top">
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="70" class="pagetitletxt"> </td>
<td width="50" align="center" class="icontxt">
<a href="company_addform.php"><img src="images/iconNew.png" alt="新增" width="32" height="32" border="0"/><br/> 新增
</a></td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="pagetitletxt">
<b><img src="images/iconList.jpg" width="48" height="48" align="absmiddle"/> 公司</b>
</td>
</tr>
<tr>
<td height="25" align="left" valign="middle" class="msg"><?php if (!empty($_GET["msg"])) echo $_GET['msg']; ?></td>
</tr>
<tr>
<td align="left" valign="middle">
<!--<form name="company_sort_update" method="post" action="company_sort_update.php" enctype="multipart/form-data">-->
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" class="listtitletxt"></td>
<!--<td width="40" class="listtitletxt">Sort</td>-->
<td width="50" class="listtitletxt">樓層</td>
<td width="50" class="listtitletxt">室號</td>
<td width="250" class="listtitletxt">公司名稱</td>
<td width="250" class="listtitletxt">公司商標</td>
<td width="30" class="listtitletxt"></td>
<td width="30" class="listtitletxt"></td>
<td width="30" class="listtitletxt"></td>
</tr>
<?php
$sql = "SELECT * FROM company where deleted = ? ORDER BY floor ASC, companyname_en ASC ";
$sth = $dbh->prepare($sql);
if (!$sth->execute(array("0")))
throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
print "<tr>";
print "<td class='listtxt' style='padding-left:5'> </td>";
//print "<td class='listtxt' valign='middle' align='left'><input class='sortinput' type='text' name='idarraynumber[]' value='" . $row{'sort'} . "' size='2' /><input type='hidden' name='idarray[]' value='" . $row{'id'} . "'></td>";
print "<td class='listtxt' style='padding-left:5'>" . $row{'floor'} . "</td>";
print "<td class='listtxt' style='padding-left:5'>" . $row{'room_no'} . "</td>";
if ($row{'companyname_en'} <> '') {
print "<td class='listtxt' style='padding-left:5'>" . $row{'companyname_en'} . "</td>";
} else if ($row{'companyname_tc'} <> '') {
print "<td class='listtxt' style='padding-left:5'>" . $row{'companyname_tc'} . "</td>";
} else {
print "<td class='listtxt' style='padding-left:5'>" . $row{'companyname_sc'} . "</td>";
}
if ($row{'logo'} <> '') {
print "<td class='listtxt' style='padding-left:5'><img src='../images/company_logo/" . $row{'logo'} . "' style='width:200px;'/></td>";
} else {
print "<td class='listtxt' style='padding-left:5'></td>";
}
//Status
print "<td class='listtxt' align='center'>";
if ($row{'status'} == '1') // Enable
{
print "<a href='company_status.php?id=" . $row{'id'} . "'>顯示</a>";
} else // Disable
{
print "<a href='company_status.php?id=" . $row{'id'} . "'>隱藏</a>";
}
print "</td>";
// Modify
print "<td class='listtxt' align='center'><a href='#' onClick=\"window.location='company_modifyform.php?id=" . $row{'id'} . "'\">修改</a></td>";
// Delete
print "<td class='listtxt' align='center'><a href='#' onClick=\"DeleteRow(" . $row{'id'} . ")\">刪除</a></td>";
print "</tr>";
}
$dbh = null;
?>
</table>
<!--<input type="submit" value="Update Sort"></form>-->
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>