PHP Smarty Tag in SQL query

Question

i am working on a shop that uses smarty tag. I want to do following sql query:

{php}
    $sql = "SELECT intraship_shipmentnumber FROM orders WHERE orders_id = {$ORDER_NUMBER} ";
{/php}

when i insert a static order number the sql query works, but it does not work with the smarty tag and i poorly have no idea how to insert it so it works.

Marcel Wasilewski · Accepted Answer · 2015-09-11 15:34:03Z

1

I already found a solution myself. Here it is for anyone who is interested:

First you assign a variable via Smarty:

{assign var=test value=$ORDER_NUMBER}

Then you can put this in a PHP Variable which you can use:

$order = $this->get_template_vars('test');

answered Sep 11, 2015 at 15:34

Marcel Wasilewski

2,6991 gold badge19 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alex · Accepted Answer · 2015-09-11 15:06:49Z

0

I am not an Smarty expert. But could you try:

{php}
    $sql = "SELECT intraship_shipmentnumber FROM orders WHERE orders_id = {/php}{$ORDER_NUMBER}{php} ";
{/php}

answered Sep 11, 2015 at 15:06

Alex

17.3k1 gold badge31 silver badges52 bronze badges

Collectives™ on Stack Overflow

PHP Smarty Tag in SQL query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related