Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Variable in URL
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Variable in URL
#42968
Variable in URL 4 Years, 3 Months ago Karma: 0
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
The administrator has disabled public write access.
 
#42977
Re:Variable in URL 4 Years, 3 Months ago Karma: 667
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
The administrator has disabled public write access.
 
#42991
Re:Variable in URL 4 Years, 3 Months ago Karma: 0
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
The administrator has disabled public write access.
 
#42992
Re:Variable in URL 4 Years, 3 Months ago Karma: 667
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
The administrator has disabled public write access.
 
#42994
Re:Variable in URL 4 Years, 3 Months ago Karma: 0
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
The administrator has disabled public write access.
 
#42995
Re:Variable in URL 4 Years, 3 Months ago Karma: 667
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
The administrator has disabled public write access.
 
Go to topPage: 1