php | Convert array to FIND_IN_SET

Question

I'm trying to convert my array to query string. May be you can help me.

My array looks like:

Array
(
    [3] => Array
        (
            [0] => 7
            [1] => 13
            [2] => 1
        )

    [4] => Array
        (
            [0] => 14
            [1] => 2
        )

)

And I'm trying to convert this into:

(FIND_IN_SET('13', vals) || FIND_IN_SET('7', vals) || FIND_IN_SET('1', vals)) AND (FIND_IN_SET('14', vals) || FIND_IN_SET('2', vals))

How can I do this? Thanks!

How are you trying to build this query? What API are you using? — Phylogenesis
– Phylogenesis, Commented May 15, 2015 at 9:20
^ Besides that; Have you tried something to get to your goal yourself? — Rizier123
– Rizier123, Commented May 15, 2015 at 9:20

Akshay Hegde · Accepted Answer · 2015-05-15 09:39:27Z

2

This may help you.

 [akshay@localhost tmp]$ cat test.php
 <?php

 $array = array(array(7,13,1),array(14,2));

 function convert_to_string($array)
 {
  return implode(" AND ",array_map(function($v){ return "(".implode(" || ", array_map( function($q){ return sprintf("FIND_IN_SET('%s', vals)",$q);},array_values($v))).")";},array_values($array)));    
 }

 echo convert_to_string($array);

 ?>

Output

 [akshay@localhost tmp]$ php test.php
 (FIND_IN_SET('7', vals) || FIND_IN_SET('13', vals) || FIND_IN_SET('1', vals)) AND (FIND_IN_SET('14', vals) || FIND_IN_SET('2', vals))

answered May 15, 2015 at 9:39

Akshay Hegde

17.1k2 gold badges25 silver badges39 bronze badges

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

1 Comment

Phylogenesis Over a year ago

Bear in mind that if any of the values in the array are user-supplied, then this is ripe for SQL injection.

Collectives™ on Stack Overflow

php | Convert array to FIND_IN_SET

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related