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

									session_start();
					include "inc/chec.php";
					include "conn/conn.php";
				?>
				
				  
				    
				        
				          上 传 日 志 管 理
				        
				        
				          
				              
				                日志查询
				              
				              
				                ID
				                数据名称
				                用户名
				                上传时间
				                操作
				              
				              							    $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){ 
								?>
				              
				                
				                
				                
				                
				                	
																		
				              
				              							  		$l_rst->movenext();
									}
							  ?>