Systeme pagination

Fermé
jesaye Messages postés 45 Date d'inscription samedi 26 mars 2011 Statut Membre Dernière intervention 20 mai 2015 - 13 mai 2011 à 18:17
 jesaye - 14 mai 2011 à 00:29
Bonjour,

Je cherche une personne pouvant m'aider pour un système de pagination en php / mysql.

Le code et les requêtes sont déjà créer.

J'ai mis en place un script de ce frequency-decoder.com mais il marche pas.

Il faudrait m'aider à créer ou chercher mes erreurs dans mon script js paginate.

Merci d'avance

2 réponses

salut,
si tu nous donne le code on pourra te répondre ;)
0
Voici mon code javascript :
/*
paginate table object v2.1 by frequency-decoder.com

Released under a creative commons Attribution-ShareAlike 2.5 license (http://creativecommons.org/licenses/by-sa/2.5/)

Please credit frequency decoder in any derivative work - thanks

You are free:

* to copy, distribute, display, and perform the work
* to make derivative works
* to make commercial use of the work

Under the following conditions:

by Attribution.
--------------
You must attribute the work in the manner specified by the author or licensor.

sa
--
Share Alike. If you alter, transform, or build upon this work, you may distribute the resulting work only under a license identical to this one.

* For any reuse or distribution, you must make clear to others the license terms of this work.
* Any of these conditions can be waived if you get permission from the copyright holder.
*/

