ARI Soft - Populating records into complex table

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 Smart Content

Populating records into complex table

(1 viewing) (1) Guest

Page: 12 3 4 5

TOPIC: Populating records into complex table

Forum Tools

#30918

Populating records into complex table 11 Years, 8 Months ago	Karma: 0
These are awesome tools. But I cannot determine how to populate table cells with database field values. The table layout is moderately complex, and it will contain only about a dozen rows/records. No paging is necessary. I presume I will use {arisqltable} to iterate the database records. But, then, how do I populate the table rows with the field values? Thanks, David.

dwoosley

Reasonably nice guy.

The administrator has disabled public write access.

#30922

Re:Populating records into complex table 11 Years, 8 Months ago Karma: 748

Hello,

If you want to show data from a database, use "ARI SQL Table" plugin. A sample code:

Code:



{arisqltable}

  {arisqltablequery}

    SELECT id,title

    FROM #__content

  {/arisqltablequery}

{/arisqltable}

Regards,
ARI Soft

admin

The administrator has disabled public write access.

#30929

Re:Populating records into complex table 11 Years, 8 Months ago Karma: 0

I thought using "ARI SQL Table" is what I mentioned in my second paragraph.

I envision something that works like this:

Code:



{arisqltable}

    {arisqltablequery}

        SELECT * FROM myTable 

    {/arisqltablequery}

    <tr>

        <td>{AAA}</td>

        <td>{BBB}</td>

        <td><img src="path/{CCC}.jpg"/></td>

    </tr>

    <tr>

        <td colspan="3">

             {DDD}

        </td>

    </tr>

{/arisqltable}

... and how to obtain the database field values for AAA, BBB, CCC, and DDD is what I don't understand. And, notice that the record requires two rows.

David.

dwoosley

Reasonably nice guy.

Last Edit: 2012/08/26 22:27 By dwoosley.

The administrator has disabled public write access.

#30938

Re:Populating records into complex table 11 Years, 8 Months ago	Karma: 748
The extension doesn't support ability to show data from one database record on several row in HTML table, but it is possible to format values with help of {arisqltablecolumn} tag. Regards, ARI Soft

admin

The administrator has disabled public write access.

#30963

Re:Populating records into complex table 11 Years, 8 Months ago	Karma: 0
Which combination of tools can I use to create the list of locations shown on this page: http://www.gofarmersbank.com/service_branch_list.go Thanks.

dwoosley

Reasonably nice guy.

The administrator has disabled public write access.

#30964

Re:Populating records into complex table 11 Years, 8 Months ago	Karma: 748
Plugins from "ARI Smart Content" package can't show data from a database in format like on provided page. Regards, ARI Soft

admin

The administrator has disabled public write access.

Page: 12 3 4 5

Useful Links