How do I have values from an array show up in a php string?

Question

I have two values in an array that I want to have show up in a string variable that I am building. Theses values are dynamic and are subject to change, so I want to be able to build the string straight from the array. I thought I was on the right track but the values are not showing up.

My Code:

$range = "WHERE transdate >= \"{$halfway['startdate']}\" AND transdate <= \"{$halfway['enddate']}\"";

The output:

WHERE transdate >= "" AND transdate <= ""

i hope you escape your array beforehand

knittl
– knittl

2011-06-03 16:37:18 +00:00
Commented Jun 3, 2011 at 16:37 — knittl
– knittl, Commented Jun 3, 2011 at 16:37

Jong Bor Lee · Accepted Answer · 2011-06-03 16:28:13Z

4

The following works for me in php 5.3.5 cli. I haven't modified your string

$halfway = array(
    'startdate' => 'somedate',
    'enddate' => 'otherdate'
);

$range = "WHERE transdate >= \"{$halfway['startdate']}\" AND transdate <= \"{$halfway['enddate']}\"";

print $range;

Output:

WHERE transdate >= "somedate" AND transdate <= "otherdate"

Check that $halfway actually has data.

answered Jun 3, 2011 at 16:28

Jong Bor Lee

3,8651 gold badge28 silver badges27 bronze badges

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

1 Comment

tehman Over a year ago

wow...haha. I was building the string before the array. Thanks

Jay Sidri · Accepted Answer · 2011-06-03 16:25:30Z

1

Try removing the quotes in the array element.. I think that would work..

WHERE transdate >= \"{$halfway[startdate]}\" AND transdate <= \"{$halfway[enddate]}\"

answered Jun 3, 2011 at 16:25

Jay Sidri

6,4063 gold badges48 silver badges70 bronze badges

3 Comments

Brad Christie Over a year ago

According to my testing, either should work. Tells me it's something wrong with the $halfway object.

Jay Sidri Over a year ago

"WHERE transdate >= '$halfway[startdate]' AND transdate <= '$halfway[enddate]'"; How about that?

tehman Over a year ago

Yeah this works too, I was building the string before halfway so the values were not showing up.

dogmatic69 · Accepted Answer · 2012-12-21 00:43:40Z

0

Why do you use a framework and not use its ORM?

$this->ModelName->find('all', array(
    'conditions' => array(
        'ModelName.transdate BETWEEN ? AND ?' => array(
            $halfway['startdate'],
            $halfway['enddate']
         )
    )
));

answered Dec 21, 2012 at 0:43

dogmatic69

7,5834 gold badges34 silver badges50 bronze badges

Collectives™ on Stack Overflow

How do I have values from an array show up in a php string?

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related