Tekil Mesaj gösterimi - Php Panel Sayfalama

Konu Php Panel Sayfalama

07-02-2015, 10:09:39

Arkadaşlar merhaba. Elimde bir php panel bulunmakta. Bunu siteye bağlayabiliyorum fakat şöyle bir problem yaşamaktayım, ben panelden sayfa oluşturunca sayfaya link verip sadece o sayfanın bilgilerini - içeriklerini göstermesi lazım. Yani birnevi wordpress mantığı oluşturulan her sayfa için ayrı bir link - sayfa oluşturması lazım.

Sayfa-ekle.php :

<?php
@ob_start();
@session_start();
include("include/baglan.php");
include("include/fonksiyonlar.php");
oturumkontrolana();

if($_POST['sayfa_sira'] && $_GET['islem']=="")
{
	$sayfa_sira = $_POST['sayfa_sira'];
	$sayfa_adi = $_POST['sayfa_adi'];
	$durum = $_POST['durum'];
	$aciklama = $_POST['aciklama'];
		
	$kaynak = $_FILES["resim"]["tmp_name"];  
	$dosya = $_FILES["resim"]["name"];
	$uzanti = explode(".", $_FILES[resim][name]); 
	$random = rand(0,9999);
	$yeni_isim = $random."_".$dosya;
	$hedef  = "../lib/images/sayfalar/".$yeni_isim;
	
	if($dosya=="")
	$yeni_isim="no-image";
	
	$gitti=move_uploaded_file($kaynak,$hedef);
	
	$sayfa_ekle_sorgu=mysql_query("insert into sayfalar (sira, 
														   adi, 
														   resim,
														   durum,
														   aciklama) 
														   values ('$sayfa_sira',
																   '$sayfa_adi',
																   '$yeni_isim',
																   '$durum',
																   '$aciklama')");
																   
	$bilgi = '	 <div class="alert alert-success">
										Başarı ile Eklenmiştir !
				  </div>' ; 
}



if($_POST['sayfa_sira'] && $_GET['islem']=="duzenle")
{
	$sayfa_sira = $_POST['sayfa_sira'];
	$sayfa_adi = $_POST['sayfa_adi'];
	$duzenlenecek_id = $_GET['id'];
	$durum = $_POST['durum'];
	$aciklama = $_POST['aciklama'];
	
	$kaynak = $_FILES["resim"]["tmp_name"];  
	$dosya = $_FILES["resim"]["name"];
	$uzanti = explode(".", $_FILES[resim][name]); 
	$random = rand(0,9999);
	$yeni_isim = $random."_".$dosya;
	$hedef  = "../lib/images/sayfalar/".$yeni_isim;
	
	if($dosya!="")
	{
		$resim_bul=mysql_fetch_array(mysql_query("select * from sayfalar where id='$duzenlenecek_id'"));
		$resim_sil=unlink("../lib/images/sayfalar/".$resim_bul['resim']);
	
		$sayfa_duzenle_sorgu=mysql_query("update sayfalar set durum='$durum', sira='$sayfa_sira', adi='$sayfa_adi', resim='$yeni_isim', aciklama='$aciklama' where id='$duzenlenecek_id'");
		
		$gitti=move_uploaded_file($kaynak,$hedef);		
	}
	else
	{	
	$sayfa_duzenle_sorgu=mysql_query("update sayfalar set durum='$durum', aciklama='$aciklama', sira='$sayfa_sira', adi='$sayfa_adi' where id='$duzenlenecek_id'");
	}
	
	$bilgi = '	 <div class="alert alert-success">
										Başarı ile Güncellenmiştir !
				  </div>' ;
}



if($_GET['islem']=="duzenle")
{
	$id = $_GET['id'];
	
	$durum = "duzenle" ;
	
	$sayfa_dizi=mysql_fetch_array(mysql_query("select * from sayfalar where id = '$id'"));
	
}

?>


