In Which file of X Cart 5 we can put insert into query

Question

In X cart how can we put insert into command.

And also in which specific file?

Answer 1

X-Cart 5 uses Doctrine ORM to work with database records. It adds a few wrapper classes for easier programming, but most of the documentation available for Doctrine applies to X-Cart 5 too.

Also, you can find a great article on adding custom X-Cart 5 database entities here.

Answer 2

You have to create a controller file and create any method and do your logic here like and get this details in tpl file Like getRecords() :

public function getRecords(){

$options = \XLite::getInstance()->getOptions('database_details');
  // do your connection login
  // do your query logic 
}