index.php

<?php
include("template/header.php");
include("lib/dbcon.php");
?>
<h2>여기는 메인페이지입니다.</h2>

<?php
	$sql = "select * from blog order by wdate DESC";
	if( $rs = $db->query($sql) ) {
		if( $rows = $rs->fetchAll() ) {
			foreach( $rows as $row ){
?>

<div class="panel panel-info">
	<div class="panel-heading">
		<p><strong><?php echo $row['title'];?></strong></p>
		<p>
			<?php echo $row['username'];?> /
			<?php echo $row['wdate'];?>
		</p>
	</div>
	<div class="panel-body">
		<?php echo $row['content'];?>
		<?php if( $row['upfile'] ){ ?>
			<hr>
			<?php
			if( $info = getimagesize("data/" . $row['upfile']) ) {
				$width = $info[0];
				$imgwidth = "";
				if( $width > 500 ) $imgwidth = " width='500'";
			?>
				<p>
					<img src="data/<?php echo $row['upfile'];?>"<?php echo $imgwidth;?>>
				<p>
			<?php } else { ?>
				<p>
					첨부파일:
					<a href="data/<?php echo $row['upfile'];?>">
						<?php echo $row['upfile'];?>
					</a>
				</p>
			<?php } ?>


		<?php } ?>
	</div>
</div>

<?php
			}
		}
	}
?>

<?php
include("template/footer.php");
?>