Forum Webmastera, HTML, CSS, PHP, MySQL, Hosting, Domeny - Forum dla Webmasterów › Technologie internetowe - tworzenie stron WWW › Początkujący webmaster v
Skrypt paginacji - jak wkleić do kodu? - prosze o pomoc

Ocena wątku:
  • 0 głosów - średnia: 0
  • 1
  • 2
  • 3
  • 4
  • 5
Tryb drzewa
Skrypt paginacji - jak wkleić do kodu? - prosze o pomoc
neneth Offline
Member
***
Liczba postów: 56
Liczba wątków: 21
Dołączył: 07-04-2010
Reputacja: 0
#1
22-11-2010, 16:34
Witam, jestem początkującym webmasterem i mam problem. Chciałem do swojej strony wkleić skrypt paginacji, ale nie za bardzo wiem, jak to zrobić. Proszę o pomoc. Oto fragment skryptu moje strony:

index.php
Kod PHP:
    <div  id="tresc">
                 
                 <div id="box">
                            
            
                            <div class="mid"> 
                    
                                <div class="content">
                                    <?php
 if(!isset($_GET['page'])){
    include('strony/strona_glowna.php');
    }else{
$dozwolone=array('kulturysci','rejestracja','przypomnienie','logowanie','zmiana-danych','weryfikacja','nastolatki','grB','3lata','krazenie','refluks','nadcisnienie','nerki','makroskladniki','mikroskladniki','woda','weglowodany','tluszcze','bialka','tabele_kaloryczne','indeks','wzrost_waga','spalone_kalorie','bmi','przyczyny','czym','kiedy','adres','miazdzyca','tradzik','ciaza_w_cukrzycy','cukrzycaII','formularz','strona_glowna','dieta_odchudzajaca','dieta_1000','kopenhaska','anderson','hay','kwasniewski','cambridge','gerson','budwig','dukan','morze','southbeach','atkins','niskocholesterolowa','wapn','sod','hollywood','niskoenergetyczna','lekkostrawna','makrobiotyka','mayr','bircher','evers','chiny','1200kcal','celulit','stres','blekitna','czerwona','fiolet','zielona','zolta','blyskawiczna','diamond','france','francuska','hinduska','kekwicka','ketogeniczna','montignac','kosci','redukcyjna','rownowaga','bomba_witaminowa','gr0','grA','grB','grAB','wiosenna','lato','jesien','zima','ksiezyc','slonce','nowy_rok','swieta','weekend','jablko_ryz','bialko','grejpfrut','jogurt','kapusta','koktajl','mleko','sok','owoce','pszenica','twarog_ryz','ziemniaki','lod','aktywni','sportowcy','kulturysci','nastolatki','nastolatkowie','kosmonauta','szczupli','wysmukli','leniwi','zdrowie_uroda','odmlodzeni','oczyszczanie','wegetarianin','lasuchy','ciaza','matka','niecierpliwi','siedmiodniowa','stabilizacja','brzuch','komorka','wzrok','tradzik','cukrzyca1','cukrzyca2','cukrzycaII','ciaza_w_cukrzycy','zaparcia','jelito','bezglutenowa','bioskladniki','nowotwor','watroba','tarczyca','nerki','zatrucia','wrzody','miazdzyca','dna_moczanowa','krazenie','nadcisnienie','refluks','rekonwalescent','dziewczyna','3lata','20lat','30lat','40lat','starsi');
if(in_array($_GET['page'],$dozwolone)){
$name="$_GET[page].php";
}else{
$name='budowa.php';
}
if(file_exists('strony/'.$name)){
include('strony/'.$name);
}else{
echo'Strona w budowie';
}

    }
?>


                                </div>
                 
                            </div>
    
                            <div class="bot">
                            </div>

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