var tablePaginater = (function() {
/*

Localise the button titles here...

%p is replaced with the appropriate page number
%t is replaced with the total number of pages

*/
var tableInfo = {},
uniqueID = 0,
text = ["First Page","Previous Page (Page %p)","Next Page (Page %p)","Last Page (Page %t)","Page %p of %t"];

var addClass = function(e,c) {
if(new RegExp("(^|\\s)" + c + "(\\s|$)").test(e.className)) return;
e.className += ( e.className ? " " : "" ) + c;
};

/*@cc_on
/*@if (@_win32)
var removeClass = function(e,c) {
e.className = !c ? "" : e.className.replace(new RegExp("(^|\\s)" + c + "(\\s|$)"), " ").replace(/^\s*((?:[\S\s]*\S)?)\s*$/, '$1');
};
@else @*/
var removeClass = function(e,c) {
e.className = !c ? "" : (e.className || "").replace(new RegExp("(^|\\s)" + c + "(\\s|$)"), " ").replace(/^\s\s*/, '').replace(/\s\s*$/, '');
};
/*@end
@*/

var addEvent = function(obj, type, fn) {
if( obj.attachEvent ) {
obj["e"+type+fn] = fn;
obj[type+fn] = function(){obj["e"+type+fn]( window.event );};
obj.attachEvent( "on"+type, obj[type+fn] );
} else {
obj.addEventListener( type, fn, true );
};
};
var removeEvent = function(obj, type, fn) {
try {
if( obj.detachEvent ) {
obj.detachEvent( "on"+type, obj[type+fn] );
obj[type+fn] = null;
} else {
obj.removeEventListener( type, fn, true );
};
} catch(err) {};
};
var stopEvent = function(e) {
e = e || window.event;
if(e.stopPropagation) {
e.stopPropagation();
e.preventDefault();
};

/*@cc_on@*/
/*@if(@_win32)
e.cancelBubble = true;
e.returnValue = false;
/*@end@*/
return false;
};

var init = function(tableId) {
var tables = tableId && typeof(tableId) == "string" ? [document.getElementById(tableId)] : document.getElementsByTagName('table'),
hook, maxPages, visibleRows, numPages, cp, cb, rowList;

for(var t = 0, tbl; tbl = tables[t]; t++) {
if(tbl.className.search(/paginate-([0-9]+)/) == -1) { continue; };

if(!tbl.id) { tbl.id = "fdUniqueTableId_" + uniqueID++; };

maxPages = tbl.className.search(/max-pages-([0-9]+)/) == -1 ? null : Number(tbl.className.match(/max-pages-([0-9]+)/)[1]);
if(maxPages % 2 == 0 && maxPages > 1) { maxPages--; };

hook = tbl.getElementsByTagName('tbody');
hook = (hook.length) ? hook[0] : tbl;

visibleRows = calculateVisibleRows(hook);

if(maxPages > (visibleRows / Number(tbl.className.match(/paginate-([0-9]+)/)[1]))) {
maxPages = null;
};

numPages = Math.ceil(visibleRows / Number(tbl.className.match(/paginate-([0-9]+)/)[1]));

if(numPages < 2 && !(tbl.id in tableInfo)) {
continue;
};

cp = (tbl.id in tableInfo) ? Math.min(tableInfo[tbl.id].currentPage, numPages) : 1;

tableInfo[tbl.id] = {
rowsPerPage:Number(tbl.className.match(/paginate-([0-9]+)/)[1]),
currentPage:cp,
totalRows:hook.getElementsByTagName('tr').length,
hook:hook,
maxPages:maxPages,
numPages:numPages,
rowStyle:tbl.className.search(/rowstyle-([\S]+)/) != -1 ? tbl.className.match(/rowstyle-([\S]+)/)[1] : false,
callbacks:parseCallback(/^paginationcallback-/i, /paginationcallback-([\S-]+)/ig, tbl.className)
};

showPage(tbl.id);
hook = null;
};
};

var parseCallback = function(head, regExp, cname) {
var cbs = [],
matchs = cname.match(regExp),
parts, obj, func;

if(!matchs) { return []; };

for(var i = 0, mtch; mtch = matchs[i]; i++) {
mtch = mtch.replace(head, "").replace(/-/g, ".");

try {
if(mtch.indexOf(".") != -1) {
parts = mtch.split('.');
obj = window;
for (var x = 0, part; part = obj[parts[x]]; x++) {
if(part instanceof Function) {
(function() {
var method = part;
func = function (data) { method.apply(obj, [data]) };
})();
} else {
obj = part;
};
};
} else {
func = window[mtch];
};

if(!(func instanceof Function)) continue;
cbs[cbs.length] = func;
} catch(err) {};
};

return cbs;
};

var callback = function(tblId, opts) {
if(!(tblId in tableInfo) || !(tableInfo[tblId]["callbacks"].length)) return;
for(var i = 0, func; func = tableInfo[tblId]["callbacks"][i]; i++) {
func(opts || {});
};
};

var calculateVisibleRows = function(hook) {
var trs = hook.rows,
cnt = 0,
reg = /(^|\s)invisibleRow(\s|$)/;

for(var i = 0, tr; tr = trs[i]; i++) {
if(tr.parentNode != hook || tr.getElementsByTagName("th").length || (tr.parentNode && tr.parentNode.tagName.toLowerCase().search(/thead|tfoot/) != -1)) continue;
if(tr.className.search(reg) == -1) { cnt++; };
};

return cnt;
};

var createButton = function(details, ul, pseudo) {
var li = document.createElement("li"),
but = document.createElement(pseudo ? "div" : "a"),
span = document.createElement("span");

if(!pseudo) {
but.href = "#";
but.title = details.title;
};

but.className = details.className;

ul.appendChild(li);
li.appendChild(but);
but.appendChild(span);
span.appendChild(document.createTextNode(details.text));

if(!pseudo) {
li.onclick = but.onclick = buttonClick;
if(details.id) { but.id = details.id; };
};

li = but = span = null;
};
var removePagination = function(tableId) {
var wrapT = document.getElementById(tableId + "-fdtablePaginaterWrapTop"),
wrapB = document.getElementById(tableId + "-fdtablePaginaterWrapBottom");
if(wrapT) { wrapT.parentNode.removeChild(wrapT); };
if(wrapB) { wrapB.parentNode.removeChild(wrapB); };
};
var buildPagination = function(tblId) {
if(!(tblId in tableInfo)) { return; };

removePagination(tblId);

var details = tableInfo[tblId];

if(details.numPages < 2) return;

function resolveText(txt, curr) {
curr = curr || details.currentPage;
return txt.replace("%p", curr).replace("%t", details.numPages);
};

if(details.maxPages) {
findex = Math.max(0, Math.floor(Number(details.currentPage - 1) - (Number(details.maxPages - 1) / 2)));
lindex = findex + Number(details.maxPages);
if(lindex > details.numPages) {
lindex = details.numPages;
findex = Math.max(0, details.numPages - Number(details.maxPages));
};
} else {
findex = 0;
lindex = details.numPages;
};


var wrapT = document.createElement("div");
wrapT.className = "fdtablePaginaterWrap fdtablePaginatorWrapTop";
wrapT.id = tblId + "-fdtablePaginaterWrapTop";

var wrapB = document.createElement("div");
wrapB.className = "fdtablePaginaterWrap fdtablePaginatorWrapBottom";
wrapB.id = tblId + "-fdtablePaginaterWrapBottom";

// Create list scaffold
var ulT = document.createElement("ul");
ulT.id = tblId + "-tablePaginater";

var ulB = document.createElement("ul");
ulB.id = tblId + "-tablePaginaterClone";
ulT.className = ulB.className = "fdtablePaginater";

// Add to the wrapper DIVs
wrapT.appendChild(ulT);
wrapB.appendChild(ulB);

// FIRST (only created if maxPages set)
if(details.maxPages) {
createButton({title:text[0], className:"first-page", text:"\u00ab"}, ulT, !findex);
createButton({title:text[0], className:"first-page", text:"\u00ab"}, ulB, !findex);
};

// PREVIOUS (only created if there are more than two pages)
if(details.numPages > 2) {
createButton({title:resolveText(text[1], details.currentPage-1), className:"previous-page", text:"\u2039", id:tblId+"-previousPage"}, ulT, details.currentPage == 1);
createButton({title:resolveText(text[1], details.currentPage-1), className:"previous-page", text:"\u2039", id:tblId+"-previousPageC"}, ulB, details.currentPage == 1);
};

// NUMBERED
for(var i = findex; i < lindex; i++) {
createButton({title:resolveText(text[4], i+1), className:i != (details.currentPage-1) ? "page-"+(i+1) : "currentPage page-"+(i+1), text:(i+1), id:i == (details.currentPage-1) ? tblId + "-currentPage" : ""}, ulT);
createButton({title:resolveText(text[4], i+1), className:i != (details.currentPage-1) ? "page-"+(i+1) : "currentPage page-"+(i+1), text:(i+1), id:i == (details.currentPage-1) ? tblId + "-currentPageC" : ""}, ulB);
};

// NEXT (only created if there are more than two pages)
if(details.numPages > 2) {
createButton({title:resolveText(text[2], details.currentPage + 1), className:"next-page", text:"\u203a", id:tblId+"-nextPage"}, ulT, details.currentPage == details.numPages);
createButton({title:resolveText(text[2], details.currentPage + 1), className:"next-page", text:"\u203a", id:tblId+"-nextPageC"}, ulB, details.currentPage == details.numPages);
};

// LAST (only created if maxPages set)
if(details.maxPages) {
createButton({title:resolveText(text[3], details.numPages), className:"last-page", text:"\u00bb"}, ulT, lindex == details.numPages);
createButton({title:resolveText(text[3], details.numPages), className:"last-page", text:"\u00bb"}, ulB, lindex == details.numPages);
};

// DOM inject wrapper DIVs (FireFox 2.x Bug: this has to be done here if you use display:table)
if(document.getElementById(tblId+"-paginationListWrapTop")) {
document.getElementById(tblId+"-paginationListWrapTop").appendChild(wrapT);
} else {
document.getElementById(tblId).parentNode.insertBefore(wrapT, document.getElementById(tblId));
};

if(document.getElementById(tblId+"-paginationListWrapBottom")) {
document.getElementById(tblId+"-paginationListWrapBottom").appendChild(wrapB);
} else {
document.getElementById(tblId).parentNode.insertBefore(wrapB, document.getElementById(tblId).nextSibling);
};
};

// The tableSort script uses this function to redraw.
var tableSortRedraw = function(tableid, identical) {
if(!tableid || !(tableid in fdTableSort.tableCache) || !(tableid in tableInfo)) { return; };

var dataObj = fdTableSort.tableCache[tableid],
data = dataObj.data,
len1 = data.length,
len2 = len1 ? data[0].length - 1 : 0,
hook = dataObj.hook,
colStyle = dataObj.colStyle,
rowStyle = dataObj.rowStyle,
colOrder = dataObj.colOrder,
page = tableInfo[tableid].currentPage - 1,
d1 = tableInfo[tableid].rowsPerPage * page,
d2 = Math.min(tableInfo[tableid].totalRows, d1 + tableInfo[tableid].rowsPerPage),
cnt = 0,
rs = 0,
reg = /(^|\s)invisibleRow(\s|$)/,
tr, tds, cell, pos;

for(var i = 0; i < len1; i++) {
tr = data[i][len2];

if(colStyle) {
tds = tr.cells;
for(thPos in colOrder) {
if(!colOrder[thPos]) removeClass(tds[thPos], colStyle);
else addClass(tds[thPos], colStyle);
};
};

if(tr.className.search(reg) != -1) { continue; };

if(!identical) {
cnt++;

if(cnt > d1 && cnt <= d2) {
if(rowStyle) {
if(rs++ & 1) addClass(tr, rowStyle);
else removeClass(tr, rowStyle);
};
tr.style.display = "";
} else {
tr.style.display = "none";
};

// Netscape 8.1.2 requires the removeChild call or it freaks out, so add the line if you want to support this browser
// hook.removeChild(tr);
hook.appendChild(tr);
};
};

tr = tds = hook = null;
};

var showPage = function(tblId, pageNum) {
if(!(tblId in tableInfo)) { return; };

var page = Math.max(0, !pageNum ? tableInfo[tblId].currentPage - 1 : pageNum - 1),
d1 = tableInfo[tblId].rowsPerPage * page,
d2 = Math.min(tableInfo[tblId].totalRows, d1 + tableInfo[tblId].rowsPerPage),
trs = tableInfo[tblId].hook.rows,
cnt = 0,
rc = 0,
len = trs.length,
rs = tableInfo[tblId].rowStyle,
reg = /(^|\s)invisibleRow(\s|$)/,
row = [];

for(var i = 0; i < len; i++) {
if(trs[i].className.search(reg) != -1 || trs[i].getElementsByTagName("th").length || (trs[i].parentNode && trs[i].parentNode.tagName.toLowerCase().search(/thead|tfoot/) != -1)) { continue; };

cnt++;

if(cnt > d1 && cnt <= d2) {
if(rs) {
if(rc++ & 1) {
addClass(trs[i], rs);
} else {
removeClass(trs[i], rs);
}
};
trs[i].style.display = "";
row[row.length] = trs[i];
} else {
trs[i].style.display = "none";
};
};

buildPagination(tblId);
callback(tblId, {"table":tblId, "totalRows":len, "currentPage":(page+1), "rowsPerPage":tableInfo[tblId].rowsPerPage, "visibleRows":row});
};

var buttonClick = function(e) {
e = e || window.event;

var a = this.tagName.toLowerCase() == "a" ? this : this.getElementsByTagName("a")[0];

if(a.className.search("currentPage") != -1) return false;

var ul = this;
while(ul.tagName.toLowerCase() != "ul") ul = ul.parentNode;

var tblId = ul.id.replace("-tablePaginaterClone","").replace("-tablePaginater", "");

tableInfo[tblId].lastPage = tableInfo[tblId].currentPage;

var showPrevNext = 0;

if(a.className.search("previous-page") != -1) {
tableInfo[tblId].currentPage = tableInfo[tblId].currentPage > 1 ? tableInfo[tblId].currentPage - 1 : tableInfo[tblId].numPages;
showPrevNext = 1;
} else if(a.className.search("next-page") != -1) {
tableInfo[tblId].currentPage = tableInfo[tblId].currentPage < tableInfo[tblId].numPages ? tableInfo[tblId].currentPage + 1 : 1;
showPrevNext = 2;
} else if(a.className.search("first-page") != -1) {
tableInfo[tblId].currentPage = 1;
} else if(a.className.search("last-page") != -1) {
tableInfo[tblId].currentPage = tableInfo[tblId].numPages;
} else {
tableInfo[tblId].currentPage = parseInt(a.className.match(/page-([0-9]+)/)[1]) || 1;
};

showPage(tblId);

// Focus on the appropriate button (previous, next or the current page)
// I'm hoping screen readers are savvy enough to indicate the focus event to the user
if(showPrevNext == 1) {
var elem = document.getElementById(ul.id.search("-tablePaginaterClone") != -1 ? tblId + "-previousPageC" : tblId + "-previousPage");
} else if(showPrevNext == 2) {
var elem = document.getElementById(ul.id.search("-tablePaginaterClone") != -1 ? tblId + "-nextPageC" : tblId + "-nextPage");
} else {
var elem = document.getElementById(ul.id.search("-tablePaginaterClone") != -1 ? tblId + "-currentPageC" : tblId + "-currentPage");
};

if(elem && elem.tagName.toLowerCase() == "a") { elem.focus(); };

return stopEvent(e);
};

var onUnLoad = function(e) {
var tbl, lis, pagination, uls;
for(tblId in tableInfo) {
uls = [tblId + "-tablePaginater", tblId + "-tablePaginaterClone"];
for(var z = 0; z < 2; z++) {
pagination = document.getElementById(uls[z]);
if(!pagination) { continue; };
lis = pagination.getElementsByTagName("li");
for(var i = 0, li; li = lis[i]; i++) {
li.onclick = null;
if(li.getElementsByTagName("a").length) { li.getElementsByTagName("a")[0].onclick = null; };
};
};
};
};

addEvent(window, "load", init);
addEvent(window, "unload", onUnLoad);

return {
init: function(tableId) { init(tableId); },
redraw: function(tableid, identical) { tableSortRedraw(tableid, identical); },
tableIsPaginated: function(tableId) { return (tableId in tableInfo); },
changeTranslations: function(translations) { text = translations; }
};
})();



