ARI Soft - Passing parameters to SQL

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show Cart

Recent Events

31/12/2023 New Year SALE

We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

more...
21/11/2023 BLACK FRIDAY 23 is coming

BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.

more...

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

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

Passing parameters to SQL

(1 viewing) (1) Guest

Page: 1

TOPIC: Passing parameters to SQL

Forum Tools

#68956

Passing parameters to SQL 1 Year, 10 Months ago	Karma: 0
Hi, Is there a worked example of passing parameters to a SQL query? I want to display only the first few columns on the first page and then when the user clicks on a link, it opens a new page with just the individual record showing (with all the other fields). What I really need to know is the format for the SQL in the sub page and the link on the main page (and how it is set up). Thanks Steve

Steevp

The administrator has disabled public write access.

#68964

Re:Passing parameters to SQL 1 Year, 10 Months ago Karma: 748

Hello,

If you want to use request parameters in SQL query, it will look like:

Code:



SELECT

 id, title

FROM

 #__content

WHERE id = {$REQUEST:VAR_NAME}

Just replace VAR_NAME with variable name. For example if want to pass ID via article_id variable, it will look like:

Code:



SELECT

 id, title

FROM

 #__content

WHERE id = {$REQUEST:article_id}

Regards,
ARI Soft

admin