limiter le nombre de résultats
Bonjour a tous
Tous dabort je m'ecuse pour les faute d'orthographe.
Je suis nouveaux dans le domaine de php et smarty.
Et je voudais que le dernier ID de ma table sois afficher sur ma page. Or li m'affiche toute la table. Merci de votre indulgence.
Voici mon code
Fichier test.php
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Document sans titre</title>
</head>
<?php // Inclusion de la librairie
require_once('libs/Smarty.class.php');
define('MOTIV_ROOT_PATH','./');
include_once( MOTIV_ROOT_PATH.'include/dbc.inc.php' );// Ma connetion msql
require_once('header.php');
// Instanciation d'un l'objet Smarty
require_once('block.php');
$smarty->compile_check = true;
$smarty->debugging = false;
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;
}
}
mysql_select_db($dbname, $link);
$query_Recordset1 = "SELECT acceuilID, Titre1, article1, FROM table_motiv_acceuil LIMIT 1 acceuilID";
$Recordset1 = mysql_query($query_Recordset1, $link) or die(mysql_error());
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
#...your mysql connection & smarty initialization goes here
while ($row = mysql_fetch_assoc($Recordset1))
{
$id[] = $row['acceuilID'];
$titles[] = $row['Titre1'];
$article[] = $row['article1'];
}
$smarty = new Smarty();
$smarty->assign ('ids',$id);
$smarty->assign ('titles',$titles);
$smarty->assign ("articlesdroite",$article);
// Affichage du template après compilation
$smarty->cache_lifetime = 24 * 60 * 60;
$smarty->display('test.tpl');
?> |
Fichier test.tpl
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Test smarty</title>
</head>
<body>
<div id="conteneur"></div>
<div id="conteneur2"></div>
<div id="block4"><div id="block3"></div><div id="left_content">
<div class="h2"></div>
<div id "content">
</div>
</div>
</div>
<div id="content">
<div class="h1"></div>
<div class="content"><br /></div>
<span class="content">{section name=id loop=$titles}
{$articlesdroite[id]}{/section}
</span><br />
<div class="h1"><br />
</div></div>
</div></td><div id="block5"></div>
<div id="bloc_du_bas"></div></div>
</div><div id="bloc_du_bas2"></div></div>
</body>
</html> |