Pass string as parameters to execute([$string_list]) in PHP PDO [duplicate]

Question

I'm looking for the best way to do what this probably can't do until the future:

// Only one of these, different each time
$arg_string = "'arg1', 'arg2', 'arg3'";         // Unknown number of arguments!
$arg_string = "'arg1', 'arg2', 'arg3', 'arg4'"; // Unknown number of arguments!
$arg_string = "'arg1'";                         // Unknown number of arguments!

// Where I need help
$stmt->execute([$arg_string]); // Wish I could, maybe PHP 9 will

My problem is that a $string or $array can't be easily passed to a function() as its parameters.

This is important for my work because I am creating a method to query the database and I may have an unknown number of columns or values. This is what the code will look like just before using exec().

I found this SO article (PHP use variable to pass multiple arguments to function) which discusses call_user_func_array(). But, I can't figure out how to use call_user_func_array() with execute(). Even if I were to guess, I still would want to know what is best.

I don't mind turning $arg_string into an array first, or not, whatever is best.

What is the best way to do what this can't:

$stmt->execute([$arg_string]);

The manual has some pretty clear examples: php.net/manual/en/pdostatement.execute.php (which is always a good place to start when in doubt) — M. Eriksson
– M. Eriksson, Commented Jul 31, 2021 at 11:19

Barmar · Accepted Answer · 2021-07-31 11:17:34Z

2

You don't need a string, each arg should be a separate array element.

$arg_array = ['arg1']; // or
$arg_array = ['arg1', 'arg2']; // or
$arg_array = ['arg1', 'arg2', 'arg3'];

$stmt->execute($arg_array);

answered Jul 31, 2021 at 11:17

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

3 Comments

Jesse Over a year ago

To accept this answer, I need you to demonstrate starting with $arg_string and how you got it into the array to use. I have already been using explode() and others to no avail.

Barmar Over a year ago

I think you need to go back a step. Why do you need $arg_string in the first place? If you're creating everything dynamically, do it by building $arg_array from what you need.

Barmar Over a year ago

Or use a parsable string like JSON.

Jesse · Accepted Answer · 2021-07-31 17:16:47Z

-1

From PDOStatement::execute | php.net:

// Only one of these, different each time
$arg_string = "'arg1', 'arg2', 'arg3'";         // Unknown number of arguments!
$arg_string = "'arg1', 'arg2', 'arg3', 'arg4'"; // Unknown number of arguments!
$arg_string = "'arg1'";                         // Unknown number of arguments!

// Where I need help
$arg_array = explode(",", str_replace(["'", ' '], '', $arg_string)); // My solution
$stmt->execute([$arg_array]);

edited Jul 31, 2021 at 17:16

answered Jul 31, 2021 at 11:59

Jesse

1,0641 gold badge18 silver badges32 bronze badges

3 Comments

user8034901 Over a year ago

Is this an answer or an addition to your question? Are you asking how to explode the string into an array?

user8034901 Over a year ago

You don't want spaces or single quotes in your array, so use $arg_array = explode(",", str_replace(["'", ' '], '', $arg_string));

Jesse Over a year ago

@brombeer it is a way to get $arg_string into the explode() method as the question seeks. I found the right answer.

Collectives™ on Stack Overflow

Pass string as parameters to execute([$string_list]) in PHP PDO [duplicate]

2 Answers 2

3 Comments

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Linked

Related