1#@!#!123s

: / home3 / antlerworldwide / public_html / admin /
Filename : promotion.php
back
<?php include('checklogin.php')?>
<?php include('include/header.php')?>
            <!--// top-bar -->

          
            <!-- Forms content -->
          <section class="forms-section">
			
			<?php
include('include/conectdb.php');
$error='';
if(isset($_POST['contact']))
{
	
	
	$title=$_POST['title'];
	
	$text=$_POST['text'];
	$text=str_replace("'","\'",$text);
	
	
  
  $sql=mysqli_query($dbc,"INSERT INTO `promotion`(`id`, `name`,`tlb_des`) VALUES (NULL,'$title','$text')");
 
 if($sql)
 {
	  echo'<span class="successmssg">Content succeessfully added to the website, <br/> <a href="promotion.php" class="btn btn-primary">click to add more</a> <b></span>';
	 exit();
 }
 else
 {
	 echo 'Database Problem';
 }
	
}

?>
<!--********************************************************************************************************************************************************************-->             <!--*************************************************************************** Start Add Details ****************************************************************-->  
<!--********************************************************************************************************************************************************************-->                 
                
                <div class="outer-w3-agile mt-3">
                    <h4 class="tittle-w3-agileits mb-4">Add Detail</h4>
                    <form action="#" method="post">
                        <div class="form-row">
                          
                            <div class="form-group col-md-6">
                                <label for="inputCity">Title</label>
                                <input type="text" name="title" class="form-control">
                            </div>
                          <div class="form-group col-md-12">
                                <label for="inputCity">Desicription</label>
                                <textarea  name="text" id="summernote"></textarea>
                            </div>
                          
                        </div>
                       
                        
                       
                        <div class="form-group col-md-12 text-center mt-4">
                    <button type="submit" name="contact" id="vchangeProfile" class="btn btn-primary" data-dismiss="modal" aria-hidden="true" title="submit">Add</button>
                    <a href="welcome.php" class="btn btn-primary" data-dismiss="modal" aria-hidden="true" title="cancel">Cancel</a>  
                    </div>
                    </form>
                </div>
                
              
                
                
                
                
                
<!--********************************************************************************************************************************************************************-->             <!--*************************************************************************** Start Table List ****************************************************************-->  
<!--********************************************************************************************************************************************************************-->             
                           <script type="text/javascript">
function delconf(id)
{
	var msg="Are you sure to deletd Information# "+id+"?";
	var reply=confirm(msg);
	return reply;
}
</script>


			  <div class="outer-w3-agile mt-3">
                    <h4 class="tittle-w3-agileits mb-4">View Details</h4>
                    <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                        <div class=" table-responsive">
                                    <table id="datatable" class="table table-striped table-bordered" cellspacing="0" width="100%">
                                        <thead>
                                            <tr>
                                                <th>Action</th>
                                                <th>Sr.No.</th>
                                                <th>Title</th>
                                                
                                                <th>Description</th>
                                                
                                                
                                                

                                            </tr>
                                        </thead>

                                       

                                        <tbody>
										
										<?php
include('include/conectdb.php');
$inc=1;
//$bg='';
$sql=mysqli_query($dbc,"SELECT * FROM `promotion`");
if(mysqli_num_rows($sql)>0)
{
?>
										
										 <?php
  while($row=mysqli_fetch_array($sql))
  {
	 //$bg=($bg=='#E3EDF0'?'#ffffff':'#E3EDF0');
  ?>
                                            <tr>

                                                <td>
                                                   <a href="promotion_edit.php?id=<?php echo $row['id']; ?>"   class="btn btn-success btn-xs" data-title="View" title="edit"> <span><i class="fa fa-edit" aria-hidden="true"></i></span></a>
                                                    <a href="promotion_delete.php?id=<?=$row['id']?>" onclick="return delconf('<?=$row['id']?>')" class="btn btn-danger btn-xs">
                                                        <span><i class="fa fa-trash" aria-hidden="true"></i></span></a>

                                                </td>
                                                <td><?php echo $inc++; ?></td>
                                                
                                                <td><?=$row['name']?></td>
                                               
												
                                                <td><?=substr($row['tlb_des'],0,200)?></td>
                                                
                                                
                                               
                                            </tr>
											
											<?php }?>
											
											<?php }?>

<?php
if(mysqli_num_rows($sql)=='')
{
	echo 'Sorry!! No Data Found';
}
?>
                                           

                                        </tbody>
                                    </table>

                                </div>
                    </div>
                    
                    
                    
                   
                    
                  
                    
                </div>

                
         </section>

            <!--// Forms content -->
<?php include('include/footer.php') ?>