获取mysql查询中的当前url

Question

How can i get the full curent url wether it https or https in a mysql query like below ?

AND `url` = 'http://.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];'

As the above part does not work

Complete string , i want to add this at the end with AND :

$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "customer_online WHERE `customer_id` != '0' AND date_added > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 HOUR) ");

Answer 1

public function getRegisteredUsersOnline(){ 
 $url = "http".(!empty($_SERVER['HTTPS'])?"s":"")."//".
        $_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];

   $query = $this->db->prepare("SELECT COUNT(*) as `num` FROM " . DB_PREFIX . "customer_online WHERE customer_id != '0' AND `date_added` > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 HOUR) 
   AND `url` = ?");
   $query->execute( array( $url ) );
   $count = $query->fetch(2);
   return $count['num'];

}