<!DOCTYPE html>
<!--  
Template Name: Conquer Responsive Admin Dashboard Template build with Twitter Bootstrap 2.3.1
Version: 1.4
Author: KeenThemes
Website: http://www.keenthemes.com
Purchase: http://themeforest.net/item/conquer-responsive-admin-dashboard-template/3716838
-->
<!--[if IE 8]> <html lang="en" class="ie8"> <![endif]-->
<!--[if IE 9]> <html lang="en" class="ie9"> <![endif]-->
<!--[if !IE]><!--> <html lang="en"> <!--<![endif]-->
<!-- BEGIN HEAD -->
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <title>PoloPanel.v1</title>
	<meta content="width=device-width, initial-scale=1.0" name="viewport" />
	<meta content="" name="description" />
	<meta content="" name="author" />
	<!-- BEGIN GLOBAL MANDATORY STYLES -->
	<link href="assets/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" />
	<link href="assets/plugins/bootstrap/css/bootstrap-responsive.min.css" rel="stylesheet" />
	<link href="assets/plugins/font-awesome/css/font-awesome.css" rel="stylesheet" />
	<link href="assets/css/style.css" rel="stylesheet" />
	<link href="assets/css/style-responsive.css" rel="stylesheet" />
	<link href="assets/css/themes/default.css" rel="stylesheet" id="style_color" />
	<link href="assets/plugins/uniform/css/uniform.default.css" rel="stylesheet" type="text/css" />
	<link href="#" rel="stylesheet" id="style_metro" />
	<!-- END GLOBAL MANDATORY STYLES -->
	<!-- BEGIN PAGE LEVEL STYLES -->	
	<link href="assets/plugins/fancybox/source/jquery.fancybox.css" rel="stylesheet" rel="stylesheet" type="text/css" />
	<link href="assets/plugins/gritter/css/jquery.gritter.css" rel="stylesheet" type="text/css" />
	<link href="assets/plugins/bootstrap-daterangepicker/daterangepicker.css" rel="stylesheet" type="text/css" />
	<link href="assets/plugins/fullcalendar/fullcalendar/bootstrap-fullcalendar.css" rel="stylesheet" type="text/css"  />
	<link href="assets/plugins/jqvmap/jqvmap/jqvmap.css" media="screen" rel="stylesheet" type="text/css" />
	<!-- END PAGE LEVEL STYLES -->
    <!-- BEGIN PAGE LEVEL STYLES -->
   <link rel="stylesheet" type="text/css" href="assets/plugins/bootstrap-fileupload/bootstrap-fileupload.css" />
   <link rel="stylesheet" type="text/css" href="assets/plugins/gritter/css/jquery.gritter.css" />
   <link rel="stylesheet" type="text/css" href="assets/plugins/chosen-bootstrap/chosen/chosen.css" />
   <link rel="stylesheet" type="text/css" href="assets/plugins/select2/select2.css" />
   <link rel="stylesheet" type="text/css" href="assets/plugins/jquery-tags-input/jquery.tagsinput.css" />
   <link rel="stylesheet" type="text/css" href="assets/plugins/clockface/css/clockface.css" />
   <link rel="stylesheet" type="text/css" href="assets/plugins/bootstrap-wysihtml5/bootstrap-wysihtml5.css" />
   <link rel="stylesheet" type="text/css" href="assets/plugins/bootstrap-datepicker/css/datepicker.css" />
   <link rel="stylesheet" type="text/css" href="assets/plugins/bootstrap-timepicker/compiled/timepicker.css" />
   <link rel="stylesheet" type="text/css" href="assets/plugins/bootstrap-colorpicker/css/colorpicker.css" />
   <link rel="stylesheet" type="text/css" href="assets/plugins/bootstrap-toggle-buttons/static/stylesheets/bootstrap-toggle-buttons.css" />
   <link rel="stylesheet" type="text/css" href="assets/plugins/bootstrap-daterangepicker/daterangepicker.css" />
   <!-- END PAGE LEVEL STYLES -->
</head>
<!-- END HEAD -->

