What is the PHP variable or object to connect to database

[ColdDistance]

Hi, I'm trying to build a personal module to manage returns and I want to make a HTML select with the orders and their customers.

 

I need to know what is the variable or object to connect with the database because I do a SQL query in my PHP script, but I don't know how to do the connection to database.

[presta4you.com]

Check this link: http://doc.prestashop.com/display/PS15/DB+class+best+practices

[vekia]

use the Db object,

 

you can use static getInstance() function

 

for example:

Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS("SELECT * FROM `"._DB_PREFIX_."products");

[ColdDistance]

Thank you for your answers, I hope they will be useful.

[vekia]

i forgot to mention about little modification for INSERT / UPDATE / DELETE queries:

 

in these cases you have to use execute function instead the executeS

 

example:

Db::getInstance()->execute('INSERT INTO `'._DB_PREFIX_.'something` (row) VALUES (value)');

[ColdDistance]

Thanks, the query is for the select HTML tags. For create or update orders I use stored procedures.