Show Orderby Array value Value in SQL Query When using IN()

Asked Mar 22 '18 at 07:13

Active Mar 22 '18 at 07:25

Viewed 31 times

Following is my code which retrives cookie value and shows recently viewed products

//get cookie vlue
$myCookieArr = array_unique(json_decode($_COOKIE['myshopping']));
//reverce cookie order
$myCookieArry = array_reverse($myCookieArr);
//loop through
foreach ($myCookieArry as $key => $value) {
    $allCProduct .= $value.",";
}
$allCProduct = rtrim($allCProduct,',');

$getRandProduct = $conn->query("SELECT * FROM product WHERE id IN (".$allCProduct.")" );

It Works fine but issue is it is not in order of array_reverse($myCookieArr). so how can i make order by my array value.

So what happen is first viewed product will be last if second one product is viewed by user.let suppose i am getting array as

(
 [0] => 35
 [0] => 39
 //This is Two product 
 //i have already seen
)

Now if i show third product 40 so order should like

(
 [0] => 40
 [1] => 35
 [2] => 39
)

NOTE : i don't have issue of security

So how can i achieve that ?

edited Mar 22 '18 at 07:25

Your Common Sense

156,878
40
214
345

asked Mar 22 '18 at 07:13

your code is wide open to **SQL injection** – Your Common Sense Mar 22 '18 at 07:17
show here what you are getting in `$myCookieArr` and `$myCookieArry`.... – Yash Parekh Mar 22 '18 at 07:17
`$myCookieArr` Stores All Cookie value and `$myCookieArry` is reverce of cookie array @YashParekh – Mar 22 '18 at 07:21
what is the value of `myCookieArr` – Thamaraiselvam Mar 22 '18 at 07:22
why you all are asking completely irrelevant questions? – Your Common Sense Mar 22 '18 at 07:24
`myCookieArr` Strores user product-id – Mar 22 '18 at 07:24
agree with @YourCommonSense – Mar 22 '18 at 07:25

Show Orderby Array value Value in SQL Query When using IN()

0 Answers0