log.php

十大精典PHP项目开发全程案例+代码

<?php
	session_start();
	include "inc/chec.php";
	include "conn/conn.php";
?>
<table width="380" height="440" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td colspan="4" valign="top"><table width="380" height="60" border="0" cellpadding="0" cellspacing="0"  >
        <tr>
          <td height="20" colspan="4" align="center" valign="middle">上 传 日 志 管 理</td>
        </tr>
        <tr>
          <td colspan="4"><table width="375" border="0" align="center" cellpadding="0" cellspacing="0">
              <tr>
                <td height="10" colspan="5" align="right" valign="middle"><a href="#" onclick="javacript:Wopen=open('operation.php?action=l_found','添加目录','height=500,width=665,scrollbars=no');">日志查询</a></td>
              </tr>
              <tr>
                <td height="30" align="center" valign="middle">ID</td>
                <td height="30" align="center" valign="middle">数据名称</td>
                <td height="30" align="center" valign="middle">用户名</td>
                <td height="30" align="center" valign="middle">上传时间</td>
                <td height="30" align="center" valign="middle">操作</td>
              </tr>
              <?php
			    $years=date("Y");
				$months=date("m");
				
			  	switch ($_GET[types]){	
					case "all":
						$q_date = $years."-".$months."-".$_GET[days];
						$l_sqlstr="select id,name,userName,issueDate,type  from tb_audio where property='用户' and issueDate like '%".$q_date."%' Union select id,name,userName,issueDate,type from tb_video where property='用户' and issueDate like '%".$q_date."%'";
						break;
					case "audio":
						$q_date = $years."-".$months."-".$_GET[days];
						$l_sqlstr="select id,name,userName,issueDate,type,address from tb_audio where property='用户' and issueDate like '%".$q_date."%'";
						break;
					case "video":
						$q_date = $years."-".$months."-".$_GET[days];
			  			$l_sqlstr="select id,name,userName,issueDate,type,address from tb_video where property='用户' and issueDate like '%".$q_date."%'";
						break;
					default:
			  			$l_sqlstr="select id,name,userName,issueDate,type,address from tb_audio where property='用户' Union select id,name,userName,issueDate,type,address from tb_video where property='用户'";
						break;
				}
				$l_rst = $conn->execute($l_sqlstr);
				while(!$l_rst->EOF){ 
				?>
              <tr>
                <td height="18" align="center" valign="middle"><?php echo $l_rst->fields[0]; ?></td>
                <td height="18" align="center" valign="middle"><?php echo $l_rst->fields[1]; ?></td>
                <td height="18" align="center" valign="middle"><?php echo $l_rst->fields[2]; ?></td>
                <td height="18" align="center" valign="middle"><?php echo $l_rst->fields[3]; ?></td>
                	<form name="form1" method="post" action=""><td height="18" align="center" valign="middle">
					<input type="button" name="Submit2" class="submit" value="详细" onclick="javascript:Wopen=open('operation.php?action=<?php echo ($l_rst->fields[4])=="Audio"?"audio":"video"; ?>&id=<?php echo $l_rst->fields[0]; ?>','','height=700,width=665,scrollbars=no');">                    
					</td></form>
              </tr>
              <?php
			  		$l_rst->movenext();
					}
			  ?>
          </table></td>
        </tr>
    </table></td>
  </tr>
</table>