In the stock code, why do some identical database queries sometimes have this `` symbol around the prefix_table, and should I use it?
Below are some examples
$this->db->query("UPDATE `" . DB_PREFIX . "order`...........
$this->db->query("INSERT INTO " . DB_PREFIX . "order_history........
$this->db->query("SELECT * FROM `" . DB_PREFIX . "order_total`........
$this->db->query("SELECT * FROM " . DB_PREFIX . "order_total..........
User defined due to reserved terms already used by the industry. It is also known to be used due to some web servers believing these can be function names as opposed to used defined names but that one is still a puzzle.boopbeepforum wrote: ↑Sun Jun 20, 2021 9:00 amIn the stock code, why do some identical database queries sometimes have this `` symbol around the prefix_table, and should I use it?
Below are some examples
$this->db->query("UPDATE `" . DB_PREFIX . "order`...........
$this->db->query("INSERT INTO " . DB_PREFIX . "order_history........
$this->db->query("SELECT * FROM `" . DB_PREFIX . "order_total`........
$this->db->query("SELECT * FROM " . DB_PREFIX . "order_total..........
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
https://dev.mysql.com/doc/refman/8.0/en ... fiers.htmlboopbeepforum wrote: ↑Sun Jun 20, 2021 9:00 amIn the stock code, why do some identical database queries sometimes have this `` symbol around the prefix_table, and should I use it?
Below are some examples
$this->db->query("UPDATE `" . DB_PREFIX . "order`...........
$this->db->query("INSERT INTO " . DB_PREFIX . "order_history........
$this->db->query("SELECT * FROM `" . DB_PREFIX . "order_total`........
$this->db->query("SELECT * FROM " . DB_PREFIX . "order_total..........
Who is online
Users browsing this forum: No registered users and 192 guests