duanhuangyun3887 2019-05-10 10:37
浏览 253

使用bind_param PHP在数组中动态执行查询

i actually start using prepare statement and i find interesting but the path is actually not clear to me on how i can insert an array into a bind_param in prepare statement.

from the code below, i use the register_user function to grap all the $register_data which are username, password, email etc and i implode the $register_data in $data and the keys in $field but how do i bind the array in the bind_param so my query can execute correctly and dynamically. Thanks

if (empty($_POST) == false && empty($errors) == true) {

    $register_data = array(
        'email' => $email,
        'username' => $username,
        'first_name' => $first_name,
        'last_name' => $last_name,
        'password' => $password
    );

    register_user($register_data);

    exit();

}


function register_user($register_data) {
    global $connection;

    array_walk($register_data, 'array_sanitize');
    $register_data['password'] = md5($register_data['password']);

    $fields = implode(', ', array_keys($register_data));
    $data = implode(', ', $register_data);

    $stmt = $connection -> prepare("INSERT into users ($fields) VALUES (?)");
    // the problem is around here
    $stmt -> bind_param('s', $data);
    $stmt -> execute();
}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 使用C#,asp.net读取Excel文件并保存到Oracle数据库
    • ¥15 C# datagridview 单元格显示进度及值
    • ¥15 thinkphp6配合social login单点登录问题
    • ¥15 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场 部分对应不上
    • ¥15 如何在scanpy上做差异基因和通路富集?
    • ¥20 关于#硬件工程#的问题,请各位专家解答!
    • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
    • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
    • ¥30 截图中的mathematics程序转换成matlab
    • ¥15 动力学代码报错,维度不匹配