How I can sort the data with array in php?

Question

In postman,

I post the array like

key => Image[] / value => 1
key => Image[] / value => 2
key => Image[] / value => 3

I want when I put an array which user's card images, receive the card's Idx and Name.

So I make query like this,

$query = "SELECT DISTINCT
                    Idx AS Idx, 
                    Name AS Name 
                    FROM Card
                    WHERE Card.Image IN ('$_POST[Image]')";

But, It receive no data. So I remove '' so

WHERE Card.Image IN ('$_POST[Image]')" 
=> WHERE Card.Image IN ($_POST[Image])";

Then return Unknown column 'Array' in 'where clause'

I don't know what is problem of this.

when I post array like /key name[]/value 1 I know it can receive $_POST[name].

How I can post array and receive of it.

Please help me.

add your post code. It seems that you aren't posting the images correctly. To set more than one file/image at the same time you'll need a preventdefault and an ajax function and insert one by one (this is the best secure and reliable option). — JoelBonetR
– JoelBonetR, Commented Mar 14, 2018 at 8:43
@JoelBonetR I just using postman so I don't add this but add the picture — Polaris Nation
– Polaris Nation, Commented Mar 14, 2018 at 8:56
@PolarisNation did you checked my last edited answer. please check and try and let me know worked or not? — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Mar 17, 2018 at 6:44

Death-is-the-real-truth · Accepted Answer · 2018-03-15 04:10:38Z

1

I hope Image column contains numbers.

Use implode() to correct your IN query

$string=$_POST['Image'];
$array= implode(',', $string);
$query = "SELECT DISTINCT Idx AS Idx, Name AS Name FROM Card WHERE Card.Image IN ($array)";

Note:-

1.Query will become:-SELECT DISTINCT Idx AS Idx, Name AS Name FROM Card WHERE Card.Image IN (1,2,3). Now it will execute fine.

2.Try to use prepared statements of mysqli_* or PDO to prevent your code from SQL-INJECTION. You current code is wide-open for it.

edited Mar 15, 2018 at 4:10

answered Mar 14, 2018 at 8:46

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

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

1 Comment

Polaris Nation Over a year ago

Thanks you saved my time. the solution was settled.

Rp9 · Accepted Answer · 2018-03-14 08:43:35Z

0

$string=$_POST[Image];
$array=array_map('intval', explode(',', $string));
$array = implode("','",$array);
$query = "SELECT DISTINCT Idx AS Idx, Name AS Name FROM Card WHERE 
           Card.Image IN ('".$array."')";

answered Mar 14, 2018 at 8:43

Rp9

1,9612 gold badges27 silver badges34 bronze badges

2 Comments

rollstuhlfahrer Over a year ago

While this code may answer the question, providing additional context regarding why and/or how this code answers the question improves its long-term value.

Polaris Nation Over a year ago

I try this code but could not get any response of it

Collectives™ on Stack Overflow

How I can sort the data with array in php?

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related