Smarty

[thiebo]

Hello,

Trying to get SmartyPaginate to work, here's what I do :


[php:1:177c5c9006]<?php
function get_db_results ()
{
$key = $_POST['key'];
$blah = $_POST['blah'];
$boo = $_POST['boo'];

$connexion = connexion (NOM, PASSE, BASE, SERVEUR);
$query = "SELECT * FROM table, tabletwo
WHERE table.id = idtabletwo
AND word LIKE '%$key%'
AND blah LIKE '%$blah%'
AND boo LIKE '%$boo%'
ORDER BY year;
$actes = sql_query($query);
return $actes;
}

?>[/php:1:177c5c9006]


and :



[php:1:177c5c9006]<?php
if (isSet($_POST['find']))
{
// required connect
SmartyPaginate::connect();
// set items per page
SmartyPaginate::setLimit(7);

$start = SmartyPaginate::getCurrentIndex();
$limit = SmartyPaginate::getLimit();
$data = get_db_results ();

$smarty->assign('actes', array_slice($data, $start, $limit));
SmartyPaginate::setTotal(count_results());

SmartyPaginate::assign($smarty);
// display results
$smarty->display('listeactes.tpl');
}

?>[/php:1:177c5c9006]

where count_results() is a simple mysql_num_rows.
(I know I could have used SQL_CALC_FOUND_ROWS)...

this returns nice results when I get it going, counts the results correctly, provides a nice array (did a print_r(get_db_results())

but when I click on the link to the 7 next results, I get a white page, no error message and nothing in view-source.

The url does change from http://localhost/simple.php to http://localhost/simple.php?next=8

but that's about it.

I was hoping maybe to resolve this by using the SmartyPaginate::getUrl() function, but since I don't get any error messages, I'm not certain whether this would be a solution.

I don't see what I'm doing wrong here....

[thiebo]

when integrating SmartyPaginate::getUrl, I think the problem comes from /?next=8 in the url not being identified....

this is what I now do :

[php:1:4f3053c10b]<?php
if (isSet($_POST['find']))
{
SmartyPaginate::connect();
SmartyPaginate::setLimit(7);

$motcle = $_POST['motcle'];

$connexion = connexion (NOM, PASSE, BASE, SERVEUR);
$query = sprintf ("SELECT * FROM table, tabletwo
WHERE table.id = idtabletwo
AND key LIKE '%%%1\$s%%' ", $key);
$data = sql_query ($query);
SmartyPaginate::setTotal(count_results());
SmartyPaginate::setUrl(sprintf("http://localhost/simple.php/?key=%s", $key));
$start = SmartyPaginate::getCurrentIndex();
$limit = SmartyPaginate::getLimit();

$smarty->assign('actes',array_slice ($data, $start, $limit));

SmartyPaginate::assign($smarty);
$smarty->display('listeactes.tpl');

}

?>[/php:1:4f3053c10b]

the first set of results is fine and the url : http://localhost/simple.php

click on the second set of resuts, get a white page, no error message and the url : http://localhost/simple.php/?key=don&next=8

"don" is what I had filled out for key, that's correct...

maybe the url isn't found, I don't understand...

[mohrt]

What does the template look like? this should work OK. maybe debug what data you are getting back from your SQL query. On a side note, it might be more efficient to select only the records you want from the db, instead of selecting everything and then slicing out the pagination content afterwards.

[thiebo]

Hi Monte,

Thanks for answering again.

When I enter a request with a keyword giving 20 results, the array I get from mysql is the 20 results array that looks like this :

[thiebo]

Sorry,

I'm not being precise enough. When I click on the second range of results, I do get error messages :

[mohrt]

It looks like you are trying to use $_POST on the second pagination query, which will be empty. You need to store the posted info for the next query. Something like:

[php:1:d4a649be16]session_start();
if(!empty($_POST))
$_SESSION['POST'] = $_POST;[/php:1:d4a649be16]

Then use $_SESSION['POST'] instead of $_POST in the rest of your logic.

[thiebo]

Hi again,

Thanks for this. This is what I now do :


[php:1:d359b3a9dc]<?php
session_start ();
require ('path.php');
require ('mysql.php');
require('SmartyPaginate.class.php');
$smarty = new Smarty_smartysite;
if(!empty($_POST)){
$_SESSION['POST'] = $_POST;
}

if (isSet($_POST['find']))
{

function count_results (){
bla bla
}

SmartyPaginate::connect();
SmartyPaginate::setLimit(7);
$motcle = $_SESSION['POST']['motcle'];
$connexion = connexion (NOM, PASSE, BASE, SERVEUR);
$query = sprintf ("SELECT * FROM Actes, Bibliographie
WHERE Bibliographie.id = idBiblio
AND MotsClef LIKE '%%%1\$s%%' ", $motcle);
$data = sql_query ($query);
SmartyPaginate::setTotal(count_results());
SmartyPaginate::setUrl(sprintf("http://localhost/fonstheobaldi/privmed/actesimple.php/?motcle=%s", $motcle));
$start = SmartyPaginate::getCurrentIndex();
$limit = SmartyPaginate::getLimit();
$smarty->assign('actes',array_slice ($data, $start, $limit));
SmartyPaginate::assign($smarty);}
$smarty->display('listeactes.tpl');
?>[/php:1:d359b3a9dc]


Entering a query giving 20 results, are correctly counted, first page looks fine, clicking on second page, gives me a white page with only my navigation bar, and this url :

http://localhost/fonstheobaldi/privmed/actesimple.php/?motcle=don&next=8

trying to get back to the homepage, the url becomes :

http://localhost/fonstheobaldi/privmed/actesimple.php/accueil.php

as if it's trying to reach both pages....

sorry to be a pain on this one... I really need the pagination, and I really appreciate the smarty logic, so I don't want to give up.

Many thanks again,

Thiebo

[mohrt]

Open the smarty debugging console ($smarty->debugging = true) and see if the data you expect is getting assigned to the template. Did you get the PHP errors figured out?

[thiebo]

well well well,
when I put debugging to true, I get some results !
on the first set of results (the ones that look fine) :

[mohrt]

Actually those are just warnings, you're error reporting is set way high. You should try using the default:

error_reporting(E_ALL ^ E_NOTICE);

[thiebo]

yes, but error_reporting(E_ALL ^ E_NOTICE);
puts it to a lower level of reporting. I'm still developping on my own computer, once I publish my site on a server, I will not have much choise of the level of errors. For the time being, I'm hoping to make this the best I can...

this really is strange : the exemple you give in the README document is clear and works really neat, but for some reason I just don't understand, I find difficulties changing $_data = range (1,100) to $_data = mysql_query_results(). It seems dead simple in principle, but I've again spent a long weekend trying to paginate.... (happy me, my wife is with my in-laws).
Still the range of data I get from my mysql_query is an array just as many other arrays of mysql-results in my website.

you don't happen to see what I'm doing wrong ?

[mohrt]

I can't see from what you posted, I guess you'll have to compare line by line until it becomes apparent what isn't right.

[thiebo]

I guess...
many thanks for your time and help,
kind regards,