how to pass the php variable in Mysql select Query

Question

$valid is An array and $createdon and $days are get the Date value from array. My select query is not work with these date value of PHP variable please solve its.

function checkexpiretime($valid)
    {
        $db = &JFactory::getDBO();
        foreach($valid as $validity)
        {
             echo $createdon=$validity->CreatedOn;
             echo $days=$validity->days;
        }
        echo $query="SELECT * FROM jos_generatekey WHERE CreatedOn BETWEEN DATE_ADD('".$createdon."',".INTERVAL $days DAY.")". "AND CURDATE()"; 
        $db->setQuery($query);
        $checkexpire = $db->loadObjectList();
        print_r($checkexpire);
        return $checkexpire;
    }

possible duplicate of Pass a php variable to mysql query

Eelke
– Eelke

2012-08-09 05:54:24 +00:00
Commented Aug 9, 2012 at 5:54 — Eelke
– Eelke, Commented Aug 9, 2012 at 5:54
is $valid a multi-dimensional array?

Bhuvan Rikka
– Bhuvan Rikka

2012-08-09 05:55:26 +00:00
Commented Aug 9, 2012 at 5:55 — Bhuvan Rikka
– Bhuvan Rikka, Commented Aug 9, 2012 at 5:55

Muhammad Zeeshan · Accepted Answer · 2012-08-09 06:27:10Z

0

Query should be like this:

$query= "SELECT * FROM jos_generatekey WHERE CreatedOn BETWEEN DATE_ADD('".$createdon."',INTERVAL ". $days ." DAY) AND CURDATE()";

edited Aug 9, 2012 at 6:27

answered Aug 9, 2012 at 5:58

Muhammad Zeeshan

8,86610 gold badges47 silver badges55 bronze badges

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

1 Comment

dhiraj Over a year ago

$query= "SELECT * FROM jos_generatekey WHERE CreatedOn BETWEEN DATE_ADD('".$createdon."',INTERVAL ". $days ." DAY)"; your query is running but use it with current date function

Collectives™ on Stack Overflow

how to pass the php variable in Mysql select Query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related