Display MIGX customDB without TV.

91 Posts

alexmercenary Reply #1, 11 years, 7 months ago

Hi guys, hi Bruno.

I have set up a a couple of cmp's for a couple of custom tables using MIGXdb and this is working fine.

One of the CMP's i only want to manage from under Components > MyMIGXdbCMP and don't want to add it to a resource to manage from there.

So my question if my rows in my custom table aren't assigned to resources via a TV and are managed only via the components menu how can i display them on the front end?

I can't seem to get anything to work. Sorry if this is unclear, let me know and i'll try and clarify.

Cheers,

Alex

Twitter @alexmercenary

5,888 Posts

Bruno17 Reply #2, 11 years, 7 months ago

if its a simple listing, you can use rowboat. If its more complicated stuff and perhaps with some joins you can try to use blox.

Let me see your schema and some html-example, how you would like to display your datas.

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

91 Posts

alexmercenary Reply #3, 11 years, 7 months ago

It's pretty simple Bruno.

<?xml version="1.0" encoding="UTF-8"?>
<model package="fundrazors" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM">
    <object class="Fundrazor" table="fundrazors" extends="xPDOSimpleObject">
    	<field key="image" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
        <field key="title" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
        <field key="description" dbtype="text" phptype="string" null="false" default="" />
        
        <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
        <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
        
        <index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
			<column key="id" collation="A" null="false" />
		</index>
    </object>
</model>

and my rowTpl looks like this:

<div class="fr-event">
	<div class="image">
		<img src="[[+image]]" alt="[[+title]]" />
	</div>
	<div class="description">
		<h2>[[+title]]</h2>
		[[+description]]
	</div>
</div>

Thanks

Twitter @alexmercenary

91 Posts

alexmercenary Reply #4, 11 years, 7 months ago

The Rowboat addon looks perfect for that right?

* Rowboat is spot on for the job Bruno. Thanks again! [ed. note: alexmercenary last edited this post 11 years, 7 months ago.]

Twitter @alexmercenary