I have a query. Query is include sql function. So I want to directly. But I need parameter.
$parameters = DB::select("SELECT GetFlowPropertyValue(flow.id, 'PCommonLineDataNumber') subscriberNumber, (SELECT Id FROM ConfigurationItem WHERE FlowId = flow.id ORDER BY Id DESC Limit 1) ConfigurationItemId, GetObjectTypeRelationParentObjectValue(6, 1, flow.id) CustomerId, GetFlowPropertyValue(flow.id, 'MainOfferingName') MainOfferingName, GetFlowPropertyValue(flow.Id, 'CampaignName') CampaignName FROM akislar flow WHERE id ='$query->id'");
As you can see, Final parameter come foreach but doesnt run. I use dd and I write query. I see $query->id is look like empty. It is not defined. How can I bind $query->id ?