<!-- BEGIN BODY -->
<body class="fixed-top">
	<!-- BEGIN HEADER -->
	<?php include("header.php") ;?>
	<!-- END HEADER -->
    
    
    
	<!-- BEGIN CONTAINER -->
	<div id="container" class="row-fluid">
		
        
        <!-- BEGIN SIDEBAR -->
		<?php include("menu.php") ;?>
		<!-- END SIDEBAR MENU -->
		</div>
		<!-- END SIDEBAR -->
        
        
        
		<!-- BEGIN PAGE -->
		<div id="body">
			
			<!-- BEGIN PAGE CONTAINER-->
			<div class="container-fluid">
				<!-- BEGIN PAGE HEADER-->
				<div class="row-fluid">
					<div class="span12">
						  	
						<!-- BEGIN PAGE TITLE & BREADCRUMB-->			
						<h3 class="page-title">
							<?=ucwords($_SESSION['yonetici_ad_soyad'])?> <small>Hoşgeldin | Site Yönetim Paneli</small>
						</h3>
						<!-- END PAGE TITLE & BREADCRUMB-->
					</div>
				</div>
				<!-- END PAGE HEADER-->
                
                
				<!-- BURALAR BENIM ALANIM BASI-->
				<div id="page" class="dashboard">
					
                	<div class="widget box light-grey">
                     
                     <div class="widget-title">

                        <h4><i class="icon-edit"></i> Sayfa Ekleme / Güncelleme</h4>
                        
                     </div> <!--widget-title end-->
                     
                     
                    <div class="widget-body form">
                    
                    <?=$bilgi?>
                    
                        <!-- BEGIN FORM-->
                        <form action="#" id="form_sample_1" class="form-horizontal" method="post" enctype="multipart/form-data">
                            <div class="control-group">
                              <label class="control-label">Sayfa Sırası</label>
                              <div class="controls">
                                 <input type="text" name="sayfa_sira" data-required="1" class="span6 " value="<?=$sayfa_dizi['sira']?>"/>
                              </div>
                           </div>
                                                      
                           <div class="control-group">
                              <label class="control-label">Sayfa Adı</label>
                              <div class="controls">
                                 <input name="sayfa_adi" type="text" class="span6 " value="<?=$sayfa_dizi['adi']?>"/>
                              </div>
                           </div>
                           
                           
                           
                           <div class="control-group">
                              <label class="control-label">Sayfa Resmi</label>
                              <div class="controls">
                                    <div class="fileupload fileupload-new" data-provides="fileupload">
                                       <div class="input-append">
                                          <div class="uneditable-input">
                                             <i class="icon-file fileupload-exists"></i> 
                                             <span class="fileupload-preview"></span>
                                          </div>
                                          <span class="btn btn-file">
                                          <span class="fileupload-new">Resim Seç</span>
                                          <span class="fileupload-exists">Değiştir</span>
                                          <input type="file" name="resim" class="default" />
                                          </span>
                                          <a href="#" class="btn fileupload-exists" data-dismiss="fileupload">Vazgeç</a>
                                       </div>
                                    </div>
                                 </div>
                           </div>
                           
                           <div class="control-group">
                                 <label class="control-label">Durumu</label>
                                 <div class="controls">
                                    <div class="basic-toggle-button">
                                      
                                      <?php
									  if($_GET['islem']=='duzenle')
									  {
									 ?>
                                     <input type="checkbox" class="toggle" name="durum" <?php if($sayfa_dizi['durum']=='1') {?>checked="checked" <?php } ?> value="1" />
                                     <?php
									  }
									  else
									  {
									  ?>
                                      <input type="checkbox" class="toggle" checked="checked" name="durum"  value="1" />
                                      <?php
									  }
									  ?>
                                    </div>
                                 </div>
                              </div>
                           
                          
                           <div class="control-group">
                                 <label class="control-label">Açıklama</label>
                                 <div class="controls">
                                    <textarea class="span12 ckeditor m-wrap" name="aciklama" rows="6"><?=$sayfa_dizi['aciklama']?></textarea>
                                 </div>
                              </div>
                          
                           
                           <div class="form-actions">
                           
                           <?php
						   if($_GET['islem']=="duzenle")
						   {
						   ?>
                           <button type="submit" onclick="submit();" class="btn btn-primary"><i class="icon-ok"></i> Güncelle</button>
                           <?php
						   }
						   else
						   {
						   ?>
                           <button type="submit" onclick="submit();" class="btn btn-primary"><i class="icon-ok"></i> Kaydet</button>	
                           <?php
						   }
						   ?>
                           </div>
                        </form>
                        <!-- END FORM-->
                     
                     </div> <!--widget box light-grey end-->
                 
				</div>
				<!-- BURALAR BENIM ALANIM-->
                
                
			</div>
			<!-- END PAGE CONTAINER-->	
            
            	
		</div>
		<!-- END PAGE -->
        
        
	</div>
	<!-- END CONTAINER -->
    
    
    
	<!-- BEGIN FOOTER -->
	<?php include("footer.php") ;?>
	<!-- END FOOTER -->
    
    <!-- BEGIN JAVASCRIPTS(Load javascripts at bottom, this will reduce page load time) -->
   <!-- BEGIN CORE PLUGINS -->
   <script src="assets/plugins/jquery-1.8.3.min.js" type="text/javascript"></script>   
   <!-- IMPORTANT! Load jquery-ui-1.10.1.custom.min.js before bootstrap.min.js to fix bootstrap tooltip conflict with jquery ui tooltip -->  
   <script src="assets/plugins/jquery-ui/jquery-ui-1.10.1.custom.min.js" type="text/javascript"></script>      
   <script src="assets/plugins/bootstrap/js/bootstrap.min.js" type="text/javascript"></script>
   <!--[if lt IE 9]>
   <script src="assets/plugins/excanvas.js"></script>
   <script src="assets/plugins/respond.js"></script>  
   <![endif]-->   
   <script src="assets/plugins/breakpoints/breakpoints.js" type="text/javascript"></script>  
   <!-- IMPORTANT! jquery.slimscroll.min.js depends on jquery-ui-1.10.1.custom.min.js --> 
   <script src="assets/plugins/jquery-slimscroll/jquery.slimscroll.min.js" type="text/javascript"></script>
   <script src="assets/plugins/jquery.blockui.js" type="text/javascript"></script>  
   <script src="assets/plugins/jquery.cookie.js" type="text/javascript"></script>
   <script src="assets/plugins/uniform/jquery.uniform.min.js" type="text/javascript" ></script> 
   <!-- END CORE PLUGINS -->
   <!-- BEGIN PAGE LEVEL PLUGINS -->
   <script type="text/javascript" src="assets/plugins/jquery-validation/dist/jquery.validate.min.js"></script>
   <script type="text/javascript" src="assets/plugins/jquery-validation/dist/additional-methods.min.js"></script>
   <script type="text/javascript" src="assets/plugins/chosen-bootstrap/chosen/chosen.jquery.min.js"></script>
   <!-- END PAGE LEVEL PLUGINS -->
   <!-- BEGIN PAGE LEVEL PLUGINS -->
   <script type="text/javascript" src="assets/plugins/ckeditor/ckeditor.js"></script>  
   <script type="text/javascript" src="assets/plugins/bootstrap-fileupload/bootstrap-fileupload.js"></script>
   <script type="text/javascript" src="assets/plugins/chosen-bootstrap/chosen/chosen.jquery.min.js"></script>
   <script type="text/javascript" src="assets/plugins/select2/select2.min.js"></script>
   <script type="text/javascript" src="assets/plugins/bootstrap-wysihtml5/wysihtml5-0.3.0.js"></script> 
   <script type="text/javascript" src="assets/plugins/bootstrap-wysihtml5/bootstrap-wysihtml5.js"></script>
   <script type="text/javascript" src="assets/plugins/jquery-tags-input/jquery.tagsinput.min.js"></script>
   <script type="text/javascript" src="assets/plugins/bootstrap-toggle-buttons/static/js/jquery.toggle.buttons.js"></script>
   <script type="text/javascript" src="assets/plugins/bootstrap-datepicker/js/bootstrap-datepicker.js"></script>
   <script type="text/javascript" src="assets/plugins/clockface/js/clockface.js"></script>
   <script type="text/javascript" src="assets/plugins/bootstrap-daterangepicker/date.js"></script>
   <script type="text/javascript" src="assets/plugins/bootstrap-daterangepicker/daterangepicker.js"></script> 
   <script type="text/javascript" src="assets/plugins/bootstrap-colorpicker/js/bootstrap-colorpicker.js"></script>  
   <script type="text/javascript" src="assets/plugins/bootstrap-timepicker/js/bootstrap-timepicker.js"></script>
   <script type="text/javascript" src="assets/plugins/jquery-inputmask/jquery.inputmask.bundle.min.js"></script>   
   <script type="text/javascript" src="assets/plugins/jquery.input-ip-address-control-1.0.min.js"></script>
   <!-- END PAGE LEVEL PLUGINS -->
   <!-- BEGIN PAGE LEVEL STYLES -->
   <script src="assets/scripts/app.js"></script>
   <script src="assets/scripts/form-validation.js"></script>
   <script src="assets/scripts/form-components.js"></script> 
   <!-- END PAGE LEVEL STYLES -->    
   <script>
      jQuery(document).ready(function() {   
         // initiate layout and plugins
         App.init();
         FormValidation.init();
		 FormComponents.init();
      });
   </script>
   <!-- END JAVASCRIPTS -->
</body>
<!-- END BODY -->
</html>

Page.php

<?php include("yonet/include/baglan.php"); ?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
	<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
	<title>DENEME</title>
</head>
<body>
	<?php
		$sql = mysql_query("select * from sayfalar");
		$adi = $oku['adi'];
		while($oku=mysql_fetch_assoc($sql)){ ?>
		<?php
if ($oku['id']=='5') {
    echo '<h4>'$adi'</h4>'
	
	
	
}
?>
		
	<?php } ?>
</body>
</html>