Select records from table and display

[alahiri]

How do I query from table and display the records?

Earlier I have done these.
1. Create a SQL structure and import it to database. Is this acceptable in Contao?
2. Create a form and bind it to the new table imported.
3. Save records in the table.

Now I want to do these.
1. Query the records (with / without conditions) from this table and display the records.
How do I do it? Is there any in-built solution? Is it possible to write PHP code? Where do I put the PHP file?

Any sort of advice would be great.

[ga.n]

How do I query from table and display the records?
1. Query the records (with / without conditions) from this table and display the records.
How do I do it? Is there any in-built solution? Is it possible to write PHP code? Where do I put the PHP file?

Any sort of advice would be great.

You can use a "Listing" frontend module, just create it from Themes -> <yourtheme> -> Modules, then show it by using a Content Element of type "Module"

[alahiri]

You can use a "Listing" frontend module, just create it from Themes -> <yourtheme> -> Modules, then show it by using a Content Element of type "Module"

Thank you ga.n. Its working.
Now I wish to display only the records which are uploaded by the log in user. Is there any way I can do it? How do I design the page?
Can I edit and delete the records, just like other CRUD apps?

[Andreas]

Create your php files in folder /templates/. Then within contao you can include them with this insert tag (examples):

{{file::myPHP.php}}
{{file::inc-myPHP.html5}}

You also can code in templates, e.g. in j_xxx templates which you then can select within your layout.

You also can create an HTML module or CE with the above insert tag.

The listing module is just for listing, no CRUD, no FE editing.

You can test MetaModels or Contao Catalog Manager for handling your own DB tables. They both offer FE editing.

In listing module field "Condition" you also can use the insert tag to first check the logged in member an so build the condition dynamically.

[ga.n]

Thank you ga.n. Its working.
Now I wish to display only the records which are uploaded by the log in user. Is there any way I can do it? How do I design the page?

IIRC you can use insert tags inside the "Condition" field
so will be something like

user_id = {{user::id}}

Can I edit and delete the records, just like other CRUD apps?

Editing in frontend can be achieved by creating a form through the form generator and then using the loadFormField and processFormData hooks

For deleting (as stated above) you can use the "file" insert tags

(It seems the Forum platform don't let me post links, just google contao insert tags and contao hooks for more information)