style.css
Kod:
p
{
text-align: left;
color: #0000ff;
font-family: verdana;

}
html {background-image:url(abstrakcja.jpg)}
body {width:1000px;
    height:1920px;
    margin-left:auto;
    font-family: serif;
    margin-right:auto;
}
#menugorne {background:#EEEEEE ;
        float:left;
            width: 1000px;
        height: 74px;
        margin-top:4px;
            font-family: Verdana, Trebuchet MS, Arial, sans-serif, Helvetica;
            font-size:11px;

}
/*^'^ Navigation Structure ^'^*/
.nav-container-outer{
background: #fefdd3;
padding: 0px;
height: 74px;
width:1000px;
background: url(images/nav-bg.jpg);
}
.float-left{
float: left;
}
.float-right{
float: right;
}
.nav-container .divider{
display:block;
font-size:1px;
border-width:0px;
border-style:solid;
}
.nav-container .divider-vert{
float:left;
width:0px;
display: none;
}
.nav-container .item-secondary-title{
display:block;
cursor:default;
white-space:nowrap;
}
.clear{
font-size:1px;
height:0px;
width:0px;
clear:left;
line-height:0px;
display:block;
float:none;
}
.nav-container{
position:relative;
zoom:1;
margin: 0 auto;
}
.nav-container a, .nav-container li{
float:left;
display:block;
white-space:nowrap;
}
.nav-container div a, .nav-container ul a, .nav-container ul li{
float:none;
}
.nav-container ul{
left:-10000px;
position:absolute;
}
.nav-container, .nav-container ul{
list-style:none;
padding:0px;
margin:0px;
}
.nav-container li a{
float:none
}
.nav-container li{
position:relative;
}
.nav-container ul{
z-index:10;
}
.nav-container ul ul{
z-index:20;
}
.nav-container ul ul ul{
z-index:30;
}
.nav-container ul ul ul ul{
z-index:40;
}
.nav-container ul ul ul ul ul{
z-index:50;
}
li:hover>ul{
left:auto;
}
#nav-container ul {
top:100%;
}
#nav-container ul li:hover>ul{
top:0px;
left:100%;
}

/*^'^ Primary Items ^'^*/    
#nav-container a{    
padding:0px 3px 8px 10px;
margin: 25px 0px 0px 0px;
color: #0b01b8;
font-family: Trebuchet MS, Arial, sans-serif, Helvetica;
font-size:12px;
text-decoration:none;
font-weight: bold;
background: url(images/item-primary-bg.jpg);
background-repeat: no-repeat;
background-position: top;
}

#nav-container a:hover{
color: #0b01b8;
background: url(images/item-primary-bg.jpg);
background-repeat: no-repeat;
background-position: center;
}

/*^'^ Secondary Items Container ^'^*/    
#nav-container div, #nav-container ul{    
padding:6px 4px 6px 0px;
margin:0px 0px 0px 0px;
background: url(images/item-secondary-container-bg.jpg);
background-repeat: repeat-x;
background-color: #c6d1fc;
border-bottom: 1px solid #0000ff;
}

/*^'^ Secondary Items ^'^*/    
#nav-container div a, #nav-container ul a{    
padding:3px 10px 3px 6px;
background-color: #0000ff;
background: url(images/item-secondary-bg.jpg);
background-repeat: no-repeat;
background-position: 0px 22px;
font-size:11px;
border-width:0px;
border-style:none;
margin: 0px 0px 0px 0px;
width: 149px;
}

/*^'^ Secondary Items Hover State ^'^*/    
#nav-container div a:hover, #nav-container ul a:hover{    
background-color: #FFFFFF;
background: url(images/item-secondary-bg.jpg);
background-repeat: no-repeat;
color:#0000ff;
}

/*^'^ Secondary Item Titles ^'^*/    
#nav-container .item-secondary-title{    
cursor:default;
padding:4px 0px 3px 7px;
color: #0000ff;
font-family: Arial, Trebuchet MS, Arial, sans-serif, Helvetica;
font-size:11px;
/* background: url(images/item-secondary-title-bg.jpg); */
background-repeat: no-repeat;
font-weight:bold;
}

/*^'^ Horizontal Dividers ^'^*/    
#nav-container .divider-horiz{    
border-top-width:1px;
margin:5px 5px;
border-color: #FFFFFF;
}

/*^'^ Vertical Dividers ^'^*/    
#nav-container .divider-vert{    
border-left-width:1px;
height:15px;
margin:4px 2px 0px 2px;
border-color:#0000ff;
}

#menuboczne{
background: url(images/mid.jpg) repeat-y;
            width: 200px;
        height: 1678px;
        float:left;
        margin-top:6px;
            font-family: Verdana, Trebuchet MS, Arial, sans-serif, Helvetica;
            font-size:11px;
}
#menuboczne A:link {text-decoration: none; color: #0000ff;}
A:visited {text-decoration: none; color: #0000ff;}
A:active {text-decoration: none; color: #0000ff;}
A:hover {font-weight:bold; text-decoration: underline; color: #0000ff;}

#menu1 {background: url(images/top_kategorie.jpg) no-repeat;
      width: 200px;
       height: 43px;
       margin-top:10px;
       margin-left:10px;
       margin-right:7px;
       padding-left: 10px;
    padding-top: 10px;
    font: bold 14px "Verdana";
}
#tresc {background:#EEEEEE;
            width: 600px;
        height: 500px;
        float:left;
        overflow: auto;
        font-family: Verdana, Trebuchet MS, Arial, sans-serif, Helvetica;
               font-size:11px;
        text-align:justify;
        line-height:20px;
        margin-top:6px;
        margin-left:6px;

}

#box {
width: 550px;
margin-left:20px;
margin-top:25px;
margin-right:25px;
}

