Variable input arguments in PHP

Question

I have an half PHP/half algorithmic question. I will have random inputs between 0 and 4. they will be used in the same query such as

  <?php  SELECT * FROM `table` WHERE inputs in (input0,input1,input2)  //for 3 inputs
          SELECT * FROM `table` WHERE inputs in (input0,input1)  //for 2 inputs
         //do nothing for zero inputs ?>

I believe this is the start point.

 <?php
 function myfunc(){
   $args = func_get_args();
  foreach ($args as $arg)
   echo $arg."/n";
 }
  myfunc('hello', 'world', '.');
      ?>

Now I think I can run the foreach loop n times for n individual inputs but I couldn't figure out how to use them in the query effectively. Can I create an array and pass it somehow to the query as inputs?

thanks

arda

Wouldn't it be much easier if you passed an array to the function instead of multiple scalar arguments? Frankly, variable arguments come to mind much more frequently than it's a good idea to use them. — Jon
– Jon, Commented Apr 11, 2013 at 19:12

OdinX · Accepted Answer · 2013-04-11 19:18:16Z

1

You could also pass your function an array:

function myfunc(array('input2','input1'));

But to answer your question using func_get_args:

<?php
function buildQuery() {
    $args = func_get_args();

    $q = implode(', ',$args);

    return 'SELECT * FROM `table` WHERE inputs in ('.$q.');';
}

echo buildQuery('input0','input1');
?>

Outputs:

SELECT * FROM table WHERE inputs in (input0, input1);

answered Apr 11, 2013 at 19:18

OdinX

4,2291 gold badge26 silver badges35 bronze badges

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

Comments

Cano64 · Accepted Answer · 2013-04-11 19:20:03Z

0

Don't forget to sanitize your inputs first before you use them in a query. Try this

$i = impode(", ", array_map(function($a) {
   return '"' . mysql_real_escape_string($a) . '"';
}, func_get_args());

and then replace (input0,input1) with content of $i like this

$q = "SELECT * FROM `table` WHERE inputs in " . $i;

answered Apr 11, 2013 at 19:20

Cano64

2371 gold badge2 silver badges8 bronze badges

Collectives™ on Stack Overflow

Variable input arguments in PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related