Check to see if current customer purchased specific product.

**camerondied** · 21 Jan 2016, 06:35 PM

Hello.. hopefully someone can help me.. I'm trying to write a code where it's like

if $_SESSION['customer_id'] purchased product ='123' echo 'HTML'

basically I want to display a specific message to customers who have purchase specific products on who they should contact/what they should do next. Thanks in advance!

**mc12345678** · 21 Jan 2016, 06:53 PM

Originally Posted by camerondied

Hello.. hopefully someone can help me.. I'm trying to write a code where it's like

if $_SESSION['customer_id'] purchased product ='123' echo 'HTML'

basically I want to display a specific message to customers who have purchase specific products on who they should contact/what they should do next. Thanks in advance!

Tables orders and orders_products are tables you want to reference/use. Orders has the customers_id and an orders_id in it, while orders_products has the matching orders_id and then the products_id(s) associated with the order. So thinking you would want to do a sql query on the set of tables and depending on how many such searches you want to do you could either focus the query or leave it open. Focussed would be to ask the sql server to look for the customer to have purchased the specific product id, a little left open would be to obtain a list of all products_ids that the customer has purchased... Wide open would be to just pull all order history. :)

if you do a specific search, then if there is a response (RecordCount() > 0), and/or not at the End Of File (EOF) then the product was previously purchased and to take an action...