Back office form to allow webmaster to create database rows in custom pss_table.

[pmaojo]

The idea is a tab in the admin interface with a view of the table, (that is already working) and input fields and add button, to add more rows to that table... 

 

Any idea? Ive already spent a lot of hours googling this.... thankyou

Edited April 28, 2014 by pmaojo (see edit history)

[vekia]

to add more rows to your table you have to create seaprate form to include new row. (form with fields that you want to insert) 

you've got it and now wondering how to insert it to database? or what?

[pmaojo]

don´t have any clue on how to make it with smarty and in prestashop context

 

I have:

 

- Table in DB
- I managed to show the DB table on myaccount.tpl for each user (table is a tracking of services offered)

 

I need a starting point.

[vekia]

you can't deal with database in smarty .tpl files

you can do it only in php files.

 

you can do it twice. with object model, or manually with sql query.

example of query below:

Db::getInstance()->execute('INSERT INTO `'._DB_PREFIX_.'myTable` (name,value) VALUES ('This is name','This is value'));

you can run this query in your .php file

[pmaojo]

thankyou.

 

so I can make it just php and hook it somewhere in the backoffice? do I need to make a module?

Edited April 29, 2014 by pmaojo (see edit history)