调用sql,并将结果集以table形式展示在浏览器中

最新推荐文章于 2022-10-10 23:53:08 发布

原创最新推荐文章于 2022-10-10 23:53:08 发布 · 725 阅读

CC 4.0 BY-SA版权

本文展示了一段使用PHP从特定数据库表中查询日期维度信息的脚本，包括日期相关的多种属性，如月份、季度和年份等，并将查询结果以表格形式呈现。

<?php
header ( "Content-Type: text/html;charset=utf-8" );

$db_link = mysql_connect ( "172.16.1.194", "root", "123456" ) or die ( "wrong!" );

$sql = "SELECT  DayID,                   
				DayNumInMonth,           
				DayNumInYear,            
				cast(GregorianDate as date),           
				WeekDayName,             
				WeekId,                  
				WeekNumInYear,           
				BroadcastWeekId,         
				BroadcastWeekNumInYear,  
				BradcastWeekNumInYear,   
				FiscalWeekId,            
				FiscalWeekNumInYear,     
				MonthId,                 
				MonthNum,                
				MonthName,               
				FiscalMonthId,           
				FiscalMonthNum,          
				FiscalMonthName,         
				BroadcastMonthId,        
				BroadcastMonthNum,       
				BroadcastMonthName,      
				QuarterNum,              
				FiscalQuarterNum,        
				YearNum,                 
				FiscalYearNum,           
				BroadcastYearNum,        
				cast(CreatedDtim as date),             
				QuarterId
		FROM AdDataCenter.`Dim_Day` AS a 
		WHERE 1=1 
		-- AND a.`GregorianDate` >= CURDATE()
		LIMIT 100;
		";
$sql_result = mysql_query ( $sql, $db_link );
$rows = mysql_num_rows ( $sql_result );
$cols = mysql_num_fields ( $sql_result );
// echo "rows=" . ($rows);
// echo "<br/>";
// echo "cols=" . ($cols);
echo '<table align="center" width="70%" border="1">';
echo '<caption><h1>未来10天信息表</h1></caption>';
$i = 0;
$ii = 0;

//echo '' mysql;
echo '<td>' .'DayID'. '</td>';                         
echo '<td>' .'DayNumInMonth'. '</td>';                 
echo '<td>' .'DayNumInYear'. '</td>';                  
echo '<td>' .'GregorianDate'. '</td>';                 
echo '<td>' .'WeekDayName'. '</td>';                   
echo '<td>' .'WeekId'. '</td>';                        
echo '<td>' .'WeekNumInYear'. '</td>';                 
echo '<td>' .'BroadcastWeekId'. '</td>';               
echo '<td>' .'BroadcastWeekNumInYear'. '</td>';        
echo '<td>' .'BradcastWeekNumInYear'. '</td>';         
echo '<td>' .'FiscalWeekId'. '</td>';                  
echo '<td>' .'FiscalWeekNumInYear'. '</td>';           
echo '<td>' .'MonthId'. '</td>';                       
echo '<td>' .'MonthNum'. '</td>';                      
echo '<td>' .'MonthName'. '</td>';                     
echo '<td>' .'FiscalMonthId'. '</td>';                 
echo '<td>' .'FiscalMonthNum'. '</td>';                
echo '<td>' .'FiscalMonthName'. '</td>';               
echo '<td>' .'BroadcastMonthId'. '</td>';              
echo '<td>' .'BroadcastMonthNum'. '</td>';             
echo '<td>' .'BroadcastMonthName'. '</td>';            
echo '<td>' .'QuarterNum'. '</td>';                    
echo '<td>' .'FiscalQuarterNum'. '</td>';              
echo '<td>' .'YearNum'. '</td>';                       
echo '<td>' .'FiscalYearNum'. '</td>';                 
echo '<td>' .'BroadcastYearNum'. '</td>';              
echo '<td>' .'CreatedDtim'. '</td>';                   
echo '<td>' .'QuarterId'. '</td>';  

while($row = mysql_fetch_row($sql_result)){
	echo '<tr>';
	$i ++;
	foreach ( $row as $output ) {
		$ii ++;
		echo '<td>' . $output . '</td>';
	}
}

?>