how to bind a bind_param with non variables

Question

i have a funktion that is suposed to make it easy to make prepared sql querys

here is the function

    function preparedConnection($stmt,$param){ 
    $dbUsername= 'root';
    $dbPassword='';
    $dbip = 'localhost';
    $db = '129393';

    $conn = new mysqli($dbip, $dbUsername, $dbPassword, $db);
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    echo $stmt."<br>";
    $stmt_db = $conn->prepare($stmt);
    echo $param;
    $stmt_db->bind_param($param);


    $stmt_db->execute();
    $stmt_db->close();
    $conn->close();
    exit();
}

here is how i use it

       $stmt = "INSERT INTO task_times (task_id, login_id, title, description,
    used_fixed_price_per_hour ,used_discount_percent, used_price_type) VALUES (?, ?, ?, ?, ?, ?, ?)";

    $param = "'iissiii', $task_id , $login_id, '$title', '$description', $used_fixed_price_per_hour, $used_discount_percent, $used_price_type";

    $db->preparedConnection($stmt,$param);

but i does not accept vaiables that are string eny help?

what you are trying here with $param just doesn't work. You cannot pass multiple arguments wrapped in a single string.. — Jeff
– Jeff, Commented Apr 16, 2019 at 9:08
either make $param an array and use things like call_user_func_array to call bind_param; or use PDO where you can pass in an array as params — Jeff
– Jeff, Commented Apr 16, 2019 at 9:11

jeroen · Accepted Answer · 2019-04-16 09:12:46Z

1

You need to pass each parameter to bind_param() individually.

A possible solution that gives you a bit more flexibility than hardcoding it, would be to use array unpacking: You pass an array with all individual values and unpack it where you need it:

$param = [
    'iissiii',
    $task_id,
    $login_id,
    // etc.
];

And in your function:

$stmt_db->bind_param(...$param);

answered Apr 16, 2019 at 9:12

jeroen

91.8k22 gold badges117 silver badges132 bronze badges

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

Collectives™ on Stack Overflow

how to bind a bind_param with non variables

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related