Hello,

Could you help me to the next point.

URL:

localhost/dominique-lieffrig/index.php/mnu-sites?categorie=Divers

Content:

{arijdatatable bAutoWidth="false" bPaginate="true"}
{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="CATEGORIE" alias="CATEGORIE" width="20%"}
{/arisqltablecolumn}

{arisqltablecolumn id="SUJET" alias="SUJET" width="40%"}
{/arisqltablecolumn}

{arisqltablecolumn id="URL" alias="URL"}
{coltemplate}<a href="{$URL}" target="_blank">{$URL}</a>{/coltemplate}
{/arisqltablecolumn}


{/arisqltablecolumns}
{arisqltablequery}
SELECT sit_abrev_categorie AS CATEGORIE,sit_sujet AS SUJET, sit_url as URL
FROM tbl_site_sit where sit_abrev_categorie = {$REQUEST:categorie} order by sit_abrev_categorie
{/arisqltablequery}
{/arisqltable}
{/arijdatatable}


I do not get results.

Thank you.

Best regards.

Dominique Lieffrig

Hello,

Your sent the link to your local machine. It is not available over the Internet.

About your plugin code, it is not possible to use {$REQUEST:categorie} in SQL query.

Regards,
ARI Soft

Hello,

Thank you for your reply.

On localhost, it was just to show the passage of a parameter value.

How can I do to get the value from the URL and use it in the SQL statement of the plugin ?

Thank you.

Best regards.

Dominique Lieffrig

For example you can use DirectPHP Joomla! plugin to use a PHP code in articles. It is possible to place PHP code which will read a request variable inside a plugin code with help of DirectPHP (or similar) plugin.

Regards,
ARI Soft

Thank you.

I installed the plugin and I inserted the following code in the property "Content" of the Smart Content plugin but it does not work.
I also put the php code in the article containing the module, but without success.

<?php
$categorie = $_GET['categorie'];
echo $categorie;
?>
{arijdatatable bAutoWidth="false" bPaginate="true"}
<?php echo date('l j D, Y H:i:s');?>
{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="CATEGORIE" alias="CATEGORIE" width="20%"}
{/arisqltablecolumn}

{arisqltablecolumn id="SUJET" alias="SUJET" width="40%"}
{/arisqltablecolumn}

{arisqltablecolumn id="URL" alias="URL"}
{coltemplate}<a href="{$URL}" target="_blank">{$URL}</a>{/coltemplate}
{/arisqltablecolumn}


{/arisqltablecolumns}
{arisqltablequery}
SELECT sit_abrev_categorie AS CATEGORIE,sit_sujet AS SUJET, sit_url as URL
FROM tbl_site_sit where sit_abrev_categorie = {$REQUEST:categorie} order by sit_abrev_categorie
{/arisqltablequery}
{/arisqltable}
{/arijdatatable}


Can you help me.

Thank you very much.

Dominique

Could you provide a link to a page where we can see the problem and a temporary access to your J! backend by email so we can investigate it?

Regards,
ARI Soft