Use table to search and select row for edit

[lozdown]

I'm new to SQLPage. How to select an item from a table and pass it to an edit form?

[lovasoa]

Hello and welcome to SQLPage !

The easiest way to achieve what you want to do is to add an "edit" column to your table with a link to your edition page. Like so:

select 'table' as component, 'action' as markdown;
select *, format('[Edit](edit.sql?id=%s)', id) as action from users;

Then, in edit.sql, you can have your form:

select 'form' as component;
select 'text' as type, 'Username' as name, username as value from users where id = $id;

update users set username = :Username where id = $id and :Username is not null;

See the simple website example

table.sql	edit.sql

[lozdown]

Very helpful - thanks