#box .title {
padding-left: 10px;
padding-top: 12px;
font: bold 12px "Verdana";
text-align:left;
}

#box .top {
background: url(images/top.jpg) no-repeat;
height: 43px;
width: 532px;
}

#box .bot {
background: url(images/bot.jpg) no-repeat;
height: 10px;
width: 550px;
margin-bottom:25px;
background-position: center top;
}

#box .mid {
background: url(images/mid.jpg) repeat-y;
height: 100%;
width: 550px;
background-position: center top;
}

#box .content {
width: 530px;
padding-bottom: 10px;
padding-top: 10px;
padding-left: 10px;
padding-right: 10px;
font: normal 12px "Verdana";
text-align:justify;
line-height: 20px;
}

#komentarze {width:600px;
   height:400px;
   float:left;
   margin-left:6px;
   margin-top:6px;
}
#prawy {
background: url(images/mid.jpg) repeat-y;
            width: 188px;
        height: 1748px;
        float:right;
        overflow: auto;
        font-family: Verdana, Trebuchet MS, Arial, sans-serif, Helvetica;
               font-size:11px;
        text-align:justify;
        margin-top:6px;
  
}
#prawy_wew {background: url(images/top_prawy.jpg) no-repeat;
      width: 168px;
       height: 43px;
       margin-top:10px;
       margin-left:10px;
       margin-right:10px;
       padding-left: 10px;
    padding-top: 10px;
    font: bold 14px "Verdana";
}
#adres {background:#c6d1fc;
    width: 156px;
    height: 113px;
       margin-left:10px;
       margin-right:10px;
       padding-left: 10px;
       padding-top:5px;
    font: 12px "Verdana";
    line-height:17px;
}  
#kontakt {
background: url(images/mid.jpg) repeat-y;
            width: 400px;
        height: 400px;
        float:left;
        margin-top:6px;      
        margin-bottom:6px;
        margin-left:6px;
            font-family: Verdana, Trebuchet MS, Arial, sans-serif, Helvetica;
            font-size:11px;}


#kontakt_wew {background: url(images/top_kontakt.jpg) no-repeat;
      width: 475px;
       height: 43px;
       margin-top:10px;
       margin-left:10px;
       margin-right:6px;
       padding-left: 10px;
    padding-top: 10px;
    font: bold 12px "Verdana";
  
}

#newsletter {
background: url(images/mid.jpg) repeat-y;
            width: 187px;
        height: 195px;
        float:right;
        margin-bottom:6px;       
        margin-left:6px;
        margin-right:6px;
            font-family: Verdana, Trebuchet MS, Arial, sans-serif, Helvetica;
            font-size:11px;
            text-align:left;

  
}
#newsletter_wew {background: url(images/top_newsletter.jpg) no-repeat;
      width: 250px;
       height: 43px;
       float:right;
       margin-top:10px;
       margin-left:10px;
       margin-right:10px;
       padding-left: 10px;
    padding-top: 10px;
    font: bold 14px "Verdana";
}
#sonda {
background: url(images/mid.jpg) repeat-y;
            width: 187px;
        height: 200px;
        float:right;
        margin-bottom:6px;     
        margin-top:6px;
        margin-right:6px;
        margin-left:6px;
            font-family: Verdana, Trebuchet MS, Arial, sans-serif, Helvetica;
            font-size:11px;
            color:#000000;
              text-align:left;
  
}
#sonda_wew{background: url(images/top_sonda.jpg) no-repeat;
      width: 477px;
       height: 43px;
       float:left;
       margin-top:10px;
       margin-right:10px;
       margin-left:10px;
       padding-left: 10px;
    padding-top: 10px;
    font: bold 14px "Verdana";
  
}
#logowanie {
background: url(images/mid.jpg) repeat-y;
            width: 315px;
        height: 430px;
        float:left;
        overflow: auto;
        font-family: Verdana, Trebuchet MS, Arial, sans-serif, Helvetica;
               font-size:11px;
        text-align:left;
        line-height:20px;
        margin-bottom:6px;
        margin-left:6px;
  
}
#logowanie_wew {background: url(images/top_logowanie.jpg) no-repeat;
      width: 290px;
       height: 43px;
         float:left;
       margin-top:10px;
       margin-left:10px;
       margin-right:10px;
       padding-left: 10px;
    padding-top: 10px;
    font: bold 14px "Verdana";
}
#stopka {background:#0000ff;
            width: 1000px;
        height: 25px;
        padding-top:5px;
      font-family: Verdana, Trebuchet MS, Verdana, sans-serif, Helvetica;
    font-size:12px;
    clear: both;
    width: 1000px;
    color: #FFFFFF;
    text-align:center;
}
A oto skrypt ppaginacji.
config.php
Kod PHP:
$mysql_hostname = "localhost";
$mysql_user = "username";
$mysql_password = "password";
$mysql_database = "database";
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password)
or die("Opps some thing went wrong");
mysql_select_db($mysql_database, $bd)
or die("Opps some thing went wrong");
?>
jquery_pagination.js
[quote]
$(document).ready(function()
{
//Display Loading Image
function Display_Load()
{
$("#loading").fadeIn(900,0);
$("#loading").html("<img src="bigLoader.gif" />");
}
//Hide Loading Image
function Hide_Load()
{
$("#loading").fadeOut('slow');
};

//Default Starting Page Results
$("#pagination li:first")
.css({'color' : '#FF0084'}).css({'border' : 'none'});
Display_Load();
$("#content").load("pagination_data.php?page=1", Hide_Load());

//Pagination Click
$("#pagination li").click(function(){
Display_Load();
//CSS Styles
$("#pagination li")
.css({'border' : 'solid #dddddd 1px'})
.css({'color' : '#0063DC'});

$(this)
.css({'color' : '#FF0084'})
.css({'border' : 'none'});

//Loading Data
var pageNum = this.id;
$("#content").load("pagination_data.php?page=" + pageNum, Hide_Load());
});

});
[/php]
pagination.php
Kod PHP:
<?php
include('config.php');
$per_page = 9;

