Need help to make dinamic pagination
i need help to clean sytanx errors a little and to do a pagination for dinamic pages.i give a beer on paypall who helps me at the finish here is my code
<?php require_once('./Connections/filminitaliano.php');
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$maxRows_listaFilm = 10;
$pageNum_listaFilm = 0;
if (isset($_GET['pageNum_listaFilm'])) {
$pageNum_listaFilm = $_GET['pageNum_listaFilm'];
}
$startRow_listaFilm = $pageNum_listaFilm * $maxRows_listaFilm;
$varCategoria_listaFilm = "0";
if (isset($_GET['cat']) && $_GET['cat'] > 0 ? (int) $_GET['cat'] : 0){
$varCategoria_listaFilm = $_GET["cat"];
}
else {
header("Location: genere.php?cat=1/Azione");
}
mysql_select_db($database_filminitaliano, $filminitaliano);
$query_listaFilm = sprintf("SELECT * FROM filme WHERE filme.intCategoria = %s", GetSQLValueString($varCategoria_listaFilm, "int"));
$query_limit_listaFilm = sprintf("%s LIMIT %d, %d", $query_listaFilm, $startRow_listaFilm, $maxRows_listaFilm);
$listaFilm = mysql_query($query_limit_listaFilm, $filminitaliano) or die(mysql_error());
$row_listaFilm = mysql_fetch_assoc($listaFilm);
if (isset($_GET['totalRows_listaFilm'])) {
$totalRows_listaFilm = $_GET['totalRows_listaFilm'];
} else {
$all_listaFilm = mysql_query($query_listaFilm);
$totalRows_listaFilm = mysql_num_rows($all_listaFilm);
}
$totalPages_listaFilm = ceil($totalRows_listaFilm/$maxRows_listaFilm)-1;
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Site Setup</title>
<meta name="viewport" content="width=device-width">
<!-- Main stylesheet imports bootstrap css and adds custom -->
<link href="css/style.css" rel="stylesheet">
<!-- Modernizr for browser feature-checking
and HTML5shim (included) see modernizr.com -->
<script src="js/modernizr-2.5.3.min.js"></script>
<!-- Fav and touch icons -->
<!-- OR remove these lines and place icons directly
in the site root folder mathiasbynens.be/notes/touch-icons -->
<link rel="shortcut icon" href="img/favicon.ico">
<link rel="apple-touch-icon" href="img/apple-touch-icon.png">
<link rel="apple-touch-icon" sizes="72x72" href="img/apple-touch-icon-72x72.png">
<link rel="apple-touch-icon" sizes="114x114" href="img/apple-touch-icon-114x114.png">
<link rel="stylesheet" type="text/css" href="css/demo.css" />
<link rel="stylesheet" type="text/css" href="css/elastislide.css" />
<link rel="stylesheet" type="text/css" href="css/custom.css" />
<script src="js/modernizr.custom.17475.js"></script>
</head>
<body>
<div class="navbar navbar-fixed-top">
<div class="navbar-inner">
<div class="container">
<a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</a>
<a class="brand" href="index.html" style="font-family:'alba'; font-size:24px;">Film in italiano.com</a>
<div class="nav-collapse">
<ul class="nav">
<li class="active"><a href="#"><i class="icon-home icon-white"></i> Homepage</a></li>
<li><a href="#">In Cinema</a></li>
<li><a href="#">Articoli</a></li>
<li><a href="#">Accesso utenti</a></li>
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown">Genere <b class="caret"></b></a>
<ul class="dropdown-menu">
<?php include 'inc/listacategoria.php'?>
</ul>
</li>
</ul>
<form class="navbar-search pull-right" action="">
<input type="text" class="search-query span2" placeholder="Search">
</form>
</div><!-- /.nav-collapse -->
</div><!-- /.container -->
</div><!-- /navbar-inner -->
</div><!-- /navbar -->
<div class="container">
<p>ULTIMI FILM AGGIUNTI</p>
<div class="container demo-1">
<!-- Codrops top bar -->
<!--/ Codrops top bar -->
<div class="main">
<header class="clearfix">
<nav class="codrops-demos">
</nav>
</header>
<!-- Elastislide Carousel -->
</div>
</div>
<div>
</div>
<table width="100%" border="0">
<tr>
<td><?php if ($totalRows_listaFilm > 0) { // Show if recordset not empty ?>
<?php do { ?>
<div id="mainwrapper">
<!-- Image Caption 1 -->
<div id="box-1" class="box"> <a href="film.php?id=<?php echo mysql_real_escape_string($row_listaFilm['id']); ?>/<?php echo $row_listaFilm['titolo_link']; ?>"><img src="copFilm/descrcare.jpg" width="150" height="199" id="image-1"/></a>
<span class="caption simple-caption">
<div style="width:150"><p style="font-size:12px;"><?php echo $row_listaFilm['titolo']; ?></p></div>
</span>
</div></div>
<?php } while ($row_listaFilm = mysql_fetch_assoc($listaFilm)); ?>
<?php } // Show if recordset not empty ?>
<?php if ($totalRows_listaFilm == 0) { // Show if recordset empty ?>
Nessun film in questa categoria
<?php } // Show if recordset empty ?></td>
</tr>
<tr>
<td>Space for pagination </td>
</tr>
</table>
</div>
</div> <!-- /container -->
<!-- ==============================================
JavaScript below! -->
<!-- jQuery via Google + local fallback, see h5bp.com -->
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script>window.jQuery || document.write('<script src="js/jquery-1.7.1.min.js"><\/script>')</script>
<!-- Bootstrap JS -->
<script src="js/bootstrap.min.js"></script>
<!-- Prettify -->
<script src="js/prettify/prettify.js"></script>
<!-- Initialize Scripts -->
<script>
addEventListener('load', prettyPrint, false);
$(document).ready(function(){
// Activate prettyprint
$('pre').addClass('prettyprint');
// Initialize tabs and pills
$('.note-tabs').tab();
}); // end document.ready
</script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
<script type="text/javascript" src="js/jquerypp.custom.js"></script>
<script type="text/javascript" src="js/jquery.elastislide.js"></script>
<script type="text/javascript">
$( '#carousel' ).elastislide();
</script>
</body>
</html>
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Bookmarks