La requete est du type : SELECT * FROM sgun_guilde WHERE tag = $tag;
La variable tag est importer grâce à une fonction recherche dans une page htm
Voici la fonction recherche :
Code
<form id="search_form" method="post" action="<!--[pnmodurl modname="SGUnivers" type="FFG" func="guilde"]-->">
<div>
<input type="text" id="search_q" name="q" size="15" maxlength="15" value="<!--[$tag]-->" />
<input type="submit" value="<!--[pnml name="_SEARCH"]-->" />
</div>
</form>
<div>
<input type="text" id="search_q" name="q" size="15" maxlength="15" value="<!--[$tag]-->" />
<input type="submit" value="<!--[pnml name="_SEARCH"]-->" />
</div>
</form>
Voici ce que j'ai mis dans le fichier pnFFG.php (=pnuser.php)
Code
function SGUnivers_FFG_guilde($args)
{
// SELECT * FROM sgun_guilde WHERE tag = $tag;
$pntable = pnDBGetTables();
$guildecolumn = $pntable['sgun_guilde_column'];
$where = "WHERE $guildecolumn[tag] = '" . pnVarPrepForStore($tag) . "'";
$objArray = DBUtil::selectObjectArray ('sgun_guilde', $where, $orderBy);
$objectData = $objectArray->get($where, $sortParam, $startnum-1, $pagesize);
// get total number of records for building the pagination by method call
$objcount = $objectArray->getCount($where);
// get pnRender instance for this module
$render = pnRender::getInstance('SGUnivers', false);
// assign the object-array we loaded above
$render->assign('objectArray', $objectData);
// assign the information required to create the pager
$render->assign('pager', array('numitems' => $objcount,
'itemsperpage' => $pagesize));
// fetch and return the appropriate template
return SGUnivers_processRenderTemplate($render, 'FFG', 'guilde', $args);
}
{
// SELECT * FROM sgun_guilde WHERE tag = $tag;
$pntable = pnDBGetTables();
$guildecolumn = $pntable['sgun_guilde_column'];
$where = "WHERE $guildecolumn[tag] = '" . pnVarPrepForStore($tag) . "'";
$objArray = DBUtil::selectObjectArray ('sgun_guilde', $where, $orderBy);
$objectData = $objectArray->get($where, $sortParam, $startnum-1, $pagesize);
// get total number of records for building the pagination by method call
$objcount = $objectArray->getCount($where);
// get pnRender instance for this module
$render = pnRender::getInstance('SGUnivers', false);
// assign the object-array we loaded above
$render->assign('objectArray', $objectData);
// assign the information required to create the pager
$render->assign('pager', array('numitems' => $objcount,
'itemsperpage' => $pagesize));
// fetch and return the appropriate template
return SGUnivers_processRenderTemplate($render, 'FFG', 'guilde', $args);
}
et voici la page SGUnivers_FFG_guilde.htm
Code
<!--[* purpose of this template: view template for FFG area *]-->
<!--[include file="SGUnivers_FFG_header.htm"]-->
<table class="pn-admintable">
<thead>
<tr>
<th align="right" valign="middle">
<!--[pnml name="ID GUILDE"]-->
</a>
</th>
<th align="left" valign="middle">
<!--[pnml name="TAG DE LA GUILDE"]-->
</a>
</th>
<th align="left" valign="middle">
<!--[pnml name="NOM DE LA GUILDE"]-->
</a>
</th>
</tr>
</thead>
<tbody>
<!--[foreach from=$objectArray item="guilde"]-->
<tr class="<!--[cycle values="pn-odd, pn-even"]-->">
<td align="right" valign="top">
<!--[$guilde.guildeid|pnvarprepfordisplay|default:""]-->
</td>
<td align="left" valign="top">
<!--[$guilde.tag|pnmodcallhooks|pnvarprephtmldisplay|default:""]-->
</td>
<td align="left" valign="top">
<!--[$guilde.nomguilde|pnvarprepfordisplay|default:""]-->
</td>
</tr>
<!--[foreachelse]-->
<tr class="<!--[cycle values="pn-odd, pn-even"]-->">
<td align="left" valign="top" colspan="4">
<!--[pnml name="_NOSUCHITEMFOUND" i=$itemsname]-->
</td></tr>
<!--[/foreach]-->
</tbody>
</table>
<!--[pager rowcount=$pager.numitems limit=$pager.itemsperpage]-->
</div>
<!--[include file="SGUnivers_FFG_footer.htm"]-->
<!--[include file="SGUnivers_FFG_header.htm"]-->
<table class="pn-admintable">
<thead>
<tr>
<th align="right" valign="middle">
<!--[pnml name="ID GUILDE"]-->
</a>
</th>
<th align="left" valign="middle">
<!--[pnml name="TAG DE LA GUILDE"]-->
</a>
</th>
<th align="left" valign="middle">
<!--[pnml name="NOM DE LA GUILDE"]-->
</a>
</th>
</tr>
</thead>
<tbody>
<!--[foreach from=$objectArray item="guilde"]-->
<tr class="<!--[cycle values="pn-odd, pn-even"]-->">
<td align="right" valign="top">
<!--[$guilde.guildeid|pnvarprepfordisplay|default:""]-->
</td>
<td align="left" valign="top">
<!--[$guilde.tag|pnmodcallhooks|pnvarprephtmldisplay|default:""]-->
</td>
<td align="left" valign="top">
<!--[$guilde.nomguilde|pnvarprepfordisplay|default:""]-->
</td>
</tr>
<!--[foreachelse]-->
<tr class="<!--[cycle values="pn-odd, pn-even"]-->">
<td align="left" valign="top" colspan="4">
<!--[pnml name="_NOSUCHITEMFOUND" i=$itemsname]-->
</td></tr>
<!--[/foreach]-->
</tbody>
</table>
<!--[pager rowcount=$pager.numitems limit=$pager.itemsperpage]-->
</div>
<!--[include file="SGUnivers_FFG_footer.htm"]-->
J'ai lu la doc anglaise concernant le Dbutil:: Mais apparement quelques choses à du m'échapper. Je tiens aussi à signaler que le pntable est rempli correctement (grâce à modulestudio)
Merci de votre aide
