Am fisieru index.php
Cod: Selectaţi tot
<?php
include_once ('db.php');
include_once ('function.php');
$xcategorie = $_GET['id'];
$page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]);
$limit = 10;
$startpoint = ($page * $limit) - $limit;
$statement = "`anunturi` where `categorie` = '" . $xcategorie . "'";
?>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link href="css/pagination.css" rel="stylesheet" type="text/css" />
<link href="css/B_blue.css" rel="stylesheet" type="text/css" />
<style type="text/css">
.records {
width: 700px;
height:2325;
margin: 5px;
padding:2px 5px;
border:1px solid #B6B6B6;
}
.record {
color: #474747;
margin: 20px 0;
padding: 3px 5px;
background:#E6E6E6;
border: 1px solid #B6B6B6;
cursor: pointer;
letter-spacing: 2px;
}
.round {
-moz-border-radius:8px;
-khtml-border-radius: 8px;
-webkit-border-radius: 8px;
border-radius:8px;
}
p.createdBy{
padding:5px;
width: 510px;
font-size:15px;
text-align:center;
}
p.createdBy a {color: #666666;text-decoration: none;}
</style>
<div class="records round">
<?php
//show records
$query = mysql_query("SELECT * FROM {$statement} LIMIT {$startpoint} , {$limit}");
while ($row = mysql_fetch_assoc($query)) {
$id = $row["id"];
$email_la_pag_anunt = $row["email"];
$vip = $row["vip"];
$textanunt = $row["textanunt"];
$categorie = $row["categorie"];
$titluanunt = $row["titluanunt"];
$data_adaugari = strftime("%d-%b-%Y", strtotime($row['data_adaugari']));
$expira = strftime("%d-%b-%Y", strtotime($row['expira']));
$check_pic = "anunt/$id/poza.jpg";
$default_pic = "anunt/0/poza.jpg";
if (file_exists($check_pic)) {
$user_pic = "<img src=\"$check_pic\" width=\"167px\" height=\"150\" border=\"0\" alt=\"Listing Image\" class=\"listingimage\" />";
} else {
$user_pic = "<img src=\"$default_pic\" width=\"167px\" height=\"150\" border=\"0\" alt=\"Listing Image\" class=\"listingimage\"/>";
}
$textanunt=''.$row['textanunt'].'';
$text = ucfirst($textanunt);
$textanuntCut = substr($text, 0, 300);
$titluanunt=''.$row['titluanunt'].'';
$titlu = ucfirst($titluanunt);
$titluanuntCut = substr($titlu, 0, 11);
$pret = $row["pret"];
$moneda = $row["moneda"];
?>
<div class="record round"><?php echo '<table width="690" border="0" cellspacing="10">
<tr>
<td width="187" height="150" rowspan="2" valign="top" background="imagini/background_display_prima_pagina.JPG"><div align="center" class="style3"><a href="anunt.php?id=' . $id . '"">' . $titluanuntCut . '</a></div>
<div align="center"><a href="anunt.php?id=' . $id . '">' . $user_pic . '</a></div></td>
<td width="469" height="131" valign="top" background="imagini/background_display_prima_pagina.JPG"><div class="style3">' . $textanuntCut . '...</div></td>
</tr>
<tr>
<td height="35" valign="top" background="imagini/background_display_prima_pagina.JPG"><div align="right" class="style2"><span class="style1">Pret: ' . $pret . ' ' . $moneda . '</span></div></td>
</tr>
</table>';?></div>
<?php
}
?>
<?php
echo pagination($statement,$limit,$page);
?>
</div>
Cod: Selectaţi tot
<?php
/**
* @link: http://www.Awcore.com/dev
*/
$xcategorie = $_GET['id'];
$xsubcategorie = $_GET['subcategorie'];
function pagination($query, $per_page = 10,$page = 1, $url = '?id=. $xcategorie .&'){
$query = "SELECT COUNT(*) as `num` FROM {$query}";
$row = mysql_fetch_array(mysql_query($query));
$total = $row['num'];
$adjacents = "2";
$page = ($page == 0 ? 1 : $page);
$start = ($page - 1) * $per_page;
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($total/$per_page);
$lpm1 = $lastpage - 1;
$pagination = "";
$xcategorie = $_GET['id'];
$xsubcategorie = $_GET['subcategorie'];
if($lastpage > 1)
{
$pagination .= "<ul class='pagination'>";
$pagination .= "<li class='details'>Page $page of $lastpage</li>";
if ($lastpage < 7 + ($adjacents * 2))
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<li><a class='current'>$counter</a></li>";
else
$pagination.= "<li><a href='?id=" . $xcategorie . "&subcategorie=" . $xsubcategorie . "&page=$counter'>$counter</a></li>";
}
}
elseif($lastpage > 5 + ($adjacents * 2))
{
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<li><a class='current'>$counter</a></li>";
else
$pagination.= "<li><a href='?id=" . $xcategorie . "&subcategorie=" . $xsubcategorie . "&page=$counter'>$counter</a></li>";
}
$pagination.= "<li class='dot'>...</li>";
$pagination.= "<li><a href='?id=" . $xcategorie . "&subcategorie=" . $xsubcategorie . "&page=$lpm1'>$lpm1</a></li>";
$pagination.= "<li><a href='?id=" . $xcategorie . "&subcategorie=" . $xsubcategorie . "&page=$lastpage'>$lastpage</a></li>";
}
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<li><a href='?id=" . $xcategorie . "&subcategorie=" . $xsubcategorie . "&page=1'>1</a></li>";
$pagination.= "<li><a href='?id=" . $xcategorie . "&subcategorie=" . $xsubcategorie . "&page=2'>2</a></li>";
$pagination.= "<li class='dot'>...</li>";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<li><a class='current'>$counter</a></li>";
else
$pagination.= "<li><a href='?id=" . $xcategorie . "&subcategorie=" . $xsubcategorie . "&page=$counter'>$counter</a></li>";
}
$pagination.= "<li class='dot'>..</li>";
$pagination.= "<li><a href='?id=" . $xcategorie . "&subcategorie=" . $xsubcategorie . "&page=$lpm1'>$lpm1</a></li>";
$pagination.= "<li><a href='?id=" . $xcategorie . "&subcategorie=" . $xsubcategorie . "&page=$lastpage'>$lastpage</a></li>";
}
else
{
$pagination.= "<li><a href='?id=" . $xcategorie . "&subcategorie=" . $xsubcategorie . "&page=1'>1</a></li>";
$pagination.= "<li><a href='?id=" . $xcategorie . "&subcategorie=" . $xsubcategorie . "&page=2'>2</a></li>";
$pagination.= "<li class='dot'>..</li>";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<li><a class='current'>$counter</a></li>";
else
$pagination.= "<li><a href='?id=" . $xcategorie . "&subcategorie=" . $xsubcategorie . "&page=$counter'>$counter</a></li>";
}
}
}
if ($page < $counter - 1){
$pagination.= "<li><a href='?id=" . $xcategorie . "&subcategorie=" . $xsubcategorie . "&page=$next'>Urmatoarea</a></li>";
$pagination.= "<li><a href='?id=" . $xcategorie . "&subcategorie=" . $xsubcategorie . "&page=$lastpage'>Ultima</a></li>";
}else{
$pagination.= "<li><a class='current'>Urmatoarea</a></li>";
$pagination.= "<li><a class='current'>Ultima</a></li>";
}
$pagination.= "</ul>\n";
}
return $pagination;
}
?>Cod: Selectaţi tot
<?php
/**
* @link: http://www.Awcore.com/dev
*/
$db = @mysql_connect('localhost', 'rootr', '') or die(mysql_error());
@mysql_select_db('test', $db) or die(mysql_error());
?>Un exemplu cum afiseaza este aici, adresa URL:
evi-anunturi.net/categorie.php?id=Telefoane&subcategorie=Telefoane%20mobile
Stima
