php - insert a new row using decoded json string

Question

$str is a json object-string from client side
keys are column names
need to insert a new row using prepared values - i.e. corresponding key value pairs
how can I do - like this:

$str = {"fname":"lorem","sname":"ipsum","nick":"dolor"};

function btn_send($str){
    global $db;
    $obj = json_decode($str);
    $sq = "insert into members (...keys) values (...prepared_values)";
    $st = $db->prepare($sq);
    $st->execute([...]);
}

question from:https://stackoverflow.com/questions/65839655/insert-a-new-row-using-decoded-json-string

Answer 1

<?php


$str = '{"fname":"lorem","sname":"ipsum","nick":"dolor"}';

function btn_send($str){
    global $db;
    $data = json_decode($str,true);
    $column_names = "`". implode("`,`",array_keys($data)) . "`";
    $prepared_chars = implode(",",array_fill(0,count(array_values($data)),'?'));
    $sq = "insert into members ($column_names) values ($prepared_chars)";
    $st = $db->prepare($sq);
    $st->execute(array_values($data));
}

You can make the column names out of the json keys and have those many ? placeholders as much as values for those keys. While executing the prepared query, you can just supply the values.