<?php
ob_start(); 
require_once 'includes/toolBox.php';
require_once 'adminheader.php';
 ?>        
    <div class="content">
        <div class="breadLine">
            <ul class="breadcrumb">
                <li><a href="index.php">Puthupally Admin Panel</a> <span class="divider">></span></li>
                 <li><a href="#">News Management</a> <span class="divider">></span></li>                  
                <li class="active">News List</li>
            </ul>
        </div>
        
        <div class="workplace">
        <?php 
		include 'message.php';
        ?>  
      
                                    
            <div class="row-fluid">
                <div class="span12">
                    
                    <div class="widgetButtons">                        
                        <div class="bb"><a href="#" class="tipb" title="Edit"><span class="ibw-edit"></span></a></div>
                        <div class="bb">
                            <a href="#" class="tipb" title="Upload"><span class="ibw-folder"></span></a>
                            <div class="caption red">31</div>
                        </div>
                        <div class="bb"><a href="addnews.php" class="tipb" title="Add new"><span class="ibw-plus"></span></a></div>
                        <div class="bb"><a href="#" class="tipb" title="Add to favorite"><span class="ibw-favorite"></span></a></div>
                        <div class="bb">
                            <a href="#" class="tipb" title="Send mail"><span class="ibw-mail"></span></a>
                            <div class="caption green">31</div>
                        </div>
                        <div class="bb"><a href="#" class="tipb" title="Settings"><span class="ibw-settings"></span></a></div>
                    </div>
                    
                </div>
            </div>
            <div class="dr"><span></span></div> 
           
   
                <div class="span10">                    
                    <div class="head clearfix">
                        <div class="isw-grid"></div>
                        <h1>Sortable table</h1>                               
                    </div>
                    <div class="block-fluid table-sorting clearfix">
                        <table cellpadding="0" cellspacing="0" width="100%" class="table" id="tSortable">
                            <thead>
                                <tr>
                                   
                                    <th width="5%">ID</th>
                                    <th width="10%">News</th>
                                    <th width="10%">Image</th>
                                    <th width="10%">Description</th>
                                    <th width="10%">Brochure</th>
                                    <th width="10%">Action</th>                                    
                                </tr>
                            </thead>
                            <tbody>
                            	<?php 
                            	$query="SELECT * FROM cms_news ORDER BY id DESC";
								$raw=firesql($query,'res');
								$no=1;
								while ($res=mysqli_fetch_array($raw))
								{
									$des=substr($res['description'],0,25);
									?>
                                <tr>
                                   
                                    <td><?php echo $no;?></td>
                                    <td><?php echo $res['title']; ?></td>
                                    <td><img src="uploads/news/<?php echo $res['image']; ?>" alt="baner image" width="200px" height="200px"></td>
                                    <td><?php echo $des; ?>....</td> 
                                    <td><?php echo $res['brochure']; ?></td> 
                                    <td>
                                    <a href="news-delete.php?delid=<?php echo $res['id'] ?>" onclick="return confirm('Are You Sure ?');" class="btn btn-small btn-danger">Delete</a>
                                    <a href="editnews.php?editid=<?php echo $res['id'] ?>" class="btn btn-small btn-info">Edit</a>
                                    </td>                                  
                                </tr>  
                                <?php
                                $no++;}
                                ?>                                                          
                            </tbody>
                        </table>
                    </div>
                </div>                                
                            
            
            
            
            
 <?php require_once 'adminfooter.php' ?>