//Calculating no of pages
$sql = "select * from messages";
$result = mysql_query($sql);
$count = mysql_num_rows($result);
$pages = ceil($count/$per_page)
?>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/
libs/jquery/1.3.0/jquery.min.js"></script>
<script type="text/javascript" src="jquery_pagination.js"></script>

<div id="loading" ></div>
<div id="content" ></div>
<ul id="pagination">
<?php
//Pagination Numbers
for($i=1; $i<=$pages; $i++)
{
echo '<li id="'.$i.'">'.$i.'</li>';
}
?>
</ul> 
pagination_data.php
Kod PHP:
<?php
include('config.php');
$per_page = 9;
if($_GET)
{
$page=$_GET['page'];
}

$start = ($page-1)*$per_page;
$sql = "select * from messages order by msg_id limit $start,$per_page";
$result = mysql_query($sql);
?>
<table width="800px">
<?php
while($row = mysql_fetch_array($result))
{
$msg_id=$row['msg_id'];
$message=$row['message'];
?>
<tr>
<td><?php echo $msg_id; ?></td>
<td><?php echo $message; ?></td>
</tr>
<?php
}
?>
</table> 
CSS Code
Kod:
#loading
{
width: 100%;
position: absolute;
}
li
{
list-style: none;
float: left;
margin-right: 16px;
padding:5px;
border:solid 1px #dddddd;
color:#0063DC;
}
li:hover
{
color:#FF0084;
cursor: pointer;
}
Bardzo mi zależy na pomocy, więc bardzo proszę kogoś życzliwego. Z góry dziękuje za zainteresowanie.
Szukaj
Odpowiedz
Pedro84 Offline
Przyjaciel Forum
****
Liczba postów: 2,587
Liczba wątków: 2
Dołączył: 03-04-2010
Reputacja: 58
#2
22-11-2010, 17:58
Google.pl -> php paginacja. Setki przykładów. Implementacje. Nic trudnego...
Szukaj
Odpowiedz


Podobne wątki…
Wątek: Autor Odpowiedzi: Wyświetleń: Ostatni post
  pomoc z google analitycs blondynka2 1 2,526 09-03-2015, 04:54
Ostatni post: blondynka2
  Prosze o pomoc - kolor formularza kontaktowego puchallowen 3 4,015 08-11-2014, 14:40
Ostatni post: Kartofelek
  [Skrypt] Okienko z reklamą na wierzchu strony www krysek76 1 2,637 08-05-2014, 20:39
Ostatni post: Kartofelek
  Proszę o rady i wskazówki sauron33 4 2,879 22-05-2013, 17:27
Ostatni post: kornell
  Wyszukiwarka na stronie - kod proszę o pomoc saur0n 2 2,543 10-05-2013, 23:45
Ostatni post: kornell

Skocz do:


Użytkownicy przeglądający ten wątek:
Sponsorzy i przyjaciele
SeoHost.pl