Voici mon code php :
<?php

if(isset($_GET['suppr']) && is_numeric($_GET['suppr']))
{
supprimermatchs($_GET['suppr']);
}

?>
<h1>Liste des Matchs</h1>

<div id="manage_tool">
<a href="index.php?page=match" title="Ajouter un Match">
<img src="./images/ajouter_data.png" />
<span>Ajouter</span>
</a>
<a href="index.php?page=list-match" title="Visualiser la liste">
<img src="./images/view_data.png" />
<span>Voir</span>
</a>
</div>

<div id="conteneur_tableau">

<ul id="theTable-tablePaginater" class="fdtablePaginater">
<li><a ... ><span>«</span></a></li>
<li><a ... ><span><</span></a></li>
<li><a ... ><span>1</span></a></li>
<li><a ... ><span>2</span></a></li>
...
<li><a ... ><span>N</span></a></li>
<li><a ... ><span>&rsaquo</span></a></li>
<li><div ... ><span>»</span></div></li>

</ul>

<table id="theTable" class="tabl_view" class="sortable-onload-3 no-arrow rowstyle-alt colstyle-alt paginate-10 max-pages-7 paginationcallback-callbackTest-calculateTotalRating paginationcallback-callbackTest-displayTextInfo sortcompletecallback-callbackTest-calculateTotalRating" >
<thead>
<tr>
<th class="t_edit">Modif</th>
<th class="t_del">Suppr</th>
<th class="numid sortable-num">Num</th>
<th class="numid sortable-num">Competition</th>
<th class="sortable-saison">Saison</th>
<th class="sortable-date">Date Match</th>
<th class="sortable-date">Heure</th>
<th class="sortable-lieu">Lieu</th>
<th class="sortable-lieu">Stade</th>
<th class="sortable-local">Local</th>
<th class="sortable-visiteur">Visiteur</th>
<th class="sortable-score_L">Scr Local</th>
<th class="sortable-score_V">Scr Visiteur</th>
<th class="sortable-forfait_L">Forf Local</th>
<th class="sortable-forfait_V">Forf Visiteur</th>
<th class="sortable-prolongation">Prolong</th>
<th class="sortable-tireauxbutes">Tir Bute</th>
<th class="sortable-tirebuteL">Tir Bute Local</th>
<th class="sortable-tirebuteV">Tir Bute Visiteur</th>
<th class="sortable-report">Report</th>
<th class="sortable-datereport">Date Report</th>
<th class="sortable-pointswin">Pts Gagné</th>
</tr>
</thead>
<tbody>
<?php
$result = get_list_matchs();
$num_ligne = 1; // initialisation du numero de chaque champs
while($match = mysql_fetch_assoc($result) ):
?>
<tr>
<td class="c_mod"><a href="index.php?page=match&modif=<?php echo $match['cal_id']; ?>" title="Modifier"><img src="./images/editer.png" /></a></td>
<td class="c_del"><a href="index.php?page=list-match&suppr=<?php echo $match['cal_id']; ?>" title="Supprimer" onclick="return(confirm('Etes-vous sûr de vouloir supprimer cette entrée?'));"><img src="./images/corbeille.gif" /></a></td>
<td class="t_num"><?php echo $num_ligne++; ?></td>
<td><?php echo get_compet($match['compet_id']); ?></td>
<td><?php echo $match['cal_saison']; ?></td>
<td><?php echo $match['cal_date']; ?></td>
<td><?php echo $match['cal_heure']; ?></td>
<td><?php echo $match['cal_lieu']; ?></td>
<td><?php echo $match['cal_stade']; ?></td>
<td><?php echo $match['cal_locaux']; ?></td>
<td><?php echo $match['cal_visiteurs']; ?></td>
<td><?php echo $match['cal_score_locaux']; ?></td>
<td><?php echo $match['cal_score_visiteurs']; ?></td>
<td><?php echo $match['cal_forfait_locaux']; ?></td>
<td><?php echo $match['cal_forfait_visiteurs']; ?></td>
<td><?php echo $match['cal_prolong']; ?></td>
<td><?php echo $match['cal_tirsaubut']; ?></td>
<td><?php echo $match['cal_tirsaubut_locaux']; ?></td>
<td><?php echo $match['cal_tirsaubut_visiteurs']; ?></td>
<td><?php echo $match['cal_report_bool']; ?></td>
<td><?php echo $match['cal_report_date']; ?></td>
<td><?php echo $match['cal_gainspt']; ?></td>
</tr>
<?php endwhile; ?>
</tbody>
</table >
</div>
0